contig_metadata
7 rows where bioproject = "PRJNA689790" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3219589 | 3219589 | PRJNA689790_S_NODE_2463_length_409_cov_2.118280_g2348_i0 | PRJNA689790 | 2463 | 409 | 2.11828 | 8.6637652 | uncultured Methanobacterium sp. | 176306 | Archaea | Archaea | 52.8 | 0.039 | NTclustered | gi|2621703503|emb|OY762552.1| | 176306 | g2348 | i0 | 100 | 0.0684596577017115 | 28 | 0 | 7 | 0 | 67 | 94 | 2248673 | 2248700 | MAG: uncultured Methanobacterium sp. isolate 3f2017ab-9e69-417f-80a5-32741c1572f8 genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | uncultured Methanobacterium sp. | |
| 21580314 | 21580314 | PRJNA689790_S_NODE_12217_length_171_cov_1.164179_g12102_i0 | PRJNA689790 | 12217 | 171 | 1.164179 | 1.99074609 | Haloprofundus | 1911573 | Archaea | Archaea | 52.8 | 0.014 | NTclustered | gi|1633225932|gb|CP039833.1| | 2572921 | g12102 | i0 | 100 | 0.327485380116959 | 28 | 0 | 16 | 0 | 6 | 33 | 609549 | 609522 | Haloprofundus sp. MHR1 chromosome, complete genome | blastn | 56 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloprofundus | Haloprofundus sp. MHR1 | |
| 22346078 | 22346078 | PRJNA689790_S_NODE_14938_length_157_cov_1.616667_g14823_i0 | PRJNA689790 | 14938 | 157 | 1.616667 | 2.53816719 | Halorhabdus sp. BNX81 | 2980181 | Archaea | Archaea | 62.1 | 2.15e-5 | NTclustered | gi|2460785470|gb|CP107254.1| | 2980181 | g14823 | i0 | 94.872 | 0.248407643312102 | 39 | 2 | 25 | 0 | 109 | 147 | 2014429 | 2014391 | Halorhabdus sp. BNX81 chromosome, complete genome | blastn | 39 | 62.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halorhabdus | Halorhabdus sp. BNX81 | |
| 29513677 | 29513677 | PRJNA689790_S_NODE_13370_length_164_cov_1.842520_g13255_i0 | PRJNA689790 | 13370 | 164 | 1.84252 | 3.0217328 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 53.9 | 1.45e-6 | NR | MAL20712.1 | 2026739 | g13255 | i0 | 50 | 0.951219512195122 | 52 | 26 | 95.1 | 0 | 7 | 162 | 1217 | 1268 | MAL20712.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 156 | 53.9 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 30398783 | 30398783 | PRJNA689790_S_NODE_10553_length_183_cov_1.054795_g10438_i0 | PRJNA689790 | 10553 | 183 | 1.054795 | 1.93027485 | Candidatus Poseidoniales archaeon | 2163009 | Archaea | Archaea | 55.5 | 2.92e-7 | NR | HIA39890.1 | 2163009 | g10438 | i0 | 55 | 0.655737704918033 | 40 | 18 | 65.6 | 0 | 169 | 50 | 138 | 177 | HIA39890.1 hypothetical protein [Candidatus Poseidoniales archaeon] | diamond | 120 | 55.5 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniales archaeon | ||||
| 30493148 | 30493148 | PRJNA689790_S_NODE_16293_length_152_cov_1.356522_g16178_i0 | PRJNA689790 | 16293 | 152 | 1.356522 | 2.06191344 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 60.8 | 4.35e-9 | NR | RAH13712.1 | 2026739 | g16178 | i0 | 52.2 | 0.907894736842105 | 46 | 22 | 90.8 | 0 | 4 | 141 | 56 | 101 | RAH13712.1 MAG: hypothetical protein CMB20_004395 [Methanobacteriota archaeon] | diamond | 138 | 60.8 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 30947110 | 30947110 | PRJNA689790_S_NODE_4594_length_283_cov_2.369919_g4479_i0 | PRJNA689790 | 4594 | 283 | 2.369919 | 6.70687077 | root | 1 | Root_unresolved | Root_unresolved | 44.7 | 0.0112 | NR | WP_320161787.1 | 1005933 | g4479 | i0 | 40.7 | 1.04946996466431 | 59 | 33 | 62.5 | 2 | 206 | 30 | 184 | 240 | WP_320161787.1 CBS domain-containing protein [uncultured Methanoregula sp.] | diamond | 297 | 44.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | uncultured Methanoregula 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);;