contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA1196384" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2873528 | 2873528 | PRJNA1196384_S_NODE_7783_length_155_cov_0.889831_g7719_i0 | PRJNA1196384 | 7783 | 155 | 0.889831 | 1.37923805 | Xylographa carneopallida | 1590122 | Fungi | Fungi | 78.2 | 3.03e-16 | NR | MCJ1296998.1 | 1590122 | g7719 | i0 | 74 | 0.967741935483871 | 50 | 13 | 96.8 | 0 | 154 | 5 | 108 | 157 | MCJ1296998.1 Rho GTPase protein rac1 [Xylographa carneopallida] | diamond | 150 | 78.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Baeomycetales | Xylographaceae | Xylographa | Xylographa carneopallida | |
| 15070856 | 15070856 | PRJNA1196384_S_NODE_192_length_773_cov_3.889946_g148_i0 | PRJNA1196384 | 192 | 773 | 3.889946 | 30.06928258 | Ascomycota | 4890 | Fungi | Fungi | 330 | 6.64e-111 | NR | CDO51397.1 | 1173061 | g148 | i0 | 67.4 | 15.0155239327296 | 239 | 76 | 92.8 | 1 | 771 | 55 | 19 | 255 | CDO51397.1 similar to Saccharomyces cerevisiae YHR203C RPS4B Protein component of the small (40S) ribosomal subunit [Geotrichum candidum] | diamond | 11607 | 330 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Dipodascaceae | Geotrichum | Geotrichum candidum | |
| 15625535 | 15625535 | PRJNA1196384_S_NODE_7413_length_157_cov_1.300000_g7349_i0 | PRJNA1196384 | 7413 | 157 | 1.3 | 2.041 | Fungi | 4751 | Fungi | Fungi | 78.6 | 8.52e-17 | NR | XP_019022324.1 | 698492 | g7349 | i0 | 72.9 | 22.968152866242 | 48 | 13 | 91.7 | 0 | 13 | 156 | 72 | 119 | XP_019022324.1 uncharacterized protein SAICODRAFT_60256 [Saitoella complicata NRRL Y-17804] | diamond | 3606 | 79 | 0.994936708860759 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saitoella | Saitoella complicata | ||||
| 18174283 | 18174283 | PRJNA1196384_S_NODE_2795_length_232_cov_2.384615_g2731_i0 | PRJNA1196384 | 2795 | 232 | 2.384615 | 5.5323068 | Eukaryota | 2759 | Fungi | Fungi | 129 | 8.24e-36 | NR | XP_503229.1 | 4952 | g2731 | i0 | 77.9 | 13.9396551724138 | 77 | 17 | 99.6 | 0 | 2 | 232 | 81 | 157 | XP_503229.1 60S ribosomal protein eL15 [Yarrowia lipolytica] | diamond | 3234 | 130 | 0.992307692307692 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Yarrowia | Yarrowia lipolytica | ||
| 26945784 | 26945784 | PRJNA1196384_S_NODE_7542_length_156_cov_1.638655_g7478_i0 | PRJNA1196384 | 7542 | 156 | 1.638655 | 2.5563018 | Exophiala aquamarina CBS 119918 | 1182545 | Fungi | Fungi | 55.8 | 2.19e-7 | NR | XP_013253897.1 | 1182545 | g7478 | i0 | 56.8 | 4.03846153846154 | 44 | 19 | 84.6 | 0 | 155 | 24 | 217 | 260 | XP_013253897.1 adenylate kinase 1 [Exophiala aquamarina CBS 119918] | diamond | 630 | 55.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Herpotrichiellaceae | Exophiala | Exophiala aquamarina | |
| 26964820 | 26964820 | PRJNA1196384_S_NODE_7262_length_158_cov_1.595041_g7198_i0 | PRJNA1196384 | 7262 | 158 | 1.595041 | 2.52016478 | Eukaryota | 2759 | Fungi | Fungi | 91.3 | 1.68e-21 | NR | CAD0054548.1 | 5580 | g7198 | i0 | 84.6 | 32.1835443037975 | 52 | 8 | 98.7 | 0 | 158 | 3 | 104 | 155 | CAD0054548.1 unnamed protein product, partial [Aureobasidium pullulans] | diamond | 5085 | 91.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Saccotheciaceae | Aureobasidium | Aureobasidium pullulans | |
| 27040869 | 27040869 | PRJNA1196384_S_NODE_6442_length_165_cov_1.359375_g6378_i0 | PRJNA1196384 | 6442 | 165 | 1.359375 | 2.24296875 | Tolypocladium ophioglossoides CBS 1 | 71617 | Fungi | Fungi | 55.8 | 3.17e-8 | NR | KND92392.1 | 1163406 | g6378 | i0 | 79.4 | 3.29090909090909 | 34 | 7 | 61.8 | 0 | 2 | 103 | 29 | 62 | KND92392.1 60S acidic ribosomal protein P2 [Tolypocladium ophioglossoides CBS 100239] | diamond | 543 | 55.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Ophiocordycipitaceae | Tolypocladium | Tolypocladium ophioglossoides | |
| 27849369 | 27849369 | PRJNA1196384_S_NODE_7364_length_157_cov_2.150000_g7300_i0 | PRJNA1196384 | 7364 | 157 | 2.15 | 3.3755 | Fungi | 4751 | Fungi | Fungi | 71.6 | 4.81e-14 | NR | XP_066771658.1 | 56418 | g7300 | i0 | 70.6 | 5.84713375796178 | 51 | 15 | 97.5 | 0 | 155 | 3 | 63 | 113 | XP_066771658.1 NAC domain-containing protein [Lipomyces arxii] | diamond | 918 | 71.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lipomycetes | Lipomycetales | Lipomycetaceae | Lipomyces | Lipomyces arxii | |
| 28462271 | 28462271 | PRJNA1196384_S_NODE_1926_length_282_cov_2.991837_g1862_i0 | PRJNA1196384 | 1926 | 282 | 2.991837 | 8.43698034 | Ustulina deusta | 110526 | Fungi | Fungi | 92 | 5.33e-22 | NR | KAI0910267.1 | 110526 | g1862 | i0 | 66.1 | 6.6063829787234 | 56 | 19 | 59.6 | 0 | 271 | 104 | 1 | 56 | KAI0910267.1 ribosomal protein S14p/S29e-domain-containing protein [Ustulina deusta] | diamond | 1863 | 92 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Xylariales | Xylariaceae | Ustulina | Ustulina deusta | |
| 28999170 | 28999170 | PRJNA1196384_S_NODE_6788_length_162_cov_1.200000_g6724_i0 | PRJNA1196384 | 6788 | 162 | 1.2 | 1.944 | Xylaria longipes | 114818 | Fungi | Fungi | 60.8 | 1.63e-9 | NR | RYC55243.1 | 114818 | g6724 | i0 | 57.7 | 3.85185185185185 | 52 | 22 | 96.3 | 0 | 156 | 1 | 98 | 149 | RYC55243.1 hypothetical protein CHU98_g10965 [Xylaria longipes] | diamond | 624 | 60.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Xylariales | Xylariaceae | Xylaria | Xylaria longipes | |
| 29282791 | 29282791 | PRJNA1196384_S_NODE_2709_length_235_cov_5.348485_g2645_i0 | PRJNA1196384 | 2709 | 235 | 5.348485 | 12.56893975 | Ophiostoma piceae UAMH 11346 | 1262450 | Fungi | Fungi | 71.2 | 7.39e-14 | NR | EPE05284.1 | 1262450 | g2645 | i0 | 72.9 | 1.82553191489362 | 48 | 13 | 61.3 | 0 | 1 | 144 | 21 | 68 | EPE05284.1 60s acidic ribosomal protein p2 [Ophiostoma piceae UAMH 11346] | diamond | 429 | 71.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Ophiostomatales | Ophiostomataceae | Ophiostoma | Ophiostoma piceae | |
| 29661423 | 29661423 | PRJNA1196384_S_NODE_1230_length_348_cov_3.000000_g1166_i0 | PRJNA1196384 | 1230 | 348 | 3 | 10.44 | Peltigera leucophlebia | 52883 | Fungi | Fungi | 57.4 | 7.39e-7 | NR | MCJ1345808.1 | 52883 | g1166 | i0 | 36.8 | 0.818965517241379 | 95 | 55 | 79.3 | 3 | 329 | 54 | 21 | 113 | MCJ1345808.1 hypothetical protein [Peltigera leucophlebia] | diamond | 285 | 57.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Peltigerales | Peltigeraceae | Peltigera | Peltigera leucophlebia | |
| 31083548 | 31083548 | PRJNA1196384_S_NODE_4035_length_198_cov_1.298137_g3971_i0 | PRJNA1196384 | 4035 | 198 | 1.298137 | 2.57031126 | Penicillium glandicola | 197659 | Fungi | Fungi | 40.8 | 0.0345 | NR | CAI7566309.1 | 197659 | g3971 | i0 | 62.9 | 0.53030303030303 | 35 | 13 | 53 | 0 | 159 | 55 | 37 | 71 | CAI7566309.1 unnamed protein product [Penicillium glandicola] | diamond | 105 | 40.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium glandicola | |
| 31747506 | 31747506 | PRJNA1196384_S_NODE_3217_length_217_cov_1.733333_g3153_i0 | PRJNA1196384 | 3217 | 217 | 1.733333 | 3.76133261 | Aspergillus nomiae NRRL 13137 | 1509407 | Fungi | Fungi | 107 | 5.810000000000001e-26 | NR | XP_015407273.1 | 1509407 | g3153 | i0 | 68.6 | 2.93087557603687 | 70 | 22 | 96.8 | 0 | 216 | 7 | 94 | 163 | XP_015407273.1 glyceraldehyde-3-phosphate dehydrogenase, partial [Aspergillus nomiae NRRL 13137] | diamond | 636 | 107 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus nomiae |
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);;