contig_metadata
6 rows where bioproject = "PRJNA986481", tax_clade = "Stenosarchaea group" and tax_superkingdom = "Archaea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11176593 | 11176593 | PRJNA986481_P_NODE_14029_length_438_cov_1.120823_g13505_i0 | PRJNA986481 | 14029 | 438 | 1.120823 | 4.90920474 | Methanolobus sp. ZRKC2 | 3125783 | Archaea | Archaea | 54.7 | 0.012 | NTclustered | gi|2708450131|gb|CP146980.1| | 3125783 | g13505 | i0 | 92.308 | 0.089041095890411 | 39 | 1 | 9 | 2 | 282 | 319 | 2375858 | 2375821 | Methanolobus sp. ZRKC2 chromosome, complete genome | blastn | 39 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanolobus | Methanolobus sp. ZRKC2 | |
| 15300002 | 15300002 | PRJNA986481_P_NODE_38132_length_266_cov_0.930876_g37607_i0 | PRJNA986481 | 38132 | 266 | 0.930876 | 2.47613016 | Halalkalicoccus | 332246 | Archaea | Archaea | 446 | 9.549999999999999e-121 | NTclustered | gi|1779814881|ref|NR_164956.1| | 2675002 | g37607 | i0 | 96.992 | 101.661654135338 | 266 | 7 | 99 | 1 | 2 | 266 | 281 | 16 | Halalkalicoccus subterraneus strain GSM28 16S ribosomal RNA, partial sequence | blastn | 27042 | 446 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus subterraneus | |
| 27658441 | 27658441 | PRJNA986481_P_NODE_14544_length_430_cov_2.036745_g14019_i0 | PRJNA986481 | 14544 | 430 | 2.036745 | 8.7580035 | Haloferacaceae | 1644056 | Archaea | Archaea | 67.4 | 7.42e-10 | NR | WP_122104754.1 | 1644056 | g14019 | i0 | 34.7 | 4.08837209302326 | 118 | 66 | 76.7 | 3 | 365 | 36 | 1912 | 2026 | WP_122104754.1 MULTISPECIES: malectin domain-containing carbohydrate-binding protein [Haloferacaceae] | diamond | 1758 | 67.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | |||
| 29079225 | 29079225 | PRJNA986481_P_NODE_60528_length_241_cov_1.046875_g60003_i0 | PRJNA986481 | 60528 | 241 | 1.046875 | 2.52296875 | Methanoregulaceae archaeon | 2485498 | Archaea | Archaea | 48.9 | 2.33e-4 | NR | RPI38806.1 | 2485498 | g60003 | i0 | 39.7 | 0.721991701244813 | 58 | 32 | 72.2 | 1 | 63 | 236 | 185 | 239 | RPI38806.1 MAG: hypothetical protein EHM53_07905 [Methanoregulaceae archaeon] | diamond | 174 | 48.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregulaceae archaeon | ||
| 30632502 | 30632502 | PRJNA986481_P_NODE_51633_length_250_cov_1.875622_g51108_i0 | PRJNA986481 | 51633 | 250 | 1.875622 | 4.689055 | Methanomicrobiales | 2191 | Archaea | Archaea | 49.7 | 1.39e-4 | NR | WP_346733691.1 | 90427 | g51108 | i0 | 37.8 | 3.732 | 82 | 28 | 94.8 | 3 | 3 | 239 | 201 | 262 | WP_346733691.1 kelch repeat-containing protein [Methanoculleus sp.] | diamond | 933 | 50.1 | 0.992015968063872 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanoculleus | Methanoculleus sp. | |
| 31069258 | 31069258 | PRJNA986481_P_NODE_28435_length_307_cov_3.449612_g27910_i0 | PRJNA986481 | 28435 | 307 | 3.449612 | 10.59030884 | Candidatus Methanophagales archaeon | 2056316 | Archaea | Archaea | 45.8 | 0.00585 | NR | MCR5852524.1 | 2056316 | g27910 | i0 | 29.3 | 1.60260586319218 | 82 | 57 | 80.1 | 1 | 302 | 57 | 81 | 161 | MCR5852524.1 hypothetical protein [Candidatus Methanophagales archaeon] | diamond | 492 | 45.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Candidatus Methanophagales | Candidatus Methanophagales 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);;