contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJEB83711" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18850627 | 18850627 | PRJEB83711_P_NODE_79935_length_239_cov_4.102410_g79669_i0 | PRJEB83711 | 79935 | 239 | 4.10241 | 9.8047599 | Conidiobolus | 34487 | Fungi | Fungi | 416 | 6.609999999999999e-112 | NTclustered | gi|2863069531|gb|PQ659535.1| | 34488 | g79669 | i0 | 99.138 | 71.1004184100418 | 232 | 0 | 96 | 2 | 10 | 239 | 2 | 233 | Conidiobolus coronatus strain RCEF 7906 large subunit ribosomal RNA gene, partial sequence | blastn | 16993 | 420 | 0.990476190476191 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Ancylistaceae | Conidiobolus | Conidiobolus coronatus | |
| 19269555 | 19269555 | PRJEB83711_P_NODE_45116_length_277_cov_1.284314_g44850_i0 | PRJEB83711 | 45116 | 277 | 1.284314 | 3.55754978 | Pandora neoaphidis | 76017 | Fungi | Fungi | 512 | 9.73e-141 | NTclustered | gi|166812027|gb|EU267193.1| | 76017 | g44850 | i0 | 100 | 99.8483754512635 | 277 | 0 | 100 | 0 | 1 | 277 | 836 | 1112 | 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 | 27658 | 512 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Pandora | Pandora neoaphidis | |
| 19269709 | 19269709 | PRJEB83711_P_NODE_51696_length_263_cov_4.205263_g51430_i0 | PRJEB83711 | 51696 | 263 | 4.205263 | 11.05984169 | Conidiobolus coronatus | 34488 | Fungi | Fungi | 486 | 5.5499999999999986e-133 | NTclustered | gi|6561312|gb|AF113417.1|AF113417 | 34488 | g51430 | i0 | 100 | 101.874524714829 | 263 | 0 | 100 | 0 | 1 | 263 | 50 | 312 | Conidiobolus coronatus strain NRRL1912 18S ribosomal RNA gene, partial sequence | blastn | 26793 | 486 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Ancylistaceae | Conidiobolus | Conidiobolus coronatus | |
| 23096410 | 23096410 | PRJEB83711_P_NODE_56579_length_254_cov_2.414365_g56313_i0 | PRJEB83711 | 56579 | 254 | 2.414365 | 6.1324871 | Conidiobolus coronatus | 34488 | Fungi | Fungi | 453 | 5.41e-123 | NTclustered | gi|87043182|gb|DQ364201.1| | 34488 | g56313 | i0 | 98.819 | 73.5472440944882 | 254 | 3 | 100 | 0 | 1 | 254 | 610 | 357 | Conidiobolus coronatus strain ARSEF 206 28S ribosomal RNA gene, partial sequence | blastn | 18681 | 453 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Ancylistaceae | Conidiobolus | Conidiobolus coronatus | |
| 23096700 | 23096700 | PRJEB83711_P_NODE_69799_length_246_cov_2.838150_g69533_i0 | PRJEB83711 | 69799 | 246 | 2.83815 | 6.981849 | Conidiobolus coronatus | 34488 | Fungi | Fungi | 444 | 3.14e-120 | NTclustered | gi|44936836|gb|AY546691.1| | 34488 | g69533 | i0 | 99.187 | 13.3577235772358 | 246 | 2 | 100 | 0 | 1 | 246 | 1820 | 1575 | Conidiobolus coronatus isolate AFTOL-ID 137 28S large subunit ribosomal RNA gene, partial sequence | blastn | 3286 | 444 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Ancylistaceae | Conidiobolus | Conidiobolus coronatus |
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);;