RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA1192965" and tax_clade = "Cyanobacteriota/Melainabacteria group"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_kingdom 1

tax_clade 1

  • Cyanobacteriota/Melainabacteria group · 5 ✖

bioproject 1

  • PRJNA1192965 · 5 ✖
Link rowid ▼ query bioproject node length coverage rel_abundance taxname_lca taxid_lca taxoncategory taxoncategorysimple bits evalue lowcoverage_flag analysis_used target taxid gene allele pident sumperc_cov alnlen mismatch qcov gapopen qstart qend tstart tend target_title analysis sumalnlen maxbits bits_percmax tax_superkingdom tax_clade tax_kingdom tax_phylum tax_class tax_order tax_family tax_genus tax_species
2871277 2871277 PRJNA1192965_P_NODE_1523_length_332_cov_1.420849_g1504_i0 PRJNA1192965 1523 332 1.420849 4.71721868 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 204 3.97e-65   NR MBX9724270.1 2364082 g1504 i0 90.9 0.993975903614458 110 10 99.4 0 331 2 57 166 MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium] diamond 330 204 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
24546564 24546564 PRJNA1192965_P_NODE_4320_length_245_cov_0.895349_g4301_i0 PRJNA1192965 4320 245 0.895349 2.19360505 Calothrix sp. PCC 7716 2853227 Bacteria Bacteria 436 5.229999999999999e-118   NTclustered gi|2083844586|dbj|AP025018.1| 2853227 g4301 i0 98.776 272.49387755102 245 3 100 0 1 245 1858539 1858295 Calothrix sp. PCC 7716 DNA, complete genome blastn 66761 436 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Calotrichaceae Calothrix Calothrix sp. PCC 7716
26945699 26945699 PRJNA1192965_P_NODE_4742_length_243_cov_0.905882_g4723_i0 PRJNA1192965 4742 243 0.905882 2.20129326 Cyanobacteria bacterium PR.023 2067979 Bacteria Bacteria 99.4 1.71e-25   NR MBA4076561.1 2067979 g4723 i0 75.4 0.703703703703704 57 14 70.4 0 6 176 5 61 MBA4076561.1 hypothetical protein [Cyanobacteria bacterium PR.023] diamond 171 99.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium PR.023
28683156 28683156 PRJNA1192965_P_NODE_4687_length_243_cov_1.811765_g4668_i0 PRJNA1192965 4687 243 1.811765 4.40258895 Cyanobacteria bacterium UBA12227 2055765 Bacteria Bacteria 48.5 3.17e-4   NR HAG82264.1 2055765 g4668 i0 42.9 1.5679012345679 56 32 69.1 0 239 72 215 270 HAG82264.1 PEP-CTERM sorting domain-containing protein [Cyanobacteria bacterium UBA12227] diamond 381 48.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium UBA12227
29314479 29314479 PRJNA1192965_P_NODE_4749_length_243_cov_0.905882_g4730_i0 PRJNA1192965 4749 243 0.905882 2.20129326 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 130 6.069999999999998e-35   NR MBX9694561.1 2847862 g4730 i0 77.9 0.950617283950617 77 17 95.1 0 233 3 244 320 MBX9694561.1 hypothetical protein [Cyanobacteriota bacterium] diamond 231 130 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;