contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJNA540466" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3058728 | 3058728 | PRJNA540466_S_NODE_13563_length_471_cov_1.474874_g13019_i0 | PRJNA540466 | 13563 | 471 | 1.474874 | 6.94665654 | Kickxella alabastrina | 61397 | Fungi | Fungi | 206 | 3.32e-48 | NTclustered | gi|2323998200|ref|XM_051533948.1| | 61397 | g13019 | i0 | 82.906 | 6.00849256900212 | 234 | 35 | 49 | 4 | 217 | 449 | 601 | 372 | Kickxella alabastrina 40S ribosomal protein S9 (BX661DRAFT_174943), mRNA | blastn | 2830 | 206 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Kickxella | Kickxella alabastrina | |
| 5612007 | 5612007 | PRJNA540466_S_NODE_57365_length_250_cov_1.740113_g56816_i0 | PRJNA540466 | 57365 | 250 | 1.740113 | 4.3502825 | Capillidium heterosporum | 1167838 | Fungi | Fungi | 318 | 2.02e-82 | NTclustered | gi|1583106424|ref|NC_040967.1| | 1167838 | g56816 | i0 | 91.139 | 48.128 | 237 | 17 | 93 | 4 | 6 | 238 | 1047 | 811 | Conidiobolus heterosporus strain RCEF6331 mitochondrion, complete genome | blastn | 12032 | 318 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Ancylistaceae | Capillidium | Capillidium heterosporum | |
| 8160763 | 8160763 | PRJNA540466_S_NODE_27427_length_342_cov_1.230483_g26878_i0 | PRJNA540466 | 27427 | 342 | 1.230483 | 4.20825186 | Kickxella alabastrina | 61397 | Fungi | Fungi | 141 | 6.71e-29 | NTclustered | gi|2324014349|ref|XM_051532979.1| | 61397 | g26878 | i0 | 78.281 | 1.54678362573099 | 221 | 46 | 64 | 2 | 121 | 340 | 514 | 295 | Kickxella alabastrina 60S ribosomal protein L6 (BX661DRAFT_142974), partial mRNA | blastn | 529 | 141 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Kickxella | Kickxella alabastrina | |
| 14536670 | 14536670 | PRJNA540466_S_NODE_17712_length_418_cov_2.736232_g17163_i0 | PRJNA540466 | 17712 | 418 | 2.736232 | 11.43744976 | Capillidium heterosporum | 1167838 | Fungi | Fungi | 254 | 1.03e-62 | NTclustered | gi|1583106424|ref|NC_040967.1| | 1167838 | g17163 | i0 | 90.674 | 18.5406698564593 | 193 | 14 | 45 | 4 | 2 | 190 | 2936 | 2744 | Conidiobolus heterosporus strain RCEF6331 mitochondrion, complete genome | blastn | 7750 | 254 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Ancylistaceae | Capillidium | Capillidium heterosporum | |
| 24734089 | 24734089 | PRJNA540466_S_NODE_49080_length_266_cov_2.093264_g48531_i0 | PRJNA540466 | 49080 | 266 | 2.093264 | 5.56808224 | Microconidiobolus nodosus | 1167817 | Fungi | Fungi | 130 | 1.09e-25 | NTclustered | gi|2032035993|gb|MW795365.1| | 1167817 | g48531 | i0 | 87.179 | 6.59774436090226 | 117 | 12 | 44 | 3 | 23 | 138 | 12860 | 12974 | Microconidiobolus nodosus strain ATCC 16577 mitochondrion, complete genome | blastn | 1755 | 130 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Ancylistaceae | Microconidiobolus | Microconidiobolus nodosus |
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);;