contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA680334" and tax_phylum = "Mucoromycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4477948 | 4477948 | PRJNA680334_S_NODE_5704_length_371_cov_234338.195266_g5219_i0 | PRJNA680334 | 5704 | 371 | 234338.195266 | 869394.70443686 | Glomus sp. Tf 2-16 | 262042 | Fungi | Fungi | 411 | 5.049999999999999e-110 | NTclustered | gi|41353938|gb|AY522919.1| | 262042 | g5219 | i0 | 93.478 | 38.5849056603774 | 276 | 18 | 74 | 0 | 96 | 371 | 306 | 31 | Glomus sp. Tf 2-16 26S ribosomal RNA gene, partial sequence | blastn | 14315 | 411 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Glomerales | Glomeraceae | Glomus | Glomus sp. Tf 2-16 | |
| 7028470 | 7028470 | PRJNA680334_S_NODE_45006_length_198_cov_3.872727_g44520_i0 | PRJNA680334 | 45006 | 198 | 3.872727 | 7.66799946 | Phycomyces blakesleeanus | 4837 | Fungi | Fungi | 78.7 | 2.83e-10 | NTclustered | gi|1069946648|ref|XM_018434100.1| | 763407 | g44520 | i0 | 94.118 | 0.727272727272727 | 51 | 3 | 26 | 0 | 88 | 138 | 455 | 405 | Phycomyces blakesleeanus NRRL 1555(-) cytochrome c oxidase subunit 4 COX4 (COX4_2), partial mRNA | blastn | 144 | 78.7 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Phycomycetaceae | Phycomyces | Phycomyces blakesleeanus | |
| 9578156 | 9578156 | PRJNA680334_S_NODE_32388_length_219_cov_7.209677_g31902_i0 | PRJNA680334 | 32388 | 219 | 7.209677 | 15.78919263 | Umbelopsis ramanniana | 41833 | Fungi | Fungi | 163 | 8.58e-36 | NTclustered | gi|2323699405|ref|XM_051592596.1| | 1314678 | g31902 | i0 | 80.66 | 20.4657534246575 | 212 | 39 | 96 | 2 | 9 | 219 | 432 | 222 | Umbelopsis ramanniana AG uncharacterized protein (K450DRAFT_263142), partial mRNA | blastn | 4482 | 163 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Umbelopsidomycetes | Umbelopsidales | Umbelopsidaceae | Umbelopsis | Umbelopsis ramanniana | |
| 10853982 | 10853982 | PRJNA680334_S_NODE_50529_length_191_cov_3.658228_g50043_i0 | PRJNA680334 | 50529 | 191 | 3.658228 | 6.98721548 | Gamsiella multidivaricata | 101098 | Fungi | Fungi | 152 | 1.57e-32 | NTclustered | gi|2323787328|ref|XM_051556087.1| | 101098 | g50043 | i0 | 93.204 | 11.3403141361257 | 103 | 7 | 54 | 0 | 1 | 103 | 1088 | 1190 | Gamsiella multidivaricata 60S ribosomal protein L3 (BC939DRAFT_454620), mRNA | blastn | 2166 | 152 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Gamsiella | Gamsiella multidivaricata | |
| 13923269 | 13923269 | PRJNA680334_S_NODE_51311_length_190_cov_4.280255_g50825_i0 | PRJNA680334 | 51311 | 190 | 4.280255 | 8.1324845 | Fungi | 4751 | Fungi | Fungi | 145 | 2.6199999999999997e-30 | NTclustered | gi|2323709042|ref|XM_051563602.1| | 64574 | g50825 | i0 | 85.714 | 64.821052631579 | 140 | 16 | 73 | 4 | 33 | 171 | 1 | 137 | Radiomyces spectabilis ribosomal L29e protein family-domain-containing protein (BYT42DRAFT_475122), partial mRNA | blastn | 12316 | 145 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Radiomycetaceae | Radiomyces | Radiomyces spectabilis | |
| 14678804 | 14678804 | PRJNA680334_S_NODE_43132_length_201_cov_2.214286_g42646_i0 | PRJNA680334 | 43132 | 201 | 2.214286 | 4.45071486 | Gongronella sp. w5 | 483437 | Fungi | Fungi | 180 | 7.69e-41 | NTclustered | gi|2301278552|ref|NC_066217.1| | 483437 | g42646 | i0 | 84.699 | 72.6766169154229 | 183 | 25 | 91 | 3 | 13 | 195 | 1197 | 1376 | Gongronella sp. w5 culture CCTCC:AF 2012004 mitochondrion, complete genome | blastn | 14608 | 180 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Cunninghamellaceae | Gongronella | Gongronella sp. w5 | |
| 18502505 | 18502505 | PRJNA680334_S_NODE_74455_length_169_cov_2.014706_g73969_i0 | PRJNA680334 | 74455 | 169 | 2.014706 | 3.40485314 | Radiomyces spectabilis | 64574 | Fungi | Fungi | 145 | 2.26e-30 | NTclustered | gi|2323700946|ref|XM_051566190.1| | 64574 | g73969 | i0 | 82.738 | 20.6745562130178 | 168 | 23 | 98 | 6 | 5 | 169 | 1776 | 1612 | Radiomyces spectabilis peptidase S28 (BYT42DRAFT_550936), mRNA | blastn | 3494 | 145 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Radiomycetaceae | Radiomyces | Radiomyces spectabilis | |
| 21571519 | 21571519 | PRJNA680334_S_NODE_60737_length_180_cov_4.428571_g60251_i0 | PRJNA680334 | 60737 | 180 | 4.428571 | 7.9714278 | Mucorales | 4827 | Fungi | Fungi | 294 | 2.3e-75 | NTclustered | gi|1707324993|gb|MN197918.1| | 42458 | g60251 | i0 | 96.111 | 100.005555555556 | 180 | 7 | 100 | 0 | 1 | 180 | 278 | 99 | Lichtheimia corymbifera isolate T49 large subunit ribosomal RNA gene, partial sequence | blastn | 18001 | 294 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Lichtheimiaceae | Lichtheimia | Lichtheimia corymbifera |
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);;