contig_metadata
12 rows where bioproject = "PRJNA688352" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18518940 | 18518940 | PRJNA688352_P_NODE_12335_length_241_cov_0.916667_g12232_i0 | PRJNA688352 | 12335 | 241 | 0.916667 | 2.20916747 | Archaea | 2157 | Archaea | Archaea | 140 | 1.19e-37 | NR | HIJ16845.1 | 1906666 | g12232 | i0 | 88.8 | 2.98755186721992 | 80 | 9 | 99.6 | 0 | 1 | 240 | 335 | 414 | HIJ16845.1 phosphopyruvate hydratase [Thermoplasmata archaeon] | diamond | 720 | 140 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 23619776 | 23619776 | PRJNA688352_P_NODE_9859_length_246_cov_0.890173_g9756_i0 | PRJNA688352 | 9859 | 246 | 0.890173 | 2.18982558 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 127 | 3.17e-33 | NR | HIH28275.1 | 1906666 | g9756 | i0 | 85.4 | 4 | 82 | 12 | 100 | 0 | 1 | 246 | 62 | 143 | HIH28275.1 catalase-peroxidase [Thermoplasmata archaeon] | diamond | 984 | 127 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 26639032 | 26639032 | PRJNA688352_P_NODE_10561_length_244_cov_0.900585_g10458_i0 | PRJNA688352 | 10561 | 244 | 0.900585 | 2.1974274 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 128 | 1.36e-33 | NR | MDQ1371479.1 | 2806419 | g10458 | i0 | 74.4 | 0.959016393442623 | 78 | 20 | 95.9 | 0 | 242 | 9 | 214 | 291 | MDQ1371479.1 hydrogenase expression/formation protein HypD [Thermoplasmatota archaeon] | diamond | 234 | 128 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 28451975 | 28451975 | PRJNA688352_P_NODE_8286_length_249_cov_0.875000_g8183_i0 | PRJNA688352 | 8286 | 249 | 0.875 | 2.17875 | Methanobacteriati | 3366610 | Archaea | Archaea | 73.9 | 4.34e-13 | NR | MEM2891010.1 | 1906666 | g8183 | i0 | 80 | 2.91566265060241 | 40 | 8 | 48.2 | 0 | 1 | 120 | 674 | 713 | MEM2891010.1 PQQ-binding-like beta-propeller repeat protein [Thermoplasmata archaeon] | diamond | 726 | 73.9 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 28661352 | 28661352 | PRJNA688352_P_NODE_7267_length_251_cov_0.865169_g7164_i0 | PRJNA688352 | 7267 | 251 | 0.865169 | 2.17157419 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 123 | 2.15e-30 | NR | RLF53669.1 | 1906666 | g7164 | i0 | 66.3 | 2.97609561752988 | 83 | 28 | 99.2 | 0 | 250 | 2 | 441 | 523 | RLF53669.1 MAG: DNA polymerase II large subunit [Thermoplasmata archaeon] | diamond | 747 | 123 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 29513574 | 29513574 | PRJNA688352_P_NODE_12410_length_241_cov_0.916667_g12307_i0 | PRJNA688352 | 12410 | 241 | 0.916667 | 2.20916747 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 160 | 4.04e-44 | NR | HIJ16692.1 | 1906666 | g12307 | i0 | 95 | 0.995850622406639 | 80 | 4 | 99.6 | 0 | 241 | 2 | 56 | 135 | HIJ16692.1 DUF4910 domain-containing protein [Thermoplasmata archaeon] | diamond | 240 | 160 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 29904348 | 29904348 | PRJNA688352_P_NODE_12431_length_241_cov_0.916667_g12328_i0 | PRJNA688352 | 12431 | 241 | 0.916667 | 2.20916747 | Archaea | 2157 | Archaea | Archaea | 76.6 | 1.85e-14 | NR | HIH00427.1 | 1906666 | g12328 | i0 | 97.6 | 2.09128630705394 | 42 | 1 | 52.3 | 0 | 114 | 239 | 1 | 42 | HIH00427.1 EamA family transporter [Thermoplasmata archaeon] | diamond | 504 | 76.6 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 30745756 | 30745756 | PRJNA688352_P_NODE_9534_length_246_cov_0.890173_g9431_i0 | PRJNA688352 | 9534 | 246 | 0.890173 | 2.18982558 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 160 | 7.35e-48 | NR | MCU0860165.1 | 1906666 | g9431 | i0 | 96.3 | 0.98780487804878 | 81 | 3 | 98.8 | 0 | 245 | 3 | 62 | 142 | MCU0860165.1 MBL fold metallo-hydrolase [Thermoplasmata archaeon] | diamond | 243 | 160 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 31820520 | 31820520 | PRJNA688352_P_NODE_8217_length_249_cov_0.875000_g8114_i0 | PRJNA688352 | 8217 | 249 | 0.875 | 2.17875 | Methanomassiliicoccales archaeon | 1906667 | Archaea | Archaea | 105 | 1.94e-24 | NR | MCG7844092.1 | 1906667 | g8114 | i0 | 89.3 | 0.674698795180723 | 56 | 6 | 67.5 | 0 | 2 | 169 | 487 | 542 | MCG7844092.1 hypothetical protein [Methanomassiliicoccales archaeon] | diamond | 168 | 105 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Methanomassiliicoccales | Methanomassiliicoccales archaeon | ||||
| 32137149 | 32137149 | PRJNA688352_P_NODE_9778_length_246_cov_0.890173_g9675_i0 | PRJNA688352 | 9778 | 246 | 0.890173 | 2.18982558 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 139 | 1.2e-36 | NR | MCU0859586.1 | 1906666 | g9675 | i0 | 91.4 | 0.98780487804878 | 81 | 7 | 98.8 | 0 | 1 | 243 | 271 | 351 | MCU0859586.1 hypothetical protein [Thermoplasmata archaeon] | diamond | 243 | 139 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 32148682 | 32148682 | PRJNA688352_P_NODE_11978_length_242_cov_0.911243_g11875_i0 | PRJNA688352 | 11978 | 242 | 0.911243 | 2.20520806 | root | 1 | Root_unresolved | Root_unresolved | 148 | 9.24e-41 | NR | MBE3140675.1 | 1906666 | g11875 | i0 | 91.3 | 5.9504132231405 | 80 | 7 | 99.2 | 0 | 242 | 3 | 182 | 261 | MBE3140675.1 amino acid permease [Thermoplasmata archaeon] | diamond | 1440 | 149 | 0.993288590604027 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 32831847 | 32831847 | PRJNA688352_P_NODE_10140_length_245_cov_0.895349_g10037_i0 | PRJNA688352 | 10140 | 245 | 0.895349 | 2.19360505 | Methanomassiliicoccales archaeon | 1906667 | Archaea | Archaea | 138 | 5.12e-37 | NR | MDD1747769.1 | 1906667 | g10037 | i0 | 87.7 | 0.991836734693878 | 81 | 10 | 99.2 | 0 | 245 | 3 | 134 | 214 | MDD1747769.1 MFS transporter [Methanomassiliicoccales archaeon] | diamond | 243 | 138 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Methanomassiliicoccales | Methanomassiliicoccales 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);;