contig_metadata
9 rows where bioproject = "PRJNA631119" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7529758 | 7529758 | PRJNA631119_P_NODE_27226_length_264_cov_1.560209_g27108_i0 | PRJNA631119 | 27226 | 264 | 1.560209 | 4.11895176 | root | 1 | Root_unresolved | Root_unresolved | 488 | 1.5499999999999999e-133 | NTclustered | gi|155128|gb|J04639.1|TTHTAQP1A | 271 | g27108 | i0 | 100 | 55.5416666666667 | 264 | 0 | 100 | 0 | 1 | 264 | 1713 | 1450 | Thermus aquaticus DNA polymerase (PolI) gene | blastn | 14663 | 488 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus aquaticus | ||
| 8804844 | 8804844 | PRJNA631119_P_NODE_29747_length_254_cov_2.701657_g29629_i0 | PRJNA631119 | 29747 | 254 | 2.701657 | 6.86220878 | Bacteria | 2 | Bacteria | Bacteria | 470 | 5.37e-128 | NTclustered | gi|155128|gb|J04639.1|TTHTAQP1A | 271 | g29629 | i0 | 100 | 47.8976377952756 | 254 | 0 | 100 | 0 | 1 | 254 | 792 | 539 | Thermus aquaticus DNA polymerase (PolI) gene | blastn | 12166 | 470 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus aquaticus | ||
| 10080324 | 10080324 | PRJNA631119_P_NODE_27048_length_265_cov_1.109375_g26930_i0 | PRJNA631119 | 27048 | 265 | 1.109375 | 2.93984375 | Aminithiophilus | 3029078 | Bacteria | Bacteria | 135 | 2.3400000000000003e-27 | NTclustered | gi|2041259188|gb|CP074691.1| | 2268202 | g26930 | i0 | 78.605 | 11.3698113207547 | 215 | 38 | 80 | 8 | 1 | 211 | 825111 | 825321 | Synergistota bacterium strain L-13 chromosome, complete genome | blastn | 3013 | 135 | 1 | Bacteria | Thermotogati | Synergistota | Synergistota bacterium | ||||||
| 11355212 | 11355212 | PRJNA631119_P_NODE_19289_length_301_cov_1.276316_g19171_i0 | PRJNA631119 | 19289 | 301 | 1.276316 | 3.84171116 | Mesotoga sp. | 2053577 | Bacteria | Bacteria | 155 | 3.559999999999999e-42 | NR | MCB1222954.1 | 2053577 | g19171 | i0 | 71 | 0.996677740863787 | 100 | 29 | 99.7 | 0 | 1 | 300 | 129 | 228 | MCB1222954.1 molecular chaperone DnaK [Mesotoga sp.] | diamond | 300 | 155 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Kosmotogales | Kosmotogaceae | Mesotoga | Mesotoga sp. | ||
| 14632243 | 14632243 | PRJNA631119_P_NODE_5252_length_496_cov_3.016548_g5134_i0 | PRJNA631119 | 5252 | 496 | 3.016548 | 14.96207808 | Deinococcus ficus | 317577 | Bacteria | Bacteria | 54.7 | 0.013 | NTclustered | gi|1220365708|gb|CP021084.1| | 317577 | g5134 | i0 | 100 | 0.0584677419354839 | 29 | 0 | 6 | 0 | 182 | 210 | 134507 | 134479 | Deinococcus ficus strain CC-FR2-10 plasmid pDFI3, complete sequence | blastn | 29 | 54.7 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus ficus | ||
| 27472710 | 27472710 | PRJNA631119_P_NODE_35883_length_245_cov_0.895349_g35765_i0 | PRJNA631119 | 35883 | 245 | 0.895349 | 2.19360505 | FCB group | 1783270 | Bacteria | Bacteria | 45.1 | 0.00541 | NR | MEY4529876.1 | 1913990 | g35765 | i0 | 32.1 | 1.93469387755102 | 78 | 51 | 93.1 | 1 | 1 | 228 | 47 | 124 | MEY4529876.1 hypothetical protein [Deinococcota bacterium] | diamond | 474 | 45.1 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococcota bacterium | ||||||
| 27757079 | 27757079 | PRJNA631119_P_NODE_32624_length_249_cov_0.875000_g32506_i0 | PRJNA631119 | 32624 | 249 | 0.875 | 2.17875 | Bacteria | 2 | Bacteria | Bacteria | 127 | 6.12e-33 | NR | WP_110886524.1 | 309889 | g32506 | i0 | 69.9 | 7.98795180722892 | 83 | 25 | 100 | 0 | 249 | 1 | 247 | 329 | WP_110886524.1 acyl-CoA dehydrogenase family protein [Deinococcus yavapaiensis] | diamond | 1989 | 128 | 0.9921875 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus yavapaiensis | ||
| 28407369 | 28407369 | PRJNA631119_P_NODE_22806_length_283_cov_1.428571_g22688_i0 | PRJNA631119 | 22806 | 283 | 1.428571 | 4.04285593 | Thermotogaceae bacterium | 2268206 | Bacteria | Bacteria | 45.4 | 0.00307 | NR | MDI3471901.1 | 2268206 | g22688 | i0 | 32.9 | 0.80565371024735 | 76 | 49 | 79.5 | 2 | 17 | 241 | 4 | 78 | MDI3471901.1 uncharacterized protein [Thermotogaceae bacterium] | diamond | 228 | 45.4 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Thermotogaceae | Thermotogaceae bacterium | |||
| 31072996 | 31072996 | PRJNA631119_P_NODE_36015_length_245_cov_0.895349_g35897_i0 | PRJNA631119 | 36015 | 245 | 0.895349 | 2.19360505 | FCB group | 1783270 | Bacteria | Bacteria | 57 | 3.62e-7 | NR | MDX2007146.1 | 1955249 | g35897 | i0 | 42.5 | 2.75510204081633 | 80 | 40 | 98 | 1 | 245 | 6 | 126 | 199 | MDX2007146.1 G8 domain-containing protein [Meiothermus sp.] | diamond | 675 | 57 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Meiothermus | Meiothermus sp. |
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);;