contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJEB20058" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25515983 | 25515983 | PRJEB20058_P_NODE_173321_length_283_cov_9.387387_g170498_i0 | PRJEB20058 | 173321 | 283 | 9.387387 | 26.56630521 | Zoophthora radicans | 42210 | Fungi | Fungi | 523 | 4.5999999999999983e-144 | NTclustered | gi|2489628978|gb|OQ831924.1| | 42210 | g170498 | i0 | 100 | 97.9646643109541 | 283 | 0 | 100 | 0 | 1 | 283 | 1878 | 1596 | Zoophthora radicans strain ATCC 208865 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 27724 | 523 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Zoophthora | Zoophthora radicans | |
| 25517961 | 25517961 | PRJEB20058_P_NODE_220209_length_242_cov_3.977901_g217384_i0 | PRJEB20058 | 220209 | 242 | 3.977901 | 9.62652042 | Neozygites floridana | 164420 | Fungi | Fungi | 169 | 2.07e-37 | NTclustered | gi|22535855|gb|AF296758.1| | 164420 | g217384 | i0 | 89.552 | 49.7892561983471 | 134 | 13 | 55 | 1 | 110 | 242 | 184 | 317 | Neozygites floridana small subunit ribosomal RNA gene, partial sequence | blastn | 12049 | 169 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Neozygitomycetes | Neozygitales | Neozygitaceae | Neozygites | Neozygites floridana | |
| 25649300 | 25649300 | PRJEB20058_P_NODE_114610_length_375_cov_2.863057_g111796_i0 | PRJEB20058 | 114610 | 375 | 2.863057 | 10.73646375 | Rhopalomyces elegans | 78913 | Fungi | Fungi | 316 | 1.15e-81 | NTclustered | gi|82398415|gb|DQ273795.1| | 78913 | g111796 | i0 | 83.38 | 37.6266666666667 | 361 | 41 | 95 | 14 | 9 | 364 | 2467 | 2121 | Rhopalomyces elegans isolate AFTOL-ID 142 28S ribosomal RNA gene, partial sequence | blastn | 14110 | 316 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Zoopagomycetes | Zoopagales | Helicocephalidaceae | Rhopalomyces | Rhopalomyces elegans | |
| 25923729 | 25923729 | PRJEB20058_P_NODE_161236_length_298_cov_4.421941_g158413_i0 | PRJEB20058 | 161236 | 298 | 4.421941 | 13.17738418 | Neozygites parvispora | 164421 | Fungi | Fungi | 274 | 5.43e-69 | NTclustered | gi|22535857|gb|AF296760.1| | 164421 | g158413 | i0 | 88.186 | 31.1946308724832 | 237 | 18 | 77 | 8 | 47 | 276 | 265 | 32 | Neozygites parvispora small subunit ribosomal RNA gene, partial sequence | blastn | 9296 | 274 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Neozygitomycetes | Neozygitales | Neozygitaceae | Neozygites | Neozygites parvispora | |
| 25928752 | 25928752 | PRJEB20058_P_NODE_53892_length_572_cov_105.749511_g51151_i0 | PRJEB20058 | 53892 | 572 | 105.749511 | 604.88720292 | Entomophthora muscae | 34485 | Fungi | Fungi | 422 | 3.73e-113 | NTclustered | gi|82398173|gb|DQ273772.1| | 34485 | g51151 | i0 | 81.038 | 44.3041958041958 | 559 | 80 | 95 | 22 | 1 | 543 | 2231 | 1683 | Entomophthora muscae isolate AFTOL-ID 28 28S ribosomal RNA gene, partial sequence | blastn | 25342 | 422 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora muscae | |
| 26061887 | 26061887 | PRJEB20058_P_NODE_213965_length_246_cov_22.583784_g211141_i0 | PRJEB20058 | 213965 | 246 | 22.583784 | 55.55610864 | Capillidium heterosporum | 1167838 | Fungi | Fungi | 324 | 4.26e-84 | NTclustered | gi|1583106424|ref|NC_040967.1| | 1167838 | g211141 | i0 | 92.857 | 50.2967479674797 | 224 | 14 | 90 | 2 | 2 | 223 | 1047 | 824 | Conidiobolus heterosporus strain RCEF6331 mitochondrion, complete genome | blastn | 12373 | 324 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Ancylistaceae | Capillidium | Capillidium heterosporum | |
| 26564569 | 26564569 | PRJEB20058_P_NODE_123592_length_357_cov_29.905405_g120775_i0 | PRJEB20058 | 123592 | 357 | 29.905405 | 106.76229585 | Zoophthora | 34482 | Fungi | Fungi | 420 | 8.04e-113 | NTclustered | gi|1269236919|gb|MG253005.1| | 42210 | g120775 | i0 | 88.427 | 65.140056022409 | 337 | 34 | 93 | 2 | 1 | 333 | 729 | 394 | Zoophthora radicans isolate ARSEF:11861 small subunit ribosomal RNA gene, partial sequence | blastn | 23255 | 420 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Zoophthora | Zoophthora radicans |
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);;