RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA280983" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermotogati · 4 ✖

bioproject 1

  • PRJNA280983 · 4 ✖

tax_clade 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
13812354 13812354 PRJNA280983_P_NODE_4671_length_301_cov_1.722222_g4556_i0 PRJNA280983 4671 301 1.722222 5.18388822 root 1 Root_unresolved Root_unresolved 556 4.87e-154   NTclustered gi|155128|gb|J04639.1|TTHTAQP1A 271 g4556 i0 100 65.9900332225914 301 0 100 0 1 301 2292 1992 Thermus aquaticus DNA polymerase (PolI) gene blastn 19863 556 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus aquaticus
18910402 18910402 PRJNA280983_P_NODE_4355_length_317_cov_1.287313_g4240_i0 PRJNA280983 4355 317 1.287313 4.08078221 root 1 Root_unresolved Root_unresolved 586 6.579999999999998e-163   NTclustered gi|155128|gb|J04639.1|TTHTAQP1A 271 g4240 i0 100 61.4952681388013 317 0 100 0 1 317 1159 1475 Thermus aquaticus DNA polymerase (PolI) gene blastn 19494 586 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus aquaticus
22735794 22735794 PRJNA280983_P_NODE_4058_length_331_cov_1.187943_g3943_i0 PRJNA280983 4058 331 1.187943 3.93209133 root 1 Root_unresolved Root_unresolved 612 1.14e-170   NTclustered gi|155128|gb|J04639.1|TTHTAQP1A 271 g3943 i0 100 67.5196374622357 331 0 100 0 1 331 1812 1482 Thermus aquaticus DNA polymerase (PolI) gene blastn 22349 612 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus aquaticus
31685846 31685846 PRJNA280983_P_NODE_10077_length_166_cov_0.871795_g9962_i0 PRJNA280983 10077 166 0.871795 1.4471797 Deinococcus petrolearius 1751295 Bacteria Bacteria 109 4.49e-26   NR WP_380050238.1 1751295 g9962 i0 100 0.975903614457831 54 0 97.6 0 164 3 423 476 WP_380050238.1 hypothetical protein [Deinococcus petrolearius] diamond 162 109 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus petrolearius

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