contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA763243" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3294489 | 3294489 | PRJNA763243_P_NODE_3583_length_718_cov_4.361240_g3299_i0 | PRJNA763243 | 3583 | 718 | 4.36124 | 31.3137032 | Entomophthora muscae | 34485 | Fungi | Fungi | 165 | 8.84e-36 | NTclustered | gi|82398173|gb|DQ273772.1| | 34485 | g3299 | i0 | 85.987 | 30.2033426183844 | 157 | 19 | 22 | 3 | 557 | 712 | 2166 | 2320 | Entomophthora muscae isolate AFTOL-ID 28 28S ribosomal RNA gene, partial sequence | blastn | 21686 | 165 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora muscae | |
| 9672541 | 9672541 | PRJNA763243_P_NODE_7428_length_534_cov_6.156182_g7087_i0 | PRJNA763243 | 7428 | 534 | 6.156182 | 32.87401188 | Pandora neoaphidis | 76017 | Fungi | Fungi | 835 | 0 | NTclustered | gi|1390219702|gb|MH366634.1| | 76017 | g7087 | i0 | 99.563 | 73.5243445692884 | 458 | 2 | 99 | 0 | 75 | 532 | 50 | 507 | Pandora neoaphidis voucher Number 19 large subunit ribosomal RNA gene, partial sequence | blastn | 39262 | 835 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Pandora | Pandora neoaphidis | |
| 13959199 | 13959199 | PRJNA763243_P_NODE_2851_length_793_cov_120.550000_g2584_i0 | PRJNA763243 | 2851 | 793 | 120.55 | 955.9615 | Opisthokonta | 33154 | Fungi | Fungi | 182 | 9.729999999999999e-41 | NTclustered | gi|1515573218|gb|MG764572.1| | 2012320 | g2584 | i0 | 86.391 | 21.4249684741488 | 169 | 19 | 21 | 4 | 1 | 168 | 1055 | 890 | Piptocephalis sp. strain Brazil2 large subunit ribosomal RNA gene, partial sequence | blastn | 16990 | 182 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Zoopagomycetes | Zoopagales | Piptocephalidaceae | Piptocephalis | Piptocephalis sp. | |
| 14771621 | 14771621 | PRJNA763243_P_NODE_16172_length_385_cov_7.435897_g15827_i0 | PRJNA763243 | 16172 | 385 | 7.435897 | 28.62820345 | Pandora neoaphidis | 76017 | Fungi | Fungi | 706 | 0 | NTclustered | gi|166812027|gb|EU267193.1| | 76017 | g15827 | i0 | 100 | 98.2103896103896 | 382 | 0 | 99 | 0 | 1 | 382 | 776 | 1157 | 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 | 37811 | 706 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Pandora | Pandora neoaphidis | |
| 21607507 | 21607507 | PRJNA763243_P_NODE_66257_length_234_cov_2.503106_g65911_i0 | PRJNA763243 | 66257 | 234 | 2.503106 | 5.85726804 | Zoophthora | 34482 | Fungi | Fungi | 427 | 2.9799999999999993e-115 | NTclustered | gi|1669295027|gb|MK970714.1| | 42210 | g65911 | i0 | 100 | 93.2777777777778 | 231 | 0 | 99 | 0 | 4 | 234 | 61 | 291 | Zoophthora radicans strain ARSEF3376 large subunit ribosomal RNA gene, partial sequence | blastn | 21827 | 427 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Zoophthora | Zoophthora radicans | |
| 24970762 | 24970762 | PRJNA763243_P_NODE_9200_length_490_cov_10.577938_g8858_i0 | PRJNA763243 | 9200 | 490 | 10.577938 | 51.8318962 | Entomophthora muscae | 34485 | Fungi | Fungi | 381 | 5.369999999999998e-101 | NTclustered | gi|82398173|gb|DQ273772.1| | 34485 | g8858 | i0 | 81.188 | 41.9040816326531 | 505 | 67 | 99 | 20 | 5 | 490 | 1733 | 2228 | Entomophthora muscae isolate AFTOL-ID 28 28S ribosomal RNA gene, partial sequence | blastn | 20533 | 381 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora muscae | |
| 24970774 | 24970774 | PRJNA763243_P_NODE_9820_length_477_cov_5.027228_g9477_i0 | PRJNA763243 | 9820 | 477 | 5.027228 | 23.97987756 | Entomophthora muscae | 34485 | Fungi | Fungi | 398 | 5.1799999999999975e-106 | NTclustered | gi|82398173|gb|DQ273772.1| | 34485 | g9477 | i0 | 85.714 | 36.6540880503145 | 385 | 45 | 80 | 10 | 87 | 467 | 2061 | 1683 | Entomophthora muscae isolate AFTOL-ID 28 28S ribosomal RNA gene, partial sequence | blastn | 17484 | 398 | 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);;