contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA493244" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 455825 | 455825 | PRJNA493244_P_NODE_1486961_length_246_cov_1.383784_g1463836_i0 | PRJNA493244 | 1486961 | 246 | 1.383784 | 3.40410864 | Entomophthora muscae | 34485 | Fungi | Fungi | 455 | 1.4500000000000002e-123 | NTclustered | gi|82398173|gb|DQ273772.1| | 34485 | g1463836 | i0 | 100 | 3.04471544715447 | 246 | 0 | 100 | 0 | 1 | 246 | 1944 | 1699 | Entomophthora muscae isolate AFTOL-ID 28 28S ribosomal RNA gene, partial sequence | blastn | 749 | 455 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora muscae | |
| 1731195 | 1731195 | PRJNA493244_P_NODE_1731242_length_198_cov_2.211679_g1708117_i0 | PRJNA493244 | 1731242 | 198 | 2.211679 | 4.37912442 | Smittium sp. CO-13-W10 | 1214007 | Fungi | Fungi | 121 | 4.64e-23 | NTclustered | gi|397529756|gb|JQ302941.1| | 1214007 | g1708117 | i0 | 81.699 | 37.4444444444444 | 153 | 20 | 77 | 6 | 1 | 153 | 1159 | 1303 | Smittium sp. CO-13-W10 note PCR amp code:433-183 28S ribosomal RNA gene, partial sequence | blastn | 7414 | 121 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Legeriomycetaceae | Smittium | Smittium sp. CO-13-W10 | |
| 3651063 | 3651063 | PRJNA493244_P_NODE_1668463_length_207_cov_3.458904_g1645338_i0 | PRJNA493244 | 1668463 | 207 | 3.458904 | 7.15993128 | Neozygites | 150350 | Fungi | Fungi | 265 | 2.1399999999999997e-66 | NTclustered | gi|514159587|gb|KC822921.1| | 1310154 | g1645338 | i0 | 90.732 | 49.0289855072464 | 205 | 10 | 96 | 5 | 10 | 207 | 263 | 465 | Neozygites osornensis isolate NO1 small subunit ribosomal RNA gene, partial sequence | blastn | 10149 | 265 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Neozygitomycetes | Neozygitales | Neozygitaceae | Neozygites | Neozygites osornensis | |
| 5561326 | 5561326 | PRJNA493244_P_NODE_914205_length_446_cov_25.909091_g891229_i0 | PRJNA493244 | 914205 | 446 | 25.909091 | 115.55454586 | Capillidium heterosporum | 1167838 | Fungi | Fungi | 239 | 3.0900000000000003e-58 | NTclustered | gi|1583106424|ref|NC_040967.1| | 1167838 | g891229 | i0 | 91.477 | 17.7264573991031 | 176 | 11 | 39 | 4 | 1 | 172 | 2919 | 2744 | Conidiobolus heterosporus strain RCEF6331 mitochondrion, complete genome | blastn | 7906 | 239 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Ancylistaceae | Capillidium | Capillidium heterosporum | |
| 5561445 | 5561445 | PRJNA493244_P_NODE_973545_length_418_cov_103.507003_g950480_i0 | PRJNA493244 | 973545 | 418 | 103.507003 | 432.65927254 | Pandora neoaphidis | 76017 | Fungi | Fungi | 658 | 0 | NTclustered | gi|1390220561|gb|MH366739.1| | 76017 | g950480 | i0 | 98.148 | 81.8564593301435 | 378 | 6 | 90 | 1 | 42 | 418 | 1 | 378 | Pandora neoaphidis voucher Number 31 large subunit ribosomal RNA gene, partial sequence | blastn | 34216 | 658 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Pandora | Pandora neoaphidis | |
| 8107991 | 8107991 | PRJNA493244_P_NODE_1069187_length_377_cov_11.411392_g1046070_i0 | PRJNA493244 | 1069187 | 377 | 11.411392 | 43.02094784 | Entomophthora muscae | 34485 | Fungi | Fungi | 355 | 2.44e-93 | NTclustered | gi|82398173|gb|DQ273772.1| | 34485 | g1046070 | i0 | 85.632 | 41.2015915119363 | 348 | 39 | 91 | 10 | 35 | 377 | 1688 | 2029 | Entomophthora muscae isolate AFTOL-ID 28 28S ribosomal RNA gene, partial sequence | blastn | 15533 | 355 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora muscae | |
| 10028094 | 10028094 | PRJNA493244_P_NODE_1452068_length_254_cov_9.963731_g1428943_i0 | PRJNA493244 | 1452068 | 254 | 9.963731 | 25.30787674 | Capillidium | 2878381 | Fungi | Fungi | 315 | 2.66e-81 | NTclustered | gi|2273784342|ref|NC_064684.1| | 181046 | g1428943 | i0 | 91.416 | 10.4763779527559 | 233 | 15 | 91 | 4 | 3 | 232 | 4469 | 4239 | Conidiobolus rhysosporus strain ATCC 12588 mitochondrion, complete genome | blastn | 2661 | 315 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Ancylistaceae | Capillidium | Capillidium rhysosporum | |
| 11303155 | 11303155 | PRJNA493244_P_NODE_1748029_length_184_cov_4.455285_g1724904_i0 | PRJNA493244 | 1748029 | 184 | 4.455285 | 8.1977244 | Entomophthoraceae | 34481 | Fungi | Fungi | 209 | 8.8e-50 | NTclustered | gi|82398173|gb|DQ273772.1| | 34485 | g1724904 | i0 | 87.234 | 72.8913043478261 | 188 | 18 | 100 | 5 | 1 | 184 | 1523 | 1338 | Entomophthora muscae isolate AFTOL-ID 28 28S ribosomal RNA gene, partial sequence | blastn | 13412 | 211 | 0.990521327014218 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora muscae | |
| 11933707 | 11933707 | PRJNA493244_P_NODE_1192170_length_331_cov_6.185185_g1169046_i0 | PRJNA493244 | 1192170 | 331 | 6.185185 | 20.47296235 | Neoconidiobolus thromboides | 76012 | Fungi | Fungi | 254 | 7.96e-63 | NTclustered | gi|2032035963|gb|MW795364.1| | 76012 | g1169046 | i0 | 86.364 | 1.84894259818731 | 242 | 22 | 71 | 10 | 75 | 308 | 32646 | 32408 | Neoconidiobolus thromboides strain ATCC 12587 mitochondrion, complete genome | blastn | 612 | 254 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Ancylistaceae | Neoconidiobolus | Neoconidiobolus thromboides | |
| 17032837 | 17032837 | PRJNA493244_P_NODE_1380754_length_273_cov_6.905660_g1357629_i0 | PRJNA493244 | 1380754 | 273 | 6.90566 | 18.8524518 | Furia neopyralidarum | 181055 | Fungi | Fungi | 473 | 4.51e-129 | NTclustered | gi|20385357|gb|AF368518.1| | 181055 | g1357629 | i0 | 99.237 | 74.4212454212454 | 262 | 2 | 96 | 0 | 12 | 273 | 588 | 849 | Furia neopyralidarum small subunit ribosomal RNA gene, partial sequence | blastn | 20317 | 473 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Furia | Furia neopyralidarum | |
| 20857922 | 20857922 | PRJNA493244_P_NODE_1669577_length_207_cov_2.068493_g1646452_i0 | PRJNA493244 | 1669577 | 207 | 2.068493 | 4.28178051 | Linderina pennispora | 61395 | Fungi | Fungi | 126 | 1.05e-24 | NTclustered | gi|2028324380|ref|XM_040885147.1| | 61395 | g1646452 | i0 | 85.246 | 2.83574879227053 | 122 | 18 | 59 | 0 | 10 | 131 | 473 | 352 | Linderina pennispora ribosomal protein S24, isoform CRA_j (DL89DRAFT_248548), partial mRNA | blastn | 587 | 126 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina pennispora | |
| 22131784 | 22131784 | PRJNA493244_P_NODE_1287138_length_301_cov_1.066667_g1264014_i0 | PRJNA493244 | 1287138 | 301 | 1.066667 | 3.21066767 | Zoophthora radicans | 42210 | Fungi | Fungi | 516 | 8.259999999999999e-142 | NTclustered | gi|1669295027|gb|MK970714.1| | 42210 | g1264014 | i0 | 100 | 82.9568106312292 | 279 | 0 | 93 | 0 | 1 | 279 | 294 | 16 | Zoophthora radicans strain ARSEF3376 large subunit ribosomal RNA gene, partial sequence | blastn | 24970 | 516 | 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);;