contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA415856" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20209649 | 20209649 | PRJNA415856_P_NODE_28516_length_177_cov_1.265625_g28255_i0 | PRJNA415856 | 28516 | 177 | 1.265625 | 2.24015625 | Deinococcus sedimenti | 1867090 | Bacteria | Bacteria | 85.9 | 1.04e-18 | NR | WP_308425475.1 | 1867090 | g28255 | i0 | 82.1 | 1.84745762711864 | 56 | 8 | 91.5 | 1 | 9 | 170 | 87 | 142 | WP_308425475.1 type IV pilin protein [Deinococcus sedimenti] | diamond | 327 | 85.9 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sedimenti | ||
| 27644466 | 27644466 | PRJNA415856_P_NODE_50484_length_162_cov_0.902655_g50223_i0 | PRJNA415856 | 50484 | 162 | 0.902655 | 1.4623011 | Thermosipho sp. (in: thermotogales) | 1968895 | Bacteria | Bacteria | 62.8 | 1.04e-9 | NR | WP_287568808.1 | 1968895 | g50223 | i0 | 54 | 0.925925925925926 | 50 | 21 | 90.7 | 2 | 149 | 3 | 451 | 499 | WP_287568808.1 hypothetical protein [Thermosipho sp. (in: thermotogales)] | diamond | 150 | 62.8 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Fervidobacteriaceae | Thermosipho | Thermosipho sp. (in: thermotogales) | ||
| 28023206 | 28023206 | PRJNA415856_P_NODE_19265_length_199_cov_1.106667_g19004_i0 | PRJNA415856 | 19265 | 199 | 1.106667 | 2.20226733 | Thermotoga sp. | 28240 | Bacteria | Bacteria | 103 | 1.16e-24 | NR | MDK2785653.1 | 28240 | g19004 | i0 | 74.2 | 1.9748743718593 | 66 | 17 | 99.5 | 0 | 1 | 198 | 222 | 287 | MDK2785653.1 hypothetical protein [Thermotoga sp.] | diamond | 393 | 103 | 1 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Thermotogaceae | Thermotoga | Thermotoga sp. | ||
| 28338905 | 28338905 | PRJNA415856_P_NODE_50206_length_162_cov_0.902655_g49945_i0 | PRJNA415856 | 50206 | 162 | 0.902655 | 1.4623011 | Truepera radiovictrix | 332249 | Bacteria | Bacteria | 84 | 3.62e-17 | NR | WP_049772926.1 | 332249 | g49945 | i0 | 75.9 | 1 | 54 | 13 | 100 | 0 | 162 | 1 | 356 | 409 | WP_049772926.1 NfeD family protein [Truepera radiovictrix] | diamond | 162 | 84 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | Truepera radiovictrix | ||
| 28370392 | 28370392 | PRJNA415856_P_NODE_51266_length_161_cov_1.464286_g51005_i0 | PRJNA415856 | 51266 | 161 | 1.464286 | 2.35750046 | Meiothermus sp. | 1955249 | Bacteria | Bacteria | 97.8 | 8.3e-23 | NR | MCX7740604.1 | 1955249 | g51005 | i0 | 98.1 | 0.987577639751553 | 53 | 1 | 98.8 | 0 | 159 | 1 | 121 | 173 | MCX7740604.1 AAA family ATPase [Meiothermus sp.] | diamond | 159 | 97.8 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Meiothermus | Meiothermus sp. | ||
| 28812163 | 28812163 | PRJNA415856_P_NODE_47408_length_163_cov_0.894737_g47147_i0 | PRJNA415856 | 47408 | 163 | 0.894737 | 1.45842131 | Allomeiothermus silvanus | 52022 | Bacteria | Bacteria | 114 | 3.07e-28 | NR | WP_276955696.1 | 52022 | g47147 | i0 | 96.3 | 0.993865030674847 | 54 | 2 | 99.4 | 0 | 163 | 2 | 183 | 236 | WP_276955696.1 glycoside hydrolase family 5 protein [Allomeiothermus silvanus] | diamond | 162 | 114 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Allomeiothermus | Allomeiothermus silvanus | ||
| 28938900 | 28938900 | PRJNA415856_P_NODE_468_length_1301_cov_6.999201_g380_i0 | PRJNA415856 | 468 | 1301 | 6.999201 | 91.05960501 | Cloacibacillus evryensis | 508460 | Bacteria | Bacteria | 97.1 | 1.38e-19 | NR | WP_256196152.1 | 508460 | g380 | i0 | 40 | 0.691775557263643 | 150 | 65 | 33.2 | 4 | 1297 | 866 | 48 | 178 | WP_256196152.1 phage tail protein [Cloacibacillus evryensis] | diamond | 900 | 97.1 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Synergistaceae | Cloacibacillus | Cloacibacillus evryensis | ||
| 29285951 | 29285951 | PRJNA415856_P_NODE_43989_length_164_cov_0.886957_g43728_i0 | PRJNA415856 | 43989 | 164 | 0.886957 | 1.45460948 | Meiothermus sp. | 1955249 | Bacteria | Bacteria | 88.2 | 1.46e-19 | NR | HEU4741687.1 | 1955249 | g43728 | i0 | 88.9 | 0.98780487804878 | 54 | 5 | 98.8 | 1 | 3 | 164 | 100 | 152 | HEU4741687.1 sulfite exporter TauE/SafE family protein [Meiothermus sp.] | diamond | 162 | 88.2 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Meiothermus | Meiothermus sp. | ||
| 30138369 | 30138369 | PRJNA415856_P_NODE_29972_length_174_cov_2.136000_g29711_i0 | PRJNA415856 | 29972 | 174 | 2.136 | 3.71664 | Allomeiothermus silvanus | 52022 | Bacteria | Bacteria | 113 | 6.17e-30 | NR | WP_276957852.1 | 52022 | g29711 | i0 | 93.1 | 2 | 58 | 4 | 100 | 0 | 174 | 1 | 26 | 83 | WP_276957852.1 hypothetical protein [Allomeiothermus silvanus] | diamond | 348 | 113 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Allomeiothermus | Allomeiothermus silvanus | ||
| 30549435 | 30549435 | PRJNA415856_P_NODE_26233_length_181_cov_1.462121_g25972_i0 | PRJNA415856 | 26233 | 181 | 1.462121 | 2.64643901 | Deinococcus budaensis | 1665626 | Bacteria | Bacteria | 59.7 | 5.04e-10 | NR | WP_184029402.1 | 1665626 | g25972 | i0 | 83.3 | 0.994475138121547 | 30 | 5 | 49.7 | 0 | 91 | 2 | 1 | 30 | WP_184029402.1 hypothetical protein [Deinococcus budaensis] | diamond | 180 | 59.7 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus budaensis | ||
| 30549440 | 30549440 | PRJNA415856_P_NODE_32793_length_170_cov_1.371901_g32532_i0 | PRJNA415856 | 32793 | 170 | 1.371901 | 2.3322317 | Trueperaceae bacterium | 2026798 | Bacteria | Bacteria | 73.2 | 5.51e-14 | NR | MDZ7704633.1 | 2026798 | g32532 | i0 | 62.5 | 0.988235294117647 | 56 | 21 | 98.8 | 0 | 169 | 2 | 145 | 200 | MDZ7704633.1 thioredoxin domain-containing protein [Trueperaceae bacterium] | diamond | 168 | 73.2 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Trueperaceae bacterium | |||
| 30612554 | 30612554 | PRJNA415856_P_NODE_51273_length_161_cov_1.455357_g51012_i0 | PRJNA415856 | 51273 | 161 | 1.455357 | 2.34312477 | Deinococcus marmoris | 249408 | Bacteria | Bacteria | 50.1 | 3.15e-5 | NR | WP_254843049.1 | 249408 | g51012 | i0 | 50.9 | 1.99378881987578 | 53 | 25 | 98.8 | 1 | 159 | 1 | 122 | 173 | WP_254843049.1 HesA/MoeB/ThiF family protein [Deinococcus marmoris] | diamond | 321 | 50.1 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus marmoris | ||
| 31561121 | 31561121 | PRJNA415856_P_NODE_26016_length_181_cov_1.984848_g25755_i0 | PRJNA415856 | 26016 | 181 | 1.984848 | 3.59257488 | Meiothermus sp. | 1955249 | Bacteria | Bacteria | 76.3 | 2.47e-14 | NR | MER3555590.1 | 1955249 | g25755 | i0 | 71.7 | 0.994475138121547 | 60 | 17 | 99.4 | 0 | 1 | 180 | 213 | 272 | MER3555590.1 sugar ABC transporter ATP-binding protein [Meiothermus sp.] | diamond | 180 | 76.3 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Meiothermus | Meiothermus sp. | ||
| 31655633 | 31655633 | PRJNA415856_P_NODE_24657_length_184_cov_1.400000_g24396_i0 | PRJNA415856 | 24657 | 184 | 1.4 | 2.576 | Deinococcus sp. | 47478 | Bacteria | Bacteria | 115 | 2.35e-31 | NR | MCL5965451.1 | 47478 | g24396 | i0 | 100 | 0.978260869565217 | 60 | 0 | 97.8 | 0 | 182 | 3 | 56 | 115 | MCL5965451.1 histone deacetylase [Deinococcus sp.] | diamond | 180 | 115 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus 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);;