RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA431371" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermotogati · 6 ✖

bioproject 1

  • PRJNA431371 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
1088115 1088115 PRJNA431371_P_NODE_9201_length_410_cov_1.121662_g9128_i0 PRJNA431371 9201 410 1.121662 4.5988142 Deinococcus 1298 Bacteria Bacteria 501 3.25e-137   NTclustered gi|821341785|gb|CP011389.1| 1309411 g9128 i0 88.835 192.6 412 41 100 5 1 410 1886024 1886432 'Deinococcus soli' Cha et al. 2014 strain N5, complete genome blastn 78966 501 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus soli (ex Cha et al. 2016)
1702937 1702937 PRJNA431371_P_NODE_16642_length_315_cov_0.950413_g16569_i0 PRJNA431371 16642 315 0.950413 2.99380095 Deinococcus sp. AB2017081 3093660 Bacteria Bacteria 520 6.719999999999999e-143   NTclustered gi|2636768990|gb|CP140098.1| 3093660 g16569 i0 99.648 165.222222222222 284 1 100 0 32 315 56955 56672 Deinococcus sp. AB2017081 chromosome, complete genome blastn 52045 520 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. AB2017081
11906683 11906683 PRJNA431371_P_NODE_1110_length_904_cov_2.256318_g1048_i0 PRJNA431371 1110 904 2.256318 20.39711472 Deinococcus soli (ex Cha et al. 2016) 1309411 Bacteria Bacteria 1559 0   NTclustered gi|821341785|gb|CP011389.1| 1309411 g1048 i0 97.792 344.99889380531 906 17 100 3 1 904 1638345 1637441 'Deinococcus soli' Cha et al. 2014 strain N5, complete genome blastn 311879 1559 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus soli (ex Cha et al. 2016)
12566848 12566848 PRJNA431371_P_NODE_28390_length_248_cov_0.880000_g28317_i0 PRJNA431371 28390 248 0.88 2.1824 Thermus 270 Bacteria Bacteria 230 9.65e-56   NTclustered gi|2049910225|gb|CP076325.1| 88190 g28317 i0 97.761 58.6290322580645 134 2 54 1 1 134 2296954 2296822 MAG: Thermus antranikianii isolate RBS10-92 chromosome, complete genome blastn 14540 230 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus antranikianii
20829968 20829968 PRJNA431371_P_NODE_2857_length_657_cov_0.922945_g2784_i0 PRJNA431371 2857 657 0.922945 6.06374865 Deinococcus aquaticus 328692 Bacteria Bacteria 614 6.649999999999999e-171   NTclustered gi|2444120906|gb|CP115165.1| 328692 g2784 i0 84.308 11.2770167427702 650 78 99 7 8 657 700828 700203 Deinococcus aquaticus strain PB-314 chromosome, complete genome blastn 7409 614 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aquaticus
23380501 23380501 PRJNA431371_P_NODE_31179_length_246_cov_0.884393_g31106_i0 PRJNA431371 31179 246 0.884393 2.17560678 Thermus brockianus 56956 Bacteria Bacteria 265 2.62e-66   NTclustered gi|2199615985|dbj|AP025593.1| 56956 g31106 i0 94.253 34.9349593495935 174 8 99 2 72 244 1657831 1658003 Thermus brockianus SNM4-1 DNA, complete genome blastn 8594 265 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus brockianus

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