contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA781453" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10966260 | 10966260 | PRJNA781453_P_NODE_11749_length_433_cov_1.283333_g11635_i0 | PRJNA781453 | 11749 | 433 | 1.283333 | 5.55683189 | Gymnopus androsaceus JB14 | 1447944 | Fungi | Fungi | 270 | 5.61e-81 | NR | KAE9397860.1 | 1447944 | g11635 | i0 | 100 | 1.99538106235566 | 144 | 0 | 99.8 | 0 | 1 | 432 | 1074 | 1217 | KAE9397860.1 pre-mRNA splicing factor [Gymnopus androsaceus JB14] | diamond | 864 | 270 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Omphalotaceae | Gymnopus | Gymnopus androsaceus | |
| 27527497 | 27527497 | PRJNA781453_P_NODE_24883_length_291_cov_1.788991_g24768_i0 | PRJNA781453 | 24883 | 291 | 1.788991 | 5.20596381 | Penicillium fimorum | 1882269 | Fungi | Fungi | 43.5 | 0.0314 | NR | KAJ5504772.1 | 1882269 | g24768 | i0 | 32 | 0.515463917525773 | 50 | 30 | 51.5 | 1 | 2 | 151 | 102 | 147 | KAJ5504772.1 hypothetical protein N7463_007646 [Penicillium fimorum] | diamond | 150 | 43.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium fimorum | |
| 27938114 | 27938114 | PRJNA781453_P_NODE_32305_length_251_cov_0.865169_g32190_i0 | PRJNA781453 | 32305 | 251 | 0.865169 | 2.17157419 | Aspergillus calidoustus | 454130 | Fungi | Fungi | 109 | 1.2e-25 | NR | CEL10766.1 | 454130 | g32190 | i0 | 71.1 | 4.41035856573705 | 83 | 19 | 93.2 | 2 | 234 | 1 | 18 | 100 | CEL10766.1 Putative Aldehyde dehydrogenase [Aspergillus calidoustus] | diamond | 1107 | 109 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus calidoustus | |
| 27969549 | 27969549 | PRJNA781453_P_NODE_18285_length_341_cov_2.130597_g18170_i0 | PRJNA781453 | 18285 | 341 | 2.130597 | 7.26533577 | Podila epicladia | 979697 | Fungi | Fungi | 47 | 0.00366 | NR | KAG0081881.1 | 979697 | g18170 | i0 | 29.6 | 1.42521994134897 | 81 | 52 | 71.3 | 2 | 303 | 61 | 219 | 294 | KAG0081881.1 hypothetical protein BGZ92_000077 [Podila epicladia] | diamond | 486 | 47 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Podila | Podila epicladia | |
| 28032901 | 28032901 | PRJNA781453_P_NODE_9805_length_477_cov_1.633663_g9691_i0 | PRJNA781453 | 9805 | 477 | 1.633663 | 7.79257251 | Gymnopus androsaceus JB14 | 1447944 | Fungi | Fungi | 276 | 5.209999999999999e-87 | NR | KAE9398844.1 | 1447944 | g9691 | i0 | 90.6 | 1 | 159 | 14 | 99.4 | 1 | 2 | 475 | 220 | 378 | KAE9398844.1 hypothetical protein BT96DRAFT_920598 [Gymnopus androsaceus JB14] | diamond | 477 | 276 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Omphalotaceae | Gymnopus | Gymnopus androsaceus | |
| 28222002 | 28222002 | PRJNA781453_P_NODE_17046_length_354_cov_1.370107_g16931_i0 | PRJNA781453 | 17046 | 354 | 1.370107 | 4.85017878 | Delitschia confertaspora ATCC 742 | 1504671 | Fungi | Fungi | 218 | 1.82e-67 | NR | KAF2196293.1 | 1513339 | g16931 | i0 | 86.3 | 3.96610169491525 | 117 | 16 | 99.2 | 0 | 352 | 2 | 270 | 386 | KAF2196293.1 PLP-dependent transferase [Delitschia confertaspora ATCC 74209] | diamond | 1404 | 218 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Delitschiaceae | Delitschia | Delitschia confertaspora | |
| 28853463 | 28853463 | PRJNA781453_P_NODE_37928_length_244_cov_0.900585_g37813_i0 | PRJNA781453 | 37928 | 244 | 0.900585 | 2.1974274 | Lophium mytilinum | 390894 | Fungi | Fungi | 45.4 | 0.00435 | NR | KAF2493283.1 | 390894 | g37813 | i0 | 31.3 | 0.983606557377049 | 80 | 47 | 98.4 | 1 | 4 | 243 | 319 | 390 | KAF2493283.1 hypothetical protein BU16DRAFT_619624 [Lophium mytilinum] | diamond | 240 | 45.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mytilinidiales | Mytilinidiaceae | Lophium | Lophium mytilinum | |
| 29201138 | 29201138 | PRJNA781453_P_NODE_13309_length_403_cov_2.393939_g13195_i0 | PRJNA781453 | 13309 | 403 | 2.393939 | 9.64757417 | Gymnopus androsaceus JB14 | 1447944 | Fungi | Fungi | 277 | 1.59e-90 | NR | KAE9409971.1 | 1447944 | g13195 | i0 | 100 | 0.997518610421836 | 134 | 0 | 99.8 | 0 | 402 | 1 | 173 | 306 | KAE9409971.1 hypothetical protein BT96DRAFT_462336 [Gymnopus androsaceus JB14] | diamond | 402 | 277 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Omphalotaceae | Gymnopus | Gymnopus androsaceus | |
| 29390562 | 29390562 | PRJNA781453_P_NODE_27329_length_276_cov_1.630542_g27214_i0 | PRJNA781453 | 27329 | 276 | 1.630542 | 4.50029592 | Gymnopus androsaceus JB14 | 1447944 | Fungi | Fungi | 120 | 2.54e-30 | NR | KAE9409971.1 | 1447944 | g27214 | i0 | 100 | 0.554347826086957 | 51 | 0 | 55.4 | 0 | 2 | 154 | 102 | 152 | KAE9409971.1 hypothetical protein BT96DRAFT_462336 [Gymnopus androsaceus JB14] | diamond | 153 | 120 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Omphalotaceae | Gymnopus | Gymnopus androsaceus | |
| 29611144 | 29611144 | PRJNA781453_P_NODE_28110_length_272_cov_1.115578_g27995_i0 | PRJNA781453 | 28110 | 272 | 1.115578 | 3.03437216 | Gymnopus androsaceus JB14 | 1447944 | Fungi | Fungi | 172 | 1.26e-52 | NR | KAE9391144.1 | 1447944 | g27995 | i0 | 100 | 0.992647058823529 | 90 | 0 | 99.3 | 0 | 272 | 3 | 92 | 181 | KAE9391144.1 hypothetical protein BT96DRAFT_959616 [Gymnopus androsaceus JB14] | diamond | 270 | 172 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Omphalotaceae | Gymnopus | Gymnopus androsaceus | |
| 29927395 | 29927395 | PRJNA781453_P_NODE_29891_length_262_cov_1.222222_g29776_i0 | PRJNA781453 | 29891 | 262 | 1.222222 | 3.20222164 | Daldinia caldariorum | 326644 | Fungi | Fungi | 43.1 | 0.0336 | NR | XP_047787429.1 | 326644 | g29776 | i0 | 47.9 | 0.549618320610687 | 48 | 25 | 55 | 0 | 217 | 74 | 95 | 142 | XP_047787429.1 uncharacterized protein F4812DRAFT_132643 [Daldinia caldariorum] | diamond | 144 | 43.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Xylariales | Hypoxylaceae | Daldinia | Daldinia caldariorum | |
| 30243290 | 30243290 | PRJNA781453_P_NODE_15292_length_374_cov_1.750831_g15178_i0 | PRJNA781453 | 15292 | 374 | 1.750831 | 6.54810794 | Tilletiopsis washingtonensis | 58919 | Fungi | Fungi | 114 | 1.36e-28 | NR | XP_025596234.1 | 58919 | g15178 | i0 | 52.1 | 1.77272727272727 | 119 | 56 | 95.5 | 1 | 373 | 17 | 106 | 223 | XP_025596234.1 hypothetical protein FA09DRAFT_340529 [Tilletiopsis washingtonensis] | diamond | 663 | 114 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Entylomatales | Tilletiopsis | Tilletiopsis washingtonensis | ||
| 31602362 | 31602362 | PRJNA781453_P_NODE_19496_length_331_cov_1.445736_g19381_i0 | PRJNA781453 | 19496 | 331 | 1.445736 | 4.78538616 | Gymnopus androsaceus JB14 | 1447944 | Fungi | Fungi | 218 | 4.08e-63 | NR | KAE9397860.1 | 1447944 | g19381 | i0 | 100 | 62.2205438066465 | 107 | 0 | 97 | 0 | 9 | 329 | 955 | 1061 | KAE9397860.1 pre-mRNA splicing factor [Gymnopus androsaceus JB14] | diamond | 20595 | 218 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Omphalotaceae | Gymnopus | Gymnopus androsaceus | |
| 31760321 | 31760321 | PRJNA781453_P_NODE_4757_length_685_cov_3.281046_g4652_i0 | PRJNA781453 | 4757 | 685 | 3.281046 | 22.4751651 | Penicillium soppii | 69789 | Fungi | Fungi | 322 | 5.439999999999999e-107 | NR | XP_057099546.1 | 69789 | g4652 | i0 | 74.9 | 1.01167883211679 | 231 | 51 | 99.9 | 4 | 685 | 2 | 45 | 271 | XP_057099546.1 uncharacterized protein N7529_004724 [Penicillium soppii] | diamond | 693 | 322 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium soppii | |
| 31855174 | 31855174 | PRJNA781453_P_NODE_35717_length_247_cov_0.885057_g35602_i0 | PRJNA781453 | 35717 | 247 | 0.885057 | 2.18609079 | Stachybotrys chartarum IBT 4 | 74722 | Fungi | Fungi | 154 | 2.4e-42 | NR | KFA53101.1 | 1280524 | g35602 | i0 | 93.9 | 0.995951417004049 | 82 | 5 | 99.6 | 0 | 2 | 247 | 436 | 517 | KFA53101.1 hypothetical protein S40293_05343 [Stachybotrys chartarum IBT 40293] | diamond | 246 | 154 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Stachybotryaceae | Stachybotrys | Stachybotrys chartarum | |
| 32551617 | 32551617 | PRJNA781453_P_NODE_38099_length_244_cov_0.900585_g37984_i0 | PRJNA781453 | 38099 | 244 | 0.900585 | 2.1974274 | [Candida] railenensis | 45579 | Fungi | Fungi | 170 | 1.37e-51 | NR | CAH2352551.1 | 45579 | g37984 | i0 | 96.2 | 0.971311475409836 | 79 | 3 | 97.1 | 0 | 243 | 7 | 98 | 176 | CAH2352551.1 uncharacterized RING finger protein [[Candida] railenensis] | diamond | 237 | 170 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Kurtzmaniella | [Candida] railenensis |
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);;