RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA643700" and tax_clade = "Bacteria candidate phyla"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • Bacteria candidate phyla · 4 ✖

bioproject 1

  • PRJNA643700 · 4 ✖

analysis 1

  • diamond · 4 ✖

tax_kingdom 0

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
26732712 26732712 PRJNA643700_P_NODE_221041_length_260_cov_4.881517_g219485_i0 PRJNA643700 221041 260 4.881517 12.6919442 Candidatus Rokuibacteriota bacterium 2053607 Bacteria Bacteria 42.7 0.0464   NR PYM82334.1 2053607 g219485 i0 41.1 1.29230769230769 56 30 64.6 1 60 227 97 149 PYM82334.1 MAG: hypothetical protein DME09_14545 [Candidatus Rokuibacteriota bacterium] diamond 336 42.7 1 Bacteria Bacteria candidate phyla   Candidatus Rokuibacteriota         Candidatus Rokuibacteriota bacterium
28439415 28439415 PRJNA643700_P_NODE_277306_length_222_cov_2.023121_g275750_i0 PRJNA643700 277306 222 2.023121 4.49132862 Candidatus Taylorbacteria bacterium RIFCSPHIGHO2_ 1802299 Bacteria Bacteria 42.4 0.0386   NR OHA16815.1 1802299 g275750 i0 32.3 0.837837837837838 62 41 82.4 1 209 27 151 212 OHA16815.1 MAG: hypothetical protein A2830_01860 [Candidatus Taylorbacteria bacterium RIFCSPHIGHO2_01_FULL_44_110] diamond 186 42.4 1 Bacteria Bacteria candidate phyla   Candidatus Tayloriibacteriota         Candidatus Taylorbacteria bacterium RIFCSPHIGHO2_01_FULL_44_110
28849557 28849557 PRJNA643700_P_NODE_262568_length_231_cov_1.714286_g261012_i0 PRJNA643700 262568 231 1.714286 3.96000066 Patescibacteria group bacterium 2052139 Bacteria Bacteria 43.1 0.0219   NR MEK7146909.1 2052139 g261012 i0 35.9 0.831168831168831 64 41 83.1 0 6 197 124 187 MEK7146909.1 NAD-dependent epimerase/dehydratase family protein [Patescibacteria group bacterium] diamond 192 43.1 1 Bacteria Bacteria candidate phyla             Patescibacteria group bacterium
29828469 29828469 PRJNA643700_P_NODE_328891_length_195_cov_1.780822_g327335_i0 PRJNA643700 328891 195 1.780822 3.4726029 Patescibacteria group bacterium 2052139 Bacteria Bacteria 42 0.0364   NR MBU1246858.1 2052139 g327335 i0 34.1 0.676923076923077 44 29 67.7 0 56 187 353 396 MBU1246858.1 serine--tRNA ligase [Patescibacteria group bacterium] diamond 132 42 1 Bacteria Bacteria candidate phyla             Patescibacteria group 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);;