contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA494251" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 475297 | 475297 | PRJNA494251_P_NODE_20921_length_312_cov_1.288703_g20607_i0 | PRJNA494251 | 20921 | 312 | 1.288703 | 4.02075336 | Linderina pennispora | 61395 | Fungi | Fungi | 252 | 2.68e-62 | NTclustered | gi|2028313086|ref|XM_040889431.1| | 61395 | g20607 | i0 | 83.094 | 53.4326923076923 | 278 | 45 | 89 | 2 | 34 | 310 | 8 | 284 | Linderina pennispora putative adenosylhomocysteinase (DL89DRAFT_277235), partial mRNA | blastn | 16671 | 252 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina pennispora | |
| 3026179 | 3026179 | PRJNA494251_P_NODE_23703_length_297_cov_1.375000_g23389_i0 | PRJNA494251 | 23703 | 297 | 1.375 | 4.08375 | Kickxella alabastrina | 61397 | Fungi | Fungi | 75 | 5.89e-9 | NTclustered | gi|2324014993|ref|XM_051536004.1| | 61397 | g23389 | i0 | 88.525 | 6.3030303030303 | 61 | 7 | 21 | 0 | 76 | 136 | 388 | 448 | Kickxella alabastrina ribosomal L27e protein family-domain-containing protein (BX661DRAFT_182577), mRNA | blastn | 1872 | 75 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Kickxella | Kickxella alabastrina | |
| 3026273 | 3026273 | PRJNA494251_P_NODE_31703_length_266_cov_1.492228_g31389_i0 | PRJNA494251 | 31703 | 266 | 1.492228 | 3.96932648 | Linderina pennispora | 61395 | Fungi | Fungi | 213 | 1.05e-50 | NTclustered | gi|2028324920|ref|XM_040888337.1| | 61395 | g31389 | i0 | 86.528 | 18.9360902255639 | 193 | 26 | 73 | 0 | 74 | 266 | 1143 | 951 | Linderina pennispora uncharacterized protein (DL89DRAFT_269536), partial mRNA | blastn | 5037 | 213 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina pennispora | |
| 4302355 | 4302355 | PRJNA494251_P_NODE_43684_length_245_cov_3.831395_g43370_i0 | PRJNA494251 | 43684 | 245 | 3.831395 | 9.38691775 | Linderina pennispora | 61395 | Fungi | Fungi | 163 | 9.79e-36 | NTclustered | gi|2028324920|ref|XM_040888337.1| | 61395 | g43370 | i0 | 82.353 | 8.02857142857143 | 187 | 33 | 76 | 0 | 1 | 187 | 217 | 403 | Linderina pennispora uncharacterized protein (DL89DRAFT_269536), partial mRNA | blastn | 1967 | 163 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina pennispora | |
| 18326802 | 18326802 | PRJNA494251_P_NODE_17335_length_336_cov_7.307985_g17021_i0 | PRJNA494251 | 17335 | 336 | 7.307985 | 24.5548296 | Linderina pennispora | 61395 | Fungi | Fungi | 67.6 | 1.13e-6 | NTclustered | gi|2028329290|ref|XM_040890787.1| | 61395 | g17021 | i0 | 100 | 1.94047619047619 | 36 | 0 | 11 | 0 | 47 | 82 | 476 | 511 | Linderina pennispora uncharacterized protein (DL89DRAFT_298313), partial mRNA | blastn | 652 | 67.6 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina pennispora | |
| 20876882 | 20876882 | PRJNA494251_P_NODE_15817_length_350_cov_1.072202_g15504_i0 | PRJNA494251 | 15817 | 350 | 1.072202 | 3.752707 | Linderina pennispora | 61395 | Fungi | Fungi | 126 | 1.92e-24 | NTclustered | gi|2028317470|ref|XM_040885084.1| | 61395 | g15504 | i0 | 82.857 | 22.7914285714286 | 140 | 24 | 40 | 0 | 30 | 169 | 422 | 561 | Linderina pennispora 60S ribosomal protein L15 (DL89DRAFT_245082), partial mRNA | blastn | 7977 | 126 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina pennispora | |
| 20877236 | 20877236 | PRJNA494251_P_NODE_40977_length_248_cov_0.880000_g40663_i0 | PRJNA494251 | 40977 | 248 | 0.88 | 2.1824 | Linderina pennispora | 61395 | Fungi | Fungi | 183 | 7.62e-42 | NTclustered | gi|2028312820|ref|XM_040889106.1| | 61395 | g40663 | i0 | 81.092 | 8.875 | 238 | 37 | 94 | 6 | 15 | 248 | 611 | 378 | Linderina pennispora thiamine diphosphate-binding protein (DL89DRAFT_273787), partial mRNA | blastn | 2201 | 183 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina pennispora | |
| 22151987 | 22151987 | PRJNA494251_P_NODE_36958_length_251_cov_0.865169_g36644_i0 | PRJNA494251 | 36958 | 251 | 0.865169 | 2.17157419 | Linderina pennispora | 61395 | Fungi | Fungi | 135 | 2.2e-27 | NTclustered | gi|2028310850|ref|XM_040891123.1| | 61395 | g36644 | i0 | 79.5 | 4.12350597609562 | 200 | 33 | 78 | 7 | 49 | 244 | 1857 | 1662 | Linderina pennispora uncharacterized protein (DL89DRAFT_319369), partial mRNA | blastn | 1035 | 135 | 1 | 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);;