contig_metadata
19 rows where bioproject = "PRJNA980839" and tax_kingdom = "Thermotogati"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 958681 | 958681 | PRJNA980839_P_NODE_213161_length_247_cov_0.885057_g209377_i0 | PRJNA980839 | 213161 | 247 | 0.885057 | 2.18609079 | Thermus thermophilus | 274 | Bacteria | Bacteria | 451 | 1.88e-122 | NTclustered | gi|2199613261|dbj|AP025596.1| | 274 | g209377 | i0 | 99.595 | 84.6923076923077 | 247 | 1 | 100 | 0 | 1 | 247 | 1061706 | 1061952 | Thermus thermophilus SNM1-1 DNA, complete genome | blastn | 20919 | 451 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus thermophilus | ||
| 2234341 | 2234341 | PRJNA980839_P_NODE_229862_length_243_cov_0.905882_g226078_i0 | PRJNA980839 | 229862 | 243 | 0.905882 | 2.20129326 | Deinococcus ficus | 317577 | Bacteria | Bacteria | 438 | 1.4399999999999996e-118 | NTclustered | gi|1220362168|gb|CP021081.1| | 317577 | g226078 | i0 | 99.177 | 11.0411522633745 | 243 | 2 | 100 | 0 | 1 | 243 | 2734729 | 2734487 | Deinococcus ficus strain CC-FR2-10, complete genome | blastn | 2683 | 438 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus ficus | ||
| 4787314 | 4787314 | PRJNA980839_P_NODE_238984_length_241_cov_0.916667_g235200_i0 | PRJNA980839 | 238984 | 241 | 0.916667 | 2.20916747 | Deinococcus wulumuqiensis | 980427 | Bacteria | Bacteria | 446 | 8.519999999999999e-121 | NTclustered | gi|1819261009|gb|CP049357.1| | 1288484 | g235200 | i0 | 100 | 27.5186721991701 | 241 | 0 | 100 | 0 | 1 | 241 | 1633223 | 1633463 | Deinococcus wulumuqiensis R12 chromosome, complete genome | blastn | 6632 | 446 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus wulumuqiensis | ||
| 7648451 | 7648451 | PRJNA980839_P_NODE_38646_length_755_cov_1.601173_g35087_i0 | PRJNA980839 | 38646 | 755 | 1.601173 | 12.08885615 | Deinococcus | 1298 | Bacteria | Bacteria | 1223 | 0 | NTclustered | gi|2095695476|gb|OK149243.1| | 47478 | g35087 | i0 | 96.016 | 103.592052980132 | 753 | 28 | 99 | 2 | 3 | 755 | 845 | 95 | Deinococcus sp. strain ATSAR 16S ribosomal RNA gene, partial sequence | blastn | 78212 | 1229 | 0.995117982099268 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. | ||
| 9887410 | 9887410 | PRJNA980839_P_NODE_245728_length_227_cov_4.519481_g241944_i0 | PRJNA980839 | 245728 | 227 | 4.519481 | 10.25922187 | Deinococcus ficus | 317577 | Bacteria | Bacteria | 420 | 4.81e-113 | NTclustered | gi|1220362168|gb|CP021081.1| | 317577 | g241944 | i0 | 100 | 199.193832599119 | 227 | 0 | 100 | 0 | 1 | 227 | 2342314 | 2342088 | Deinococcus ficus strain CC-FR2-10, complete genome | blastn | 45217 | 420 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus ficus | ||
| 11160809 | 11160809 | PRJNA980839_P_NODE_148729_length_288_cov_1.711628_g144945_i0 | PRJNA980839 | 148729 | 288 | 1.711628 | 4.92948864 | Deinococcus puniceus | 1182568 | Bacteria | Bacteria | 505 | 1.7e-138 | NTclustered | gi|1028459476|gb|CP011387.1| | 1182568 | g144945 | i0 | 98.27 | 285.243055555556 | 289 | 3 | 100 | 2 | 1 | 288 | 71295 | 71008 | Deinococcus puniceus strain DY1, complete genome | blastn | 82150 | 505 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus puniceus | ||
| 11161375 | 11161375 | PRJNA980839_P_NODE_176609_length_265_cov_1.614583_g172825_i0 | PRJNA980839 | 176609 | 265 | 1.614583 | 4.27864495 | Deinococcus aquaticus | 328692 | Bacteria | Bacteria | 424 | 4.46e-114 | NTclustered | gi|2444120906|gb|CP115165.1| | 328692 | g172825 | i0 | 95.472 | 246.675471698113 | 265 | 12 | 100 | 0 | 1 | 265 | 716208 | 715944 | Deinococcus aquaticus strain PB-314 chromosome, complete genome | blastn | 65369 | 424 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus aquaticus | ||
| 11162911 | 11162911 | PRJNA980839_P_NODE_37349_length_778_cov_3.397163_g33821_i0 | PRJNA980839 | 37349 | 778 | 3.397163 | 26.42992814 | Deinococcus sp. AB2017081 | 3093660 | Bacteria | Bacteria | 326 | 4.16e-84 | NTclustered | gi|2636772554|gb|CP140099.1| | 3093660 | g33821 | i0 | 81.055 | 4.43701799485861 | 417 | 71 | 53 | 8 | 325 | 737 | 51824 | 51412 | Deinococcus sp. AB2017081 plasmid unnamed1, complete sequence | blastn | 3452 | 326 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. AB2017081 | ||
| 14985374 | 14985374 | PRJNA980839_P_NODE_152292_length_285_cov_1.438679_g148508_i0 | PRJNA980839 | 152292 | 285 | 1.438679 | 4.10023515 | Deinococcus aetherius | 200252 | Bacteria | Bacteria | 165 | 3.2400000000000004e-36 | NTclustered | gi|2281894955|dbj|AP026560.1| | 200252 | g148508 | i0 | 79.583 | 0.842105263157895 | 240 | 41 | 83 | 5 | 37 | 272 | 2205019 | 2204784 | Deinococcus aetherius ST0316 DNA, complete genome | blastn | 240 | 165 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus aetherius | ||
| 14986604 | 14986604 | PRJNA980839_P_NODE_214372_length_247_cov_0.885057_g210588_i0 | PRJNA980839 | 214372 | 247 | 0.885057 | 2.18609079 | Deinococcus sp. D7000 | 2755035 | Bacteria | Bacteria | 412 | 8.89e-111 | NTclustered | gi|1868561018|gb|CP058534.1| | 2755035 | g210588 | i0 | 96.761 | 1 | 247 | 8 | 100 | 0 | 1 | 247 | 2549465 | 2549711 | Deinococcus sp. D7000 chromosome, complete genome | blastn | 247 | 412 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. D7000 | ||
| 14986959 | 14986959 | PRJNA980839_P_NODE_233152_length_242_cov_0.911243_g229368_i0 | PRJNA980839 | 233152 | 242 | 0.911243 | 2.20520806 | Deinococcus aetherius | 200252 | Bacteria | Bacteria | 339 | 1.49e-88 | NTclustered | gi|2281898193|dbj|AP026561.1| | 200252 | g229368 | i0 | 92.083 | 5.67355371900826 | 240 | 19 | 99 | 0 | 3 | 242 | 71557 | 71318 | Deinococcus aetherius ST0316 plasmid pDAETH-1 DNA, complete genome | blastn | 1373 | 339 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus aetherius | ||
| 21360172 | 21360172 | PRJNA980839_P_NODE_182557_length_261_cov_1.308511_g178773_i0 | PRJNA980839 | 182557 | 261 | 1.308511 | 3.41521371 | Deinococcus actinosclerus | 1768108 | Bacteria | Bacteria | 466 | 7.17e-127 | NTclustered | gi|972944657|gb|CP013910.1| | 1768108 | g178773 | i0 | 98.851 | 18.5862068965517 | 261 | 3 | 100 | 0 | 1 | 261 | 2224267 | 2224007 | Deinococcus actinosclerus strain BM2 chromosome, complete genome | blastn | 4851 | 466 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus actinosclerus | ||
| 23911673 | 23911673 | PRJNA980839_P_NODE_235179_length_242_cov_0.911243_g231395_i0 | PRJNA980839 | 235179 | 242 | 0.911243 | 2.20520806 | Thermus parvatiensis | 456163 | Bacteria | Bacteria | 448 | 2.3799999999999995e-121 | NTclustered | gi|982540758|gb|CP014142.1| | 456163 | g231395 | i0 | 100 | 17 | 242 | 0 | 100 | 0 | 1 | 242 | 24958 | 24717 | Thermus parvatiensis strain RL plasmid pTP143, complete sequence | blastn | 4114 | 448 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus parvatiensis | ||
| 24221991 | 24221991 | PRJNA980839_P_NODE_237499_length_241_cov_0.916667_g233715_i0 | PRJNA980839 | 237499 | 241 | 0.916667 | 2.20916747 | Thermus | 270 | Bacteria | Bacteria | 435 | 1.84e-117 | NTclustered | gi|982539283|gb|CP014141.1| | 456163 | g233715 | i0 | 99.17 | 37.6473029045643 | 241 | 2 | 100 | 0 | 1 | 241 | 485469 | 485709 | Thermus parvatiensis strain RL, complete genome | blastn | 9073 | 435 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus parvatiensis | ||
| 28005658 | 28005658 | PRJNA980839_P_NODE_235245_length_242_cov_0.911243_g231461_i0 | PRJNA980839 | 235245 | 242 | 0.911243 | 2.20520806 | uncultured Truepera sp. | 543023 | Bacteria | Bacteria | 42 | 0.0461 | NR | CAA9558971.1 | 543023 | g231461 | i0 | 58.6 | 0.359504132231405 | 29 | 12 | 36 | 0 | 89 | 3 | 1 | 29 | CAA9558971.1 MAG: Two-component transcriptional response regulator, LuxR family [uncultured Truepera sp.] | diamond | 87 | 42 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | uncultured Truepera sp. | ||
| 28194658 | 28194658 | PRJNA980839_P_NODE_159806_length_278_cov_3.292683_g156022_i0 | PRJNA980839 | 159806 | 278 | 3.292683 | 9.15365874 | Deinococcus aestuarii | 2774531 | Bacteria | Bacteria | 147 | 1.32e-38 | NR | WP_216326300.1 | 2774531 | g156022 | i0 | 71.7 | 2.9568345323741 | 92 | 26 | 99.3 | 0 | 3 | 278 | 115 | 206 | WP_216326300.1 glycoside hydrolase family 78 protein [Deinococcus aestuarii] | diamond | 822 | 147 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus aestuarii | ||
| 29205432 | 29205432 | PRJNA980839_P_NODE_206369_length_249_cov_0.875000_g202585_i0 | PRJNA980839 | 206369 | 249 | 0.875 | 2.17875 | Thermus brockianus | 56956 | Bacteria | Bacteria | 42.7 | 0.0325 | NR | WP_244363896.1 | 56956 | g202585 | i0 | 36.4 | 0.662650602409639 | 55 | 28 | 66.3 | 1 | 15 | 179 | 62 | 109 | WP_244363896.1 nickel permease [Thermus brockianus] | diamond | 165 | 42.7 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus brockianus | ||
| 30279422 | 30279422 | PRJNA980839_P_NODE_247812_length_200_cov_4.362205_g244028_i0 | PRJNA980839 | 247812 | 200 | 4.362205 | 8.72441 | Deinococcus budaensis | 1665626 | Bacteria | Bacteria | 112 | 8.54e-27 | NR | WP_343057851.1 | 1665626 | g244028 | i0 | 87.9 | 0.99 | 66 | 8 | 99 | 0 | 1 | 198 | 136 | 201 | WP_343057851.1 replication restart helicase PriA [Deinococcus budaensis] | diamond | 198 | 112 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus budaensis | ||
| 32681336 | 32681336 | PRJNA980839_P_NODE_223020_length_245_cov_0.895349_g219236_i0 | PRJNA980839 | 223020 | 245 | 0.895349 | 2.19360505 | Meiothermus hypogaeus | 884155 | Bacteria | Bacteria | 68.2 | 1.01e-11 | NR | WP_244947016.1 | 884155 | g219236 | i0 | 48.6 | 0.857142857142857 | 70 | 34 | 85.7 | 1 | 231 | 22 | 130 | 197 | WP_244947016.1 DUF6423 family protein [Meiothermus hypogaeus] | diamond | 210 | 68.2 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Meiothermus | Meiothermus hypogaeus |
Advanced export
JSON shape: default, array, newline-delimited
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);;