contig_metadata
7 rows where bioproject = "PRJNA798511" and tax_kingdom = "Methanobacteriati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18642765 | 18642765 | PRJNA798511_P_NODE_94495_length_247_cov_0.885057_g90229_i0 | PRJNA798511 | 94495 | 247 | 0.885057 | 2.18609079 | Methanosarcina sp. MTP4 | 1434100 | Archaea | Archaea | 52.8 | 0.022 | NTclustered | gi|805342629|gb|CP009505.1| | 1434100 | g90229 | i0 | 100 | 0.11336032388664 | 28 | 0 | 11 | 0 | 15 | 42 | 1786294 | 1786267 | Methanosarcina sp. MTP4, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. MTP4 | |
| 26769088 | 26769088 | PRJNA798511_P_NODE_97381_length_245_cov_0.895349_g93115_i0 | PRJNA798511 | 97381 | 245 | 0.895349 | 2.19360505 | Candidatus Nanohaloarchaea archaeon | 2594798 | Archaea | Archaea | 66.2 | 1.98e-10 | NR | MFB6245005.1 | 2594798 | g93115 | i0 | 44.3 | 0.96734693877551 | 79 | 37 | 96.7 | 1 | 2 | 238 | 443 | 514 | MFB6245005.1 ATP-dependent endonuclease [Candidatus Nanohaloarchaea archaeon] | diamond | 237 | 66.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Candidatus Nanohaloarchaea | Candidatus Nanohaloarchaea archaeon | ||||
| 28001696 | 28001696 | PRJNA798511_P_NODE_99645_length_243_cov_0.905882_g95379_i0 | PRJNA798511 | 99645 | 243 | 0.905882 | 2.20129326 | Methanoregula boonei | 358766 | Archaea | Archaea | 42.4 | 0.0495 | NR | WP_012107125.1 | 358766 | g95379 | i0 | 46.5 | 0.530864197530864 | 43 | 22 | 51.9 | 1 | 69 | 194 | 120 | 162 | WP_012107125.1 MFS transporter [Methanoregula boonei] | diamond | 129 | 42.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | Methanoregula boonei | |
| 28285422 | 28285422 | PRJNA798511_P_NODE_100306_length_243_cov_0.905882_g96040_i0 | PRJNA798511 | 100306 | 243 | 0.905882 | 2.20129326 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 43.9 | 0.0129 | NR | RLF48892.1 | 1906666 | g96040 | i0 | 38.9 | 0.666666666666667 | 54 | 33 | 66.7 | 0 | 172 | 11 | 27 | 80 | RLF48892.1 MAG: NAD-dependent protein deacylase [Thermoplasmata archaeon] | diamond | 162 | 43.9 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 28727734 | 28727734 | PRJNA798511_P_NODE_101867_length_242_cov_0.911243_g97601_i0 | PRJNA798511 | 101867 | 242 | 0.911243 | 2.20520806 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 67 | 1.01e-10 | NR | MDA8609943.1 | 2026739 | g97601 | i0 | 44.4 | 1.00413223140496 | 81 | 43 | 97.9 | 1 | 6 | 242 | 445 | 525 | MDA8609943.1 zinc-ribbon domain-containing protein [Methanobacteriota archaeon] | diamond | 243 | 67 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 28759207 | 28759207 | PRJNA798511_P_NODE_54367_length_337_cov_2.723485_g50101_i0 | PRJNA798511 | 54367 | 337 | 2.723485 | 9.17814445 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 44.7 | 0.0158 | NR | MDI6707611.1 | 2806419 | g50101 | i0 | 29.1 | 0.916913946587537 | 103 | 57 | 91.7 | 3 | 322 | 14 | 107 | 193 | MDI6707611.1 hypothetical protein [Thermoplasmatota archaeon] | diamond | 309 | 44.7 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 32181205 | 32181205 | PRJNA798511_P_NODE_75298_length_277_cov_1.122549_g71032_i0 | PRJNA798511 | 75298 | 277 | 1.122549 | 3.10946073 | root | 1 | Root_unresolved | Root_unresolved | 43.1 | 0.0092 | NR | HJJ67539.1 | 2058474 | g71032 | i0 | 45.5 | 0.953068592057762 | 44 | 22 | 45.5 | 1 | 180 | 55 | 21 | 64 | HJJ67539.1 hypothetical protein [Methanocorpusculum sp.] | diamond | 264 | 43.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanocorpusculaceae | Methanocorpusculum | Methanocorpusculum sp. |
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);;