contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJNA1139127" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 285220 | 285220 | PRJNA1139127_P_NODE_38981_length_266_cov_2.911917_g38488_i0 | PRJNA1139127 | 38981 | 266 | 2.911917 | 7.74569922 | Pandora neoaphidis | 76017 | Fungi | Fungi | 460 | 3.41e-125 | NTclustered | gi|1390219702|gb|MH366634.1| | 76017 | g38488 | i0 | 100 | 80.703007518797 | 249 | 0 | 94 | 0 | 18 | 266 | 51 | 299 | Pandora neoaphidis voucher Number 19 large subunit ribosomal RNA gene, partial sequence | blastn | 21467 | 460 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Pandora | Pandora neoaphidis | |
| 1032220 | 1032220 | PRJNA1139127_P_NODE_1361_length_1841_cov_3.345588_g1243_i0 | PRJNA1139127 | 1361 | 1841 | 3.345588 | 61.59227508 | Capillidium | 2878381 | Fungi | Fungi | 990 | 0 | NTclustered | gi|2273784342|ref|NC_064684.1| | 181046 | g1243 | i0 | 83.912 | 13.4703965236285 | 1094 | 116 | 67 | 32 | 798 | 1841 | 4026 | 2943 | Conidiobolus rhysosporus strain ATCC 12588 mitochondrion, complete genome | blastn | 24799 | 990 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Ancylistaceae | Capillidium | Capillidium rhysosporum | |
| 5388232 | 5388232 | PRJNA1139127_P_NODE_19285_length_435_cov_8.859116_g18794_i0 | PRJNA1139127 | 19285 | 435 | 8.859116 | 38.5371546 | Capillidium heterosporum | 1167838 | Fungi | Fungi | 235 | 3.8899999999999994e-57 | NTclustered | gi|1583106424|ref|NC_040967.1| | 1167838 | g18794 | i0 | 91.379 | 18.1034482758621 | 174 | 11 | 39 | 4 | 1 | 170 | 2917 | 2744 | Conidiobolus heterosporus strain RCEF6331 mitochondrion, complete genome | blastn | 7875 | 235 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Ancylistaceae | Capillidium | Capillidium heterosporum | |
| 15587832 | 15587832 | PRJNA1139127_P_NODE_12693_length_582_cov_1.375246_g12216_i0 | PRJNA1139127 | 12693 | 582 | 1.375246 | 8.00393172 | Neoconidiobolus thromboides | 76012 | Fungi | Fungi | 769 | 0 | NTclustered | gi|2032035963|gb|MW795364.1| | 76012 | g12216 | i0 | 92.992 | 56.1872852233677 | 528 | 36 | 91 | 1 | 1 | 527 | 34701 | 34174 | Neoconidiobolus thromboides strain ATCC 12587 mitochondrion, complete genome | blastn | 32701 | 769 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Ancylistaceae | Neoconidiobolus | Neoconidiobolus thromboides |
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);;