contig_metadata
28 rows where analysis = "diamond", bioproject = "PRJNA1120203" and tax_phylum = "Thermoplasmatota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5377653 | 5377653 | PRJNA1120203_P_NODE_105225_length_241_cov_0.916667_g104209_i0 | PRJNA1120203 | 105225 | 241 | 0.916667 | 2.20916747 | Candidatus Thalassarchaeum sp. | 3134679 | Archaea | Archaea | 160 | 8.529999999999998e-47 | NR | MCH2643658.1 | 3134679 | g104209 | i0 | 93.8 | 2.98755186721992 | 80 | 5 | 99.6 | 0 | 241 | 2 | 63 | 142 | MCH2643658.1 NADP-dependent isocitrate dehydrogenase [Candidatus Thalassarchaeum sp.] | diamond | 720 | 160 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Thalassarchaeaceae | Candidatus Thalassarchaeum | Candidatus Thalassarchaeum sp. | ||
| 27544080 | 27544080 | PRJNA1120203_P_NODE_100704_length_243_cov_0.905882_g99688_i0 | PRJNA1120203 | 100704 | 243 | 0.905882 | 2.20129326 | Marine Group II euryarchaeote MED-G37 | 2007298 | Archaea | Archaea | 159 | 3.639999999999999e-46 | NR | PDH22008.1 | 2007298 | g99688 | i0 | 98.8 | 1.97530864197531 | 80 | 1 | 98.8 | 0 | 2 | 241 | 39 | 118 | PDH22008.1 MAG: hypothetical protein CND66_03665 [Marine Group II euryarchaeote MED-G37] | diamond | 480 | 159 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Marine Group II euryarchaeote MED-G37 | ||||
| 27786112 | 27786112 | PRJNA1120203_P_NODE_79424_length_251_cov_0.865169_g78408_i0 | PRJNA1120203 | 79424 | 251 | 0.865169 | 2.17157419 | Candidatus Thalassarchaeum | 3134675 | Archaea | Archaea | 171 | 2.74e-50 | NR | WP_338171170.1 | 2599289 | g78408 | i0 | 83.1 | 10.9123505976096 | 83 | 14 | 99.2 | 0 | 251 | 3 | 25 | 107 | WP_338171170.1 4-demethylwyosine synthase TYW1 [Candidatus Thalassarchaeum betae] | diamond | 2739 | 172 | 0.994186046511628 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Thalassarchaeaceae | Candidatus Thalassarchaeum | Candidatus Thalassarchaeum betae | ||
| 27828238 | 27828238 | PRJNA1120203_P_NODE_97964_length_244_cov_0.900585_g96948_i0 | PRJNA1120203 | 97964 | 244 | 0.900585 | 2.1974274 | Candidatus Poseidoniales archaeon | 2163009 | Archaea | Archaea | 111 | 1.07e-27 | NR | DAC16965.1 | 2163009 | g96948 | i0 | 89.7 | 0.713114754098361 | 58 | 6 | 71.3 | 0 | 71 | 244 | 3 | 60 | DAC16965.1 MAG TPA: DUF835 domain-containing protein [Candidatus Poseidoniales archaeon] | diamond | 174 | 111 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniales archaeon | ||||
| 28080689 | 28080689 | PRJNA1120203_P_NODE_87885_length_248_cov_0.880000_g86869_i0 | PRJNA1120203 | 87885 | 248 | 0.88 | 2.1824 | Candidatus Poseidoniales archaeon | 2163009 | Archaea | Archaea | 146 | 1.18e-38 | NR | MEL0332134.1 | 2163009 | g86869 | i0 | 97.6 | 1.98387096774194 | 82 | 2 | 99.2 | 0 | 3 | 248 | 187 | 268 | MEL0332134.1 putative Ig domain-containing protein [Candidatus Poseidoniales archaeon] | diamond | 492 | 146 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniales archaeon | ||||
| 28364765 | 28364765 | PRJNA1120203_P_NODE_104426_length_241_cov_0.916667_g103410_i0 | PRJNA1120203 | 104426 | 241 | 0.916667 | 2.20916747 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 66.2 | 1.9e-10 | NR | MCI4320533.1 | 1906666 | g103410 | i0 | 40 | 0.995850622406639 | 80 | 47 | 99.6 | 1 | 240 | 1 | 151 | 229 | MCI4320533.1 hypothetical protein [Thermoplasmata archaeon] | diamond | 240 | 66.2 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 28396508 | 28396508 | PRJNA1120203_P_NODE_81046_length_250_cov_0.870056_g80030_i0 | PRJNA1120203 | 81046 | 250 | 0.870056 | 2.17514 | Candidatus Poseidoniales archaeon | 2163009 | Archaea | Archaea | 163 | 1.84e-44 | NR | MEL0331592.1 | 2163009 | g80030 | i0 | 91.6 | 1.992 | 83 | 7 | 99.6 | 0 | 2 | 250 | 56 | 138 | MEL0331592.1 MMPL family transporter [Candidatus Poseidoniales archaeon] | diamond | 498 | 163 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniales archaeon | ||||
| 28491335 | 28491335 | PRJNA1120203_P_NODE_96567_length_244_cov_0.900585_g95551_i0 | PRJNA1120203 | 96567 | 244 | 0.900585 | 2.1974274 | Candidatus Poseidoniales archaeon | 2163009 | Archaea | Archaea | 161 | 8.61e-44 | NR | RJV01078.1 | 2163009 | g95551 | i0 | 100 | 0.995901639344262 | 81 | 0 | 99.6 | 0 | 1 | 243 | 714 | 794 | RJV01078.1 MAG: carboxypeptidase regulatory-like domain-containing protein [Candidatus Poseidoniales archaeon] | diamond | 243 | 161 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniales archaeon | ||||
| 28586137 | 28586137 | PRJNA1120203_P_NODE_100847_length_243_cov_0.905882_g99831_i0 | PRJNA1120203 | 100847 | 243 | 0.905882 | 2.20129326 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 145 | 4.99e-39 | NR | MEC7273303.1 | 2806419 | g99831 | i0 | 85 | 1.97530864197531 | 80 | 12 | 98.8 | 0 | 2 | 241 | 93 | 172 | MEC7273303.1 acyltransferase domain-containing protein [Thermoplasmatota archaeon] | diamond | 480 | 145 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 28680868 | 28680868 | PRJNA1120203_P_NODE_99207_length_243_cov_0.905882_g98191_i0 | PRJNA1120203 | 99207 | 243 | 0.905882 | 2.20129326 | Poseidonia sp. | 2666344 | Archaea | Archaea | 90.5 | 4.29e-19 | NR | MBL6733340.1 | 2666344 | g98191 | i0 | 54.4 | 0.975308641975309 | 79 | 36 | 97.5 | 0 | 242 | 6 | 120 | 198 | MBL6733340.1 hypothetical protein [Poseidonia sp.] | diamond | 237 | 90.5 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniaceae | Candidatus Poseidonia | Poseidonia sp. | ||
| 29469696 | 29469696 | PRJNA1120203_P_NODE_103290_length_242_cov_0.911243_g102274_i0 | PRJNA1120203 | 103290 | 242 | 0.911243 | 2.20520806 | Candidatus Poseidoniales archaeon | 2163009 | Archaea | Archaea | 81.3 | 1.01e-15 | NR | MEK9695473.1 | 2163009 | g102274 | i0 | 56 | 0.929752066115702 | 75 | 32 | 93 | 1 | 7 | 231 | 790 | 863 | MEK9695473.1 hypothetical protein [Candidatus Poseidoniales archaeon] | diamond | 225 | 81.3 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniales archaeon | ||||
| 29533196 | 29533196 | PRJNA1120203_P_NODE_11850_length_919_cov_2.230496_g10968_i0 | PRJNA1120203 | 11850 | 919 | 2.230496 | 20.49825824 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 221 | 2.41e-66 | NR | MEM3334188.1 | 1906666 | g10968 | i0 | 42.9 | 1.02829162132753 | 315 | 155 | 97 | 8 | 917 | 27 | 18 | 325 | MEM3334188.1 glycosyltransferase [Thermoplasmata archaeon] | diamond | 945 | 221 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 30164655 | 30164655 | PRJNA1120203_P_NODE_8832_length_1197_cov_2.409253_g8100_i0 | PRJNA1120203 | 8832 | 1197 | 2.409253 | 28.83875841 | Ferroplasma acidiphilum | 74969 | Archaea | Archaea | 624 | 3.059999999999999e-223 | NR | WP_171481667.1 | 74969 | g8100 | i0 | 99.4 | 0.791979949874687 | 316 | 2 | 79.2 | 0 | 948 | 1 | 1 | 316 | WP_171481667.1 methyltransferase domain-containing protein [Ferroplasma acidiphilum] | diamond | 948 | 624 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmatales | Ferroplasmaceae | Ferroplasma | Ferroplasma acidiphilum | ||
| 30354919 | 30354919 | PRJNA1120203_P_NODE_105912_length_241_cov_0.916667_g104896_i0 | PRJNA1120203 | 105912 | 241 | 0.916667 | 2.20916747 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 159 | 2.88e-43 | NR | MEC9119775.1 | 2806419 | g104896 | i0 | 96.3 | 1.99170124481328 | 80 | 3 | 99.6 | 0 | 240 | 1 | 1244 | 1323 | MEC9119775.1 CARDB domain-containing protein [Thermoplasmatota archaeon] | diamond | 480 | 159 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 30354928 | 30354928 | PRJNA1120203_P_NODE_67572_length_273_cov_2.025000_g66556_i0 | PRJNA1120203 | 67572 | 273 | 2.025 | 5.52825 | Thermoplasmatales archaeon | 2268204 | Archaea | Archaea | 69.3 | 1.18e-12 | NR | MCW6168950.1 | 2268204 | g66556 | i0 | 58.6 | 0.637362637362637 | 58 | 24 | 63.7 | 0 | 95 | 268 | 1 | 58 | MCW6168950.1 HEPN domain-containing protein [Thermoplasmatales archaeon] | diamond | 174 | 69.3 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmatales | Thermoplasmatales archaeon | ||||
| 30354940 | 30354940 | PRJNA1120203_P_NODE_96432_length_244_cov_0.900585_g95416_i0 | PRJNA1120203 | 96432 | 244 | 0.900585 | 2.1974274 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 64.3 | 9.67e-10 | NR | MED5351190.1 | 2806419 | g95416 | i0 | 93.9 | 0.405737704918033 | 33 | 2 | 40.6 | 0 | 145 | 243 | 1 | 33 | MED5351190.1 hypothetical protein [Thermoplasmatota archaeon] | diamond | 99 | 64.3 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 30480894 | 30480894 | PRJNA1120203_P_NODE_105173_length_241_cov_0.916667_g104157_i0 | PRJNA1120203 | 105173 | 241 | 0.916667 | 2.20916747 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 62.8 | 6.83e-11 | NR | HTW55595.1 | 1906666 | g104157 | i0 | 84.8 | 0.410788381742739 | 33 | 5 | 41.1 | 0 | 140 | 238 | 1 | 33 | HTW55595.1 hypothetical protein [Thermoplasmata archaeon] | diamond | 99 | 62.8 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 30575344 | 30575344 | PRJNA1120203_P_NODE_105993_length_241_cov_0.916667_g104977_i0 | PRJNA1120203 | 105993 | 241 | 0.916667 | 2.20916747 | Poseidonia sp. | 2666344 | Archaea | Archaea | 94 | 3.2800000000000003e-21 | NR | MEK9651108.1 | 2666344 | g104977 | i0 | 65.2 | 1.84232365145228 | 69 | 24 | 85.9 | 0 | 240 | 34 | 159 | 227 | MEK9651108.1 4'-phosphopantetheinyl transferase superfamily protein [Poseidonia sp.] | diamond | 444 | 94 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniaceae | Candidatus Poseidonia | Poseidonia sp. | ||
| 30575348 | 30575348 | PRJNA1120203_P_NODE_48633_length_324_cov_1.227092_g47617_i0 | PRJNA1120203 | 48633 | 324 | 1.227092 | 3.97577808 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 213 | 2.51e-66 | NR | MEC7664915.1 | 2806419 | g47617 | i0 | 94.4 | 2 | 108 | 6 | 100 | 0 | 324 | 1 | 29 | 136 | MEC7664915.1 TIM barrel protein [Thermoplasmatota archaeon] | diamond | 648 | 213 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 31049841 | 31049841 | PRJNA1120203_P_NODE_98055_length_244_cov_0.900585_g97039_i0 | PRJNA1120203 | 98055 | 244 | 0.900585 | 2.1974274 | Poseidonia sp. | 2666344 | Archaea | Archaea | 95.1 | 1.7400000000000003e-21 | NR | MBL6733450.1 | 2666344 | g97039 | i0 | 62 | 0.971311475409836 | 79 | 28 | 95.9 | 2 | 234 | 1 | 149 | 226 | MBL6733450.1 hypothetical protein [Poseidonia sp.] | diamond | 237 | 95.1 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniaceae | Candidatus Poseidonia | Poseidonia sp. | ||
| 31070579 | 31070579 | PRJNA1120203_P_NODE_86155_length_248_cov_0.880000_g85139_i0 | PRJNA1120203 | 86155 | 248 | 0.88 | 2.1824 | Archaea | 2157 | Archaea | Archaea | 85.9 | 1.67e-19 | NR | RJU85304.1 | 2163009 | g85139 | i0 | 82.9 | 1.98387096774194 | 41 | 7 | 49.6 | 0 | 246 | 124 | 74 | 114 | RJU85304.1 MAG: DUF393 domain-containing protein [Candidatus Poseidoniales archaeon] | diamond | 492 | 85.9 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniales archaeon | ||||
| 31112513 | 31112513 | PRJNA1120203_P_NODE_77335_length_252_cov_1.720670_g76319_i0 | PRJNA1120203 | 77335 | 252 | 1.72067 | 4.3360884 | Ferroplasma sp. | 2591003 | Archaea | Archaea | 131 | 1.6e-34 | NR | WP_298279440.1 | 2591003 | g76319 | i0 | 72.3 | 0.988095238095238 | 83 | 23 | 98.8 | 0 | 2 | 250 | 6 | 88 | WP_298279440.1 hypothetical protein [Ferroplasma sp.] | diamond | 249 | 131 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmatales | Ferroplasmaceae | Ferroplasma | Ferroplasma sp. | ||
| 31333898 | 31333898 | PRJNA1120203_P_NODE_67136_length_274_cov_1.915423_g66120_i0 | PRJNA1120203 | 67136 | 274 | 1.915423 | 5.24825902 | Ferroplasma sp. | 2591003 | Archaea | Archaea | 161 | 5.24e-45 | NR | WP_298276926.1 | 2591003 | g66120 | i0 | 82.4 | 0.996350364963504 | 91 | 16 | 99.6 | 0 | 1 | 273 | 409 | 499 | WP_298276926.1 cytosine permease [Ferroplasma sp.] | diamond | 273 | 161 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmatales | Ferroplasmaceae | Ferroplasma | Ferroplasma sp. | ||
| 31639492 | 31639492 | PRJNA1120203_P_NODE_80036_length_251_cov_0.865169_g79020_i0 | PRJNA1120203 | 80036 | 251 | 0.865169 | 2.17157419 | Candidatus Thalassarchaeum | 3134675 | Archaea | Archaea | 60.5 | 3.81e-9 | NR | MEC8954742.1 | 2806419 | g79020 | i0 | 93.5 | 0.741035856573705 | 31 | 2 | 37.1 | 0 | 1 | 93 | 123 | 153 | MEC8954742.1 fructose-bisphosphatase class II [Thermoplasmatota archaeon] | diamond | 186 | 60.5 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 31713577 | 31713577 | PRJNA1120203_P_NODE_36697_length_380_cov_0.889251_g35682_i0 | PRJNA1120203 | 36697 | 380 | 0.889251 | 3.3791538 | Thermoplasmatales archaeon | 2268204 | Archaea | Archaea | 122 | 1.6799999999999999e-29 | NR | MDA8142731.1 | 2268204 | g35682 | i0 | 51.2 | 0.986842105263158 | 125 | 58 | 98.7 | 1 | 380 | 6 | 66 | 187 | MDA8142731.1 DEAD/DEAH box helicase [Thermoplasmatales archaeon] | diamond | 375 | 122 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmatales | Thermoplasmatales archaeon | ||||
| 32473120 | 32473120 | PRJNA1120203_P_NODE_58939_length_293_cov_1.359091_g57923_i0 | PRJNA1120203 | 58939 | 293 | 1.359091 | 3.98213663 | Thermoplasmatales archaeon | 2268204 | Archaea | Archaea | 130 | 1.82e-35 | NR | MCW6168948.1 | 2268204 | g57923 | i0 | 68.4 | 0.972696245733788 | 95 | 29 | 97.3 | 1 | 5 | 289 | 4 | 97 | MCW6168948.1 hypothetical protein [Thermoplasmatales archaeon] | diamond | 285 | 130 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmatales | Thermoplasmatales archaeon | ||||
| 32662075 | 32662075 | PRJNA1120203_P_NODE_87340_length_248_cov_0.880000_g86324_i0 | PRJNA1120203 | 87340 | 248 | 0.88 | 2.1824 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 152 | 1.1999999999999998e-44 | NR | MEC8979460.1 | 2806419 | g86324 | i0 | 92.7 | 0.991935483870968 | 82 | 6 | 99.2 | 0 | 248 | 3 | 104 | 185 | MEC8979460.1 hypothetical protein [Thermoplasmatota archaeon] | diamond | 246 | 152 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 32808983 | 32808983 | PRJNA1120203_P_NODE_81160_length_250_cov_0.870056_g80144_i0 | PRJNA1120203 | 81160 | 250 | 0.870056 | 2.17514 | Archaea | 2157 | Archaea | Archaea | 164 | 7.84e-45 | NR | GIR34577.1 | 2163009 | g80144 | i0 | 98.8 | 2.988 | 83 | 1 | 99.6 | 0 | 2 | 250 | 1026 | 1108 | GIR34577.1 MAG: vitamin B12-dependent ribonucleotide reductase [Candidatus Poseidoniales archaeon] | diamond | 747 | 164 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniales 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);;