contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJNA1204310" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3595461 | 3595461 | PRJNA1204310_P_NODE_12543_length_497_cov_3.733491_g12246_i0 | PRJNA1204310 | 12543 | 497 | 3.733491 | 18.55545027 | Fungi | 4751 | Fungi | Fungi | 287 | 1.2199999999999998e-72 | NTclustered | gi|2028324920|ref|XM_040888337.1| | 61395 | g12246 | i0 | 79.756 | 18.897384305835 | 410 | 71 | 81 | 12 | 81 | 484 | 404 | 1 | Linderina pennispora uncharacterized protein (DL89DRAFT_269536), partial mRNA | blastn | 9392 | 287 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina pennispora | |
| 7982699 | 7982699 | PRJNA1204310_P_NODE_36467_length_309_cov_0.991525_g36170_i0 | PRJNA1204310 | 36467 | 309 | 0.991525 | 3.06381225 | Kickxella alabastrina | 61397 | Fungi | Fungi | 182 | 3.53e-41 | NTclustered | gi|2324013387|ref|XM_051535816.1| | 61397 | g36170 | i0 | 78.157 | 26.3980582524272 | 293 | 58 | 94 | 6 | 1 | 290 | 11207 | 10918 | Kickxella alabastrina uncharacterized protein (BX661DRAFT_181839), mRNA | blastn | 8157 | 182 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Kickxella | Kickxella alabastrina | |
| 9257460 | 9257460 | PRJNA1204310_P_NODE_49328_length_258_cov_1.475676_g49031_i0 | PRJNA1204310 | 49328 | 258 | 1.475676 | 3.80724408 | Linderina pennispora | 61395 | Fungi | Fungi | 56.5 | 0.002 | NTclustered | gi|2028319880|ref|XM_040883577.1| | 61395 | g49031 | i0 | 92.5 | 0.418604651162791 | 40 | 2 | 15 | 1 | 158 | 196 | 240 | 279 | Linderina pennispora uncharacterized protein (DL89DRAFT_153351), mRNA | blastn | 108 | 56.5 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina pennispora | |
| 24554705 | 24554705 | PRJNA1204310_P_NODE_10920_length_531_cov_1.360262_g10625_i0 | PRJNA1204310 | 10920 | 531 | 1.360262 | 7.22299122 | Linderina pennispora | 61395 | Fungi | Fungi | 399 | 1.6199999999999995e-106 | NTclustered | gi|2028322926|ref|XM_040888010.1| | 61395 | g10625 | i0 | 81.466 | 91.8719397363465 | 491 | 87 | 92 | 4 | 22 | 510 | 883 | 395 | Linderina pennispora 60S ribosomal protein L10-A (DL89DRAFT_268696), partial mRNA | blastn | 48784 | 399 | 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);;