contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA1248471" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26680044 | 26680044 | PRJNA1248471_S_NODE_18621_length_167_cov_0.864407_g18521_i0 | PRJNA1248471 | 18621 | 167 | 0.864407 | 1.44355969 | Pucciniales | 5258 | Fungi | Fungi | 52 | 1.94e-6 | NR | CAH7689135.1 | 170000 | g18521 | i0 | 74.2 | 10.0239520958084 | 31 | 8 | 55.7 | 0 | 14 | 106 | 112 | 142 | CAH7689135.1 hypothetical protein PPACK8108_LOCUS24208 [Phakopsora pachyrhizi] | diamond | 1674 | 52 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Phakopsoraceae | Phakopsora | Phakopsora pachyrhizi | |
| 27958022 | 27958022 | PRJNA1248471_S_NODE_10425_length_202_cov_0.875817_g10325_i0 | PRJNA1248471 | 10425 | 202 | 0.875817 | 1.76915034 | Neohortaea acidophila | 245834 | Fungi | Fungi | 95.9 | 2.27e-24 | NR | XP_033592549.1 | 245834 | g10325 | i0 | 75 | 0.831683168316832 | 56 | 14 | 83.2 | 0 | 200 | 33 | 2 | 57 | XP_033592549.1 ATPase, F0 complex, subunit J [Neohortaea acidophila] | diamond | 168 | 95.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Neohortaea | Neohortaea acidophila | |
| 28084241 | 28084241 | PRJNA1248471_S_NODE_6185_length_237_cov_1.627660_g6085_i0 | PRJNA1248471 | 6185 | 237 | 1.62766 | 3.8575542 | Aspergillus udagawae | 91492 | Fungi | Fungi | 138 | 9.76e-36 | NR | GFF63562.1 | 91492 | g6085 | i0 | 84.4 | 3.8987341772151902 | 77 | 12 | 97.5 | 0 | 237 | 7 | 306 | 382 | GFF63562.1 unnamed protein product [Aspergillus udagawae] | diamond | 924 | 138 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus udagawae | |
| 28115791 | 28115791 | PRJNA1248471_S_NODE_20305_length_164_cov_1.330435_g20205_i0 | PRJNA1248471 | 20305 | 164 | 1.330435 | 2.1819134 | Knufia obscura | 1635080 | Fungi | Fungi | 67.8 | 1.04e-12 | NR | XP_064734377.1 | 1635080 | g20205 | i0 | 72.1 | 3.14634146341463 | 43 | 12 | 78.7 | 0 | 3 | 131 | 86 | 128 | XP_064734377.1 uncharacterized protein PMZ80_000429 [Knufia obscura] | diamond | 516 | 67.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Trichomeriaceae | Knufia | Knufia obscura | |
| 28431718 | 28431718 | PRJNA1248471_S_NODE_3826_length_280_cov_1.861472_g3726_i0 | PRJNA1248471 | 3826 | 280 | 1.861472 | 5.2121216 | Lithohypha guttulata | 1690604 | Fungi | Fungi | 127 | 1.16e-32 | NR | KAK5106566.1 | 1690604 | g3726 | i0 | 86.4 | 5.66785714285714 | 66 | 9 | 70.7 | 0 | 280 | 83 | 376 | 441 | KAK5106566.1 hypothetical protein LTS08_000686 [Lithohypha guttulata] | diamond | 1587 | 127 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Trichomeriaceae | Lithohypha | Lithohypha guttulata | |
| 29347380 | 29347380 | PRJNA1248471_S_NODE_17809_length_169_cov_1.575000_g17709_i0 | PRJNA1248471 | 17809 | 169 | 1.575 | 2.66175 | Lignoscripta atroalba | 2918522 | Fungi | Fungi | 40.8 | 0.0395 | NR | MCJ1256285.1 | 2918522 | g17709 | i0 | 94.7 | 1.3491124260355 | 19 | 1 | 33.7 | 0 | 167 | 111 | 132 | 150 | MCJ1256285.1 hypothetical protein [Lignoscripta atroalba] | diamond | 228 | 40.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Trapeliales | Trapeliaceae | Lignoscripta | Lignoscripta atroalba | |
| 29378881 | 29378881 | PRJNA1248471_S_NODE_13269_length_188_cov_2.187050_g13169_i0 | PRJNA1248471 | 13269 | 188 | 2.18705 | 4.111654 | Crucibulum laeve | 68775 | Fungi | Fungi | 71.6 | 4.18e-13 | NR | TFK40683.1 | 68775 | g13169 | i0 | 70.6 | 0.813829787234043 | 51 | 14 | 81.4 | 1 | 188 | 36 | 196 | 245 | TFK40683.1 hypothetical protein BDQ12DRAFT_770473 [Crucibulum laeve] | diamond | 153 | 71.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Nidulariaceae | Crucibulum | Crucibulum laeve | |
| 29757620 | 29757620 | PRJNA1248471_S_NODE_8851_length_209_cov_2.781250_g8751_i0 | PRJNA1248471 | 8851 | 209 | 2.78125 | 5.8128125 | Malassezia sympodialis ATCC 42132 | 1230383 | Fungi | Fungi | 66.6 | 4.97e-12 | NR | XP_018739417.1 | 1230383 | g8751 | i0 | 88.6 | 0.502392344497608 | 35 | 4 | 50.2 | 0 | 208 | 104 | 92 | 126 | XP_018739417.1 uncharacterized protein MSY001_0801 [Malassezia sympodialis ATCC 42132] | diamond | 105 | 66.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia sympodialis | |
| 29997053 | 29997053 | PRJNA1248471_S_NODE_22651_length_161_cov_0.883929_g22551_i0 | PRJNA1248471 | 22651 | 161 | 0.883929 | 1.42312569 | Fungi | 4751 | Fungi | Fungi | 43.1 | 8.65e-4 | NR | EMD30456.1 | 914234 | g22551 | i0 | 59.5 | 3.7639751552795 | 37 | 15 | 68.9 | 0 | 111 | 1 | 5 | 41 | EMD30456.1 hypothetical protein CERSUDRAFT_61147, partial [Gelatoporia subvermispora B] | diamond | 606 | 43.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Gelatoporiaceae | Gelatoporia | Gelatoporia subvermispora | |
| 30358452 | 30358452 | PRJNA1248471_S_NODE_13332_length_188_cov_1.100719_g13232_i0 | PRJNA1248471 | 13332 | 188 | 1.100719 | 2.06935172 | Ustilago trichophora | 86804 | Fungi | Fungi | 77.4 | 2.62e-16 | NR | SPO22764.1 | 86804 | g13232 | i0 | 82.5 | 3.82978723404255 | 40 | 7 | 63.8 | 0 | 1 | 120 | 94 | 133 | SPO22764.1 related to QCR6 - ubiquinol--cytochrome-c reductase 17K protein [Ustilago trichophora] | diamond | 720 | 77.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Ustilago | Ustilago trichophora | |
| 31260772 | 31260772 | PRJNA1248471_S_NODE_16935_length_172_cov_1.341463_g16835_i0 | PRJNA1248471 | 16935 | 172 | 1.341463 | 2.30731636 | root | 1 | Root_unresolved | Root_unresolved | 41.2 | 0.0497 | NR | THH19875.1 | 1095465 | g16835 | i0 | 40 | 1.41279069767442 | 40 | 24 | 69.8 | 0 | 164 | 45 | 781 | 820 | THH19875.1 hypothetical protein EW146_g1395 [Bondarzewia mesenterica] | diamond | 243 | 41.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Bondarzewiaceae | Bondarzewia | Bondarzewia mesenterica | |
| 31956532 | 31956532 | PRJNA1248471_S_NODE_16957_length_172_cov_1.243902_g16857_i0 | PRJNA1248471 | 16957 | 172 | 1.243902 | 2.13951144 | Chaetothyriales | 34395 | Fungi | Fungi | 90.1 | 1.36e-19 | NR | XP_016625510.1 | 1442370 | g16857 | i0 | 77.2 | 6.94186046511628 | 57 | 13 | 99.4 | 0 | 1 | 171 | 269 | 325 | XP_016625510.1 uncharacterized protein Z519_00504 [Cladophialophora bantiana CBS 173.52] | diamond | 1194 | 90.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Herpotrichiellaceae | Cladophialophora | Cladophialophora bantiana | |
| 32128614 | 32128614 | PRJNA1248471_S_NODE_6458_length_234_cov_1.156757_g6358_i0 | PRJNA1248471 | 6458 | 234 | 1.156757 | 2.70681138 | Aspergillus chevalieri | 182096 | Fungi | Fungi | 60.8 | 1.39e-8 | NR | XP_043131589.1 | 182096 | g6358 | i0 | 45.5 | 3.82051282051282 | 77 | 17 | 89.7 | 2 | 219 | 10 | 437 | 495 | XP_043131589.1 uncharacterized protein ACHE_10469S [Aspergillus chevalieri] | diamond | 894 | 60.8 | 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);;