contig_metadata
21 rows where bioproject = "PRJNA724011" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26988717 | 26988717 | PRJNA724011_P_NODE_78722_length_280_cov_1.487923_g77699_i0 | PRJNA724011 | 78722 | 280 | 1.487923 | 4.1661844 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 53.5 | 8.17e-6 | NR | MCL4450642.1 | 2806419 | g77699 | i0 | 49 | 1.09285714285714 | 51 | 26 | 54.6 | 0 | 279 | 127 | 253 | 303 | MCL4450642.1 deoxyhypusine synthase [Thermoplasmatota archaeon] | diamond | 306 | 53.5 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 27209931 | 27209931 | PRJNA724011_P_NODE_110882_length_237_cov_2.225610_g109859_i0 | PRJNA724011 | 110882 | 237 | 2.22561 | 5.2746957 | Candidatus Methanomethylophilaceae archaeon | 2517205 | Archaea | Archaea | 67.4 | 6.96e-11 | NR | MFA6952385.1 | 2517205 | g109859 | i0 | 54.8 | 2.67088607594937 | 62 | 27 | 78.5 | 1 | 51 | 236 | 569 | 629 | MFA6952385.1 methionine--tRNA ligase [Candidatus Methanomethylophilaceae archaeon] | diamond | 633 | 67.4 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Methanomassiliicoccales | Methanomethylophilaceae | Candidatus Methanomethylophilaceae archaeon | |||
| 27241659 | 27241659 | PRJNA724011_P_NODE_106783_length_243_cov_0.905882_g105760_i0 | PRJNA724011 | 106783 | 243 | 0.905882 | 2.20129326 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 55.1 | 1.66e-6 | NR | MCJ2519998.1 | 2806419 | g105760 | i0 | 39.5 | 1.98765432098765 | 81 | 44 | 93.8 | 2 | 237 | 10 | 31 | 111 | MCJ2519998.1 replication factor C large subunit [Thermoplasmatota archaeon] | diamond | 483 | 55.1 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 27778878 | 27778878 | PRJNA724011_P_NODE_49644_length_368_cov_1.779661_g48621_i0 | PRJNA724011 | 49644 | 368 | 1.779661 | 6.54915248 | Thermoplasmatales archaeon B_DKE | 1961136 | Archaea | Archaea | 43.9 | 0.0459 | NR | OWP56723.1 | 1961136 | g48621 | i0 | 44.2 | 0.35054347826087 | 43 | 24 | 35.1 | 0 | 1 | 129 | 209 | 251 | OWP56723.1 MAG: exodeoxyribonuclease III [Thermoplasmatales archaeon B_DKE] | diamond | 129 | 43.9 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmatales | Thermoplasmatales archaeon B_DKE | ||||
| 28126036 | 28126036 | PRJNA724011_P_NODE_29885_length_507_cov_1.557604_g28867_i0 | PRJNA724011 | 29885 | 507 | 1.557604 | 7.89705228 | Candidatus Poseidoniaceae archaeon | 2666346 | Archaea | Archaea | 71.2 | 7.4e-11 | NR | MDC0528531.1 | 2666346 | g28867 | i0 | 36.6 | 2.04733727810651 | 112 | 61 | 66.3 | 1 | 154 | 489 | 402 | 503 | MDC0528531.1 AAA domain-containing protein [Candidatus Poseidoniaceae archaeon] | diamond | 1038 | 71.2 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniaceae | Candidatus Poseidoniaceae archaeon | |||
| 28220603 | 28220603 | PRJNA724011_P_NODE_87366_length_262_cov_3.666667_g86343_i0 | PRJNA724011 | 87366 | 262 | 3.666667 | 9.60666754 | Thermoplasmata archaeon M8B2D | 1933278 | Archaea | Archaea | 43.5 | 0.0261 | NR | PNX50297.1 | 1933278 | g86343 | i0 | 36.8 | 0.652671755725191 | 57 | 35 | 64.1 | 1 | 67 | 234 | 487 | 543 | PNX50297.1 MAG: hypothetical protein BV456_07145, partial [Thermoplasmata archaeon M8B2D] | diamond | 171 | 43.5 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon M8B2D | |||||
| 28883689 | 28883689 | PRJNA724011_P_NODE_35308_length_457_cov_1.734375_g34287_i0 | PRJNA724011 | 35308 | 457 | 1.734375 | 7.92609375 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 45.1 | 0.0451 | NR | HLN50522.1 | 1906666 | g34287 | i0 | 36.6 | 0.466083150984683 | 71 | 42 | 44.6 | 2 | 394 | 191 | 112 | 182 | HLN50522.1 argininosuccinate synthase [Thermoplasmata archaeon] | diamond | 213 | 45.1 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 28883730 | 28883730 | PRJNA724011_P_NODE_67908_length_306_cov_1.536481_g66885_i0 | PRJNA724011 | 67908 | 306 | 1.536481 | 4.70163186 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 45.8 | 8.07e-4 | NR | MCI4350574.1 | 1906666 | g66885 | i0 | 40.8 | 0.480392156862745 | 49 | 29 | 48 | 0 | 215 | 69 | 4 | 52 | MCI4350574.1 MoaD/ThiS family protein [Thermoplasmata archaeon] | diamond | 147 | 45.8 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 28925658 | 28925658 | PRJNA724011_P_NODE_32808_length_478_cov_1.320988_g31789_i0 | PRJNA724011 | 32808 | 478 | 1.320988 | 6.31432264 | root | 1 | Root_unresolved | Root_unresolved | 46.2 | 0.0244 | NR | MCK5291331.1 | 1906666 | g31789 | i0 | 33.7 | 2.69246861924686 | 95 | 56 | 55.2 | 2 | 371 | 108 | 977 | 1071 | MCK5291331.1 carboxypeptidase regulatory-like domain-containing protein [Thermoplasmata archaeon] | diamond | 1287 | 46.6 | 0.991416309012876 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 29767673 | 29767673 | PRJNA724011_P_NODE_104351_length_244_cov_1.327485_g103328_i0 | PRJNA724011 | 104351 | 244 | 1.327485 | 3.2390634 | Candidatus Poseidoniales archaeon | 2163009 | Archaea | Archaea | 65.5 | 3.67e-10 | NR | DAC61879.1 | 2163009 | g103328 | i0 | 57.1 | 1.80737704918033 | 49 | 21 | 60.2 | 0 | 96 | 242 | 1488 | 1536 | DAC61879.1 MAG TPA: acyltransferase domain-containing protein, partial [Candidatus Poseidoniales archaeon] | diamond | 441 | 65.5 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniales archaeon | ||||
| 30336884 | 30336884 | PRJNA724011_P_NODE_2552_length_1833_cov_14.655114_g2171_i2 | PRJNA724011 | 2552 | 1833 | 14.655114 | 268.62823962 | Candidatus Poseidonia alphae | 1915863 | Archaea | Archaea | 368 | 9.349999999999998e-118 | NR | MDA7464093.1 | 1915863 | g2171 | i2 | 40.1 | 1.50572831423895 | 461 | 268 | 75.5 | 5 | 1759 | 377 | 1 | 453 | MDA7464093.1 DNA photolyase family protein [Candidatus Poseidonia alphae] | diamond | 2760 | 368 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniaceae | Candidatus Poseidonia | Candidatus Poseidonia alphae | ||
| 30652216 | 30652216 | PRJNA724011_P_NODE_108893_length_241_cov_2.279762_g107870_i0 | PRJNA724011 | 108893 | 241 | 2.279762 | 5.49422642 | Candidatus Poseidoniia archaeon | 2666348 | Archaea | Archaea | 42 | 0.0205 | NR | MEO2222597.1 | 2666348 | g107870 | i0 | 34.8 | 0.572614107883817 | 46 | 30 | 57.3 | 0 | 86 | 223 | 44 | 89 | MEO2222597.1 DCC1-like thiol-disulfide oxidoreductase family protein [Candidatus Poseidoniia archaeon] | diamond | 138 | 42 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniia archaeon | |||||
| 30905393 | 30905393 | PRJNA724011_P_NODE_84034_length_269_cov_1.571429_g83011_i0 | PRJNA724011 | 84034 | 269 | 1.571429 | 4.22714401 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 124 | 2.2599999999999996e-31 | NR | RLF35890.1 | 1906666 | g83011 | i0 | 61.4 | 1.95167286245353 | 88 | 34 | 98.1 | 0 | 268 | 5 | 248 | 335 | RLF35890.1 MAG: spermidine synthase [Thermoplasmata archaeon] | diamond | 525 | 124 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 31821977 | 31821977 | PRJNA724011_P_NODE_21297_length_629_cov_4.512590_g20285_i0 | PRJNA724011 | 21297 | 629 | 4.51259 | 28.3841911 | uncultured Candidatus Poseidoniales archaeon | 274854 | Archaea | Archaea | 54.7 | 2.29e-5 | NR | EHR75681.1 | 274854 | g20285 | i0 | 30.2 | 1.60254372019078 | 96 | 67 | 45.8 | 0 | 188 | 475 | 87 | 182 | EHR75681.1 MAG: putative calcium-binding EF-hand domain protein [uncultured Candidatus Poseidoniales archaeon] | diamond | 1008 | 54.7 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | uncultured Candidatus Poseidoniales archaeon | ||||
| 31853654 | 31853654 | PRJNA724011_P_NODE_17237_length_721_cov_3.057099_g16250_i0 | PRJNA724011 | 17237 | 721 | 3.057099 | 22.04168379 | Thermoplasmatales archaeon | 2268204 | Archaea | Archaea | 77.4 | 1.51e-12 | NR | MCK5031410.1 | 2268204 | g16250 | i0 | 29.9 | 1.72676837725381 | 197 | 112 | 79.1 | 6 | 29 | 598 | 115 | 292 | MCK5031410.1 hypothetical protein [Thermoplasmatales archaeon] | diamond | 1245 | 77.4 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmatales | Thermoplasmatales archaeon | ||||
| 31980226 | 31980226 | PRJNA724011_P_NODE_22518_length_607_cov_1.711610_g21505_i0 | PRJNA724011 | 22518 | 607 | 1.71161 | 10.3894727 | Acidiplasma | 507753 | Archaea | Archaea | 46.6 | 0.0385 | NR | WP_082180407.1 | 507753 | g21505 | i0 | 22.5 | 0.85502471169687 | 173 | 115 | 81.5 | 3 | 24 | 518 | 313 | 474 | WP_082180407.1 MULTISPECIES: thermopsin [Acidiplasma] | diamond | 519 | 46.6 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmatales | Ferroplasmaceae | Acidiplasma | |||
| 31980266 | 31980266 | PRJNA724011_P_NODE_50638_length_364_cov_1.054983_g49615_i0 | PRJNA724011 | 50638 | 364 | 1.054983 | 3.84013812 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 57.4 | 1.05e-6 | NR | RLF56813.1 | 1906666 | g49615 | i0 | 36.8 | 1.4010989010989 | 87 | 42 | 71.7 | 2 | 302 | 42 | 110 | 183 | RLF56813.1 MAG: hypothetical protein DRN27_08975, partial [Thermoplasmata archaeon] | diamond | 510 | 57.4 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 32201922 | 32201922 | PRJNA724011_P_NODE_64358_length_316_cov_1.489712_g63335_i0 | PRJNA724011 | 64358 | 316 | 1.489712 | 4.70748992 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 45.1 | 0.0131 | NR | HEY7588022.1 | 1906666 | g63335 | i0 | 35 | 0.977848101265823 | 103 | 57 | 88.3 | 2 | 14 | 292 | 52 | 154 | HEY7588022.1 DHH family phosphoesterase [Thermoplasmata archaeon] | diamond | 309 | 45.1 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 32233698 | 32233698 | PRJNA724011_P_NODE_102958_length_245_cov_0.895349_g101935_i0 | PRJNA724011 | 102958 | 245 | 0.895349 | 2.19360505 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 58.9 | 3.38e-8 | NR | HZY92714.1 | 1906666 | g101935 | i0 | 50 | 0.710204081632653 | 58 | 29 | 71 | 0 | 68 | 241 | 3 | 60 | HZY92714.1 NAD(P)-binding domain-containing protein [Thermoplasmata archaeon] | diamond | 174 | 58.9 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 32644146 | 32644146 | PRJNA724011_P_NODE_41000_length_415_cov_1.108187_g39977_i0 | PRJNA724011 | 41000 | 415 | 1.108187 | 4.59897605 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 46.2 | 0.0126 | NR | HEX2022280.1 | 2806419 | g39977 | i0 | 38.6 | 0.6 | 83 | 43 | 58.6 | 2 | 337 | 95 | 282 | 358 | HEX2022280.1 hypothetical protein [Thermoplasmatota archaeon] | diamond | 249 | 46.2 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 32780537 | 32780537 | PRJNA724011_P_NODE_100820_length_246_cov_2.508671_g99797_i0 | PRJNA724011 | 100820 | 246 | 2.508671 | 6.17133066 | Methanobacteriati | 3366610 | Archaea | Archaea | 44.3 | 0.0115 | NR | MDB2569492.1 | 1915863 | g99797 | i0 | 28.9 | 5.5609756097561 | 76 | 50 | 87.8 | 1 | 31 | 246 | 112 | 187 | MDB2569492.1 hypothetical protein [Candidatus Poseidonia alphae] | diamond | 1368 | 44.3 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniaceae | Candidatus Poseidonia | Candidatus Poseidonia alphae |
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);;