contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA550047" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 512630 | 512630 | PRJNA550047_P_NODE_13041_length_550_cov_33.792453_g11200_i0 | PRJNA550047 | 13041 | 550 | 33.792453 | 185.8584915 | Pandora neoaphidis | 76017 | Fungi | Fungi | 1007 | 0 | NTclustered | gi|166812027|gb|EU267193.1| | 76017 | g11200 | i0 | 99.818 | 84.6472727272727 | 548 | 1 | 99 | 0 | 1 | 548 | 618 | 1165 | Pandora neoaphidis ARSEF 7939 pn7939-3 MboI- pattern 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 25S ribosomal RNA gene, partial sequence | blastn | 46556 | 1007 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Pandora | Pandora neoaphidis | |
| 1789210 | 1789210 | PRJNA550047_P_NODE_202462_length_339_cov_13.563910_g200501_i0 | PRJNA550047 | 202462 | 339 | 13.56391 | 45.9816549 | Pandora neoaphidis | 76017 | Fungi | Fungi | 604 | 1.9599999999999993e-168 | NTclustered | gi|166812027|gb|EU267193.1| | 76017 | g200501 | i0 | 98.82 | 96.976401179941 | 339 | 4 | 100 | 0 | 1 | 339 | 2 | 340 | Pandora neoaphidis ARSEF 7939 pn7939-3 MboI- pattern 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 25S ribosomal RNA gene, partial sequence | blastn | 32875 | 604 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Pandora | Pandora neoaphidis | |
| 4343806 | 4343806 | PRJNA550047_P_NODE_46244_length_351_cov_12.946043_g44286_i0 | PRJNA550047 | 46244 | 351 | 12.946043 | 45.44061093 | Pandora neoaphidis | 76017 | Fungi | Fungi | 649 | 0 | NTclustered | gi|166812027|gb|EU267193.1| | 76017 | g44286 | i0 | 100 | 100.965811965812 | 351 | 0 | 100 | 0 | 1 | 351 | 1659 | 1309 | Pandora neoaphidis ARSEF 7939 pn7939-3 MboI- pattern 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 25S ribosomal RNA gene, partial sequence | blastn | 35439 | 649 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Pandora | Pandora neoaphidis | |
| 5619338 | 5619338 | PRJNA550047_P_NODE_36485_length_389_cov_25.990506_g34540_i0 | PRJNA550047 | 36485 | 389 | 25.990506 | 101.10306834 | Pandora neoaphidis | 76017 | Fungi | Fungi | 713 | 0 | NTclustered | gi|1390219702|gb|MH366634.1| | 76017 | g34540 | i0 | 99.743 | 90.9614395886889 | 389 | 1 | 100 | 0 | 1 | 389 | 6 | 394 | Pandora neoaphidis voucher Number 19 large subunit ribosomal RNA gene, partial sequence | blastn | 35384 | 713 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Pandora | Pandora neoaphidis | |
| 6891388 | 6891388 | PRJNA550047_P_NODE_205546_length_329_cov_4.437500_g203578_i0 | PRJNA550047 | 205546 | 329 | 4.4375 | 14.599375 | Entomophthora muscae | 34485 | Fungi | Fungi | 431 | 3.4e-116 | NTclustered | gi|82398173|gb|DQ273772.1| | 34485 | g203578 | i0 | 90.39 | 105.993920972644 | 333 | 25 | 100 | 5 | 1 | 329 | 2449 | 2778 | Entomophthora muscae isolate AFTOL-ID 28 28S ribosomal RNA gene, partial sequence | blastn | 34872 | 431 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora muscae | |
| 10050715 | 10050715 | PRJNA550047_P_NODE_591968_length_200_cov_12.622047_g589995_i0 | PRJNA550047 | 591968 | 200 | 12.622047 | 25.244094 | Ancylistaceae | 34486 | Fungi | Fungi | 202 | 1.6299999999999996e-47 | NTclustered | gi|2032035963|gb|MW795364.1| | 76012 | g589995 | i0 | 91.275 | 4.37 | 149 | 12 | 75 | 1 | 50 | 198 | 32695 | 32842 | Neoconidiobolus thromboides strain ATCC 12587 mitochondrion, complete genome | blastn | 874 | 204 | 0.990196078431373 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Ancylistaceae | Neoconidiobolus | Neoconidiobolus thromboides | |
| 11995991 | 11995991 | PRJNA550047_P_NODE_489810_length_234_cov_3.515528_g487837_i0 | PRJNA550047 | 489810 | 234 | 3.515528 | 8.22633552 | Entomophaga aulicae | 39303 | Fungi | Fungi | 267 | 6.87e-67 | NTclustered | gi|1373048|gb|U35394.1|EAU35394 | 39303 | g487837 | i0 | 94.253 | 34.7692307692308 | 174 | 10 | 74 | 0 | 1 | 174 | 5887 | 6060 | Entomophaga aulicae 18S, ITS-1, 5.8S, ITS-2, and 25S ribosomal RNA genes | blastn | 8136 | 267 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophaga | Entomophaga aulicae | |
| 14541348 | 14541348 | PRJNA550047_P_NODE_11452_length_571_cov_40.347390_g9642_i0 | PRJNA550047 | 11452 | 571 | 40.34739 | 230.3835969 | Entomophthora muscae | 34485 | Fungi | Fungi | 435 | 4.79e-117 | NTclustered | gi|82398173|gb|DQ273772.1| | 34485 | g9642 | i0 | 80.847 | 41.3747810858144 | 590 | 82 | 100 | 23 | 1 | 571 | 1693 | 2270 | Entomophthora muscae isolate AFTOL-ID 28 28S ribosomal RNA gene, partial sequence | blastn | 23625 | 435 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora muscae | |
| 20247248 | 20247248 | PRJNA550047_P_NODE_276136_length_299_cov_6.964602_g274167_i0 | PRJNA550047 | 276136 | 299 | 6.964602 | 20.82415998 | Zoophthora | 34482 | Fungi | Fungi | 189 | 2.0299999999999993e-43 | NTclustered | gi|1269236919|gb|MG253005.1| | 42210 | g274167 | i0 | 90 | 50.7993311036789 | 150 | 10 | 49 | 5 | 1 | 148 | 1272 | 1418 | Zoophthora radicans isolate ARSEF:11861 small subunit ribosomal RNA gene, partial sequence | blastn | 15189 | 189 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Zoophthora | Zoophthora radicans | |
| 23468633 | 23468633 | PRJNA550047_P_NODE_424759_length_255_cov_18.016484_g422787_i0 | PRJNA550047 | 424759 | 255 | 18.016484 | 45.9420342 | Pandora neoaphidis | 76017 | Fungi | Fungi | 472 | 1.5e-128 | NTclustered | gi|1390219702|gb|MH366634.1| | 76017 | g422787 | i0 | 100 | 59.4235294117647 | 255 | 0 | 100 | 0 | 1 | 255 | 431 | 685 | Pandora neoaphidis voucher Number 19 large subunit ribosomal RNA gene, partial sequence | blastn | 15153 | 472 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Pandora | Pandora neoaphidis | |
| 25348664 | 25348664 | PRJNA550047_P_NODE_603020_length_197_cov_8.250000_g601047_i0 | PRJNA550047 | 603020 | 197 | 8.25 | 16.2525 | Zoophthora | 34482 | Fungi | Fungi | 364 | 1.929999999999999e-96 | NTclustered | gi|402230191|gb|JX242644.1| | 42210 | g601047 | i0 | 100 | 12.2944162436548 | 197 | 0 | 100 | 0 | 1 | 197 | 118 | 314 | Zoophthora radicans strain ARSEF 388 16S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 2422 | 364 | 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);;