RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA864829", tax_clade = "FCB group" and tax_phylum = "Chlorobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chlorobiota · 5 ✖

tax_kingdom 1

tax_clade 1

  • FCB group · 5 ✖

bioproject 1

  • PRJNA864829 · 5 ✖

analysis 1

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
28042432 28042432 PRJNA864829_S_NODE_8605_length_212_cov_3.619632_g8519_i0 PRJNA864829 8605 212 3.619632 7.67361984 Pseudomonadati 3379134 Bacteria Bacteria 129 7.24e-33   NR MCE7935315.1 2293705 g8519 i0 90 1.9811320754717 70 7 99.1 0 212 3 411 480 MCE7935315.1 2-oxoglutarate dehydrogenase E1 component [Chlorobi bacterium CHB2] diamond 420 129 1 Bacteria FCB group Pseudomonadati Chlorobiota         Chlorobi bacterium CHB2
29013353 29013353 PRJNA864829_S_NODE_11488_length_188_cov_1.316547_g11402_i0 PRJNA864829 11488 188 1.316547 2.47510836 Chlorobi bacterium CHB2 2293705 Bacteria Bacteria 55.5 5.83e-7   NR MCE7933639.1 2293705 g11402 i0 52.5 0.973404255319149 61 29 97.3 0 185 3 426 486 MCE7933639.1 hypothetical protein [Chlorobi bacterium CHB2] diamond 183 55.5 1 Bacteria FCB group Pseudomonadati Chlorobiota         Chlorobi bacterium CHB2
29423292 29423292 PRJNA864829_S_NODE_12769_length_179_cov_2.092308_g12683_i0 PRJNA864829 12769 179 2.092308 3.74523132 Chlorobi bacterium OLB7 1619898 Bacteria Bacteria 100 4.76e-23   NR KXK56089.1 1619898 g12683 i0 94.8 0.972067039106145 58 3 97.2 0 176 3 221 278 KXK56089.1 MAG: preprotein translocase subunit SecY [Chlorobi bacterium OLB7] diamond 174 100 1 Bacteria FCB group Pseudomonadati Chlorobiota         Chlorobi bacterium OLB7
30086630 30086630 PRJNA864829_S_NODE_11352_length_189_cov_1.464286_g11266_i0 PRJNA864829 11352 189 1.464286 2.76750054 Chlorobi bacterium OLB7 1619898 Bacteria Bacteria 75.5 5.03e-14   NR KXK55178.1 1619898 g11266 i0 78.6 1.33333333333333 42 9 66.7 0 2 127 464 505 KXK55178.1 MAG: Membrane-associated phospholipid phosphatase [Chlorobi bacterium OLB7] diamond 252 75.5 1 Bacteria FCB group Pseudomonadati Chlorobiota         Chlorobi bacterium OLB7
30908335 30908335 PRJNA864829_S_NODE_12494_length_181_cov_1.621212_g12408_i0 PRJNA864829 12494 181 1.621212 2.93439372 Chlorobi bacterium CHB2 2293705 Bacteria Bacteria 42.4 0.0228   NR MCE7935152.1 2293705 g12408 i0 37.7 0.878453038674033 53 33 87.8 0 178 20 140 192 MCE7935152.1 PAS domain S-box protein [Chlorobi bacterium CHB2] diamond 159 42.4 1 Bacteria FCB group Pseudomonadati Chlorobiota         Chlorobi bacterium CHB2

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