RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA741997" 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

  • PRJNA741997 · 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
1997603 1997603 PRJNA741997_P_NODE_63362_length_270_cov_1.558376_g62242_i0 PRJNA741997 63362 270 1.558376 4.2076152 Thermus thermophilus 274 Bacteria Bacteria 316 7.95e-82   NTclustered gi|2074862859|dbj|AP024933.1| 274 g62242 i0 88.015 4.05925925925926 267 32 99 0 3 269 890444 890710 Thermus thermophilus AA3-7 DNA, complete genome blastn 1096 316 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus thermophilus
3749888 3749888 PRJNA741997_P_NODE_71883_length_251_cov_0.865169_g70763_i0 PRJNA741997 71883 251 0.865169 2.17157419 Thermus 270 Bacteria Bacteria 459 1.1499999999999996e-124   NTclustered gi|2049910225|gb|CP076325.1| 88190 g70763 i0 99.602 63.4223107569721 251 1 100 0 1 251 1137553 1137803 MAG: Thermus antranikianii isolate RBS10-92 chromosome, complete genome blastn 15919 459 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus antranikianii
7100281 7100281 PRJNA741997_P_NODE_63386_length_270_cov_1.487310_g62266_i0 PRJNA741997 63386 270 1.48731 4.015737 Meiothermus ruber 277 Bacteria Bacteria 477 3.4499999999999986e-130   NTclustered gi|290469363|gb|CP001743.1| 504728 g62266 i0 98.519 2.56296296296296 270 4 100 0 1 270 2925218 2924949 Meiothermus ruber DSM 1279, complete genome blastn 692 477 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Meiothermus Meiothermus ruber
11401851 11401851 PRJNA741997_P_NODE_56709_length_285_cov_1.452830_g55589_i0 PRJNA741997 56709 285 1.45283 4.1405655 Thermus 270 Bacteria Bacteria 510 3.61e-140   NTclustered gi|320149275|gb|CP001962.1| 743525 g55589 i0 98.947 5.99649122807018 285 3 100 0 1 285 2326372 2326656 Thermus scotoductus SA-01, complete genome blastn 1709 510 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus scotoductus
12200846 12200846 PRJNA741997_P_NODE_40130_length_343_cov_0.629630_g39010_i0 PRJNA741997 40130 343 0.62963 2.1596309 Deinococcus ficus 317577 Bacteria Bacteria 569 7.239999999999998e-158   NTclustered gi|1220362168|gb|CP021081.1| 317577 g39010 i0 97.321 215.763848396501 336 7 98 2 1 335 2341818 2342152 Deinococcus ficus strain CC-FR2-10, complete genome blastn 74007 569 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus ficus
12677769 12677769 PRJNA741997_P_NODE_84770_length_244_cov_0.900585_g83650_i0 PRJNA741997 84770 244 0.900585 2.1974274 Deinococcus 1298 Bacteria Bacteria 440 4.019999999999999e-119   NTclustered gi|2706837832|gb|CP149782.1| 3112952 g83650 i0 99.18 165.573770491803 244 2 100 0 1 244 1455345 1455102 Deinococcus sp. VB142 chromosome 1, complete sequence blastn 40400 440 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. VB142

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