contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA758398" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2015571 | 2015571 | PRJNA758398_S_NODE_14882_length_256_cov_3.589372_g14741_i0 | PRJNA758398 | 14882 | 256 | 3.589372 | 9.18879232 | Kickxella alabastrina | 61397 | Fungi | Fungi | 110 | 1.36e-19 | NTclustered | gi|2324005516|ref|XM_051534838.1| | 61397 | g14741 | i0 | 81.343 | 0.68359375 | 134 | 25 | 52 | 0 | 123 | 256 | 178 | 311 | Kickxella alabastrina 50S ribosomal protein L30e-like protein (BX661DRAFT_178169), mRNA | blastn | 175 | 110 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Kickxella | Kickxella alabastrina | |
| 5843253 | 5843253 | PRJNA758398_S_NODE_28545_length_198_cov_1.214765_g28404_i0 | PRJNA758398 | 28545 | 198 | 1.214765 | 2.4052347 | Linderina pennispora | 61395 | Fungi | Fungi | 141 | 3.5600000000000003e-29 | NTclustered | gi|2028324920|ref|XM_040888337.1| | 61395 | g28404 | i0 | 81.928 | 6.7020202020202 | 166 | 30 | 84 | 0 | 5 | 170 | 238 | 403 | Linderina pennispora uncharacterized protein (DL89DRAFT_269536), partial mRNA | blastn | 1327 | 141 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina pennispora | |
| 10943844 | 10943844 | PRJNA758398_S_NODE_29969_length_194_cov_1.303448_g29828_i0 | PRJNA758398 | 29969 | 194 | 1.303448 | 2.52868912 | Kickxella alabastrina | 61397 | Fungi | Fungi | 95.3 | 2.74e-15 | NTclustered | gi|2324009830|ref|XM_051538130.1| | 61397 | g29828 | i0 | 88.462 | 1.92783505154639 | 78 | 9 | 40 | 0 | 117 | 194 | 453 | 376 | Kickxella alabastrina ribosomal protein L22/L17 (BX661DRAFT_197430), partial mRNA | blastn | 374 | 95.3 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Kickxella | Kickxella alabastrina | |
| 13958336 | 13958336 | PRJNA758398_S_NODE_2071_length_638_cov_2.176570_g1944_i0 | PRJNA758398 | 2071 | 638 | 2.17657 | 13.8865166 | Zoopagomycota | 1913638 | Fungi | Fungi | 366 | 1.99e-96 | NTclustered | gi|2028323302|ref|XM_040891225.1| | 61395 | g1944 | i0 | 79.688 | 44.9639498432602 | 512 | 100 | 80 | 4 | 8 | 517 | 523 | 1032 | Linderina pennispora WD40 repeat-like protein (DL89DRAFT_32066), mRNA | blastn | 28687 | 366 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina pennispora | |
| 16042220 | 16042220 | PRJNA758398_S_NODE_1753_length_685_cov_1.588050_g1633_i0 | PRJNA758398 | 1753 | 685 | 1.58805 | 10.8781425 | Spiromyces aspiralis | 68401 | Fungi | Fungi | 383 | 2.1299999999999996e-101 | NTclustered | gi|358030843|dbj|AB609155.1| | 68401 | g1633 | i0 | 78.361 | 25.5182481751825 | 610 | 118 | 88 | 13 | 75 | 677 | 817 | 1419 | Spiromyces aspiralis EF2 gene for translation elongation factor 2, partial cds, strain: NRRL 22631 | blastn | 17480 | 383 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Spiromyces | Spiromyces aspiralis | |
| 24966188 | 24966188 | PRJNA758398_S_NODE_22300_length_218_cov_0.875740_g22159_i0 | PRJNA758398 | 22300 | 218 | 0.87574 | 1.9091132 | Kickxella alabastrina | 61397 | Fungi | Fungi | 52.8 | 0.019 | NTclustered | gi|2324018810|ref|XM_051536865.1| | 61397 | g22159 | i0 | 100 | 0.128440366972477 | 28 | 0 | 13 | 0 | 23 | 50 | 1622 | 1649 | Kickxella alabastrina Calreticulin family-domain-containing protein (BX661DRAFT_185759), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Kickxella | Kickxella alabastrina |
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);;