contig_metadata
12 rows where bioproject = "PRJNA498309", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12588664 | 12588664 | PRJNA498309_S_NODE_44070_length_190_cov_530.083871_g41902_i0 | PRJNA498309 | 44070 | 190 | 530.083871 | 1007.1593549 | Entomophthoraceae | 34481 | Fungi | Fungi | 287 | 4.11e-73 | NTclustered | gi|849047|dbj|D29948.1|ENMRNAC | 34485 | g41902 | i0 | 100 | 81.2473684210526 | 155 | 0 | 82 | 0 | 36 | 190 | 987 | 833 | Entomophthora muscae gene for 18S rRNA | blastn | 15437 | 287 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora muscae | |
| 17687025 | 17687025 | PRJNA498309_P_NODE_90414_length_218_cov_7.408840_g88265_i0 | PRJNA498309 | 90414 | 218 | 7.40884 | 16.1512712 | Entomophthoraceae | 34481 | Fungi | Fungi | 159 | 1.1e-34 | NTclustered | gi|82398173|gb|DQ273772.1| | 34485 | g88265 | i0 | 95.05 | 52.4082568807339 | 101 | 5 | 46 | 0 | 1 | 101 | 2036 | 1936 | Entomophthora muscae isolate AFTOL-ID 28 28S ribosomal RNA gene, partial sequence | blastn | 11425 | 159 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora muscae | |
| 17687060 | 17687060 | PRJNA498309_P_NODE_93734_length_209_cov_10.267442_g91585_i0 | PRJNA498309 | 93734 | 209 | 10.267442 | 21.45895378 | Conidiobolus | 34487 | Fungi | Fungi | 342 | 9.709999999999999e-90 | NTclustered | gi|158149037|dbj|AB363771.1| | 34488 | g91585 | i0 | 99.471 | 79.6650717703349 | 189 | 0 | 90 | 1 | 1 | 188 | 305 | 117 | Conidiobolus coronatus gene for large subunit rRNA, partial sequence, strain: IFM 46067 | blastn | 16650 | 342 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Ancylistaceae | Conidiobolus | Conidiobolus coronatus | |
| 17687272 | 17687272 | PRJNA498309_S_NODE_20214_length_453_cov_4.617225_g18108_i0 | PRJNA498309 | 20214 | 453 | 4.617225 | 20.91602925 | Entomophthoraceae | 34481 | Fungi | Fungi | 761 | 0 | NTclustered | gi|240104218|gb|DQ481228.2| | 76013 | g18108 | i0 | 97.95 | 145.724061810155 | 439 | 9 | 97 | 0 | 11 | 449 | 693 | 255 | Entomophthora schizophorae isolate ARSEF 6817 28S ribosomal RNA gene, partial sequence | blastn | 66013 | 761 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora schizophorae | |
| 22157886 | 22157886 | PRJNA498309_P_NODE_70098_length_285_cov_4.346774_g67949_i0 | PRJNA498309 | 70098 | 285 | 4.346774 | 12.3883059 | Pandora neoaphidis | 76017 | Fungi | Fungi | 521 | 1.6699999999999996e-143 | NTclustered | gi|1390219702|gb|MH366634.1| | 76017 | g67949 | i0 | 99.649 | 75.6035087719298 | 285 | 1 | 100 | 0 | 1 | 285 | 317 | 33 | Pandora neoaphidis voucher Number 19 large subunit ribosomal RNA gene, partial sequence | blastn | 21547 | 521 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Pandora | Pandora neoaphidis | |
| 22157968 | 22157968 | PRJNA498309_P_NODE_74978_length_267_cov_4860.439130_g72829_i0 | PRJNA498309 | 74978 | 267 | 4860.43913 | 12977.3724771 | Conidiobolus coronatus | 34488 | Fungi | Fungi | 315 | 2.82e-81 | NTclustered | gi|44936836|gb|AY546691.1| | 34488 | g72829 | i0 | 90.833 | 47.2172284644195 | 240 | 14 | 88 | 5 | 24 | 257 | 1927 | 2164 | Conidiobolus coronatus isolate AFTOL-ID 137 28S large subunit ribosomal RNA gene, partial sequence | blastn | 12607 | 315 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Ancylistaceae | Conidiobolus | Conidiobolus coronatus | |
| 24707361 | 24707361 | PRJNA498309_P_NODE_86780_length_229_cov_3.125000_g84631_i0 | PRJNA498309 | 86780 | 229 | 3.125 | 7.15625 | Massospora cicadina | 348617 | Fungi | Fungi | 414 | 2.26e-111 | NTclustered | gi|145308012|gb|EF392548.1| | 348617 | g84631 | i0 | 99.134 | 63.5938864628821 | 231 | 0 | 100 | 1 | 1 | 229 | 507 | 737 | Massospora cicadina strain ARSEF 374 18S ribosomal RNA gene, partial sequence | blastn | 14563 | 414 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Massospora | Massospora cicadina | |
| 27424950 | 27424950 | PRJNA498309_S_NODE_36983_length_233_cov_5.742424_g34815_i0 | PRJNA498309 | 36983 | 233 | 5.742424 | 13.37984792 | Entomophthora muscae | 34485 | Fungi | Fungi | 126 | 9.57e-33 | NR | KAJ9087439.1 | 34485 | g34815 | i0 | 84.3 | 0.901287553648069 | 70 | 11 | 90.1 | 0 | 211 | 2 | 334 | 403 | KAJ9087439.1 hypothetical protein DSO57_1033329 [Entomophthora muscae] | diamond | 210 | 126 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora muscae | |
| 28119251 | 28119251 | PRJNA498309_P_NODE_99625_length_195_cov_1.518987_g97476_i0 | PRJNA498309 | 99625 | 195 | 1.518987 | 2.96202465 | Entomophthora muscae | 34485 | Fungi | Fungi | 115 | 6.55e-29 | NR | KAJ9087439.1 | 34485 | g97476 | i0 | 82.8 | 0.984615384615385 | 64 | 11 | 98.5 | 0 | 194 | 3 | 339 | 402 | KAJ9087439.1 hypothetical protein DSO57_1033329 [Entomophthora muscae] | diamond | 192 | 115 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora muscae | |
| 28324136 | 28324136 | PRJNA498309_P_NODE_54906_length_351_cov_3.761146_g52758_i0 | PRJNA498309 | 54906 | 351 | 3.761146 | 13.20162246 | root | 1 | Root_unresolved | Root_unresolved | 70.1 | 9.44e-12 | NR | KAK9719117.1 | 34480 | g52758 | i0 | 55 | 7.57264957264957 | 60 | 27 | 51.3 | 0 | 27 | 206 | 152 | 211 | KAK9719117.1 hypothetical protein K7432_004982 [Basidiobolus ranarum] | diamond | 2658 | 70.5 | 0.994326241134752 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Basidiobolomycetes | Basidiobolales | Basidiobolaceae | Basidiobolus | Basidiobolus ranarum | |
| 28719300 | 28719300 | PRJNA498309_P_NODE_91907_length_214_cov_3.966102_g89758_i0 | PRJNA498309 | 91907 | 214 | 3.966102 | 8.48745828 | Basidiobolus meristosporus CBS 931.73 | 1314790 | Fungi | Fungi | 52.8 | 2.79e-6 | NR | ORY08420.1 | 1314790 | g89758 | i0 | 73.5 | 3.75700934579439 | 34 | 9 | 47.7 | 0 | 210 | 109 | 125 | 158 | ORY08420.1 Redoxin [Basidiobolus meristosporus CBS 931.73] | diamond | 804 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Basidiobolomycetes | Basidiobolales | Basidiobolaceae | Basidiobolus | Basidiobolus meristosporus | |
| 32575007 | 32575007 | PRJNA498309_P_NODE_50939_length_371_cov_6.712575_g48793_i0 | PRJNA498309 | 50939 | 371 | 6.712575 | 24.90365325 | Syncephalis plumigaleata | 1851185 | Fungi | Fungi | 67.4 | 4.13e-12 | NR | KAI8053990.1 | 1851185 | g48793 | i0 | 63 | 1.31805929919137 | 54 | 19 | 43.7 | 1 | 346 | 185 | 12 | 64 | KAI8053990.1 hypothetical protein BDF22DRAFT_742964 [Syncephalis plumigaleata] | diamond | 489 | 67.4 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Zoopagomycetes | Zoopagales | Piptocephalidaceae | Syncephalis | Syncephalis plumigaleata |
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);;