contig_metadata
17 rows where bioproject = "PRJNA799842" and tax_phylum = "Thermoproteota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14822276 | 14822276 | PRJNA799842_P_NODE_167772_length_245_cov_0.895349_g166199_i0 | PRJNA799842 | 167772 | 245 | 0.895349 | 2.19360505 | Pyrobaculum aerophilum | 13773 | Archaea | Archaea | 448 | 2.41e-121 | NTclustered | gi|18308975|gb|AE009441.1| | 178306 | g166199 | i0 | 99.592 | 1 | 245 | 1 | 100 | 0 | 1 | 245 | 1746322 | 1746566 | Pyrobaculum aerophilum str. IM2, complete genome | blastn | 245 | 448 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Pyrobaculum | Pyrobaculum aerophilum | ||
| 18645431 | 18645431 | PRJNA799842_P_NODE_166815_length_245_cov_0.895349_g165242_i0 | PRJNA799842 | 166815 | 245 | 0.895349 | 2.19360505 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 144 | 1.01e-37 | NR | MFC1752097.1 | 2056631 | g165242 | i0 | 80.2 | 1.97142857142857 | 81 | 16 | 99.2 | 0 | 244 | 2 | 343 | 423 | MFC1752097.1 carbamoyl-phosphate synthase large subunit [Thermoproteota archaeon] | diamond | 483 | 144 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 23746005 | 23746005 | PRJNA799842_P_NODE_130259_length_256_cov_0.961749_g128686_i0 | PRJNA799842 | 130259 | 256 | 0.961749 | 2.46207744 | uncultured crenarchaeote | 29281 | Archaea | Archaea | 416 | 7.159999999999998e-112 | NTclustered | gi|42557759|emb|AJ627422.1| | 29281 | g128686 | i0 | 96.094 | 1 | 256 | 8 | 100 | 1 | 1 | 256 | 10708 | 10961 | Uncultured crenarchaeote genomic fragment 54d9 | blastn | 256 | 416 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 27220787 | 27220787 | PRJNA799842_P_NODE_141102_length_250_cov_0.870056_g139529_i0 | PRJNA799842 | 141102 | 250 | 0.870056 | 2.17514 | Thermoproteati | 1783275 | Archaea | Archaea | 108 | 2.03e-25 | NR | MDQ1279173.1 | 2056631 | g139529 | i0 | 63.4 | 1.956 | 82 | 30 | 98.4 | 0 | 248 | 3 | 698 | 779 | MDQ1279173.1 hypothetical protein [Thermoproteota archaeon] | diamond | 489 | 108 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 27568434 | 27568434 | PRJNA799842_P_NODE_151084_length_248_cov_0.880000_g149511_i0 | PRJNA799842 | 151084 | 248 | 0.88 | 2.1824 | Thermoproteati | 1783275 | Archaea | Archaea | 103 | 1.7600000000000002e-26 | NR | MDP9488864.1 | 2056631 | g149511 | i0 | 96.3 | 1.95967741935484 | 54 | 2 | 65.3 | 0 | 85 | 246 | 51 | 104 | MDP9488864.1 P-II family nitrogen regulator [Thermoproteota archaeon] | diamond | 486 | 103 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 27591366 | 27591366 | PRJNA799842_P_NODE_53364_length_389_cov_0.933544_g51791_i0 | PRJNA799842 | 53364 | 389 | 0.933544 | 3.63148616 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 233 | 8.030000000000001e-77 | NR | MDP9210920.1 | 2056631 | g51791 | i0 | 94.5 | 1.98200514138817 | 128 | 7 | 98.7 | 0 | 387 | 4 | 1 | 128 | MDP9210920.1 aquaporin [Thermoproteota archaeon] | diamond | 771 | 233 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 28285537 | 28285537 | PRJNA799842_P_NODE_173886_length_244_cov_0.900585_g172313_i0 | PRJNA799842 | 173886 | 244 | 0.900585 | 2.1974274 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 111 | 1.77e-29 | NR | MDP9489408.1 | 2056631 | g172313 | i0 | 96.1 | 1.88114754098361 | 51 | 2 | 62.7 | 0 | 243 | 91 | 70 | 120 | MDP9489408.1 cupin domain-containing protein [Thermoproteota archaeon] | diamond | 459 | 111 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 28475236 | 28475236 | PRJNA799842_P_NODE_178246_length_243_cov_0.905882_g176673_i0 | PRJNA799842 | 178246 | 243 | 0.905882 | 2.20129326 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 54.7 | 2.26e-6 | NR | NLB76095.1 | 2056631 | g176673 | i0 | 67.6 | 1.66666666666667 | 34 | 11 | 42 | 0 | 1 | 102 | 368 | 401 | NLB76095.1 cofactor-independent phosphoglycerate mutase [Thermoproteota archaeon] | diamond | 405 | 54.7 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 28475237 | 28475237 | PRJNA799842_P_NODE_179286_length_243_cov_0.905882_g177713_i0 | PRJNA799842 | 179286 | 243 | 0.905882 | 2.20129326 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 59.3 | 4.59e-8 | NR | NLB77198.1 | 2056631 | g177713 | i0 | 71.1 | 0.469135802469136 | 38 | 11 | 46.9 | 0 | 242 | 129 | 267 | 304 | NLB77198.1 6-phosphofructokinase [Thermoproteota archaeon] | diamond | 114 | 59.3 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 28506814 | 28506814 | PRJNA799842_P_NODE_163107_length_246_cov_0.890173_g161534_i0 | PRJNA799842 | 163107 | 246 | 0.890173 | 2.18982558 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 88.2 | 1.31e-19 | NR | MDP9489077.1 | 2056631 | g161534 | i0 | 88.5 | 0.634146341463415 | 52 | 6 | 63.4 | 0 | 156 | 1 | 1 | 52 | MDP9489077.1 hypothetical protein [Thermoproteota archaeon] | diamond | 156 | 88.2 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 28664693 | 28664693 | PRJNA799842_P_NODE_143767_length_250_cov_0.870056_g142194_i0 | PRJNA799842 | 143767 | 250 | 0.870056 | 2.17514 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 163 | 3.6599999999999996e-46 | NR | MDP9210367.1 | 2056631 | g142194 | i0 | 98.8 | 2.988 | 83 | 1 | 99.6 | 0 | 2 | 250 | 354 | 436 | MDP9210367.1 ribulose-phosphate 3-epimerase [Thermoproteota archaeon] | diamond | 747 | 163 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 29390987 | 29390987 | PRJNA799842_P_NODE_175089_length_244_cov_0.871345_g173516_i0 | PRJNA799842 | 175089 | 244 | 0.871345 | 2.1260818 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 103 | 7.9499999999999995e-25 | NR | MBM4400782.1 | 2056631 | g173516 | i0 | 62.5 | 0.983606557377049 | 80 | 23 | 97.1 | 2 | 6 | 242 | 173 | 246 | MBM4400782.1 DUF2213 domain-containing protein [Thermoproteota archaeon] | diamond | 240 | 103 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 29399801 | 29399801 | PRJNA799842_P_NODE_181869_length_242_cov_0.911243_g180296_i0 | PRJNA799842 | 181869 | 242 | 0.911243 | 2.20520806 | Thermoproteati | 1783275 | Archaea | Archaea | 157 | 4.7e-45 | NR | MDP9488805.1 | 2056631 | g180296 | i0 | 93.8 | 5.9504132231405 | 80 | 5 | 99.2 | 0 | 240 | 1 | 164 | 243 | MDP9488805.1 formate--phosphoribosylaminoimidazolecarboxamide ligase [Thermoproteota archaeon] | diamond | 1440 | 157 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 31222828 | 31222828 | PRJNA799842_P_NODE_106775_length_283_cov_1.100000_g105202_i0 | PRJNA799842 | 106775 | 283 | 1.1 | 3.113 | Thermoprotei archaeon | 2250277 | Archaea | Archaea | 81.3 | 1.67e-15 | NR | RLG87966.1 | 2250277 | g105202 | i0 | 41.8 | 2.91519434628975 | 91 | 52 | 96.5 | 1 | 275 | 3 | 222 | 311 | RLG87966.1 MAG: hypothetical protein DRO15_03915 [Thermoprotei archaeon] | diamond | 825 | 81.3 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoprotei archaeon | |||||
| 31381376 | 31381376 | PRJNA799842_P_NODE_146256_length_249_cov_0.875000_g144683_i0 | PRJNA799842 | 146256 | 249 | 0.875 | 2.17875 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 126 | 2.31e-33 | NR | MDQ1280348.1 | 2056631 | g144683 | i0 | 74.4 | 0.987951807228916 | 82 | 21 | 98.8 | 0 | 3 | 248 | 172 | 253 | MDQ1280348.1 transporter permease [Thermoproteota archaeon] | diamond | 246 | 126 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 31571192 | 31571192 | PRJNA799842_P_NODE_158596_length_247_cov_0.885057_g157023_i0 | PRJNA799842 | 158596 | 247 | 0.885057 | 2.18609079 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 100 | 2.24e-25 | NR | MDP9493008.1 | 2056631 | g157023 | i0 | 96.1 | 0.619433198380567 | 51 | 2 | 61.9 | 0 | 247 | 95 | 55 | 105 | MDP9493008.1 hypothetical protein [Thermoproteota archaeon] | diamond | 153 | 100 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 32235682 | 32235682 | PRJNA799842_P_NODE_126078_length_260_cov_1.647059_g124505_i0 | PRJNA799842 | 126078 | 260 | 1.647059 | 4.2823534 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 189 | 6.97e-59 | NR | MDP9493316.1 | 2056631 | g124505 | i0 | 100 | 2.97692307692308 | 86 | 0 | 99.2 | 0 | 258 | 1 | 64 | 149 | MDP9493316.1 site-specific DNA-methyltransferase [Thermoproteota archaeon] | diamond | 774 | 189 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon |
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);;