contig_metadata
8 rows where bioproject = "PRJNA561212", tax_kingdom = "Methanobacteriati" and tax_phylum = "Methanobacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18397263 | 18397263 | PRJNA561212_P_NODE_19255_length_259_cov_1.209677_g19044_i0 | PRJNA561212 | 19255 | 259 | 1.209677 | 3.13306343 | Natrialba magadii | 13769 | Archaea | Archaea | 52.8 | 0.024 | NTclustered | gi|289529249|gb|CP001932.1| | 547559 | g19044 | i0 | 100 | 0.108108108108108 | 28 | 0 | 11 | 0 | 24 | 51 | 3672109 | 3672082 | Natrialba magadii ATCC 43099, complete sequence | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrialba | Natrialba magadii | |
| 20947434 | 20947434 | PRJNA561212_P_NODE_13977_length_299_cov_1.274336_g13766_i0 | PRJNA561212 | 13977 | 299 | 1.274336 | 3.81026464 | Methanolobus sp. ZRKC2 | 3125783 | Archaea | Archaea | 78.7 | 4.59e-10 | NTclustered | gi|2708450131|gb|CP146980.1| | 3125783 | g13766 | i0 | 90.164 | 0.204013377926421 | 61 | 4 | 20 | 2 | 240 | 299 | 639879 | 639820 | Methanolobus sp. ZRKC2 chromosome, complete genome | blastn | 61 | 78.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanolobus | Methanolobus sp. ZRKC2 | |
| 26681416 | 26681416 | PRJNA561212_P_NODE_5301_length_480_cov_1.454545_g5090_i0 | PRJNA561212 | 5301 | 480 | 1.454545 | 6.981816 | Methanobacteriati | 3366610 | Archaea | Archaea | 196 | 1.8500000000000002e-59 | NR | MBH33411.1 | 2026739 | g5090 | i0 | 65.6 | 13.49375 | 151 | 47 | 94.4 | 1 | 466 | 14 | 45 | 190 | MBH33411.1 3,4-dihydroxy-2-butanone-4-phosphate synthase [Methanobacteriota archaeon] | diamond | 6477 | 196 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 28387811 | 28387811 | PRJNA561212_P_NODE_16746_length_277_cov_1.308824_g16535_i0 | PRJNA561212 | 16746 | 277 | 1.308824 | 3.62544248 | Methanobacteriati | 3366610 | Archaea | Archaea | 54.7 | 3.63e-6 | NR | MAV02704.1 | 2026739 | g16535 | i0 | 46.3 | 8.29602888086643 | 54 | 29 | 58.5 | 0 | 19 | 180 | 38 | 91 | MAV02704.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 2298 | 54.7 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 28689924 | 28689924 | PRJNA561212_P_NODE_13487_length_304_cov_1.896104_g13276_i0 | PRJNA561212 | 13487 | 304 | 1.896104 | 5.76415616 | Candidatus Methanoxibalbensis ujae | 2977099 | Archaea | Archaea | 59.7 | 8.96e-8 | NR | MCW3136373.1 | 2977099 | g13276 | i0 | 36.7 | 0.888157894736842 | 90 | 52 | 88.8 | 2 | 279 | 10 | 962 | 1046 | MCW3136373.1 carboxypeptidase regulatory-like domain-containing protein [Candidatus Methanoxibalbensis ujae] | diamond | 270 | 59.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Candidatus Methanophagales | Candidatus Methanospirareceae | Candidatus Methanoxibalbensis | Candidatus Methanoxibalbensis ujae | |
| 29321110 | 29321110 | PRJNA561212_P_NODE_18649_length_263_cov_1.515789_g18438_i0 | PRJNA561212 | 18649 | 263 | 1.515789 | 3.98652507 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 57 | 4.69e-7 | NR | MBU38768.1 | 2026739 | g18438 | i0 | 51.9 | 0.593155893536122 | 52 | 24 | 59.3 | 1 | 10 | 165 | 856 | 906 | MBU38768.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 156 | 57 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 29321129 | 29321129 | PRJNA561212_P_NODE_9689_length_354_cov_1.270463_g9478_i0 | PRJNA561212 | 9689 | 354 | 1.270463 | 4.49743902 | Methanobacterium sp. | 2164 | Archaea | Archaea | 67.8 | 2.05e-10 | NR | MCE5214616.1 | 2164 | g9478 | i0 | 35.6 | 6.05084745762712 | 101 | 59 | 85.6 | 2 | 40 | 342 | 70 | 164 | MCE5214616.1 translation elongation factor EF-1 subunit alpha [Methanobacterium sp.] | diamond | 2142 | 67.8 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. | |
| 29731387 | 29731387 | PRJNA561212_P_NODE_4730_length_510_cov_1.093822_g4521_i0 | PRJNA561212 | 4730 | 510 | 1.093822 | 5.5784922 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 177 | 5.279999999999999e-52 | NR | MBU04005.1 | 2026739 | g4521 | i0 | 54.3 | 14.4647058823529 | 164 | 72 | 96.5 | 1 | 14 | 505 | 36 | 196 | MBU04005.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 7377 | 177 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota 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);;