contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJDB12134" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8927099 | 8927099 | PRJDB12134_P_NODE_14108_length_243_cov_0.917647_g13973_i0 | PRJDB12134 | 14108 | 243 | 0.917647 | 2.22988221 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 422 | 1.45e-113 | NTclustered | gi|2837721744|ref|XM_069368730.1| | 1052096 | g13973 | i0 | 97.942 | 1 | 243 | 5 | 100 | 0 | 1 | 243 | 293 | 51 | Cladosporium halotolerans uncharacterized protein (WHR41_00124), partial mRNA | blastn | 243 | 422 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 9908811 | 9908811 | PRJDB12134_P_NODE_6168_length_413_cov_1.682353_g6034_i0 | PRJDB12134 | 6168 | 413 | 1.682353 | 6.94811789 | Toxicocladosporium | 470063 | Fungi | Fungi | 763 | 0 | NTclustered | gi|1352883887|gb|MG004757.1| | 470064 | g6034 | i0 | 100 | 99.4382566585956 | 413 | 0 | 100 | 0 | 1 | 413 | 911 | 499 | Toxicocladosporium irritans isolate JN0322 internal transcribed spacer 1, 5.8S ribosmal RNA, internal transcribed spacer 2, and 28S ribosomal RNA intergenic spacer, partial sequence | blastn | 41068 | 763 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Toxicocladosporium | Toxicocladosporium irritans | |
| 11183918 | 11183918 | PRJDB12134_P_NODE_10849_length_276_cov_1.517241_g10714_i0 | PRJDB12134 | 10849 | 276 | 1.517241 | 4.18758516 | Hormonema | 46635 | Fungi | Fungi | 470 | 5.91e-128 | NTclustered | gi|1407920319|gb|MF611880.1| | 284138 | g10714 | i0 | 97.464 | 91.9710144927536 | 276 | 6 | 100 | 1 | 1 | 276 | 3566 | 3292 | Hormonema carpetanum culture ATCC:74360 28S ribosomal RNA gene, complete sequence | blastn | 25384 | 470 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Dothioraceae | Hormonema | Hormonema carpetanum | |
| 11478093 | 11478093 | PRJDB12134_P_NODE_5930_length_424_cov_1.769231_g5796_i0 | PRJDB12134 | 5930 | 424 | 1.769231 | 7.50153944 | Trichoderma atroviride | 63577 | Fungi | Fungi | 86.1 | 4.03e-12 | NTclustered | gi|2749703766|ref|XM_014090103.2| | 63577 | g5796 | i0 | 88 | 1.04009433962264 | 75 | 6 | 18 | 1 | 321 | 395 | 2198 | 2269 | Trichoderma atroviride uncharacterized protein (TrAtP1_012533), partial mRNA | blastn | 441 | 86.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Hypocreaceae | Trichoderma | Trichoderma atroviride | |
| 13734124 | 13734124 | PRJDB12134_P_NODE_11471_length_266_cov_1.611399_g11336_i0 | PRJDB12134 | 11471 | 266 | 1.611399 | 4.28632134 | Toxicocladosporium | 470063 | Fungi | Fungi | 486 | 5.629999999999999e-133 | NTclustered | gi|893146092|emb|LN834446.1| | 470064 | g11336 | i0 | 99.624 | 100.048872180451 | 266 | 1 | 100 | 0 | 1 | 266 | 397 | 662 | Toxicocladosporium irritans genomic DNA sequence contains 28S rRNA gene, strain UTHSC DI-13-181 | blastn | 26613 | 486 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Toxicocladosporium | Toxicocladosporium irritans | |
| 24225875 | 24225875 | PRJDB12134_P_NODE_12680_length_251_cov_0.865169_g12545_i0 | PRJDB12134 | 12680 | 251 | 0.865169 | 2.17157419 | Aspergillus oryzae | 5062 | Fungi | Fungi | 73.1 | 1.75e-8 | NTclustered | gi|1300533110|ref|XM_001817150.3| | 510516 | g12545 | i0 | 92.157 | 1.04382470119522 | 51 | 4 | 20 | 0 | 15 | 65 | 421 | 471 | Aspergillus oryzae RIB40 uncharacterized protein (AO090005000084), partial mRNA | blastn | 262 | 73.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus oryzae |
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);;