contig_metadata
18 rows where analysis = "blastn", bioproject = "PRJNA1089179" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2745551 | 2745551 | PRJNA1089179_P_NODE_18203_length_210_cov_7.299270_g18185_i0 | PRJNA1089179 | 18203 | 210 | 7.29927 | 15.328467 | Botrytis cinerea | 40559 | Fungi | Fungi | 261 | 2.81e-65 | NTclustered | gi|1377719091|ref|XM_024696759.1| | 332648 | g18185 | i0 | 94.643 | 1.6 | 168 | 9 | 80 | 0 | 22 | 189 | 3812 | 3645 | Botrytis cinerea B05.10 hypothetical protein (BCIN_13g02870), mRNA | blastn | 336 | 261 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Sclerotiniaceae | Botrytis | Botrytis cinerea | |
| 4845625 | 4845625 | PRJNA1089179_P_NODE_18224_length_207_cov_14.761194_g18206_i0 | PRJNA1089179 | 18224 | 207 | 14.761194 | 30.55567158 | Saccharomyces | 4930 | Fungi | Fungi | 305 | 1.26e-78 | NTclustered | gi|171456|gb|J01323.1|YSCENOB | 4932 | g18206 | i0 | 98.83 | 43.3768115942029 | 171 | 2 | 83 | 0 | 18 | 188 | 881 | 1051 | Yeast (S. cerevisiae) enolase gene (clone peno8) and flanks | blastn | 8979 | 305 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Saccharomyces | Saccharomyces cerevisiae | |
| 4845626 | 4845626 | PRJNA1089179_P_NODE_18264_length_202_cov_13.976744_g18246_i0 | PRJNA1089179 | 18264 | 202 | 13.976744 | 28.23302288 | Alternaria | 5598 | Fungi | Fungi | 296 | 7.36e-76 | NTclustered | gi|1070539835|ref|XM_018533827.1| | 5599 | g18246 | i0 | 99.39 | 3.21287128712871 | 164 | 0 | 81 | 1 | 22 | 185 | 933 | 1095 | Alternaria alternata FAD binding domain-containing protein partial mRNA | blastn | 649 | 296 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 5297650 | 5297650 | PRJNA1089179_P_NODE_18305_length_197_cov_17.120968_g18287_i0 | PRJNA1089179 | 18305 | 197 | 17.120968 | 33.72830696 | Aureobasidium pullulans | 5580 | Fungi | Fungi | 270 | 4.33e-68 | NTclustered | gi|2832839268|gb|CP139017.1| | 5580 | g18287 | i0 | 99.329 | 72.3401015228426 | 149 | 1 | 76 | 0 | 22 | 170 | 33005 | 33153 | Aureobasidium pullulans isolate CG163 mitochondrion, complete genome | blastn | 14251 | 270 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Saccotheciaceae | Aureobasidium | Aureobasidium pullulans | |
| 6120676 | 6120676 | PRJNA1089179_P_NODE_85_length_1448_cov_2777.354182_g78_i0 | PRJNA1089179 | 85 | 1448 | 2777.354182 | 40216.08855536 | Saccharomyces | 4930 | Fungi | Fungi | 2423 | 0 | NTclustered | gi|741042510|gb|CP009949.1| | 4932 | g78 | i0 | 99.924 | 90.2548342541436 | 1314 | 1 | 91 | 0 | 88 | 1401 | 446876 | 448189 | Saccharomyces cerevisiae strain NCIM3107 chromosome 8 sequence | blastn | 130689 | 2423 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Saccharomyces | Saccharomyces cerevisiae | |
| 6572693 | 6572693 | PRJNA1089179_P_NODE_15626_length_246_cov_2.184971_g15608_i0 | PRJNA1089179 | 15626 | 246 | 2.184971 | 5.37502866 | Cladosporium anthropophilum | 1970646 | Fungi | Fungi | 455 | 1.4500000000000002e-123 | NTclustered | gi|2216737164|ref|NC_061970.1| | 1970646 | g15608 | i0 | 100 | 4.28048780487805 | 246 | 0 | 100 | 0 | 1 | 246 | 16821 | 17066 | Cladosporium anthropophilum voucher KACC 49782 mitochondrion, complete genome | blastn | 1053 | 455 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium anthropophilum | |
| 7395343 | 7395343 | PRJNA1089179_P_NODE_86_length_1448_cov_1608.594182_g78_i1 | PRJNA1089179 | 86 | 1448 | 1608.594182 | 23292.44375536 | root | 1 | Root_unresolved | Root_unresolved | 2239 | 0 | NTclustered | gi|1389182097|gb|CP029160.1| | 4932 | g78 | i1 | 97.414 | 90.8252762430939 | 1315 | 32 | 91 | 2 | 48 | 1361 | 10072716 | 10071403 | Saccharomyces cerevisiae strain SY14 chromosome I, complete sequence | blastn | 131515 | 2239 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Saccharomyces | Saccharomyces cerevisiae | |
| 10398126 | 10398126 | PRJNA1089179_P_NODE_8109_length_317_cov_21.967213_g8091_i0 | PRJNA1089179 | 8109 | 317 | 21.967213 | 69.63606521 | Parastagonospora nodorum | 13684 | Fungi | Fungi | 401 | 2.5599999999999988e-107 | NTclustered | gi|169613065|ref|XM_001799898.1| | 321614 | g8091 | i0 | 91.186 | 39.6403785488959 | 295 | 26 | 93 | 0 | 21 | 315 | 486 | 780 | Parastagonospora nodorum SN15 hypothetical protein (SNOG_09662), mRNA | blastn | 12566 | 401 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Phaeosphaeriaceae | Parastagonospora | Parastagonospora nodorum | |
| 13770911 | 13770911 | PRJNA1089179_P_NODE_8271_length_315_cov_1.962810_g8253_i0 | PRJNA1089179 | 8271 | 315 | 1.96281 | 6.1828515 | Cladosporium | 5498 | Fungi | Fungi | 582 | 8.459999999999998e-162 | NTclustered | gi|1841183609|gb|MN661341.1| | 29917 | g8253 | i0 | 100 | 79.4412698412698 | 315 | 0 | 100 | 0 | 1 | 315 | 21934 | 22248 | Cladosporium cladosporioides strain YFCC 8621 mitochondrion, complete genome | blastn | 25024 | 582 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium cladosporioides | |
| 14223532 | 14223532 | PRJNA1089179_P_NODE_12312_length_269_cov_1.918367_g12294_i0 | PRJNA1089179 | 12312 | 269 | 1.918367 | 5.16040723 | Cladosporium anthropophilum | 1970646 | Fungi | Fungi | 497 | 2.63e-136 | NTclustered | gi|2216737164|ref|NC_061970.1| | 1970646 | g12294 | i0 | 100 | 1 | 269 | 0 | 100 | 0 | 1 | 269 | 25083 | 25351 | Cladosporium anthropophilum voucher KACC 49782 mitochondrion, complete genome | blastn | 269 | 497 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium anthropophilum | |
| 14223568 | 14223568 | PRJNA1089179_P_NODE_7112_length_334_cov_1.325670_g7094_i0 | PRJNA1089179 | 7112 | 334 | 1.32567 | 4.4277378 | Cladosporium anthropophilum | 1970646 | Fungi | Fungi | 617 | 2.48e-172 | NTclustered | gi|2216737164|ref|NC_061970.1| | 1970646 | g7094 | i0 | 100 | 95.3293413173653 | 334 | 0 | 100 | 0 | 1 | 334 | 7496 | 7829 | Cladosporium anthropophilum voucher KACC 49782 mitochondrion, complete genome | blastn | 31840 | 617 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium anthropophilum | |
| 15497424 | 15497424 | PRJNA1089179_P_NODE_4793_length_387_cov_2.359873_g4775_i0 | PRJNA1089179 | 4793 | 387 | 2.359873 | 9.13270851 | Alloascoidea africana | 27309 | Fungi | Fungi | 121 | 9.99e-23 | NTclustered | gi|1473246217|gb|MH859161.1| | 27309 | g4775 | i0 | 85.345 | 29.6046511627907 | 116 | 17 | 30 | 0 | 1 | 116 | 370 | 255 | Alloascoidea africana culture CBS:377.68 strain CBS 377.68 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 | 11457 | 121 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Alloascoideomycetes | Alloascoideales | Alloascoideaceae | Alloascoidea | Alloascoidea africana | |
| 18869189 | 18869189 | PRJNA1089179_P_NODE_5175_length_376_cov_4.422442_g5157_i0 | PRJNA1089179 | 5175 | 376 | 4.422442 | 16.62838192 | Eukaryota | 2759 | Fungi | Fungi | 313 | 1.49e-80 | NTclustered | gi|1677617699|gb|MK110675.1| | 2569847 | g5157 | i0 | 90.638 | 156.313829787234 | 235 | 22 | 63 | 0 | 142 | 376 | 8527 | 8761 | Acanthothecis fontana voucher 49537 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 26S ribosomal RNA gene, complete sequence | blastn | 58774 | 313 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Ostropales | Graphidaceae | Acanthothecis | Acanthothecis fontana | |
| 20595893 | 20595893 | PRJNA1089179_P_NODE_9877_length_293_cov_113.440909_g9859_i0 | PRJNA1089179 | 9877 | 293 | 113.440909 | 332.38186337 | Colletotrichum truncatum | 5467 | Fungi | Fungi | 63.9 | 1.26e-5 | NTclustered | gi|2866161737|ref|XM_036727271.2| | 5467 | g9859 | i0 | 97.297 | 0.238907849829352 | 37 | 1 | 13 | 0 | 39 | 75 | 951 | 987 | Colletotrichum truncatum mitochondrial phosphate carrier protein (CTRU02_203190), partial mRNA | blastn | 70 | 63.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Glomerellales | Glomerellaceae | Colletotrichum | Colletotrichum truncatum | |
| 21419566 | 21419566 | PRJNA1089179_P_NODE_18097_length_223_cov_5.380000_g18079_i0 | PRJNA1089179 | 18097 | 223 | 5.38 | 11.9974 | Opisthokonta | 33154 | Fungi | Fungi | 344 | 2.92e-90 | NTclustered | gi|767813157|gb|KP114602.1| | 29917 | g18079 | i0 | 100 | 83.4260089686099 | 186 | 0 | 83 | 0 | 22 | 207 | 366 | 551 | Cladosporium cladosporioides strain PF3 large subunit ribosomal RNA gene, partial sequence | blastn | 18604 | 346 | 0.994219653179191 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium cladosporioides | |
| 21419569 | 21419569 | PRJNA1089179_P_NODE_5757_length_361_cov_5.836806_g5739_i0 | PRJNA1089179 | 5757 | 361 | 5.836806 | 21.07086966 | Eukaryota | 2759 | Fungi | Fungi | 176 | 1.95e-39 | NTclustered | gi|1677617699|gb|MK110675.1| | 2569847 | g5739 | i0 | 88.356 | 9.42659279778393 | 146 | 17 | 66 | 0 | 26 | 171 | 8950 | 9095 | Acanthothecis fontana voucher 49537 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 26S ribosomal RNA gene, complete sequence | blastn | 3403 | 176 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Ostropales | Graphidaceae | Acanthothecis | Acanthothecis fontana | |
| 23969939 | 23969939 | PRJNA1089179_P_NODE_5239_length_375_cov_1.450331_g5221_i0 | PRJNA1089179 | 5239 | 375 | 1.450331 | 5.43874125 | root | 1 | Root_unresolved | Root_unresolved | 63.9 | 1.65e-5 | NTclustered | gi|1389182097|gb|CP029160.1| | 4932 | g5221 | i0 | 97.297 | 2.376 | 37 | 1 | 10 | 0 | 237 | 273 | 5253511 | 5253475 | Saccharomyces cerevisiae strain SY14 chromosome I, complete sequence | blastn | 891 | 63.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Saccharomyces | Saccharomyces cerevisiae | |
| 24420658 | 24420658 | PRJNA1089179_P_NODE_13920_length_254_cov_39.237569_g13902_i0 | PRJNA1089179 | 13920 | 254 | 39.237569 | 99.66342526 | Aspergillus piperis | 319630 | Fungi | Fungi | 54.7 | 0.006 | NTclustered | gi|1419156901|ref|XM_025655235.1| | 1448313 | g13902 | i0 | 100 | 0.338582677165354 | 29 | 0 | 11 | 0 | 156 | 184 | 126 | 98 | Aspergillus piperis CBS 112811 ABC transporter (BO85DRAFT_285050), mRNA | blastn | 86 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus piperis |
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);;