contig_metadata
20 rows where analysis = "blastn", bioproject = "PRJNA1012699" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1002464 | 1002464 | PRJNA1012699_P_NODE_1921_length_283_cov_37.266667_g1889_i0 | PRJNA1012699 | 1921 | 283 | 37.266667 | 105.46466761 | Opisthokonta | 33154 | Fungi | Fungi | 508 | 1.29e-139 | NTclustered | gi|2086743560|ref|XR_006253225.1| | 182096 | g1889 | i0 | 99.288 | 105.233215547703 | 281 | 2 | 99 | 0 | 2 | 282 | 2513 | 2233 | Aspergillus chevalieri 28S ribosomal RNA (ACHE_r70002S), rRNA | blastn | 29781 | 508 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus chevalieri | |
| 2708368 | 2708368 | PRJNA1012699_P_NODE_3443_length_246_cov_1.346821_g3411_i0 | PRJNA1012699 | 3443 | 246 | 1.346821 | 3.31317966 | Eremothecium sinecaudum | 45286 | Fungi | Fungi | 139 | 1.66e-28 | NTclustered | gi|1063858670|ref|XM_018133529.1| | 45286 | g3411 | i0 | 78.241 | 10.0691056910569 | 216 | 47 | 88 | 0 | 4 | 219 | 234 | 449 | Eremothecium sinecaudum 40S ribosomal protein uS15 (AW171_hschr74339), partial mRNA | blastn | 2477 | 139 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Eremothecium | Eremothecium sinecaudum | |
| 2708372 | 2708372 | PRJNA1012699_P_NODE_3783_length_243_cov_3.635294_g3751_i0 | PRJNA1012699 | 3783 | 243 | 3.635294 | 8.83376442 | Australozyma saopauloensis | 291208 | Fungi | Fungi | 111 | 3.56e-20 | NTclustered | gi|2675360614|ref|XM_063021441.1| | 291208 | g3751 | i0 | 87.629 | 18.9917695473251 | 97 | 11 | 40 | 1 | 45 | 141 | 147 | 52 | [Candida] saopauloensis uncharacterized protein (PUMCH_002431), partial mRNA | blastn | 4615 | 111 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Australozyma | Australozyma saopauloensis | |
| 3552983 | 3552983 | PRJNA1012699_P_NODE_4183_length_225_cov_5.190789_g4151_i0 | PRJNA1012699 | 4183 | 225 | 5.190789 | 11.67927525 | Eukaryota | 2759 | Fungi | Fungi | 412 | 7.97e-111 | NTclustered | gi|33334380|gb|AF548066.1| | 41959 | g4151 | i0 | 100 | 98.9733333333333 | 223 | 0 | 99 | 0 | 2 | 224 | 71 | 293 | Aspergillus penicillioides strain ALI 231 18S ribosomal RNA gene, partial sequence | blastn | 22269 | 412 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus penicillioides | |
| 3984537 | 3984537 | PRJNA1012699_P_NODE_1664_length_296_cov_1.434978_g1632_i0 | PRJNA1012699 | 1664 | 296 | 1.434978 | 4.24753488 | Aspergillus clavatophorus | 1915367 | Fungi | Fungi | 542 | 1.34e-149 | NTclustered | gi|2666209001|dbj|LC797027.1| | 1915367 | g1632 | i0 | 100 | 96.3885135135135 | 293 | 0 | 99 | 0 | 2 | 294 | 27950 | 28242 | Aspergillus clavatophorus NBRC 116038 mitochondrial DNA, complete genome | blastn | 28531 | 542 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus clavatophorus | |
| 6536229 | 6536229 | PRJNA1012699_P_NODE_3426_length_246_cov_2.658960_g3394_i0 | PRJNA1012699 | 3426 | 246 | 2.65896 | 6.5410416 | Trichoderma atroviride | 63577 | Fungi | Fungi | 86.1 | 2.19e-12 | NTclustered | gi|2749703766|ref|XM_014090103.2| | 63577 | g3394 | i0 | 88 | 1.79268292682927 | 75 | 6 | 30 | 1 | 35 | 109 | 2269 | 2198 | Trichoderma atroviride uncharacterized protein (TrAtP1_012533), partial mRNA | blastn | 441 | 86.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Hypocreaceae | Trichoderma | Trichoderma atroviride | |
| 9085572 | 9085572 | PRJNA1012699_P_NODE_1648_length_297_cov_1.754464_g1616_i0 | PRJNA1012699 | 1648 | 297 | 1.754464 | 5.21075808 | Debaryomyces hansenii | 4959 | Fungi | Fungi | 268 | 2.52e-67 | NTclustered | gi|50427260|ref|XM_462243.1| | 284592 | g1616 | i0 | 83.448 | 101.037037037037 | 290 | 46 | 97 | 2 | 1 | 288 | 290 | 1 | Debaryomyces hansenii CBS767 ubiquitin-40S ribosomal protein S31 fusion protein (DEHA2G16082g), partial mRNA | blastn | 30008 | 268 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Debaryomyces | Debaryomyces hansenii | |
| 9085606 | 9085606 | PRJNA1012699_P_NODE_3568_length_245_cov_0.906977_g3536_i0 | PRJNA1012699 | 3568 | 245 | 0.906977 | 2.22209365 | Saitoella complicata | 5606 | Fungi | Fungi | 235 | 2.05e-57 | NTclustered | gi|1102186376|ref|XM_019169521.1| | 698492 | g3536 | i0 | 84.914 | 35.4204081632653 | 232 | 35 | 95 | 0 | 2 | 233 | 460 | 229 | Saitoella complicata NRRL Y-17804 translationally controlled tumor protein (SAICODRAFT_5728), partial mRNA | blastn | 8678 | 235 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saitoella | Saitoella complicata | ||||
| 9930456 | 9930456 | PRJNA1012699_P_NODE_2508_length_257_cov_1.690217_g2476_i0 | PRJNA1012699 | 2508 | 257 | 1.690217 | 4.34385769 | Fusarium | 5506 | Fungi | Fungi | 54.7 | 0.006 | NTclustered | gi|302921564|ref|XM_003053262.1| | 660122 | g2476 | i0 | 96.875 | 0.249027237354086 | 32 | 1 | 12 | 0 | 98 | 129 | 589 | 558 | Fusarium vanettenii 77-13-4 uncharacterized protein (NECHADRAFT_78175), partial mRNA | blastn | 64 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium vanettenii | |
| 9930457 | 9930457 | PRJNA1012699_P_NODE_2968_length_250_cov_0.881356_g2936_i0 | PRJNA1012699 | 2968 | 250 | 0.881356 | 2.20339 | root | 1 | Root_unresolved | Root_unresolved | 460 | 3.17e-125 | NTclustered | gi|1063302621|gb|KX808523.1| | 4931 | g2936 | i0 | 100 | 107.568 | 249 | 0 | 99 | 0 | 2 | 250 | 426 | 178 | Saccharomyces bayanus strain TBGSSY6 18S ribosomal RNA gene, partial sequence | blastn | 26892 | 460 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Saccharomyces | Saccharomyces bayanus | |
| 10361247 | 10361247 | PRJNA1012699_P_NODE_2049_length_278_cov_1.312195_g2017_i0 | PRJNA1012699 | 2049 | 278 | 1.312195 | 3.6479021 | Alternaria conjuncta | 181017 | Fungi | Fungi | 305 | 1.78e-78 | NTclustered | gi|2323868538|ref|XM_051467474.1| | 181017 | g2017 | i0 | 90.789 | 80.7410071942446 | 228 | 21 | 82 | 0 | 1 | 228 | 211 | 438 | Alternaria conjuncta 40S ribosomal protein S23 (RPS23), partial mRNA | blastn | 22446 | 305 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria conjuncta | |
| 10361272 | 10361272 | PRJNA1012699_P_NODE_3509_length_246_cov_0.901734_g3477_i0 | PRJNA1012699 | 3509 | 246 | 0.901734 | 2.21826564 | Metarhizium robertsii | 568076 | Fungi | Fungi | 183 | 7.549999999999997e-42 | NTclustered | gi|629717389|ref|XM_007822318.1| | 655844 | g3477 | i0 | 81.223 | 33.3130081300813 | 229 | 41 | 93 | 2 | 6 | 233 | 1167 | 940 | Metarhizium robertsii ARSEF 23 NADH-ubiquinone oxidoreductase 49 kDa subunit (MAA_04320), partial mRNA | blastn | 8195 | 183 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Clavicipitaceae | Metarhizium | Metarhizium robertsii | |
| 11205706 | 11205706 | PRJNA1012699_P_NODE_3609_length_245_cov_0.906977_g3577_i0 | PRJNA1012699 | 3609 | 245 | 0.906977 | 2.22209365 | root | 1 | Root_unresolved | Root_unresolved | 451 | 1.87e-122 | NTclustered | gi|602367|gb|U18530.1|SCE9871 | 4932 | g3577 | i0 | 100 | 28.130612244898 | 244 | 0 | 99 | 0 | 1 | 244 | 12706 | 12463 | Saccharomyces cerevisiae chromosome V cosmids 9871, 8199, 9867, 9495 and lambda clones 6693 and 5898 | blastn | 6892 | 451 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Saccharomyces | Saccharomyces cerevisiae | |
| 11636645 | 11636645 | PRJNA1012699_P_NODE_750_length_411_cov_0.917160_g718_i0 | PRJNA1012699 | 750 | 411 | 0.91716 | 3.7695276 | Aspergillus pseudotamarii | 132259 | Fungi | Fungi | 84.2 | 1.4e-11 | NTclustered | gi|1799759755|ref|XM_032057830.1| | 132259 | g718 | i0 | 96.078 | 4.53771289537713 | 51 | 2 | 12 | 0 | 344 | 394 | 561 | 511 | Aspergillus pseudotamarii 40S ribosomal protein eS6 (BDV38DRAFT_274361), partial mRNA | blastn | 1865 | 84.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus pseudotamarii | |
| 12911649 | 12911649 | PRJNA1012699_P_NODE_591_length_450_cov_2.729443_g559_i0 | PRJNA1012699 | 591 | 450 | 2.729443 | 12.2824935 | Candida margitis | 1775924 | Fungi | Fungi | 267 | 1.43e-66 | NTclustered | gi|2325466559|ref|XM_051818331.1| | 1775924 | g559 | i0 | 80.58 | 7.19777777777778 | 345 | 67 | 77 | 0 | 40 | 384 | 396 | 52 | Candida margitis RPL23A (CANMA_000928), partial mRNA | blastn | 3239 | 267 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Candida | Candida margitis | |
| 18854105 | 18854105 | PRJNA1012699_P_NODE_695_length_424_cov_1.547009_g663_i0 | PRJNA1012699 | 695 | 424 | 1.547009 | 6.55931816 | Komagataella | 460517 | Fungi | Fungi | 110 | 2.39e-19 | NTclustered | gi|46981804|gb|AY532168.1| | 4922 | g663 | i0 | 82.787 | 0.575471698113208 | 122 | 21 | 29 | 0 | 298 | 419 | 169 | 290 | Pichia pastoris ATP phosphoribosyltransferase (HIS1) gene, complete cds | blastn | 244 | 110 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Pichiales | Pichiaceae | Komagataella | Komagataella pastoris | |
| 19283676 | 19283676 | PRJNA1012699_P_NODE_4096_length_234_cov_2.403727_g4064_i0 | PRJNA1012699 | 4096 | 234 | 2.403727 | 5.62472118 | Schizosaccharomyces cryophilus | 866546 | Fungi | Fungi | 126 | 1.22e-24 | NTclustered | gi|891598739|ref|XM_013169579.1| | 653667 | g4064 | i0 | 83.942 | 36.7777777777778 | 137 | 16 | 57 | 4 | 18 | 151 | 1190 | 1323 | Schizosaccharomyces cryophilus OY26 60S ribosomal protein K5, variant 2 (SPOG_01306), partial mRNA | blastn | 8606 | 126 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Schizosaccharomycetes | Schizosaccharomycetales | Schizosaccharomycetaceae | Schizosaccharomyces | Schizosaccharomyces cryophilus | |
| 20128816 | 20128816 | PRJNA1012699_P_NODE_1796_length_290_cov_6.184332_g1764_i0 | PRJNA1012699 | 1796 | 290 | 6.184332 | 17.9345628 | Fungi | 4751 | Fungi | Fungi | 534 | 2.19e-147 | NTclustered | gi|2612872|gb|AF010303.1| | 63354 | g1764 | i0 | 100 | 99.6551724137931 | 289 | 0 | 99 | 0 | 1 | 289 | 298 | 10 | Sclerotium sp. BSC-97 18S ribosomal RNA gene, partial sequence | blastn | 28900 | 534 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Sclerotiniaceae | Sclerotiniaceae sp. BSC-97 | ||
| 20559204 | 20559204 | PRJNA1012699_P_NODE_2917_length_251_cov_0.876404_g2885_i0 | PRJNA1012699 | 2917 | 251 | 0.876404 | 2.19977404 | Saccharomyces cerevisiae | 4932 | Fungi | Fungi | 464 | 2.47e-126 | NTclustered | gi|741042505|gb|CP009944.1| | 4932 | g2885 | i0 | 100 | 33.1035856573705 | 251 | 0 | 100 | 0 | 1 | 251 | 127478 | 127228 | Saccharomyces cerevisiae strain NCIM3107 chromosome 1 sequence | blastn | 8309 | 464 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Saccharomyces | Saccharomyces cerevisiae | |
| 24384116 | 24384116 | PRJNA1012699_P_NODE_2900_length_251_cov_0.876404_g2868_i0 | PRJNA1012699 | 2900 | 251 | 0.876404 | 2.19977404 | Aspergillus chevalieri | 182096 | Fungi | Fungi | 145 | 3.65e-30 | NTclustered | gi|2086725159|ref|XM_043281309.1| | 182096 | g2868 | i0 | 83.432 | 0.673306772908366 | 169 | 15 | 67 | 9 | 16 | 182 | 1337 | 1180 | Aspergillus chevalieri uncharacterized protein (ACHE_10621S), partial mRNA | blastn | 169 | 145 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus chevalieri |
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);;