contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA719595" and tax_phylum = "Ascomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1985540 | 1985540 | PRJNA719595_P_NODE_8702_length_245_cov_0.906977_g8667_i0 | PRJNA719595 | 8702 | 245 | 0.906977 | 2.22209365 | Yarrowia lipolytica | 4952 | Fungi | Fungi | 372 | 1.49e-98 | NTclustered | gi|2801357908|ref|XM_503717.3| | 4952 | g8667 | i0 | 100 | 0.820408163265306 | 201 | 0 | 82 | 0 | 45 | 245 | 2640 | 2440 | Yarrowia lipolytica uncharacterized protein (YALI1_E11136g), partial mRNA | blastn | 201 | 372 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Yarrowia | Yarrowia lipolytica | ||
| 5813034 | 5813034 | PRJNA719595_P_NODE_6505_length_253_cov_0.866667_g6470_i0 | PRJNA719595 | 6505 | 253 | 0.866667 | 2.19266751 | Cercospora kikuchii | 84275 | Fungi | Fungi | 424 | 4.22e-114 | NTclustered | gi|2124596981|ref|XM_044795495.1| | 84275 | g6470 | i0 | 96.838 | 2 | 253 | 8 | 100 | 0 | 1 | 253 | 794 | 542 | Cercospora kikuchii uncharacterized protein (CKM354_000040800), partial mRNA | blastn | 506 | 424 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Cercospora | Cercospora kikuchii | |
| 8362785 | 8362785 | PRJNA719595_P_NODE_7567_length_249_cov_0.886364_g7532_i0 | PRJNA719595 | 7567 | 249 | 0.886364 | 2.20704636 | Cladosporium cladosporioides | 29917 | Fungi | Fungi | 436 | 5.32e-118 | NTclustered | gi|301015197|gb|GQ906475.1| | 29917 | g7532 | i0 | 98.387 | 88.3333333333333 | 248 | 4 | 99 | 0 | 2 | 249 | 248 | 495 | Cladosporium cladosporioides transaldolase mRNA, complete cds | blastn | 21995 | 436 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium cladosporioides | |
| 10913506 | 10913506 | PRJNA719595_P_NODE_8629_length_245_cov_0.906977_g8594_i0 | PRJNA719595 | 8629 | 245 | 0.906977 | 2.22209365 | Purpureocillium takamizusanense | 2060973 | Fungi | Fungi | 143 | 1.28e-29 | NTclustered | gi|2234652211|ref|XM_047983266.1| | 2060973 | g8594 | i0 | 82.635 | 12.6408163265306 | 167 | 23 | 67 | 5 | 6 | 169 | 1154 | 1317 | Purpureocillium takamizusanense Glutamine synthetase (GLN1), mRNA | blastn | 3097 | 143 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Ophiocordycipitaceae | Purpureocillium | Purpureocillium takamizusanense | |
| 11397010 | 11397010 | PRJNA719595_P_NODE_6429_length_253_cov_0.866667_g6394_i0 | PRJNA719595 | 6429 | 253 | 0.866667 | 2.19266751 | Cladosporium | 5498 | Fungi | Fungi | 414 | 2.54e-111 | NTclustered | gi|1905450536|gb|MN657180.1| | 1707700 | g6394 | i0 | 96.774 | 92.6679841897233 | 248 | 8 | 98 | 0 | 6 | 253 | 5430 | 5183 | Cladosporium sp. strain YFCC8620 mitochondrion, complete genome | blastn | 23445 | 418 | 0.990430622009569 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium sp. | |
| 21112077 | 21112077 | PRJNA719595_P_NODE_8137_length_247_cov_0.896552_g8102_i0 | PRJNA719595 | 8137 | 247 | 0.896552 | 2.21448344 | Candida albicans | 5476 | Fungi | Fungi | 52.8 | 0.022 | NTclustered | gi|1111954566|ref|XM_717482.2| | 237561 | g8102 | i0 | 100 | 0.11336032388664 | 28 | 0 | 11 | 0 | 31 | 58 | 1192 | 1219 | Candida albicans SC5314 cleavage polyadenylation factor subunit (CAALFM_C202150CA), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Candida | Candida albicans |
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);;