contig_metadata
8 rows where bioproject = "PRJNA1180292" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14346847 | 14346847 | PRJNA1180292_P_NODE_10252_length_248_cov_0.891429_g10120_i0 | PRJNA1180292 | 10252 | 248 | 0.891429 | 2.21074392 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 137 | 2.9e-38 | NR | MBN1389082.1 | 2806419 | g10120 | i0 | 82.9 | 2.9758064516129 | 82 | 14 | 99.2 | 0 | 246 | 1 | 81 | 162 | MBN1389082.1 ABC transporter ATP-binding protein [Thermoplasmatota archaeon] | diamond | 738 | 137 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 19443801 | 19443801 | PRJNA1180292_P_NODE_10636_length_247_cov_0.896552_g10504_i0 | PRJNA1180292 | 10636 | 247 | 0.896552 | 2.21448344 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 149 | 3.369999999999999e-42 | NR | HEX7392766.1 | 1906666 | g10504 | i0 | 89 | 0.995951417004049 | 82 | 9 | 99.6 | 0 | 1 | 246 | 108 | 189 | HEX7392766.1 FAD-dependent oxidoreductase [Thermoplasmata archaeon] | diamond | 246 | 149 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 28114346 | 28114346 | PRJNA1180292_P_NODE_12625_length_243_cov_0.917647_g12493_i0 | PRJNA1180292 | 12625 | 243 | 0.917647 | 2.22988221 | Thermoplasmatales archaeon | 2268204 | Archaea | Archaea | 96.7 | 7.95e-22 | NR | MBP1662732.1 | 2268204 | g12493 | i0 | 87.9 | 0.716049382716049 | 58 | 7 | 71.6 | 0 | 65 | 238 | 1 | 58 | MBP1662732.1 uncharacterized protein [Thermoplasmatales archaeon] | diamond | 174 | 96.7 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmatales | Thermoplasmatales archaeon | ||||
| 28575597 | 28575597 | PRJNA1180292_P_NODE_12627_length_243_cov_0.917647_g12495_i0 | PRJNA1180292 | 12627 | 243 | 0.917647 | 2.22988221 | Archaea | 2157 | Archaea | Archaea | 151 | 2.59e-40 | NR | MBP1661960.1 | 2268204 | g12495 | i0 | 93.8 | 2.96296296296296 | 80 | 5 | 98.8 | 0 | 2 | 241 | 421 | 500 | MBP1661960.1 Acetyl-CoA synthetase [Thermoplasmatales archaeon] | diamond | 720 | 152 | 0.993421052631579 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmatales | Thermoplasmatales archaeon | ||||
| 30198355 | 30198355 | PRJNA1180292_P_NODE_9852_length_249_cov_0.886364_g9720_i0 | PRJNA1180292 | 9852 | 249 | 0.886364 | 2.20704636 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 112 | 6.760000000000001e-27 | NR | HEX7392324.1 | 1906666 | g9720 | i0 | 87.7 | 0.686746987951807 | 57 | 7 | 68.7 | 0 | 246 | 76 | 395 | 451 | HEX7392324.1 aspartate aminotransferase family protein [Thermoplasmata archaeon] | diamond | 171 | 112 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 31842082 | 31842082 | PRJNA1180292_P_NODE_9997_length_249_cov_0.869318_g9865_i0 | PRJNA1180292 | 9997 | 249 | 0.869318 | 2.16460182 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 138 | 7.780000000000001e-36 | NR | HIG99815.1 | 1906666 | g9865 | i0 | 79.3 | 0.987951807228916 | 82 | 17 | 98.8 | 0 | 247 | 2 | 35 | 116 | HIG99815.1 hypothetical protein [Thermoplasmata archaeon] | diamond | 246 | 138 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 32380244 | 32380244 | PRJNA1180292_P_NODE_12719_length_243_cov_0.917647_g12587_i0 | PRJNA1180292 | 12719 | 243 | 0.917647 | 2.22988221 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 157 | 1.35e-47 | NR | MEW5747852.1 | 2806419 | g12587 | i0 | 93.8 | 3.95061728395062 | 80 | 5 | 98.8 | 0 | 2 | 241 | 18 | 97 | MEW5747852.1 4Fe-4S binding protein [Thermoplasmatota archaeon] | diamond | 960 | 157 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 32380255 | 32380255 | PRJNA1180292_P_NODE_9819_length_249_cov_0.886364_g9687_i0 | PRJNA1180292 | 9819 | 249 | 0.886364 | 2.20704636 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 151 | 2.9e-41 | NR | MCU0853309.1 | 1906666 | g9687 | i0 | 85.4 | 0.987951807228916 | 82 | 12 | 98.8 | 0 | 2 | 247 | 312 | 393 | MCU0853309.1 hypothetical protein [Thermoplasmata archaeon] | diamond | 246 | 151 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata 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);;