RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA630877" and tax_clade = "Cyanobacteriota/Melainabacteria group"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Cyanobacteriota/Melainabacteria group · 6 ✖

bioproject 1

  • PRJNA630877 · 6 ✖
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
15180141 15180141 PRJNA630877_S_NODE_109312_length_207_cov_2.222892_g90175_i0 PRJNA630877 109312 207 2.222892 4.60138644 root 1 Root_unresolved Root_unresolved 383 5.65e-102   NTclustered gi|192337804|gb|EU751413.1| 1211 g90175 i0 100 99.6811594202899 207 0 100 0 1 207 690 484 Uncultured cyanobacterium clone SD-G09 16S ribosomal RNA gene, partial sequence blastn 20634 383 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         uncultured cyanobacterium
22829185 22829185 PRJNA630877_S_NODE_136038_length_171_cov_1.323077_g116901_i0 PRJNA630877 136038 171 1.323077 2.26246167 Bacteria 2 Bacteria Bacteria 311 2.14e-80   NTclustered gi|238544006|emb|FN298071.1| 1211 g116901 i0 99.415 100.076023391813 171 1 100 0 1 171 487 657 Uncultured cyanobacterium partial 16S rRNA gene, clone CAR-K11c-B8 blastn 17113 311 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         uncultured cyanobacterium
25378151 25378151 PRJNA630877_S_NODE_93200_length_245_cov_2.044118_g74063_i0 PRJNA630877 93200 245 2.044118 5.0080891 root 1 Root_unresolved Root_unresolved 340 4.209999999999999e-89   NTclustered gi|328835073|gb|JF508312.1| 1211 g74063 i0 98.953 96.3469387755102 191 1 78 1 54 244 12 201 Uncultured cyanobacterium clone AlertD10 16S ribosomal RNA gene, partial sequence blastn 23605 342 0.994152046783626 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         uncultured cyanobacterium
27965186 27965186 PRJNA630877_S_NODE_99305_length_229_cov_1.335106_g80168_i0 PRJNA630877 99305 229 1.335106 3.05739274 Leptolyngbya sp. Heron Island J 1385935 Bacteria Bacteria 42.4 0.0304   NR WP_152532239.1 1385935 g80168 i0 51.6 0.406113537117904 31 15 40.6 0 15 107 123 153 WP_152532239.1 hypothetical protein [Leptolyngbya sp. Heron Island J] diamond 93 42.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya Leptolyngbya sp. Heron Island J
28344128 28344128 PRJNA630877_S_NODE_82586_length_283_cov_1.760331_g63449_i0 PRJNA630877 82586 283 1.760331 4.98173673 Oculatellaceae cyanobacterium 3088181 Bacteria Bacteria 42.4 0.0308   NR HEY9754592.1 3088181 g63449 i0 34.5 0.583038869257951 55 34 57.2 2 179 18 46 99 HEY9754592.1 hypothetical protein [Oculatellaceae cyanobacterium] diamond 165 42.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oculatellales Oculatellaceae   Oculatellaceae cyanobacterium
30934017 30934017 PRJNA630877_S_NODE_42054_length_720_cov_5.994109_g24868_i0 PRJNA630877 42054 720 5.994109 43.1575848 Leptolyngbyaceae cyanobacterium SM1_4_3 2720459 Bacteria Bacteria 48.5 0.00476   NR NJL41711.1 2720459 g24868 i0 33.7 0.345833333333333 83 53 33.8 2 459 701 8 90 NJL41711.1 hypothetical protein [Leptolyngbyaceae cyanobacterium SM1_4_3] diamond 249 48.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae   Leptolyngbyaceae cyanobacterium SM1_4_3

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);;