contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJNA421571" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16999191 | 16999191 | PRJNA421571_P_NODE_100574_length_245_cov_0.895349_g98025_i0 | PRJNA421571 | 100574 | 245 | 0.895349 | 2.19360505 | Linderina pennispora | 61395 | Fungi | Fungi | 167 | 7.57e-37 | NTclustered | gi|2028320666|ref|XM_040889247.1| | 61395 | g98025 | i0 | 82.09 | 0.820408163265306 | 201 | 31 | 81 | 4 | 47 | 244 | 483 | 285 | Linderina pennispora 60S ribosomal protein L11 (DL89DRAFT_274988), partial mRNA | blastn | 201 | 167 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina pennispora | |
| 17001312 | 17001312 | PRJNA421571_P_NODE_75854_length_287_cov_1.439252_g73305_i0 | PRJNA421571 | 75854 | 287 | 1.439252 | 4.13065324 | Zancudomyces culisetae | 1213189 | Fungi | Fungi | 119 | 2.58e-22 | NTclustered | gi|311235631|ref|NG_027648.1| | 1213189 | g73305 | i0 | 85.124 | 105.682926829268 | 121 | 12 | 42 | 4 | 1 | 120 | 2809 | 2924 | Zancudomyces culisetae ATCC 16244 28S rRNA gene, partial sequence; from TYPE material | blastn | 30331 | 119 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Legeriomycetaceae | Zancudomyces | Zancudomyces culisetae | |
| 19548297 | 19548297 | PRJNA421571_P_NODE_24456_length_692_cov_2.617124_g22007_i0 | PRJNA421571 | 24456 | 692 | 2.617124 | 18.11049808 | Linderina pennispora | 61395 | Fungi | Fungi | 374 | 1.3e-98 | NTclustered | gi|2028323302|ref|XM_040891225.1| | 61395 | g22007 | i0 | 79.19 | 33.2456647398844 | 543 | 109 | 78 | 4 | 150 | 690 | 1032 | 492 | Linderina pennispora WD40 repeat-like protein (DL89DRAFT_32066), mRNA | blastn | 23006 | 374 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina pennispora | |
| 22100925 | 22100925 | PRJNA421571_P_NODE_92678_length_251_cov_0.865169_g90129_i0 | PRJNA421571 | 92678 | 251 | 0.865169 | 2.17157419 | Linderina pennispora | 61395 | Fungi | Fungi | 213 | 9.86e-51 | NTclustered | gi|2028324920|ref|XM_040888337.1| | 61395 | g90129 | i0 | 83.128 | 60.1195219123506 | 243 | 31 | 95 | 10 | 1 | 238 | 283 | 46 | Linderina pennispora uncharacterized protein (DL89DRAFT_269536), partial mRNA | blastn | 15090 | 215 | 0.990697674418605 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina pennispora |
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);;