contig_metadata
9 rows where bioproject = "PRJNA789095" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2047759 | 2047759 | PRJNA789095_P_NODE_81382_length_207_cov_4.671642_g80048_i0 | PRJNA789095 | 81382 | 207 | 4.671642 | 9.67029894 | Deinococcus geothermalis | 68909 | Bacteria | Bacteria | 383 | 5.65e-102 | NTclustered | gi|110746139|gb|CP000358.2| | 319795 | g80048 | i0 | 100 | 1 | 207 | 0 | 100 | 0 | 1 | 207 | 327239 | 327445 | Deinococcus geothermalis DSM 11300 plasmid pDGEO01, complete sequence | blastn | 207 | 383 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus geothermalis | ||
| 12251048 | 12251048 | PRJNA789095_P_NODE_70710_length_246_cov_0.890173_g69376_i0 | PRJNA789095 | 70710 | 246 | 0.890173 | 2.18982558 | Deinococcus metallilatus | 1211322 | Bacteria | Bacteria | 344 | 3.27e-90 | NTclustered | gi|1609451317|gb|CP038512.1| | 1211322 | g69376 | i0 | 91.87 | 59.2926829268293 | 246 | 20 | 100 | 0 | 1 | 246 | 2590117 | 2589872 | Deinococcus metallilatus strain MA1002 chromosome | blastn | 14586 | 344 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus metallilatus | ||
| 13968459 | 13968459 | PRJNA789095_P_NODE_71591_length_245_cov_1.476744_g70257_i0 | PRJNA789095 | 71591 | 245 | 1.476744 | 3.6180228 | Truepera | 332248 | Bacteria | Bacteria | 206 | 1.6e-48 | NTclustered | gi|2573973991|gb|CP133611.1| | 332249 | g70257 | i0 | 84.541 | 1.70204081632653 | 207 | 32 | 84 | 0 | 35 | 241 | 684096 | 684302 | Truepera radiovictrix strain CIP 108686 chromosome, complete genome | blastn | 417 | 206 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | Truepera radiovictrix | ||
| 16074384 | 16074384 | PRJNA789095_P_NODE_81613_length_204_cov_6.175573_g80279_i0 | PRJNA789095 | 81613 | 204 | 6.175573 | 12.59816892 | Deinococcus psychrotolerans | 2489213 | Bacteria | Bacteria | 54.7 | 0.005 | NTclustered | gi|1527207915|gb|CP034189.1| | 2489213 | g80279 | i0 | 94.286 | 0.17156862745098 | 35 | 2 | 17 | 0 | 136 | 170 | 24867 | 24833 | Deinococcus psychrotolerans strain S14-83 plasmid unnamed5, complete sequence | blastn | 35 | 54.7 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus psychrotolerans | ||
| 16517440 | 16517440 | PRJNA789095_P_NODE_77973_length_232_cov_11.100629_g76639_i0 | PRJNA789095 | 77973 | 232 | 11.100629 | 25.75345928 | Thermus | 270 | Bacteria | Bacteria | 429 | 8.2e-116 | NTclustered | gi|2199643112|dbj|AP025618.1| | 274 | g76639 | i0 | 100 | 6 | 232 | 0 | 100 | 0 | 1 | 232 | 84820 | 84589 | Thermus thermophilus SNM7-6 plasmid pTthSNM7-6b DNA, complete sequence | blastn | 1392 | 429 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus thermophilus | ||
| 24997121 | 24997121 | PRJNA789095_P_NODE_42100_length_310_cov_3.021097_g40766_i0 | PRJNA789095 | 42100 | 310 | 3.021097 | 9.3654007 | Thermus | 270 | Bacteria | Bacteria | 73.6 | 3.41e-13 | NR | MFN3369850.1 | 275 | g40766 | i0 | 68.1 | 1.88709677419355 | 47 | 15 | 45.5 | 0 | 170 | 310 | 129 | 175 | MFN3369850.1 hypothetical protein [Thermus sp.] | diamond | 585 | 73.6 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Thermus | Thermus sp. | ||
| 24997952 | 24997952 | PRJNA789095_P_NODE_70120_length_247_cov_0.885057_g68786_i0 | PRJNA789095 | 70120 | 247 | 0.885057 | 2.18609079 | Deinococcus geothermalis | 68909 | Bacteria | Bacteria | 379 | 9.02e-101 | NTclustered | gi|94554390|gb|CP000359.1| | 319795 | g68786 | i0 | 94.332 | 4.40485829959514 | 247 | 14 | 100 | 0 | 1 | 247 | 1104034 | 1103788 | Deinococcus geothermalis DSM 11300, complete genome | blastn | 1088 | 379 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus geothermalis | ||
| 30179979 | 30179979 | PRJNA789095_P_NODE_51172_length_283_cov_1.357143_g49838_i0 | PRJNA789095 | 51172 | 283 | 1.357143 | 3.84071469 | Deinococcus enclensis | 1049582 | Bacteria | Bacteria | 143 | 3.0899999999999997e-37 | NR | WP_307467582.1 | 1049582 | g49838 | i0 | 71.7 | 0.975265017667845 | 92 | 26 | 97.5 | 0 | 3 | 278 | 725 | 816 | WP_307467582.1 DUF4157 domain-containing protein [Deinococcus enclensis] | diamond | 276 | 143 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus enclensis | ||
| 31381101 | 31381101 | PRJNA789095_P_NODE_67276_length_250_cov_0.870056_g65942_i0 | PRJNA789095 | 67276 | 250 | 0.870056 | 2.17514 | uncultured Truepera sp. | 543023 | Bacteria | Bacteria | 140 | 2.67e-37 | NR | CAA9589084.1 | 543023 | g65942 | i0 | 83.1 | 0.996 | 83 | 14 | 99.6 | 0 | 249 | 1 | 156 | 238 | CAA9589084.1 MAG: Probable poly(beta-D-mannuronate) O-acetylase [uncultured Truepera sp.] | diamond | 249 | 140 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Truepera | uncultured Truepera 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);;