contig_metadata
21 rows where analysis = "blastn", bioproject = "PRJNA664479" and tax_kingdom = "Fungi"
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 | |
| 3180048 | 3180048 | PRJNA664479_S_NODE_11363_length_180_cov_1.557252_g11287_i0 | PRJNA664479 | 11363 | 180 | 1.557252 | 2.8030536 | uncultured fungus | 175245 | Fungi | Fungi | 322 | 1.05e-83 | NTclustered | gi|583834705|gb|KF568271.1| | 175245 | g11287 | i0 | 98.889 | 93.9166666666667 | 180 | 2 | 100 | 0 | 1 | 180 | 214 | 35 | Uncultured soil fungus clone NCD_LSU_otu3301 28S ribosomal RNA gene, partial sequence | blastn | 16905 | 322 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 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 | ||
| 5732617 | 5732617 | PRJNA664479_S_NODE_19045_length_161_cov_0.866071_g18969_i0 | PRJNA664479 | 19045 | 161 | 0.866071 | 1.39437431 | Vanrija pseudolonga | 143232 | Fungi | Fungi | 209 | 7.5e-50 | NTclustered | gi|2669736104|ref|XM_062769951.1| | 143232 | g18969 | i0 | 90.123 | 2.01242236024845 | 162 | 14 | 100 | 2 | 1 | 161 | 2540 | 2380 | Vanrija pseudolonga uncharacterized protein (LOC62_02G003417), mRNA | blastn | 324 | 209 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Vanrija | Vanrija pseudolonga | |
| 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 | |
| 8282380 | 8282380 | PRJNA664479_S_NODE_18647_length_161_cov_0.910714_g18571_i0 | PRJNA664479 | 18647 | 161 | 0.910714 | 1.46624954 | Vanrija pseudolonga | 143232 | Fungi | Fungi | 248 | 1.59e-61 | NTclustered | gi|2669723298|ref|XM_062767771.1| | 143232 | g18571 | i0 | 94.41 | 1 | 161 | 9 | 100 | 0 | 1 | 161 | 327 | 167 | Vanrija pseudolonga Esterase (est_3), mRNA | blastn | 161 | 248 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Vanrija | Vanrija pseudolonga | |
| 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 | |
| 13383208 | 13383208 | PRJNA664479_S_NODE_15771_length_165_cov_0.879310_g15695_i0 | PRJNA664479 | 15771 | 165 | 0.87931 | 1.4508615 | Vanrija pseudolonga | 143232 | Fungi | Fungi | 261 | 2.11e-65 | NTclustered | gi|2669724360|ref|XM_062767952.1| | 143232 | g15695 | i0 | 99.306 | 5.1030303030303 | 144 | 1 | 87 | 0 | 18 | 161 | 129 | 272 | Vanrija pseudolonga Heat shock protein 70 (SPAC57A7.12), mRNA | blastn | 842 | 261 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Trichosporonales | Trichosporonaceae | Vanrija | Vanrija pseudolonga | |
| 15190816 | 15190816 | PRJNA664479_S_NODE_7732_length_204_cov_0.987097_g7656_i0 | PRJNA664479 | 7732 | 204 | 0.987097 | 2.01367788 | Eukaryota | 2759 | Fungi | Fungi | 84.2 | 6.31e-12 | NTclustered | gi|441431095|gb|JX974793.1| | 175245 | g7656 | i0 | 86.667 | 8.60294117647059 | 75 | 10 | 37 | 0 | 123 | 197 | 751 | 677 | Uncultured fungus clone D281 internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, region | blastn | 1755 | 84.2 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 17207207 | 17207207 | PRJNA664479_S_NODE_17894_length_162_cov_0.902655_g17818_i0 | PRJNA664479 | 17894 | 162 | 0.902655 | 1.4623011 | Malassezia restricta | 76775 | Fungi | Fungi | 300 | 4.36e-77 | NTclustered | gi|1546635979|ref|XM_027629632.1| | 76775 | g17818 | i0 | 100 | 1 | 162 | 0 | 100 | 0 | 1 | 162 | 646 | 485 | Malassezia restricta activating transcription factor 7 interacting protein (MRET_3005), partial mRNA | blastn | 162 | 300 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 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 | |
| 23581794 | 23581794 | PRJNA664479_S_NODE_10299_length_186_cov_1.489051_g10223_i0 | PRJNA664479 | 10299 | 186 | 1.489051 | 2.76963486 | uncultured fungus | 175245 | Fungi | Fungi | 309 | 8.55e-80 | NTclustered | gi|2159203201|emb|OU941629.1| | 175245 | g10223 | i0 | 96.757 | 3.88172043010753 | 185 | 6 | 99 | 0 | 2 | 186 | 1418 | 1234 | uncultured fungus genomic DNA sequence contains 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, isolate consensus02923 | blastn | 722 | 309 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 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 | |
| 24855399 | 24855399 | PRJNA664479_S_NODE_14700_length_167_cov_0.864407_g14624_i0 | PRJNA664479 | 14700 | 167 | 0.864407 | 1.44355969 | Malassezia restricta | 76775 | Fungi | Fungi | 303 | 3.5e-78 | NTclustered | gi|1546632462|ref|XM_027627891.1| | 76775 | g14624 | i0 | 99.401 | 94.3652694610778 | 167 | 1 | 100 | 0 | 1 | 167 | 1136 | 970 | Malassezia restricta heat shock 70kDa protein 1/2/6/8 (MRET_1264), partial mRNA | blastn | 15759 | 303 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta |
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);;