contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJNA1082072" and tax_phylum = "Basidiomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7845852 | 7845852 | PRJNA1082072_P_NODE_1107_length_328_cov_1.207843_g1100_i0 | PRJNA1082072 | 1107 | 328 | 1.207843 | 3.96172504 | Fungi | 4751 | Fungi | Fungi | 166 | 2.28e-50 | NR | CAE6469251.1 | 456999 | g1100 | i0 | 76.9 | 46.609756097561 | 104 | 22 | 93.3 | 1 | 3 | 308 | 47 | 150 | CAE6469251.1 unnamed protein product [Rhizoctonia solani] | diamond | 15288 | 166 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Ceratobasidiaceae | Rhizoctonia | Rhizoctonia solani | |
| 28299150 | 28299150 | PRJNA1082072_P_NODE_1266_length_307_cov_2.230769_g1259_i0 | PRJNA1082072 | 1266 | 307 | 2.230769 | 6.84846083 | Mycena kentingensis (nom. inval.) | 1325293 | Fungi | Fungi | 50.1 | 2.09e-4 | NR | KAF7323850.1 | 1325293 | g1259 | i0 | 55.1 | 0.478827361563518 | 49 | 18 | 45.9 | 3 | 33 | 173 | 428 | 474 | KAF7323850.1 Growth factor receptor domain-containing protein [Mycena kentingensis (nom. inval.)] | diamond | 147 | 50.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Mycena | Mycena kentingensis (nom. inval.) | |
| 29111723 | 29111723 | PRJNA1082072_P_NODE_1028_length_338_cov_1.369811_g1021_i0 | PRJNA1082072 | 1028 | 338 | 1.369811 | 4.62996118 | Fungi | 4751 | Fungi | Fungi | 53.1 | 2.37e-5 | NR | XP_027485141.1 | 76775 | g1021 | i0 | 31.7 | 5.33431952662722 | 104 | 70 | 91.4 | 1 | 30 | 338 | 242 | 345 | XP_027485141.1 mitochondrial-processing peptidase subunit alpha [Malassezia restricta] | diamond | 1803 | 53.5 | 0.992523364485981 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 29869407 | 29869407 | PRJNA1082072_P_NODE_2671_length_244_cov_2.157895_g2664_i0 | PRJNA1082072 | 2671 | 244 | 2.157895 | 5.2652638 | Agaricomycetes | 155619 | Fungi | Fungi | 87.8 | 1.75e-18 | NR | KAI0315996.1 | 55340 | g2664 | i0 | 59.2 | 5.64344262295082 | 76 | 31 | 93.4 | 0 | 3 | 230 | 213 | 288 | KAI0315996.1 glycoside hydrolase [Amylostereum chailletii] | diamond | 1377 | 87.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Stereaceae | Amylostereum | Amylostereum chailletii | |
| 29932759 | 29932759 | PRJNA1082072_P_NODE_1231_length_312_cov_1.104603_g1224_i0 | PRJNA1082072 | 1231 | 312 | 1.104603 | 3.44636136 | Agaricomycetes | 155619 | Fungi | Fungi | 114 | 4.33e-28 | NR | KLO06104.1 | 27342 | g1224 | i0 | 52.9 | 18.3173076923077 | 104 | 46 | 97.1 | 1 | 6 | 308 | 5 | 108 | KLO06104.1 large subunit ribosomal protein LP0 [Schizopora paradoxa] | diamond | 5715 | 114 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Hymenochaetales | Schizoporaceae | Schizopora | Schizopora paradoxa | |
| 30098938 | 30098938 | PRJNA1082072_P_NODE_1992_length_255_cov_1.181319_g1985_i0 | PRJNA1082072 | 1992 | 255 | 1.181319 | 3.01236345 | Flagelloscypha sp. PMI_526 | 1485228 | Fungi | Fungi | 44.7 | 0.00844 | NR | KAH8824239.1 | 1485228 | g1985 | i0 | 39.1 | 0.541176470588235 | 46 | 28 | 54.1 | 0 | 226 | 89 | 177 | 222 | KAH8824239.1 hypothetical protein DL96DRAFT_1613481 [Flagelloscypha sp. PMI_526] | diamond | 138 | 44.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Tricholomataceae | Flagelloscypha | Flagelloscypha sp. PMI_526 | |
| 30730990 | 30730990 | PRJNA1082072_P_NODE_2134_length_251_cov_0.865169_g2127_i0 | PRJNA1082072 | 2134 | 251 | 0.865169 | 2.17157419 | Lentinula aciculospora | 153920 | Fungi | Fungi | 62 | 6.68e-9 | NR | KAJ4467243.1 | 153920 | g2127 | i0 | 42.5 | 1.75697211155378 | 80 | 41 | 93.2 | 3 | 251 | 18 | 521 | 597 | KAJ4467243.1 hypothetical protein J3R30DRAFT_3579153 [Lentinula aciculospora] | diamond | 441 | 62 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Omphalotaceae | Lentinula | Lentinula aciculospora | |
| 30889012 | 30889012 | PRJNA1082072_P_NODE_794_length_371_cov_1.550336_g787_i0 | PRJNA1082072 | 794 | 371 | 1.550336 | 5.75174656 | Rhodotorula toruloides ATCC 2 | 5286 | Fungi | Fungi | 45.1 | 0.0237 | NR | EGU13408.1 | 1001064 | g787 | i0 | 33.8 | 1.26145552560647 | 68 | 42 | 52.6 | 2 | 20 | 214 | 560 | 627 | EGU13408.1 Antifreeze glycoprotein [Rhodotorula toruloides ATCC 204091] | diamond | 468 | 45.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula toruloides | |
| 31268222 | 31268222 | PRJNA1082072_P_NODE_2975_length_241_cov_0.916667_g2968_i0 | PRJNA1082072 | 2975 | 241 | 0.916667 | 2.20916747 | Punctularia strigosozonata HHB-11173 SS5 | 741275 | Fungi | Fungi | 73.9 | 3.67e-13 | NR | XP_007387260.1 | 741275 | g2968 | i0 | 44.7 | 0.946058091286307 | 76 | 42 | 94.6 | 0 | 239 | 12 | 374 | 449 | XP_007387260.1 phospholipid-translocating P-type ATPase [Punctularia strigosozonata HHB-11173 SS5] | diamond | 228 | 73.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Corticiales | Punctulariaceae | Punctularia | Punctularia strigosozonata | |
| 31892212 | 31892212 | PRJNA1082072_P_NODE_1517_length_285_cov_1.320755_g1510_i0 | PRJNA1082072 | 1517 | 285 | 1.320755 | 3.76415175 | Basidiomycota | 5204 | Fungi | Fungi | 56.2 | 4.81e-7 | NR | GAA5902419.1 | 183962 | g1510 | i0 | 38.1 | 2.67368421052632 | 84 | 52 | 88.4 | 0 | 253 | 2 | 53 | 136 | GAA5902419.1 hypothetical protein JCM6883_001404 [Sporobolomyces salmoneus] | diamond | 762 | 56.6 | 0.992932862190813 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Sporobolomyces | Sporobolomyces salmoneus | |
| 31923795 | 31923795 | PRJNA1082072_P_NODE_1857_length_265_cov_1.203125_g1850_i0 | PRJNA1082072 | 1857 | 265 | 1.203125 | 3.18828125 | Fungi | 4751 | Fungi | Fungi | 110 | 1.0600000000000002e-27 | NR | XP_047901021.1 | 139415 | g1850 | i0 | 68.1 | 10.1433962264151 | 91 | 26 | 99.6 | 2 | 1 | 264 | 111 | 201 | XP_047901021.1 60S ribosomal protein L6 [Fomitopsis serialis] | diamond | 2688 | 110 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Fomitopsidaceae | Fomitopsis | Fomitopsis serialis | |
| 31955386 | 31955386 | PRJNA1082072_P_NODE_557_length_418_cov_2.544928_g550_i0 | PRJNA1082072 | 557 | 418 | 2.544928 | 10.63779904 | Fungi | 4751 | Fungi | Fungi | 127 | 4.02e-34 | NR | KAJ4481592.1 | 5353 | g550 | i0 | 45.5 | 3.11483253588517 | 145 | 73 | 99.8 | 2 | 417 | 1 | 7 | 151 | KAJ4481592.1 translationally controlled tumor-associated [Lentinula edodes] | diamond | 1302 | 127 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Omphalotaceae | Lentinula | Lentinula edodes | |
| 31955387 | 31955387 | PRJNA1082072_P_NODE_937_length_348_cov_0.818182_g930_i0 | PRJNA1082072 | 937 | 348 | 0.818182 | 2.84727336 | Agaricomycetes | 155619 | Fungi | Fungi | 46.6 | 0.00314 | NR | KAG8774635.1 | 2600210 | g930 | i0 | 61.4 | 1.51724137931034 | 44 | 17 | 37.9 | 0 | 347 | 216 | 140 | 183 | KAG8774635.1 60S ribosomal protein L19C [Serendipita sp. 397] | diamond | 528 | 46.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Sebacinales | Serendipitaceae | Serendipita | Serendipita sp. 397 | |
| 32312429 | 32312429 | PRJNA1082072_P_NODE_2559_length_246_cov_0.890173_g2552_i0 | PRJNA1082072 | 2559 | 246 | 0.890173 | 2.18982558 | Kockovaella imperatae | 4999 | Fungi | Fungi | 66.2 | 1.99e-10 | NR | XP_021869564.1 | 4999 | g2552 | i0 | 48.1 | 0.963414634146341 | 79 | 32 | 96.3 | 2 | 239 | 3 | 272 | 341 | XP_021869564.1 hypothetical protein BD324DRAFT_632566 [Kockovaella imperatae] | diamond | 237 | 66.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cuniculitremaceae | Kockovaella | Kockovaella imperatae | |
| 32722743 | 32722743 | PRJNA1082072_P_NODE_680_length_390_cov_0.971609_g673_i0 | PRJNA1082072 | 680 | 390 | 0.971609 | 3.7892751 | Tulasnella sp. 417 | 2600225 | Fungi | Fungi | 110 | 3.49e-28 | NR | KAG8920536.1 | 2600225 | g673 | i0 | 47.5 | 2.72307692307692 | 122 | 64 | 93.8 | 0 | 6 | 371 | 6 | 127 | KAG8920536.1 ribosomal protein S24A [Tulasnella sp. 417] | diamond | 1062 | 110 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Tulasnellaceae | Tulasnella | Tulasnella sp. 417 | |
| 32777024 | 32777024 | PRJNA1082072_P_NODE_1360_length_297_cov_1.375000_g1353_i0 | PRJNA1082072 | 1360 | 297 | 1.375 | 4.08375 | Fungi | 4751 | Fungi | Fungi | 99 | 2.94e-23 | NR | XP_018268414.1 | 578459 | g1353 | i0 | 58 | 9.05050505050505 | 100 | 39 | 99 | 2 | 3 | 296 | 118 | 216 | XP_018268414.1 uncharacterized protein RHOBADRAFT_18153 [Rhodotorula graminis WP1] | diamond | 2688 | 100 | 0.99 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula graminis | |
| 32817127 | 32817127 | PRJNA1082072_P_NODE_1420_length_290_cov_1.419355_g1413_i0 | PRJNA1082072 | 1420 | 290 | 1.419355 | 4.1161295 | Filobasidium floriforme | 5210 | Fungi | Fungi | 45.1 | 0.00456 | NR | XP_046035425.1 | 5210 | g1413 | i0 | 34.2 | 0.786206896551724 | 76 | 48 | 78.6 | 1 | 243 | 16 | 81 | 154 | XP_046035425.1 uncharacterized protein HD553DRAFT_313869 [Filobasidium floriforme] | diamond | 228 | 45.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Filobasidium | Filobasidium floriforme |
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);;