contig_metadata
18 rows where analysis = "blastn", bioproject = "PRJNA1248471" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1628379 | 1628379 | PRJNA1248471_S_NODE_22482_length_161_cov_1.178571_g22382_i0 | PRJNA1248471 | 22482 | 161 | 1.178571 | 1.89749931 | Exophiala bonariae | 1690606 | Fungi | Fungi | 195 | 2.1e-45 | NTclustered | gi|2724935921|ref|XM_064844748.1| | 1690606 | g22382 | i0 | 88.679 | 14.3416149068323 | 159 | 18 | 99 | 0 | 3 | 161 | 1142 | 984 | Exophiala bonariae uncharacterized protein (LTR84_001122), partial mRNA | blastn | 2309 | 195 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Herpotrichiellaceae | Exophiala | Exophiala bonariae | |
| 1628385 | 1628385 | PRJNA1248471_S_NODE_23422_length_159_cov_2.245455_g23322_i0 | PRJNA1248471 | 23422 | 159 | 2.245455 | 3.57027345 | Capnobotryella renispora | 62132 | Fungi | Fungi | 250 | 4.3499999999999996e-62 | NTclustered | gi|284158812|gb|GU214399.1| | 62132 | g23322 | i0 | 94.969 | 106.761006289308 | 159 | 8 | 100 | 0 | 1 | 159 | 1426 | 1268 | Capnobotryella renispora strain CBS 215.90 28S large subunit ribosomal RNA gene, partial sequence | blastn | 16975 | 250 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Capnobotryella | Capnobotryella renispora | |
| 1628418 | 1628418 | PRJNA1248471_S_NODE_4482_length_264_cov_1.102326_g4382_i0 | PRJNA1248471 | 4482 | 264 | 1.102326 | 2.91014064 | Knufia obscura | 1635080 | Fungi | Fungi | 124 | 5.04e-24 | NTclustered | gi|2725026886|ref|XM_064874392.1| | 1635080 | g4382 | i0 | 77.833 | 13.3863636363636 | 203 | 43 | 77 | 2 | 1 | 202 | 202 | 1 | Knufia obscura uncharacterized protein (PMZ80_005976), partial mRNA | blastn | 3534 | 124 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Trichomeriaceae | Knufia | Knufia obscura | |
| 1628447 | 1628447 | PRJNA1248471_S_NODE_7742_length_218_cov_2.656805_g7642_i0 | PRJNA1248471 | 7742 | 218 | 2.656805 | 5.7918349 | Normandina pulchella | 869219 | Fungi | Fungi | 287 | 4.85e-73 | NTclustered | gi|302180147|gb|GU121585.1| | 869219 | g7642 | i0 | 98.758 | 73.8440366972477 | 161 | 2 | 74 | 0 | 1 | 161 | 453 | 613 | Normandina pulchella isolate L531 18S ribosomal RNA gene, partial sequence | blastn | 16098 | 287 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Verrucariales | Verrucariaceae | Normandina | Normandina pulchella | |
| 4880052 | 4880052 | PRJNA1248471_S_NODE_11724_length_196_cov_4.068027_g11624_i0 | PRJNA1248471 | 11724 | 196 | 4.068027 | 7.97333292 | root | 1 | Root_unresolved | Root_unresolved | 363 | 6.899999999999998e-96 | NTclustered | gi|2765120|emb|Y11713.1| | 61459 | g11624 | i0 | 100 | 100 | 196 | 0 | 100 | 0 | 1 | 196 | 955 | 760 | C.apollinis 18S rRNA gene | blastn | 19600 | 363 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Coniosporium | Coniosporium apollinis | |||
| 5457083 | 5457083 | PRJNA1248471_S_NODE_6705_length_231_cov_2.060440_g6605_i0 | PRJNA1248471 | 6705 | 231 | 2.06044 | 4.7596164 | Staninwardia suttonii | 407955 | Fungi | Fungi | 329 | 8.51e-86 | NTclustered | gi|283827982|gb|DQ923535.2| | 407955 | g6605 | i0 | 92.275 | 100.930735930736 | 233 | 16 | 100 | 1 | 1 | 231 | 2518 | 2750 | Staninwardia suttonii strain CPC 13055 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S large subunit ribosomal RNA gene, partial sequence | blastn | 23315 | 329 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Staninwardia | Staninwardia suttonii | |
| 6731337 | 6731337 | PRJNA1248471_S_NODE_15566_length_177_cov_1.593750_g15466_i0 | PRJNA1248471 | 15566 | 177 | 1.59375 | 2.8209375 | Aspergillus sydowii | 75750 | Fungi | Fungi | 99 | 1.89e-16 | NTclustered | gi|2028207408|ref|XM_040848212.1| | 1036612 | g15466 | i0 | 100 | 0.587570621468927 | 53 | 0 | 30 | 0 | 102 | 154 | 874 | 926 | Aspergillus sydowii CBS 593.65 uncharacterized protein (ASPSYDRAFT_51032), mRNA | blastn | 104 | 99 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus sydowii | |
| 7429923 | 7429923 | PRJNA1248471_S_NODE_4966_length_254_cov_5.804878_g4866_i0 | PRJNA1248471 | 4966 | 254 | 5.804878 | 14.74439012 | Dothideomycetes | 147541 | Fungi | Fungi | 424 | 4.2399999999999996e-114 | NTclustered | gi|34880133|gb|AY374298.1| | 245562 | g4866 | i0 | 98.739 | 93.6692913385827 | 238 | 3 | 94 | 0 | 1 | 238 | 254 | 17 | Acidomyces richmondensis strain B1 18S ribosomal RNA gene, partial sequence | blastn | 23792 | 424 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Acidomyces | Acidomyces sp. 'richmondensis' | |
| 8006963 | 8006963 | PRJNA1248471_S_NODE_16307_length_174_cov_2.448000_g16207_i0 | PRJNA1248471 | 16307 | 174 | 2.448 | 4.25952 | Neophloeospora maculans | 2060153 | Fungi | Fungi | 267 | 4.7999999999999993e-67 | NTclustered | gi|284159083|gb|GU214670.1| | 2060153 | g16207 | i0 | 94.253 | 97.8505747126437 | 174 | 10 | 100 | 0 | 1 | 174 | 3792 | 3619 | Neophloeospora maculans culture CBS:115123 strain CBS 115123 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 17026 | 267 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Neophloeospora | Neophloeospora maculans | |
| 12530610 | 12530610 | PRJNA1248471_S_NODE_17390_length_170_cov_9.190083_g17290_i0 | PRJNA1248471 | 17390 | 170 | 9.190083 | 15.6231411 | root | 1 | Root_unresolved | Root_unresolved | 291 | 2.77e-74 | NTclustered | gi|2582615798|ref|XR_009468002.1| | 5061 | g17290 | i0 | 99.375 | 94.0117647058824 | 160 | 1 | 94 | 0 | 1 | 160 | 2784 | 2625 | Aspergillus niger 28S ribosomal RNA (28S rRNA), partial rRNA | blastn | 15982 | 291 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus niger | |
| 12530641 | 12530641 | PRJNA1248471_S_NODE_7970_length_216_cov_0.988024_g7870_i0 | PRJNA1248471 | 7970 | 216 | 0.988024 | 2.13413184 | root | 1 | Root_unresolved | Root_unresolved | 211 | 2.97e-50 | NTclustered | gi|551533949|gb|KF018451.1| | 5054 | g7870 | i0 | 98.347 | 55.5833333333333 | 121 | 0 | 55 | 2 | 1 | 119 | 566 | 686 | Eurotium amstelodami strain 8.2 18S ribosomal RNA gene, partial sequence | blastn | 12006 | 211 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus amstelodami | |
| 13805377 | 13805377 | PRJNA1248471_S_NODE_2091_length_327_cov_1.147482_g1991_i0 | PRJNA1248471 | 2091 | 327 | 1.147482 | 3.75226614 | Trichomerium | 1233429 | Fungi | Fungi | 425 | 1.57e-114 | NTclustered | gi|2550032664|gb|OR334718.1| | 2815427 | g1991 | i0 | 99.571 | 71.2538226299694 | 233 | 1 | 71 | 0 | 95 | 327 | 315 | 83 | Trichomerium cicatricatum strain G224 large subunit ribosomal RNA gene, partial sequence | blastn | 23300 | 425 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Trichomeriaceae | Trichomerium | Trichomerium cicatricatum | |
| 15079574 | 15079574 | PRJNA1248471_S_NODE_12172_length_194_cov_2.124138_g12072_i0 | PRJNA1248471 | 12172 | 194 | 2.124138 | 4.12082772 | Dothideomycetes | 147541 | Fungi | Fungi | 348 | 1.91e-91 | NTclustered | gi|109289576|gb|DQ678029.1| | 45145 | g12072 | i0 | 99.476 | 112.70618556701 | 191 | 1 | 98 | 0 | 4 | 194 | 1882 | 1692 | Herpotrichia juniperi isolate AFTOL-ID 1608 18S small subunit ribosomal RNA gene, partial sequence | blastn | 21865 | 348 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Melanommataceae | Herpotrichia | Herpotrichia juniperi | |
| 15656673 | 15656673 | PRJNA1248471_S_NODE_7753_length_218_cov_2.005917_g7653_i0 | PRJNA1248471 | 7753 | 218 | 2.005917 | 4.37289906 | Devriesia sp. CPC 11876 | 1485003 | Fungi | Fungi | 387 | 4.649999999999998e-103 | NTclustered | gi|283827924|gb|GQ852622.2| | 1485003 | g7653 | i0 | 98.624 | 100.073394495413 | 218 | 3 | 100 | 0 | 1 | 218 | 1630 | 1847 | Devriesia sp. CPC 11876 culture CPC:11876 28S large subunit ribosomal RNA gene, partial sequence | blastn | 21816 | 387 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Devriesia | Devriesia sp. CPC 11876 | |
| 15656682 | 15656682 | PRJNA1248471_S_NODE_8413_length_212_cov_1.736196_g8313_i0 | PRJNA1248471 | 8413 | 212 | 1.736196 | 3.68073552 | Thermomyces lanuginosus | 5541 | Fungi | Fungi | 180 | 8.19e-41 | NTclustered | gi|2837804442|ref|XM_069415794.1| | 5541 | g8313 | i0 | 83 | 22.7169811320755 | 200 | 32 | 94 | 2 | 1 | 199 | 552 | 750 | Thermomyces lanuginosus uncharacterized protein (VTN49DRAFT_7516), partial mRNA | blastn | 4816 | 180 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Trichocomaceae | Thermomyces | Thermomyces lanuginosus | |
| 20178131 | 20178131 | PRJNA1248471_S_NODE_21516_length_162_cov_2.831858_g21416_i0 | PRJNA1248471 | 21516 | 162 | 2.831858 | 4.58760996 | Ascomycota | 4890 | Fungi | Fungi | 274 | 2.64e-69 | NTclustered | gi|159144724|gb|EU107341.1| | 47239 | g21416 | i0 | 98.701 | 95.0555555555556 | 154 | 2 | 95 | 0 | 9 | 162 | 373 | 526 | Arthrobotrys polycephala isolate P063 18S ribosomal RNA gene, partial sequence | blastn | 15399 | 274 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Orbiliomycetes | Orbiliales | Orbiliaceae | Arthrobotrys | Arthrobotrys polycephala | |
| 23305995 | 23305995 | PRJNA1248471_S_NODE_25119_length_151_cov_2.029412_g25019_i0 | PRJNA1248471 | 25119 | 151 | 2.029412 | 3.06441212 | Aspergillus puulaauensis | 1220207 | Fungi | Fungi | 279 | 5.19e-71 | NTclustered | gi|1968803520|dbj|AP024451.1| | 1220207 | g25019 | i0 | 100 | 99.8079470198676 | 151 | 0 | 100 | 0 | 1 | 151 | 12648 | 12498 | Aspergillus puulaauensis MK2 mitochondrial DNA, complete genome | blastn | 15071 | 279 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus puulaauensis | |
| 24580068 | 24580068 | PRJNA1248471_S_NODE_9220_length_207_cov_2.525316_g9120_i0 | PRJNA1248471 | 9220 | 207 | 2.525316 | 5.22740412 | Phialophora verrucosa | 39412 | Fungi | Fungi | 316 | 5.819999999999998e-82 | NTclustered | gi|336088197|dbj|AB550776.1| | 39412 | g9120 | i0 | 94.203 | 103.835748792271 | 207 | 12 | 100 | 0 | 1 | 207 | 2760 | 2554 | Phialophora verrucosa genes for ITS1, 5.8S rRNA, ITS2 and large subunit rRNA, partial and complete sequence, strain: IFM 5089 | blastn | 21494 | 316 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Herpotrichiellaceae | Phialophora | Phialophora verrucosa |
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);;