contig_metadata
21 rows where bioproject = "PRJNA664479", tax_kingdom = "Fungi" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1905260 | 1905260 | PRJNA664479_S_NODE_18002_length_162_cov_0.902655_g17926_i0 | PRJNA664479 | 18002 | 162 | 0.902655 | 1.4623011 | Penicillium chrysogenum | 5076 | Fungi | Fungi | 285 | 1.2199999999999998e-72 | NTclustered | gi|2513252651|ref|XM_056711563.1| | 5076 | g17926 | i0 | 100 | 5.60493827160494 | 154 | 0 | 95 | 0 | 9 | 162 | 259 | 412 | Penicillium chrysogenum uncharacterized protein (N7489_005811), partial mRNA | blastn | 908 | 285 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium chrysogenum | |
| 1905264 | 1905264 | PRJNA664479_S_NODE_18882_length_161_cov_0.910714_g18806_i0 | PRJNA664479 | 18882 | 161 | 0.910714 | 1.46624954 | Debaryomyces hansenii | 4959 | Fungi | Fungi | 292 | 7.24e-75 | NTclustered | gi|913748857|ref|NG_042634.1| | 4959 | g18806 | i0 | 99.379 | 88.1180124223603 | 161 | 1 | 100 | 0 | 1 | 161 | 3223 | 3063 | Debaryomyces hansenii NRRL Y-7426 28S rRNA, partial sequence; from TYPE material | blastn | 14187 | 292 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Debaryomyces | Debaryomyces hansenii | |
| 2437466 | 2437466 | PRJNA664479_S_NODE_18862_length_161_cov_0.910714_g18786_i0 | PRJNA664479 | 18862 | 161 | 0.910714 | 1.46624954 | Penicillium | 5073 | Fungi | Fungi | 204 | 3.49e-48 | NTclustered | gi|2513258613|ref|XM_056712508.1| | 5076 | g18786 | i0 | 100 | 2.03726708074534 | 110 | 0 | 68 | 0 | 52 | 161 | 2457 | 2348 | Penicillium chrysogenum uncharacterized protein (N7489_006758), partial mRNA | blastn | 328 | 204 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium chrysogenum | |
| 3180057 | 3180057 | PRJNA664479_S_NODE_18763_length_161_cov_0.910714_g18687_i0 | PRJNA664479 | 18763 | 161 | 0.910714 | 1.46624954 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 270 | 3.389999999999999e-68 | NTclustered | gi|2837728708|ref|XM_069370211.1| | 1052096 | g18687 | i0 | 96.894 | 1.46583850931677 | 161 | 5 | 100 | 0 | 1 | 161 | 392 | 232 | Cladosporium halotolerans Glycogen [starch] synthase (gsy-1), partial mRNA | blastn | 236 | 270 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 3180058 | 3180058 | PRJNA664479_S_NODE_18803_length_161_cov_0.910714_g18727_i0 | PRJNA664479 | 18803 | 161 | 0.910714 | 1.46624954 | Penicillium riverlandense | 1903569 | Fungi | Fungi | 204 | 3.49e-48 | NTclustered | gi|2517683786|ref|XM_057193710.1| | 1903569 | g18727 | i0 | 89.441 | 1 | 161 | 17 | 100 | 0 | 1 | 161 | 1279 | 1439 | Penicillium riverlandense uncharacterized protein (N7474_002295), partial mRNA | blastn | 161 | 204 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium riverlandense | |
| 5732614 | 5732614 | PRJNA664479_S_NODE_17145_length_163_cov_0.894737_g17069_i0 | PRJNA664479 | 17145 | 163 | 0.894737 | 1.45842131 | Yarrowia lipolytica | 4952 | Fungi | Fungi | 302 | 1.22e-77 | NTclustered | gi|2801353433|ref|XM_501339.3| | 4952 | g17069 | i0 | 100 | 1 | 163 | 0 | 100 | 0 | 1 | 163 | 232 | 394 | Yarrowia lipolytica uncharacterized protein (YALI1_C02441g), partial mRNA | blastn | 163 | 302 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Yarrowia | Yarrowia lipolytica | ||
| 6266086 | 6266086 | PRJNA664479_S_NODE_4745_length_242_cov_1.585492_g4669_i0 | PRJNA664479 | 4745 | 242 | 1.585492 | 3.83689064 | Cladosporium | 5498 | Fungi | Fungi | 448 | 2.3799999999999995e-121 | NTclustered | gi|284158823|gb|GU214410.1| | 29918 | g4669 | i0 | 100 | 78.6859504132231 | 242 | 0 | 100 | 0 | 1 | 242 | 3015 | 3256 | Cladosporium herbarum strain CBS 723.79 28S large subunit ribosomal RNA gene, partial sequence | blastn | 19042 | 448 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium herbarum | |
| 9557639 | 9557639 | PRJNA664479_S_NODE_15208_length_166_cov_0.871795_g15132_i0 | PRJNA664479 | 15208 | 166 | 0.871795 | 1.4471797 | Penicillium rubens | 1108849 | Fungi | Fungi | 302 | 1.2500000000000001e-77 | NTclustered | gi|2625684740|ref|XM_002567191.2| | 1108849 | g15132 | i0 | 99.398 | 7.93373493975904 | 166 | 1 | 100 | 0 | 1 | 166 | 445 | 280 | Penicillium rubens uncharacterized protein (N7525_006688), partial mRNA | blastn | 1317 | 302 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium rubens | |
| 9557645 | 9557645 | PRJNA664479_S_NODE_16768_length_164_cov_0.886957_g16692_i0 | PRJNA664479 | 16768 | 164 | 0.886957 | 1.45460948 | Penicillium rubens | 1108849 | Fungi | Fungi | 174 | 2.8e-39 | NTclustered | gi|2625677430|ref|XM_061211623.1| | 1108849 | g16692 | i0 | 100 | 2.70731707317073 | 94 | 0 | 57 | 0 | 71 | 164 | 1 | 94 | Penicillium rubens uncharacterized protein (N7525_000579), partial mRNA | blastn | 444 | 174 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium rubens | |
| 9557648 | 9557648 | PRJNA664479_S_NODE_17508_length_163_cov_0.894737_g17432_i0 | PRJNA664479 | 17508 | 163 | 0.894737 | 1.45842131 | Penicillium rubens | 1108849 | Fungi | Fungi | 302 | 1.22e-77 | NTclustered | gi|255938689|ref|XM_002560069.1| | 1108849 | g17432 | i0 | 100 | 15.4969325153374 | 163 | 0 | 100 | 0 | 1 | 163 | 1765 | 1927 | Penicillium rubens uncharacterized protein (N7525_000122), partial mRNA | blastn | 2526 | 302 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium rubens | |
| 19756076 | 19756076 | PRJNA664479_S_NODE_18336_length_162_cov_0.858407_g18260_i0 | PRJNA664479 | 18336 | 162 | 0.858407 | 1.39061934 | Aspergillus glaucus | 41413 | Fungi | Fungi | 217 | 4.5199999999999996e-52 | NTclustered | gi|1245877413|ref|XM_022546995.1| | 1160497 | g18260 | i0 | 90.741 | 20.5432098765432 | 162 | 15 | 100 | 0 | 1 | 162 | 1323 | 1162 | Aspergillus glaucus CBS 516.65 uncharacterized protein (ASPGLDRAFT_48891), mRNA | blastn | 3328 | 217 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus glaucus | |
| 23581799 | 23581799 | PRJNA664479_S_NODE_15999_length_165_cov_0.879310_g15923_i0 | PRJNA664479 | 15999 | 165 | 0.87931 | 1.4508615 | Beauveria bassiana | 176275 | Fungi | Fungi | 167 | 4.72e-37 | NTclustered | gi|667660194|ref|XM_008603707.1| | 655819 | g15923 | i0 | 86.755 | 0.915151515151515 | 151 | 18 | 91 | 2 | 14 | 163 | 1369 | 1220 | Beauveria bassiana ARSEF 2860 ABC transporter (BBA_08610), partial mRNA | blastn | 151 | 167 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Cordycipitaceae | Beauveria | Beauveria bassiana | |
| 23581802 | 23581802 | PRJNA664479_S_NODE_17919_length_162_cov_0.902655_g17843_i0 | PRJNA664479 | 17919 | 162 | 0.902655 | 1.4623011 | Penicillium mononematosum | 268346 | Fungi | Fungi | 231 | 1.6099999999999998e-56 | NTclustered | gi|2517897781|ref|XM_057289909.1| | 268346 | g17843 | i0 | 92.547 | 0.993827160493827 | 161 | 12 | 99 | 0 | 2 | 162 | 1350 | 1510 | Penicillium mononematosum Carotenoid oxygenase (N7519_003131), partial mRNA | blastn | 161 | 231 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium mononematosum | |
| 28218212 | 28218212 | PRJNA664479_S_NODE_14046_length_168_cov_1.008403_g13970_i0 | PRJNA664479 | 14046 | 168 | 1.008403 | 1.69411704 | Orbilia ellipsospora | 2528407 | Fungi | Fungi | 40.8 | 0.0489 | NR | KAK6539314.1 | 2528407 | g13970 | i0 | 36.4 | 0.982142857142857 | 55 | 35 | 98.2 | 0 | 3 | 167 | 79 | 133 | KAK6539314.1 hypothetical protein TWF694_009548 [Orbilia ellipsospora] | diamond | 165 | 40.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Orbiliomycetes | Orbiliales | Orbiliaceae | Orbilia | Orbilia ellipsospora | |
| 28407963 | 28407963 | PRJNA664479_S_NODE_9366_length_192_cov_1.000000_g9290_i0 | PRJNA664479 | 9366 | 192 | 1 | 1.92 | Neophaeococcomyces mojaviensis | 3383035 | Fungi | Fungi | 54.3 | 2.96e-7 | NR | KAJ9656284.1 | 3383035 | g9290 | i0 | 49.2 | 1.96875 | 63 | 32 | 98.4 | 0 | 192 | 4 | 43 | 105 | KAJ9656284.1 histone H3.1 [Neophaeococcomyces mojaviensis] | diamond | 378 | 54.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Neophaeococcomyces | Neophaeococcomyces mojaviensis | ||
| 30112968 | 30112968 | PRJNA664479_S_NODE_5272_length_233_cov_0.913043_g5196_i0 | PRJNA664479 | 5272 | 233 | 0.913043 | 2.12739019 | Triangularia setosa | 2587417 | Fungi | Fungi | 42.4 | 0.0454 | NR | KAK4177940.1 | 2587417 | g5196 | i0 | 43.9 | 0.527896995708155 | 41 | 23 | 52.8 | 0 | 57 | 179 | 648 | 688 | KAK4177940.1 family 78 putative glycoside hydrolase [Triangularia setosa] | diamond | 123 | 42.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Podosporaceae | Triangularia | Triangularia setosa | |
| 30535909 | 30535909 | PRJNA664479_S_NODE_16473_length_164_cov_0.886957_g16397_i0 | PRJNA664479 | 16473 | 164 | 0.886957 | 1.45460948 | Aspergillus | 5052 | Fungi | Fungi | 63.5 | 5.82e-10 | NR | ODM18065.1 | 573508 | g16397 | i0 | 93.9 | 1.20731707317073 | 33 | 2 | 60.4 | 0 | 159 | 61 | 1 | 33 | ODM18065.1 hypothetical protein SI65_06853 [Aspergillus cristatus] | diamond | 198 | 63.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus cristatus | |
| 30713353 | 30713353 | PRJNA664479_S_NODE_18674_length_161_cov_0.910714_g18598_i0 | PRJNA664479 | 18674 | 161 | 0.910714 | 1.46624954 | Aspergillus wentii DTO 134E9 | 1073089 | Fungi | Fungi | 92.8 | 2.75e-20 | NR | XP_040687992.1 | 1073089 | g18598 | i0 | 81.1 | 1.97515527950311 | 53 | 10 | 98.8 | 0 | 159 | 1 | 499 | 551 | XP_040687992.1 uncharacterized protein ASPWEDRAFT_52567 [Aspergillus wentii DTO 134E9] | diamond | 318 | 92.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus wentii | |
| 30808185 | 30808185 | PRJNA664479_S_NODE_10214_length_187_cov_0.876812_g10138_i0 | PRJNA664479 | 10214 | 187 | 0.876812 | 1.63963844 | Apiospora hydei | 1337664 | Fungi | Fungi | 43.5 | 0.00914 | NR | XP_066674319.1 | 1337664 | g10138 | i0 | 40 | 0.802139037433155 | 50 | 30 | 80.2 | 0 | 174 | 25 | 1 | 50 | XP_066674319.1 uncharacterized protein PG997_000231 [Apiospora hydei] | diamond | 150 | 43.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Amphisphaeriales | Apiosporaceae | Apiospora | Apiospora hydei | |
| 31061183 | 31061183 | PRJNA664479_S_NODE_15315_length_166_cov_0.871795_g15239_i0 | PRJNA664479 | 15315 | 166 | 0.871795 | 1.4471797 | Aspergillus cristatus | 573508 | Fungi | Fungi | 50.8 | 1.85e-5 | NR | ODM17584.1 | 573508 | g15239 | i0 | 92.6 | 0.487951807228916 | 27 | 2 | 48.8 | 0 | 82 | 2 | 79 | 105 | ODM17584.1 hypothetical protein SI65_07259 [Aspergillus cristatus] | diamond | 81 | 50.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus cristatus | |
| 31693335 | 31693335 | PRJNA664479_S_NODE_4217_length_254_cov_1.117073_g4141_i0 | PRJNA664479 | 4217 | 254 | 1.117073 | 2.83736542 | Elasticomyces elasticus | 574655 | Fungi | Fungi | 47 | 0.00126 | NR | KAK5737946.1 | 574655 | g4141 | i0 | 32.8 | 0.720472440944882 | 61 | 39 | 69.7 | 1 | 34 | 210 | 67 | 127 | KAK5737946.1 hypothetical protein LTR17_006386 [Elasticomyces elasticus] | diamond | 183 | 47 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Elasticomyces | Elasticomyces elasticus |
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);;