RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA801875" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermotogati · 4 ✖

bioproject 1

  • PRJNA801875 · 4 ✖

analysis 1

  • blastn · 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
2076868 2076868 PRJNA801875_P_NODE_1622_length_299_cov_3.026515_g1519_i0 PRJNA801875 1622 299 3.026515 9.04927985 Deinococcus radiopugnans 57497 Bacteria Bacteria 496 1.0699999999999999e-135   NTclustered gi|730601855|gb|CP010028.1| 57497 g1519 i0 97.26 197.157190635452 292 8 99 0 5 296 69205 69496 Deinococcus swuensis strain DY59, complete genome blastn 58950 496 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus radiopugnans
15249863 15249863 PRJNA801875_P_NODE_3112_length_188_cov_2.078431_g3009_i0 PRJNA801875 3112 188 2.078431 3.90745028 Deinococcus 1298 Bacteria Bacteria 300 5.210000000000001e-77   NTclustered gi|2706837832|gb|CP149782.1| 3112952 g3009 i0 98.246 185.936170212766 171 3 94 0 6 176 1454113 1454283 Deinococcus sp. VB142 chromosome 1, complete sequence blastn 34956 300 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. VB142
17379449 17379449 PRJNA801875_P_NODE_1554_length_307_cov_3.511029_g1451_i0 PRJNA801875 1554 307 3.511029 10.77885903 Deinococcus peraridilitoris 432329 Bacteria Bacteria 158 5.9e-34   NTclustered gi|429132235|gb|CP003383.1| 937777 g1451 i0 77.778 548.511400651466 270 50 86 10 27 290 447254 447519 Deinococcus peraridilitoris DSM 19664 plasmid pDEIPE01, complete sequence blastn 168393 158 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus peraridilitoris
22899333 22899333 PRJNA801875_P_NODE_1698_length_289_cov_2.303150_g1595_i0 PRJNA801875 1698 289 2.30315 6.6561035 root 1 Root_unresolved Root_unresolved 497 2.8599999999999998e-136   NTclustered gi|2444916559|dbj|LC733524.2| 47478 g1595 i0 100 98.8512110726644 269 0 93 0 19 287 425 157 Deinococcus sp. AKn-1 gene for 16S rRNA, partial sequence blastn 28568 497 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp.

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