contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA533623" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4946327 | 4946327 | PRJNA533623_P_NODE_72184_length_213_cov_3.032895_g70403_i0 | PRJNA533623 | 72184 | 213 | 3.032895 | 6.46006635 | Entomophthoraceae | 34481 | Fungi | Fungi | 344 | 2.76e-90 | NTclustered | gi|18033614|gb|AF351134.1|AF351134 | 176680 | g70403 | i0 | 98.477 | 92.7276995305164 | 197 | 0 | 91 | 1 | 1 | 194 | 1452 | 1648 | Furia ithacensis small subunit ribosomal RNA gene, partial sequence | blastn | 19751 | 344 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Furia | Furia ithacensis | |
| 5610380 | 5610380 | PRJNA533623_P_NODE_45025_length_318_cov_2.704280_g43251_i0 | PRJNA533623 | 45025 | 318 | 2.70428 | 8.5996104 | Capillidium heterosporum | 1167838 | Fungi | Fungi | 220 | 7.7199999999999995e-53 | NTclustered | gi|1583106424|ref|NC_040967.1| | 1167838 | g43251 | i0 | 90.588 | 23.5251572327044 | 170 | 11 | 52 | 5 | 1 | 165 | 2913 | 2744 | Conidiobolus heterosporus strain RCEF6331 mitochondrion, complete genome | blastn | 7481 | 220 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Ancylistaceae | Capillidium | Capillidium heterosporum | |
| 11984680 | 11984680 | PRJNA533623_P_NODE_16490_length_580_cov_10.204239_g14767_i0 | PRJNA533623 | 16490 | 580 | 10.204239 | 59.1845862 | Entomophthora muscae | 34485 | Fungi | Fungi | 429 | 2.26e-115 | NTclustered | gi|82398173|gb|DQ273772.1| | 34485 | g14767 | i0 | 81.35 | 42.13965517241381 | 563 | 73 | 93 | 25 | 30 | 570 | 1729 | 2281 | Entomophthora muscae isolate AFTOL-ID 28 28S ribosomal RNA gene, partial sequence | blastn | 24441 | 429 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora muscae | |
| 15808516 | 15808516 | PRJNA533623_P_NODE_1293_length_1750_cov_34.485494_g792_i0 | PRJNA533623 | 1293 | 1750 | 34.485494 | 603.496145 | Linderina pennispora | 61395 | Fungi | Fungi | 226 | 1e-53 | NTclustered | gi|2028317174|ref|XM_040883984.1| | 61395 | g792 | i0 | 84.12 | 0.434285714285714 | 233 | 37 | 13 | 0 | 834 | 1066 | 254 | 22 | Linderina pennispora SRF-TF-domain-containing protein (DL89DRAFT_201662), partial mRNA | blastn | 760 | 226 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina pennispora | |
| 19632219 | 19632219 | PRJNA533623_P_NODE_2576_length_1327_cov_43.011058_g792_i1 | PRJNA533623 | 2576 | 1327 | 43.011058 | 570.75673966 | Linderina pennispora | 61395 | Fungi | Fungi | 226 | 7.559999999999998e-54 | NTclustered | gi|2028317174|ref|XM_040883984.1| | 61395 | g792 | i1 | 84.12 | 0.572720422004521 | 233 | 37 | 18 | 0 | 834 | 1066 | 254 | 22 | Linderina pennispora SRF-TF-domain-containing protein (DL89DRAFT_201662), partial mRNA | blastn | 760 | 226 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina pennispora | |
| 20908837 | 20908837 | PRJNA533623_P_NODE_54657_length_274_cov_14.657277_g52878_i0 | PRJNA533623 | 54657 | 274 | 14.657277 | 40.16093898 | Entomophthora muscae | 34485 | Fungi | Fungi | 326 | 1.34e-84 | NTclustered | gi|82398173|gb|DQ273772.1| | 34485 | g52878 | i0 | 90.984 | 44.5912408759124 | 244 | 18 | 88 | 3 | 9 | 249 | 2281 | 2039 | Entomophthora muscae isolate AFTOL-ID 28 28S ribosomal RNA gene, partial sequence | blastn | 12218 | 326 | 1 | 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);;