RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJNA289590" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermotogati · 8 ✖

bioproject 1

  • PRJNA289590 · 8 ✖

analysis 1

  • blastn · 8 ✖

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
1059458 1059458 PRJNA289590_P_NODE_29281_length_165_cov_0.896552_g29057_i0 PRJNA289590 29281 165 0.896552 1.4793108 Thermus 270 Bacteria Bacteria 281 1.62e-71   NTclustered gi|2199613261|dbj|AP025596.1| 274 g29057 i0 98.742 36.3636363636364 159 1 96 1 7 165 1966374 1966217 Thermus thermophilus SNM1-1 DNA, complete genome blastn 6000 281 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus thermophilus
2334674 2334674 PRJNA289590_P_NODE_27082_length_168_cov_0.873950_g26858_i0 PRJNA289590 27082 168 0.87395 1.468236 Thermus 270 Bacteria Bacteria 279 5.95e-71   NTclustered gi|1955386990|dbj|AP024305.1| 274 g26858 i0 98.734 35.2976190476191 158 1 93 1 1 157 1634335 1634178 Thermus thermophilus HB5008 DNA, complete genome blastn 5930 279 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus thermophilus
2334684 2334684 PRJNA289590_P_NODE_28922_length_165_cov_0.896552_g28698_i0 PRJNA289590 28922 165 0.896552 1.4793108 Truepera 332248 Bacteria Bacteria 202 1.29e-47   NTclustered gi|470486385|ref|NR_076754.1| 332249 g28698 i0 88.623 246.072727272727 167 17 100 1 1 165 2227 2061 Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence blastn 40602 202 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera Truepera radiovictrix
2923350 2923350 PRJNA289590_P_NODE_29363_length_165_cov_0.862069_g29139_i0 PRJNA289590 29363 165 0.862069 1.42241385 Oceanithermus profundus 187137 Bacteria Bacteria 54.7 0.004   NTclustered gi|313151615|gb|CP002361.1| 670487 g29139 i0 100 0.175757575757576 29 0 18 0 131 159 1661760 1661788 Oceanithermus profundus DSM 14977, complete genome blastn 29 54.7 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Oceanithermus Oceanithermus profundus
4887390 4887390 PRJNA289590_P_NODE_30504_length_163_cov_0.912281_g30280_i0 PRJNA289590 30504 163 0.912281 1.48701803 Thermus 270 Bacteria Bacteria 291 2.64e-74   NTclustered gi|1886399087|gb|CP053287.1| 274 g30280 i0 98.773 44.8282208588957 163 2 100 0 1 163 1825857 1826019 Thermus thermophilus strain HB27c chromosome blastn 7307 291 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus thermophilus
6162243 6162243 PRJNA289590_P_NODE_30985_length_162_cov_0.920354_g30761_i0 PRJNA289590 30985 162 0.920354 1.49097348 Thermus 270 Bacteria Bacteria 300 4.36e-77   NTclustered gi|1886399087|gb|CP053287.1| 274 g30761 i0 100 45.9135802469136 162 0 100 0 1 162 1054717 1054878 Thermus thermophilus strain HB27c chromosome blastn 7438 300 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus thermophilus
8712124 8712124 PRJNA289590_P_NODE_27067_length_168_cov_0.873950_g26843_i0 PRJNA289590 27067 168 0.87395 1.468236 Thermus 270 Bacteria Bacteria 311 2.11e-80   NTclustered gi|2090196584|gb|CP082323.1| 274 g26843 i0 100 30.9642857142857 168 0 100 0 1 168 921517 921350 Thermus thermophilus strain N-1 chromosome, complete genome blastn 5202 311 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus thermophilus
14401470 14401470 PRJNA289590_P_NODE_20612_length_196_cov_1.054422_g20388_i0 PRJNA289590 20612 196 1.054422 2.06666712 Deinococcus soli (ex Cha et al. 2016) 1309411 Bacteria Bacteria 335 1.5e-87   NTclustered gi|821341785|gb|CP011389.1| 1309411 g20388 i0 97.462 180.964285714286 197 3 100 2 1 196 1637533 1637338 'Deinococcus soli' Cha et al. 2014 strain N5, complete genome blastn 35469 335 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus soli (ex Cha et al. 2016)

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