RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA1093008" 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

  • PRJNA1093008 · 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
198400 198400 PRJNA1093008_S_NODE_15081_length_400_cov_2.822630_g14755_i0 PRJNA1093008 15081 400 2.82263 11.29052 uncultured cyanobacterium 1211 Bacteria Bacteria 625 1.7999999999999998e-174   NTclustered gi|225696243|gb|FJ805910.1| 1211 g14755 i0 95.012 126.675 401 14 100 4 1 400 3234 3629 Uncultured cyanobacterium clone AN2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence blastn 50670 625 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         uncultured cyanobacterium
5301219 5301219 PRJNA1093008_S_NODE_10265_length_441_cov_1.100543_g9939_i0 PRJNA1093008 10265 441 1.100543 4.85339463 Aliterella chasmolithica 2739056 Bacteria Bacteria 508 2.11e-139   NTclustered gi|1713066352|gb|MN243145.1| 2599943 g9939 i0 89.899 147.417233560091 396 38 90 2 25 419 2056 2450 Aliterella chasmolithica PJ S15 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence blastn 65011 508 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Aliterellaceae Aliterella Aliterella chasmolithica
9126060 9126060 PRJNA1093008_S_NODE_19008_length_379_cov_1.300654_g18681_i0 PRJNA1093008 19008 379 1.300654 4.92947866 uncultured Chroococcidiopsis sp. 259957 Bacteria Bacteria 569 8.06e-158   NTclustered gi|225696257|gb|FJ805924.1| 259957 g18681 i0 93.717 138.079155672823 382 20 100 3 1 379 3525 3145 Uncultured Chroococcidiopsis sp. clone AS2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence blastn 52332 569 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Chroococcidiopsidaceae Chroococcidiopsis uncultured Chroococcidiopsis sp.
11677086 11677086 PRJNA1093008_S_NODE_23970_length_357_cov_6.475352_g23643_i0 PRJNA1093008 23970 357 6.475352 23.11700664 uncultured Chroococcidiopsis sp. 259957 Bacteria Bacteria 573 5.829999999999998e-159   NTclustered gi|225696232|gb|FJ805899.1| 259957 g23643 i0 96.532 101.168067226891 346 12 97 0 12 357 2895 2550 Uncultured Chroococcidiopsis sp. clone NA3_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence blastn 36117 573 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Chroococcidiopsidaceae Chroococcidiopsis uncultured Chroococcidiopsis sp.
28046692 28046692 PRJNA1093008_S_NODE_72645_length_261_cov_1.925532_g72318_i0 PRJNA1093008 72645 261 1.925532 5.02563852 Stanieria cyanosphaera 102116 Bacteria Bacteria 43.1 0.0329   NR WP_015194282.1 102116 g72318 i0 38.7 0.71264367816092 62 38 71.3 0 244 59 224 285 WP_015194282.1 bifunctional ADP-dependent NAD(P)H-hydrate dehydratase/NAD(P)H-hydrate epimerase [Stanieria cyanosphaera] diamond 186 43.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pleurocapsales Dermocarpellaceae Stanieria Stanieria cyanosphaera
31204590 31204590 PRJNA1093008_S_NODE_22855_length_362_cov_1.588235_g22528_i0 PRJNA1093008 22855 362 1.588235 5.7494107 Leptolyngbya sp. FACHB-36 2692808 Bacteria Bacteria 47.8 0.002   NR WP_199290468.1 2692808 g22528 i0 40.5 0.654696132596685 79 43 65.5 1 7 243 18 92 WP_199290468.1 pantothenate kinase [Leptolyngbya sp. FACHB-36] diamond 237 47.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya Leptolyngbya sp. FACHB-36

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