contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA543299" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4336453 | 4336453 | PRJNA543299_P_NODE_13864_length_201_cov_1.342105_g13707_i0 | PRJNA543299 | 13864 | 201 | 1.342105 | 2.69763105 | Cladosporium herbarum | 29918 | Fungi | Fungi | 372 | 1.18e-98 | NTclustered | gi|284158823|gb|GU214410.1| | 29918 | g13707 | i0 | 100 | 99.9502487562189 | 201 | 0 | 100 | 0 | 1 | 201 | 1897 | 2097 | Cladosporium herbarum strain CBS 723.79 28S large subunit ribosomal RNA gene, partial sequence | blastn | 20090 | 372 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium herbarum | |
| 10047086 | 10047086 | PRJNA543299_P_NODE_19208_length_171_cov_1.852459_g19051_i0 | PRJNA543299 | 19208 | 171 | 1.852459 | 3.16770489 | Opisthokonta | 33154 | Fungi | Fungi | 316 | 4.6e-82 | NTclustered | gi|283827952|gb|EU019262.2| | 29917 | g19051 | i0 | 100 | 100 | 171 | 0 | 100 | 0 | 1 | 171 | 2380 | 2550 | Cladosporium cladosporioides strain CBS 109.21 28S large subunit ribosomal RNA gene, partial sequence | blastn | 17100 | 316 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium cladosporioides | |
| 13872503 | 13872503 | PRJNA543299_P_NODE_17971_length_177_cov_1.804688_g17814_i0 | PRJNA543299 | 17971 | 177 | 1.804688 | 3.19429776 | Ascomycota | 4890 | Fungi | Fungi | 327 | 2.2199999999999996e-85 | NTclustered | gi|1338684535|gb|MG889595.1| | 5061 | g17814 | i0 | 100 | 100 | 177 | 0 | 100 | 0 | 1 | 177 | 867 | 691 | Aspergillus niger isolate soil small subunit ribosomal RNA gene, partial sequence | blastn | 17700 | 327 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus niger | |
| 15812428 | 15812428 | PRJNA543299_P_NODE_23073_length_164_cov_0.886957_g22916_i0 | PRJNA543299 | 23073 | 164 | 0.886957 | 1.45460948 | Penicillium verrucosum | 60171 | Fungi | Fungi | 89.8 | 1.04e-13 | NTclustered | gi|2515965191|ref|XM_057219713.1| | 60171 | g22916 | i0 | 98.039 | 0.609756097560976 | 51 | 1 | 31 | 0 | 1 | 51 | 847 | 897 | Penicillium verrucosum uncharacterized protein (N7516_006993), partial mRNA | blastn | 100 | 89.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium verrucosum | |
| 17696593 | 17696593 | PRJNA543299_P_NODE_9134_length_246_cov_1.157360_g8977_i0 | PRJNA543299 | 9134 | 246 | 1.15736 | 2.8471056 | Ascomycota | 4890 | Fungi | Fungi | 438 | 1.4599999999999996e-118 | NTclustered | gi|2034480785|gb|MZ152208.1| | 61296 | g8977 | i0 | 99.177 | 99.2560975609756 | 243 | 2 | 99 | 0 | 4 | 246 | 116 | 358 | Aureobasidium sp. isolate UFMG-CM-Y6821 large subunit ribosomal RNA gene, partial sequence | blastn | 24417 | 438 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Saccotheciaceae | Aureobasidium | Aureobasidium sp. | |
| 18970175 | 18970175 | PRJNA543299_P_NODE_17395_length_180_cov_1.366412_g17238_i0 | PRJNA543299 | 17395 | 180 | 1.366412 | 2.4595416 | Hormonema | 46635 | Fungi | Fungi | 316 | 4.899999999999999e-82 | NTclustered | gi|387156426|emb|HE806159.1| | 209475 | g17238 | i0 | 98.333 | 100 | 180 | 3 | 100 | 0 | 1 | 180 | 1420 | 1599 | Uncultured Dothideomycetes partial 26S rRNA gene, clone EopYyyyy | blastn | 18000 | 316 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | uncultured Dothideomycetes | ||||
| 20245102 | 20245102 | PRJNA543299_P_NODE_26536_length_158_cov_2.807339_g26379_i0 | PRJNA543299 | 26536 | 158 | 2.807339 | 4.43559562 | Nephroma | 48858 | Fungi | Fungi | 292 | 7.07e-75 | NTclustered | gi|1517971702|gb|MH887516.1| | 203384 | g26379 | i0 | 100 | 100 | 158 | 0 | 100 | 0 | 1 | 158 | 4490 | 4647 | Nephroma helveticum small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 15800 | 292 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Peltigerales | Nephromataceae | Nephroma | Nephroma helveticum | |
| 21520692 | 21520692 | PRJNA543299_P_NODE_15097_length_193_cov_1.416667_g14940_i0 | PRJNA543299 | 15097 | 193 | 1.416667 | 2.73416731 | Metschnikowia | 27320 | Fungi | Fungi | 52.8 | 0.017 | NTclustered | gi|927912810|gb|KR815866.1| | 1715865 | g14940 | i0 | 100 | 0.870466321243523 | 28 | 0 | 15 | 0 | 9 | 36 | 186 | 159 | Metschnikowia sp. UFMG-CM-Y3404 26S large subunit ribosomal RNA gene, partial sequence | blastn | 168 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Metschnikowia | Metschnikowia sp. UFMG-CM-Y3404 | |
| 23461897 | 23461897 | PRJNA543299_P_NODE_22959_length_164_cov_0.886957_g22802_i0 | PRJNA543299 | 22959 | 164 | 0.886957 | 1.45460948 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 254 | 3.5e-63 | NTclustered | gi|2837720680|ref|XM_069368823.1| | 1052096 | g22802 | i0 | 94.512 | 1 | 164 | 9 | 100 | 0 | 1 | 164 | 1203 | 1366 | Cladosporium halotolerans uncharacterized protein (WHR41_00217), mRNA | blastn | 164 | 254 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 24070606 | 24070606 | PRJNA543299_P_NODE_13759_length_202_cov_1.189542_g13602_i0 | PRJNA543299 | 13759 | 202 | 1.189542 | 2.40287484 | Eukaryota | 2759 | Fungi | Fungi | 368 | 1.54e-97 | NTclustered | gi|38570335|gb|L76614.1|CCURGOAA | 5570 | g13602 | i0 | 99.505 | 100 | 202 | 1 | 100 | 0 | 1 | 202 | 1379 | 1580 | Cenococcum geophilum strain 349 small subunit ribosomal RNA gene, complete sequence | blastn | 20200 | 368 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Gloniales | Gloniaceae | Cenococcum | Cenococcum geophilum |
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);;