contig_metadata
3 rows where analysis = "diamond", bioproject = "PRJNA630877" and tax_phylum = "Mucoromycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27238836 | 27238836 | PRJNA630877_S_NODE_112863_length_201_cov_1.443750_g93726_i0 | PRJNA630877 | 112863 | 201 | 1.44375 | 2.9019375 | Jimgerdemannia flammicorona | 994334 | Fungi | Fungi | 42.7 | 0.0225 | NR | RUP52310.1 | 994334 | g93726 | i0 | 44.1 | 0.507462686567164 | 34 | 19 | 50.7 | 0 | 126 | 25 | 239 | 272 | RUP52310.1 beta galactosidase [Jimgerdemannia flammicorona] | diamond | 102 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Endogonomycetes | Endogonales | Endogonaceae | Jimgerdemannia | Jimgerdemannia flammicorona | |
| 27554542 | 27554542 | PRJNA630877_S_NODE_84544_length_274_cov_23.819742_g65407_i0 | PRJNA630877 | 84544 | 274 | 23.819742 | 65.26609308 | Umbelopsis sp. PMI_123 | 1896174 | Fungi | Fungi | 40.4 | 0.0377 | NR | KAH8549584.1 | 1896174 | g65407 | i0 | 73.1 | 0.284671532846715 | 26 | 5 | 26.3 | 1 | 273 | 202 | 27 | 52 | KAH8549584.1 hypothetical protein BGW37DRAFT_403801, partial [Umbelopsis sp. PMI_123] | diamond | 78 | 40.4 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Umbelopsidomycetes | Umbelopsidales | Umbelopsidaceae | Umbelopsis | Umbelopsis sp. PMI_123 | |
| 32338336 | 32338336 | PRJNA630877_S_NODE_117579_length_193_cov_27.335526_g98442_i0 | PRJNA630877 | 117579 | 193 | 27.335526 | 52.75756518 | root | 1 | Root_unresolved | Root_unresolved | 79 | 1.8e-15 | NR | CAG8817805.1 | 4874 | g98442 | i0 | 97.4 | 1565.34715025907 | 39 | 1 | 60.6 | 0 | 3 | 119 | 295 | 333 | CAG8817805.1 31082_t:CDS:2 [Gigaspora margarita] | diamond | 302112 | 79 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Diversisporales | Gigasporaceae | Gigaspora | Gigaspora margarita |
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);;