RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "blastn", bioproject = "PRJNA674308" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermotogati · 16 ✖

bioproject 1

  • PRJNA674308 · 16 ✖

analysis 1

  • blastn · 16 ✖

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
644731 644731 PRJNA674308_P_NODE_39661_length_168_cov_0.873950_g39426_i0 PRJNA674308 39661 168 0.87395 1.468236 Deinococcus geothermalis 68909 Bacteria Bacteria 311 2.11e-80   NTclustered gi|94554390|gb|CP000359.1| 319795 g39426 i0 100 19.7559523809524 168 0 100 0 1 168 1963376 1963543 Deinococcus geothermalis DSM 11300, complete genome blastn 3319 311 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus geothermalis
1166801 1166801 PRJNA674308_P_NODE_54861_length_152_cov_2.019417_g54626_i0 PRJNA674308 54861 152 2.019417 3.06951384 Thermus 270 Bacteria Bacteria 281 1.46e-71   NTclustered gi|1614035142|gb|MH827728.1| 275 g54626 i0 100 103 152 0 100 0 1 152 714 563 Thermus sp. strain 1814-2 16S ribosomal RNA gene, partial sequence blastn 15656 281 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus sp.
1920902 1920902 PRJNA674308_P_NODE_38462_length_168_cov_0.873950_g38227_i0 PRJNA674308 38462 168 0.87395 1.468236 Allomeiothermus silvanus 52022 Bacteria Bacteria 302 1.27e-77   NTclustered gi|296848933|gb|CP002042.1| 526227 g38227 i0 99.398 1.44047619047619 166 1 99 0 1 166 1688184 1688349 Meiothermus silvanus DSM 9946, complete genome blastn 242 302 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Allomeiothermus Allomeiothermus silvanus
3195797 3195797 PRJNA674308_P_NODE_53623_length_162_cov_0.920354_g53388_i0 PRJNA674308 53623 162 0.920354 1.49097348 Allomeiothermus silvanus 52022 Bacteria Bacteria 300 4.36e-77   NTclustered gi|296848933|gb|CP002042.1| 526227 g53388 i0 100 1 162 0 100 0 1 162 2092760 2092599 Meiothermus silvanus DSM 9946, complete genome blastn 162 300 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Allomeiothermus Allomeiothermus silvanus
4472682 4472682 PRJNA674308_P_NODE_27164_length_192_cov_3.125874_g26929_i0 PRJNA674308 27164 192 3.125874 6.00167808 Deinococcus ficus 317577 Bacteria Bacteria 350 5.24e-92   NTclustered gi|1220362168|gb|CP021081.1| 317577 g26929 i0 99.479 202.635416666667 192 1 100 0 1 192 2342485 2342294 Deinococcus ficus strain CC-FR2-10, complete genome blastn 38906 350 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus ficus
5748137 5748137 PRJNA674308_P_NODE_21805_length_212_cov_1.588957_g21570_i0 PRJNA674308 21805 212 1.588957 3.36858884 Thermus sp. NEB1569 2918899 Bacteria Bacteria 375 9.74e-100   NTclustered gi|2199052145|gb|CP092445.1| 2918899 g21570 i0 98.585 144.646226415094 212 3 100 0 1 212 410735 410946 Thermus sp. NEB1569 chromosome, complete genome blastn 30665 375 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus sp. NEB1569
9573316 9573316 PRJNA674308_P_NODE_36468_length_169_cov_0.866667_g36233_i0 PRJNA674308 36468 169 0.866667 1.46466723 Deinococcus sp. VB343 3385567 Bacteria Bacteria 274 2.7699999999999997e-69   NTclustered gi|2905211496|gb|CP179945.1| 3385567 g36233 i0 95.858 5.01183431952663 169 7 100 0 1 169 254173 254341 Deinococcus sp. VB343 chromosome 1, complete sequence blastn 847 274 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. VB343
12124156 12124156 PRJNA674308_P_NODE_44490_length_165_cov_2.689655_g44255_i0 PRJNA674308 44490 165 2.689655 4.43793075 Deinococcus ficus 317577 Bacteria Bacteria 231 1.65e-56   NTclustered gi|1220362168|gb|CP021081.1| 317577 g44255 i0 93.038 48.3757575757576 158 11 96 0 8 165 2340806 2340963 Deinococcus ficus strain CC-FR2-10, complete genome blastn 7982 231 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus ficus
13398895 13398895 PRJNA674308_P_NODE_42731_length_166_cov_0.888889_g42496_i0 PRJNA674308 42731 166 0.888889 1.47555574 Deinococcus grandis 57498 Bacteria Bacteria 259 7.63e-65   NTclustered gi|1751871007|dbj|AP021849.1| 57498 g42496 i0 95.122 34.1506024096386 164 8 99 0 3 166 1103762 1103599 Deinococcus grandis ATCC 43672 DNA, complete genome blastn 5669 259 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus grandis
14673696 14673696 PRJNA674308_P_NODE_23072_length_207_cov_1.316456_g22837_i0 PRJNA674308 23072 207 1.316456 2.72506392 Deinococcus sp. NW-56 2080419 Bacteria Bacteria 335 1.6099999999999997e-87   NTclustered gi|1339790003|gb|CP026516.1| 2080419 g22837 i0 96.098 174.80193236715 205 8 99 0 1 205 544408 544612 Deinococcus sp. NW-56 chromosome, complete genome blastn 36184 335 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. NW-56
14673985 14673985 PRJNA674308_P_NODE_7392_length_349_cov_24.860000_g7157_i0 PRJNA674308 7392 349 24.86 86.7614 Deinococcus soli (ex Cha et al. 2016) 1309411 Bacteria Bacteria 527 4.489999999999998e-145   NTclustered gi|821341785|gb|CP011389.1| 1309411 g7157 i0 100 162.885386819484 285 0 94 0 1 285 1636409 1636125 'Deinococcus soli' Cha et al. 2014 strain N5, complete genome blastn 56847 527 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus soli (ex Cha et al. 2016)
15947226 15947226 PRJNA674308_P_NODE_13193_length_264_cov_3.460465_g12958_i0 PRJNA674308 13193 264 3.460465 9.1356276 Deinococcus ficus 317577 Bacteria Bacteria 488 1.5499999999999999e-133   NTclustered gi|1220362168|gb|CP021081.1| 317577 g12958 i0 100 179.450757575758 264 0 100 0 1 264 2342789 2342526 Deinococcus ficus strain CC-FR2-10, complete genome blastn 47375 488 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus ficus
18497000 18497000 PRJNA674308_P_NODE_18655_length_226_cov_2.497175_g18420_i0 PRJNA674308 18655 226 2.497175 5.6436155 Deinococcus ficus 317577 Bacteria Bacteria 281 2.36e-71   NTclustered gi|1220362168|gb|CP021081.1| 317577 g18420 i0 89.381 255.924778761062 226 21 99 3 3 226 2342768 2342992 Deinococcus ficus strain CC-FR2-10, complete genome blastn 57839 281 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus ficus
20292884 20292884 PRJNA674308_P_NODE_18256_length_228_cov_8.329609_g18021_i0 PRJNA674308 18256 228 8.329609 18.99150852 Deinococcus 1298 Bacteria Bacteria 422 1.34e-113   NTclustered gi|1751871007|dbj|AP021849.1| 57498 g18021 i0 100 397.872807017544 228 0 100 0 1 228 74684 74457 Deinococcus grandis ATCC 43672 DNA, complete genome blastn 90715 422 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus grandis
21047189 21047189 PRJNA674308_P_NODE_23637_length_205_cov_1.185897_g23402_i0 PRJNA674308 23637 205 1.185897 2.43108885 Allomeiothermus silvanus 52022 Bacteria Bacteria 374 3.3599999999999997e-99   NTclustered gi|296848933|gb|CP002042.1| 526227 g23402 i0 99.512 1 205 1 100 0 1 205 2639930 2639726 Meiothermus silvanus DSM 9946, complete genome blastn 205 374 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Allomeiothermus Allomeiothermus silvanus
21047334 21047334 PRJNA674308_P_NODE_40337_length_167_cov_0.881356_g40102_i0 PRJNA674308 40337 167 0.881356 1.47186452 Meiothermus taiwanensis 172827 Bacteria Bacteria 298 1.63e-76   NTclustered gi|1395897361|gb|CP021131.1| 1339250 g40102 i0 98.802 1 167 2 100 0 1 167 218831 218665 Meiothermus taiwanensis WR-220 plasmid pMtWR-220, complete sequence blastn 167 298 1 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Meiothermus Meiothermus taiwanensis

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