contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA911178" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9820898 | 9820898 | PRJNA911178_P_NODE_306448_length_219_cov_55.253425_g303974_i0 | PRJNA911178 | 306448 | 219 | 55.253425 | 121.00500075 | Zoophthora radicans | 42210 | Fungi | Fungi | 318 | 1.73e-82 | NTclustered | gi|358441451|gb|JN939182.1| | 42210 | g303974 | i0 | 98.352 | 98.4155251141552 | 182 | 1 | 83 | 2 | 4 | 185 | 922 | 1101 | Erynia radicans strain CSB 607.92 28S ribosomal RNA (LSU) gene, partial sequence | blastn | 21553 | 318 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Zoophthora | Zoophthora radicans | |
| 11095360 | 11095360 | PRJNA911178_P_NODE_165809_length_291_cov_13.321101_g163336_i0 | PRJNA911178 | 165809 | 291 | 13.321101 | 38.76440391 | Lancisporomyces vernalis | 1402970 | Fungi | Fungi | 156 | 1.9999999999999998e-33 | NTclustered | gi|545689718|gb|KC297575.1| | 1402970 | g163336 | i0 | 77.899 | 72.1580756013746 | 276 | 43 | 92 | 18 | 11 | 279 | 1077 | 1341 | Lancisporomyces vernalis 28S ribosomal RNA gene, partial sequence | blastn | 20998 | 156 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Legeriomycetaceae | Lancisporomyces | Lancisporomyces vernalis | |
| 11454526 | 11454526 | PRJNA911178_P_NODE_82109_length_392_cov_43.429467_g79642_i0 | PRJNA911178 | 82109 | 392 | 43.429467 | 170.24351064 | Entomophthoraceae | 34481 | Fungi | Fungi | 712 | 0 | NTclustered | gi|1269236915|gb|MG252968.1| | 42210 | g79642 | i0 | 100 | 99.3137755102041 | 385 | 0 | 98 | 0 | 7 | 391 | 1230 | 1614 | Zoophthora radicans voucher 41 small subunit ribosomal RNA gene, partial sequence | blastn | 38931 | 712 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Zoophthora | Zoophthora radicans | |
| 12372080 | 12372080 | PRJNA911178_P_NODE_306910_length_215_cov_51.683099_g304436_i0 | PRJNA911178 | 306910 | 215 | 51.683099 | 111.11866285 | Entomophthora muscae | 34485 | Fungi | Fungi | 228 | 2.929999999999999e-55 | NTclustered | gi|82398173|gb|DQ273772.1| | 34485 | g304436 | i0 | 86.385 | 58.6604651162791 | 213 | 23 | 97 | 3 | 7 | 215 | 2474 | 2684 | Entomophthora muscae isolate AFTOL-ID 28 28S ribosomal RNA gene, partial sequence | blastn | 12612 | 228 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora muscae | |
| 15277786 | 15277786 | PRJNA911178_P_NODE_18452_length_780_cov_8.493635_g16349_i0 | PRJNA911178 | 18452 | 780 | 8.493635 | 66.250353 | Fungi | 4751 | Fungi | Fungi | 401 | 6.739999999999998e-107 | NTclustered | gi|2028327270|ref|XM_040888737.1| | 61395 | g16349 | i0 | 81.673 | 62.3384615384615 | 502 | 75 | 63 | 15 | 15 | 509 | 852 | 361 | Linderina pennispora 40S ribosomal protein S2 (DL89DRAFT_270502), mRNA | blastn | 48624 | 405 | 0.990123456790123 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina pennispora | |
| 17470959 | 17470959 | PRJNA911178_P_NODE_27534_length_645_cov_55.568182_g25207_i0 | PRJNA911178 | 27534 | 645 | 55.568182 | 358.4147739 | Zoophthora radicans | 42210 | Fungi | Fungi | 1181 | 0 | NTclustered | gi|2489628978|gb|OQ831924.1| | 42210 | g25207 | i0 | 99.844 | 83.7875968992248 | 643 | 0 | 99 | 1 | 1 | 643 | 2235 | 1594 | 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 | 54043 | 1181 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Zoophthora | Zoophthora radicans | |
| 17470963 | 17470963 | PRJNA911178_P_NODE_275594_length_244_cov_1.327485_g273120_i0 | PRJNA911178 | 275594 | 244 | 1.327485 | 3.2390634 | Capillidium heterosporum | 1167838 | Fungi | Fungi | 268 | 2.01e-67 | NTclustered | gi|1583106424|ref|NC_040967.1| | 1167838 | g273120 | i0 | 87.045 | 49.3688524590164 | 247 | 20 | 100 | 10 | 1 | 244 | 972 | 735 | Conidiobolus heterosporus strain RCEF6331 mitochondrion, complete genome | blastn | 12046 | 268 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Ancylistaceae | Capillidium | Capillidium heterosporum | |
| 20019549 | 20019549 | PRJNA911178_P_NODE_298916_length_235_cov_12.518519_g296442_i0 | PRJNA911178 | 298916 | 235 | 12.518519 | 29.41851965 | Entomophaga aulicae | 39303 | Fungi | Fungi | 102 | 2.06e-17 | NTclustered | gi|1373048|gb|U35394.1|EAU35394 | 39303 | g296442 | i0 | 83.193 | 50.0468085106383 | 119 | 12 | 49 | 8 | 114 | 229 | 5441 | 5328 | Entomophaga aulicae 18S, ITS-1, 5.8S, ITS-2, and 25S ribosomal RNA genes | blastn | 11761 | 102 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophaga | Entomophaga aulicae | |
| 22927367 | 22927367 | PRJNA911178_P_NODE_149098_length_305_cov_83.987069_g146625_i0 | PRJNA911178 | 149098 | 305 | 83.987069 | 256.16056045 | Entomophthoraceae | 34481 | Fungi | Fungi | 545 | 1.07e-150 | NTclustered | gi|1269236915|gb|MG252968.1| | 42210 | g146625 | i0 | 99.666 | 99.6950819672131 | 299 | 0 | 98 | 1 | 8 | 305 | 11 | 309 | Zoophthora radicans voucher 41 small subunit ribosomal RNA gene, partial sequence | blastn | 30407 | 545 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Zoophthora | Zoophthora radicans | |
| 23845349 | 23845349 | PRJNA911178_P_NODE_39539_length_545_cov_90.709746_g37133_i0 | PRJNA911178 | 39539 | 545 | 90.709746 | 494.3681157 | Entomophthora muscae | 34485 | Fungi | Fungi | 392 | 2.78e-104 | NTclustered | gi|82398173|gb|DQ273772.1| | 34485 | g37133 | i0 | 85.455 | 27.3247706422018 | 385 | 46 | 70 | 10 | 145 | 525 | 2061 | 1683 | Entomophthora muscae isolate AFTOL-ID 28 28S ribosomal RNA gene, partial sequence | blastn | 14892 | 392 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora muscae | |
| 25118912 | 25118912 | PRJNA911178_P_NODE_288980_length_242_cov_0.911243_g286506_i0 | PRJNA911178 | 288980 | 242 | 0.911243 | 2.20520806 | Kickxella alabastrina | 61397 | Fungi | Fungi | 122 | 1.6399999999999998e-23 | NTclustered | gi|2324003942|ref|XM_051534639.1| | 61397 | g286506 | i0 | 77.451 | 15.7933884297521 | 204 | 46 | 84 | 0 | 31 | 234 | 1659 | 1456 | Kickxella alabastrina uncharacterized protein (BX661DRAFT_177444), mRNA | blastn | 3822 | 122 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Kickxella | Kickxella alabastrina | |
| 25119154 | 25119154 | PRJNA911178_P_NODE_37600_length_558_cov_3.969072_g35202_i0 | PRJNA911178 | 37600 | 558 | 3.969072 | 22.14742176 | Linderina pennispora | 61395 | Fungi | Fungi | 174 | 1.1199999999999999e-38 | NTclustered | gi|2028313130|ref|XM_040891190.1| | 61395 | g35202 | i0 | 83.246 | 8.90322580645161 | 191 | 30 | 34 | 2 | 6 | 195 | 600 | 789 | Linderina pennispora uncharacterized protein (DL89DRAFT_320180), partial mRNA | blastn | 4968 | 174 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina pennispora | |
| 25477047 | 25477047 | PRJNA911178_P_NODE_35380_length_574_cov_69.984032_g33003_i0 | PRJNA911178 | 35380 | 574 | 69.984032 | 401.70834368 | Entomophthoraceae | 34481 | Fungi | Fungi | 1046 | 0 | NTclustered | gi|968907|dbj|D61381.1|ZORRNAD | 42210 | g33003 | i0 | 100 | 90.2264808362369 | 566 | 0 | 99 | 0 | 3 | 568 | 1096 | 531 | Zoophthora radicans gene for 18S rRNA | blastn | 51790 | 1046 | 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);;