contig_metadata
4 rows where bioproject = "PRJEB20058", tax_phylum = "Candidatus Micrarchaeota" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 33059484 | 33059484 | PRJEB20058_P_NODE_196877_length_258_cov_19.573604_g194053_i0 | PRJEB20058 | 196877 | 258 | 19.573604 | 50.49989832 | Archaea | 2157 | Archaea | Archaea | 46.2 | 0.00109 | NR | MCS7109795.1 | 2250274 | g194053 | i0 | 43.1 | 3.2093023255814 | 58 | 33 | 67.4 | 0 | 253 | 80 | 68 | 125 | MCS7109795.1 multiprotein bridging factor aMBF1 [Candidatus Micrarchaeota archaeon] | diamond | 828 | 46.6 | 0.991416309012876 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeota archaeon | ||||||
| 33064748 | 33064748 | PRJEB20058_P_NODE_215805_length_245_cov_3.396739_g212981_i0 | PRJEB20058 | 215805 | 245 | 3.396739 | 8.32201055 | Candidatus Micrarchaeota archaeon | 2250274 | Archaea | Archaea | 53.5 | 5.71e-6 | NR | HII53269.1 | 2250274 | g212981 | i0 | 39.1 | 0.783673469387755 | 64 | 39 | 78.4 | 0 | 202 | 11 | 11 | 74 | HII53269.1 IS200/IS605 family element transposase accessory protein TnpB [Candidatus Micrarchaeota archaeon] | diamond | 192 | 53.5 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeota archaeon | ||||||
| 33081771 | 33081771 | PRJEB20058_P_NODE_208558_length_250_cov_2.534392_g205734_i0 | PRJEB20058 | 208558 | 250 | 2.534392 | 6.33598 | Candidatus Micrarchaeota archaeon | 2250274 | Archaea | Archaea | 64.3 | 1e-9 | NR | MFH0955368.1 | 2250274 | g205734 | i0 | 97 | 0.396 | 33 | 1 | 39.6 | 0 | 9 | 107 | 974 | 1006 | MFH0955368.1 ATPase, T2SS/T4P/T4SS family [Candidatus Micrarchaeota archaeon] | diamond | 99 | 64.3 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeota archaeon | ||||||
| 33149592 | 33149592 | PRJEB20058_P_NODE_13864_length_1114_cov_11.076923_g12130_i0 | PRJEB20058 | 13864 | 1114 | 11.076923 | 123.39692222 | Candidatus Anstonellaceae archaeon | 2886383 | Archaea | Archaea | 369 | 1.9e-125 | NR | MEM3362628.1 | 2886383 | g12130 | i0 | 97.9 | 0.519748653500898 | 193 | 4 | 52 | 0 | 581 | 3 | 1 | 193 | MEM3362628.1 hypothetical protein [Candidatus Anstonellaceae archaeon] | diamond | 579 | 369 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeia | Candidatus Anstonellales | Candidatus Anstonellaceae | Candidatus Anstonellaceae 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);;