contig_metadata
11 rows where bioproject = "PRJNA846486" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4661688 | 4661688 | PRJNA846486_P_NODE_44384_length_207_cov_1.316456_g44288_i0 | PRJNA846486 | 44384 | 207 | 1.316456 | 2.72506392 | Deinococcus metallilatus | 1211322 | Bacteria | Bacteria | 152 | 1.7399999999999998e-32 | NTclustered | gi|1609451317|gb|CP038512.1| | 1211322 | g44288 | i0 | 80.288 | 1.0048309178744 | 208 | 35 | 99 | 5 | 1 | 205 | 1304917 | 1305121 | Deinococcus metallilatus strain MA1002 chromosome | blastn | 208 | 152 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus metallilatus | ||
| 5936512 | 5936512 | PRJNA846486_P_NODE_77345_length_169_cov_0.866667_g77249_i0 | PRJNA846486 | 77345 | 169 | 0.866667 | 1.46466723 | Deinococcus aetherius | 200252 | Bacteria | Bacteria | 233 | 4.7e-57 | NTclustered | gi|2281894955|dbj|AP026560.1| | 200252 | g77249 | i0 | 92.121 | 9.7396449704142 | 165 | 13 | 98 | 0 | 1 | 165 | 2448467 | 2448631 | Deinococcus aetherius ST0316 DNA, complete genome | blastn | 1646 | 233 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus aetherius | ||
| 22510179 | 22510179 | PRJNA846486_P_NODE_83718_length_166_cov_0.888889_g83622_i0 | PRJNA846486 | 83718 | 166 | 0.888889 | 1.47555574 | Thermaceae | 188786 | Bacteria | Bacteria | 86.3 | 3.51e-18 | NR | WP_013702860.1 | 186192 | g83622 | i0 | 79.6 | 2.92771084337349 | 54 | 11 | 97.6 | 0 | 3 | 164 | 222 | 275 | WP_013702860.1 acyl-CoA dehydrogenase family protein [Marinithermus hydrothermalis] | diamond | 486 | 86.7 | 0.995386389850058 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Marinithermus | Marinithermus hydrothermalis | ||
| 26674582 | 26674582 | PRJNA846486_P_NODE_89141_length_164_cov_0.904348_g89045_i0 | PRJNA846486 | 89141 | 164 | 0.904348 | 1.48313072 | Deinococcus sp. | 47478 | Bacteria | Bacteria | 41.6 | 0.0334 | NR | WP_293913725.1 | 47478 | g89045 | i0 | 42.9 | 0.640243902439024 | 35 | 20 | 64 | 0 | 107 | 3 | 157 | 191 | WP_293913725.1 LAGLIDADG family homing endonuclease [Deinococcus sp.] | diamond | 105 | 41.6 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. | ||
| 26769938 | 26769938 | PRJNA846486_P_NODE_88841_length_164_cov_0.904348_g88745_i0 | PRJNA846486 | 88841 | 164 | 0.904348 | 1.48313072 | Deinococcus sp. | 47478 | Bacteria | Bacteria | 66.2 | 5.76e-11 | NR | WP_310582088.1 | 47478 | g88745 | i0 | 65.2 | 0.841463414634146 | 46 | 16 | 84.1 | 0 | 156 | 19 | 308 | 353 | WP_310582088.1 hypothetical protein [Deinococcus sp.] | diamond | 138 | 66.2 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Deinococcales | Deinococcaceae | Deinococcus | Deinococcus sp. | ||
| 26841888 | 26841888 | PRJNA846486_P_NODE_81761_length_167_cov_0.881356_g81665_i0 | PRJNA846486 | 81761 | 167 | 0.881356 | 1.47186452 | Bacteria | 2 | Bacteria | Bacteria | 44.7 | 0.00281 | NR | MER3554936.1 | 1955249 | g81665 | i0 | 55.3 | 2.7125748502994 | 38 | 10 | 68.3 | 1 | 166 | 53 | 243 | 273 | MER3554936.1 DNA polymerase [Meiothermus sp.] | diamond | 453 | 45.1 | 0.991130820399113 | Bacteria | Thermotogati | Deinococcota | Deinococci | Thermales | Thermaceae | Meiothermus | Meiothermus sp. | ||
| 27915853 | 27915853 | PRJNA846486_P_NODE_92505_length_162_cov_1.477876_g92409_i0 | PRJNA846486 | 92505 | 162 | 1.477876 | 2.39415912 | Bacteria | 2 | Bacteria | Bacteria | 42 | 0.0231 | NR | MEY4531314.1 | 1913990 | g92409 | i0 | 45 | 2.53703703703704 | 40 | 22 | 74.1 | 0 | 17 | 136 | 221 | 260 | MEY4531314.1 hypothetical protein [Deinococcota bacterium] | diamond | 411 | 42.4 | 0.990566037735849 | Bacteria | Thermotogati | Deinococcota | Deinococcota bacterium | ||||||
| 29391703 | 29391703 | PRJNA846486_P_NODE_36469_length_223_cov_2.390805_g36373_i0 | PRJNA846486 | 36469 | 223 | 2.390805 | 5.33149515 | Trueperaceae bacterium | 2026798 | Bacteria | Bacteria | 94.7 | 1.38e-20 | NR | MDZ7703619.1 | 2026798 | g36373 | i0 | 64.3 | 0.94170403587444 | 70 | 25 | 94.2 | 0 | 222 | 13 | 205 | 274 | MDZ7703619.1 MBL fold metallo-hydrolase [Trueperaceae bacterium] | diamond | 210 | 94.7 | 1 | Bacteria | Thermotogati | Deinococcota | Deinococci | Trueperales | Trueperaceae | Trueperaceae bacterium | |||
| 29865192 | 29865192 | PRJNA846486_P_NODE_83531_length_166_cov_0.888889_g83435_i0 | PRJNA846486 | 83531 | 166 | 0.888889 | 1.47555574 | Pyramidobacter piscolens | 638849 | Bacteria | Bacteria | 47.4 | 2.77e-4 | NR | WP_156797548.1 | 638849 | g83435 | i0 | 43.5 | 1.66265060240964 | 46 | 26 | 83.1 | 0 | 165 | 28 | 6 | 51 | WP_156797548.1 ankyrin repeat domain-containing protein, partial [Pyramidobacter piscolens] | diamond | 276 | 47.4 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Dethiosulfovibrionaceae | Pyramidobacter | Pyramidobacter piscolens | ||
| 31453774 | 31453774 | PRJNA846486_P_NODE_2976_length_667_cov_2.545307_g2895_i0 | PRJNA846486 | 2976 | 667 | 2.545307 | 16.97719769 | Bacteria | 2 | Bacteria | Bacteria | 89.4 | 5.74e-18 | NR | HUM43663.1 | 1871331 | g2895 | i0 | 31.4 | 2.41529235382309 | 175 | 117 | 77.4 | 1 | 561 | 46 | 6 | 180 | HUM43663.1 phage head-tail connector protein [Fervidobacterium sp.] | diamond | 1611 | 90.1 | 0.992230854605993 | Bacteria | Thermotogati | Thermotogota | Thermotogae | Thermotogales | Fervidobacteriaceae | Fervidobacterium | Fervidobacterium sp. | ||
| 32646664 | 32646664 | PRJNA846486_P_NODE_91600_length_163_cov_0.912281_g91504_i0 | PRJNA846486 | 91600 | 163 | 0.912281 | 1.48701803 | uncultured Cloacibacillus sp. | 889794 | Bacteria | Bacteria | 64.7 | 4.43e-11 | NR | WP_294191848.1 | 889794 | g91504 | i0 | 55.8 | 0.957055214723926 | 52 | 23 | 95.7 | 0 | 8 | 163 | 39 | 90 | WP_294191848.1 N-acetylmuramoyl-L-alanine amidase family protein [uncultured Cloacibacillus sp.] | diamond | 156 | 64.7 | 1 | Bacteria | Thermotogati | Synergistota | Synergistia | Synergistales | Synergistaceae | Cloacibacillus | uncultured Cloacibacillus 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);;