contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJNA928559" and tax_phylum = "Zoopagomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1252882 | 1252882 | PRJNA928559_P_NODE_185981_length_254_cov_1.712707_g184412_i0 | PRJNA928559 | 185981 | 254 | 1.712707 | 4.35027578 | Orphella | 324624 | Fungi | Fungi | 154 | 6.15e-33 | NTclustered | gi|1405699581|gb|MG845405.1| | 370270 | g184412 | i0 | 93.269 | 42.2322834645669 | 104 | 7 | 41 | 0 | 145 | 248 | 111 | 8 | Orphella avalonensis voucher TN-43-W4 28S ribosomal RNA gene, partial sequence | blastn | 10727 | 154 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Orphellales | Orphellaceae | Orphella | Orphella avalonensis | ||
| 11106249 | 11106249 | PRJNA928559_P_NODE_157469_length_280_cov_1.507246_g155900_i0 | PRJNA928559 | 157469 | 280 | 1.507246 | 4.2202888 | Linderina pennispora | 61395 | Fungi | Fungi | 270 | 6.539999999999999e-68 | NTclustered | gi|2028311668|ref|XM_040886055.1| | 61395 | g155900 | i0 | 85.075 | 37.8071428571429 | 268 | 36 | 95 | 4 | 2 | 267 | 982 | 1247 | Linderina pennispora 26S proteasome subunit P45 (DL89DRAFT_263993), mRNA | blastn | 10586 | 270 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina pennispora | |
| 12383351 | 12383351 | PRJNA928559_P_NODE_58330_length_454_cov_7.286089_g56763_i0 | PRJNA928559 | 58330 | 454 | 7.286089 | 33.07884406 | Entomophaga aulicae | 39303 | Fungi | Fungi | 89.8 | 3.35e-13 | NTclustered | gi|1373048|gb|U35394.1|EAU35394 | 39303 | g56763 | i0 | 83.673 | 16.2202643171806 | 98 | 12 | 21 | 3 | 278 | 372 | 3579 | 3675 | Entomophaga aulicae 18S, ITS-1, 5.8S, ITS-2, and 25S ribosomal RNA genes | blastn | 7364 | 89.8 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophaga | Entomophaga aulicae | |
| 17830628 | 17830628 | PRJNA928559_P_NODE_53894_length_469_cov_7.126263_g52328_i0 | PRJNA928559 | 53894 | 469 | 7.126263 | 33.42217347 | Eukaryota | 2759 | Fungi | Fungi | 99 | 5.77e-16 | NTclustered | gi|82398173|gb|DQ273772.1| | 34485 | g52328 | i0 | 90.541 | 21.63539445629 | 74 | 7 | 16 | 0 | 396 | 469 | 2649 | 2722 | Entomophthora muscae isolate AFTOL-ID 28 28S ribosomal RNA gene, partial sequence | blastn | 10147 | 100 | 0.99 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora muscae |
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);;