contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJEB6055" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5228093 | 5228093 | PRJEB6055_S_NODE_265_length_402_cov_10006.141689_g241_i0 | PRJEB6055 | 265 | 402 | 10006.141689 | 40224.68958978 | Fungi | 4751 | Fungi | Fungi | 126 | 7.049999999999999e-35 | NR | XP_054124123.1 | 37727 | g241 | i0 | 66.7 | 8.19402985074627 | 93 | 30 | 69.4 | 1 | 388 | 110 | 1 | 92 | XP_054124123.1 uncharacterized protein EYB26_008897 [Talaromyces marneffei] | diamond | 3294 | 126 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Trichocomaceae | Talaromyces | Talaromyces marneffei | |
| 7369760 | 7369760 | PRJEB6055_S_NODE_4786_length_163_cov_2.414062_g4762_i0 | PRJEB6055 | 4786 | 163 | 2.414062 | 3.93492106 | Agaricomycetes | 155619 | Fungi | Fungi | 92.4 | 2.02e-22 | NR | VWO94102.1 | 34458 | g4762 | i0 | 80.9 | 4.10429447852761 | 47 | 9 | 86.5 | 0 | 2 | 142 | 67 | 113 | VWO94102.1 2-cysteine peroxiredoxin, partial [Ganoderma boninense] | diamond | 669 | 92.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Polyporaceae | Ganoderma | Ganoderma boninense | |
| 23077567 | 23077567 | PRJEB6055_S_NODE_4359_length_169_cov_1.492537_g4335_i0 | PRJEB6055 | 4359 | 169 | 1.492537 | 2.52238753 | Ceraceosorus guamensis | 1522189 | Fungi | Fungi | 87.8 | 2.51e-19 | NR | XP_025368547.1 | 1522189 | g4335 | i0 | 75 | 0.994082840236686 | 56 | 14 | 99.4 | 0 | 2 | 169 | 166 | 221 | XP_025368547.1 ribosomal protein S3Ae [Ceraceosorus guamensis] | diamond | 168 | 87.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Ceraceosorales | Ceraceosoraceae | Ceraceosorus | Ceraceosorus guamensis | |
| 26646705 | 26646705 | PRJEB6055_S_NODE_5841_length_151_cov_3.043103_g5817_i0 | PRJEB6055 | 5841 | 151 | 3.043103 | 4.59508553 | Opisthokonta | 33154 | Fungi | Fungi | 60.8 | 2.3e-10 | NR | KAK9680935.1 | 34480 | g5817 | i0 | 75.7 | 8.06622516556291 | 37 | 9 | 73.5 | 0 | 150 | 40 | 64 | 100 | KAK9680935.1 60S ribosomal protein L9B [Basidiobolus ranarum] | diamond | 1218 | 60.8 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Basidiobolomycetes | Basidiobolales | Basidiobolaceae | Basidiobolus | Basidiobolus ranarum | |
| 26812142 | 26812142 | PRJEB6055_S_NODE_5741_length_152_cov_2.307692_g5717_i0 | PRJEB6055 | 5741 | 152 | 2.307692 | 3.50769184 | Coemansia asiatica | 1052880 | Fungi | Fungi | 46.2 | 4.83e-4 | NR | KAJ1647732.1 | 1052880 | g5717 | i0 | 55.3 | 1.85526315789474 | 47 | 21 | 92.8 | 0 | 2 | 142 | 157 | 203 | KAJ1647732.1 60S ribosomal protein L16A [Coemansia asiatica] | diamond | 282 | 46.2 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Coemansia | Coemansia asiatica | |
| 29181228 | 29181228 | PRJEB6055_S_NODE_5849_length_151_cov_2.051724_g5825_i0 | PRJEB6055 | 5849 | 151 | 2.051724 | 3.09810324 | Quaeritorhiza haematococci | 2654861 | Fungi | Fungi | 65.9 | 7.12e-11 | NR | KAJ3077812.1 | 2654861 | g5825 | i0 | 65.9 | 0.874172185430464 | 44 | 15 | 87.4 | 0 | 149 | 18 | 270 | 313 | KAJ3077812.1 hypothetical protein HK102_004949 [Quaeritorhiza haematococci] | diamond | 132 | 65.9 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Quaeritorhizaceae | Quaeritorhiza | Quaeritorhiza haematococci | ||
| 29622595 | 29622595 | PRJEB6055_S_NODE_2050_length_217_cov_3.620879_g2026_i0 | PRJEB6055 | 2050 | 217 | 3.620879 | 7.85730743 | Polyrhizophydium stewartii | 2732419 | Fungi | Fungi | 95.9 | 5.230000000000001e-21 | NR | KAL2917375.1 | 2732419 | g2026 | i0 | 68.5 | 0.746543778801843 | 54 | 17 | 74.7 | 0 | 217 | 56 | 776 | 829 | KAL2917375.1 translation elongation factor 2 [Polyrhizophydium stewartii] | diamond | 162 | 95.9 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Polyrhizophydium | Polyrhizophydium stewartii | ||
| 30943228 | 30943228 | PRJEB6055_S_NODE_3994_length_174_cov_1.438849_g3970_i0 | PRJEB6055 | 3994 | 174 | 1.438849 | 2.50359726 | root | 1 | Root_unresolved | Root_unresolved | 41.6 | 0.00519 | NR | XP_019038176.1 | 683960 | g3970 | i0 | 60 | 1.06896551724138 | 30 | 11 | 51.7 | 1 | 171 | 82 | 29 | 57 | XP_019038176.1 uncharacterized protein WICANDRAFT_63473 [Wickerhamomyces anomalus NRRL Y-366-8] | diamond | 186 | 41.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Phaffomycetales | Wickerhamomycetaceae | Wickerhamomyces | Wickerhamomyces anomalus | |
| 31487546 | 31487546 | PRJEB6055_S_NODE_976_length_278_cov_9.740741_g952_i0 | PRJEB6055 | 976 | 278 | 9.740741 | 27.07925998 | Yarrowia lipolytica | 4952 | Fungi | Fungi | 41.6 | 0.0271 | NR | KAE8168712.1 | 4952 | g952 | i0 | 78.3 | 0.485611510791367 | 23 | 5 | 24.8 | 0 | 223 | 155 | 31 | 53 | KAE8168712.1 hypothetical protein BKA90DRAFT_10915 [Yarrowia lipolytica] | diamond | 135 | 41.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Yarrowia | Yarrowia lipolytica | ||
| 32404873 | 32404873 | PRJEB6055_S_NODE_2739_length_197_cov_2.561728_g2715_i0 | PRJEB6055 | 2739 | 197 | 2.561728 | 5.04660416 | Piptocephalis cylindrospora | 1907219 | Fungi | Fungi | 60.8 | 1.41e-9 | NR | RKP13868.1 | 1907219 | g2715 | i0 | 81.6 | 4.06598984771574 | 38 | 6 | 57.9 | 1 | 5 | 118 | 120 | 156 | RKP13868.1 ribosomal protein S17-domain-containing protein [Piptocephalis cylindrospora] | diamond | 801 | 60.8 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Zoopagomycetes | Zoopagales | Piptocephalidaceae | Piptocephalis | Piptocephalis cylindrospora | |
| 32499923 | 32499923 | PRJEB6055_S_NODE_2399_length_206_cov_3.403509_g2375_i0 | PRJEB6055 | 2399 | 206 | 3.403509 | 7.01122854 | Byssothecium circinans | 147558 | Fungi | Fungi | 45.4 | 2.35e-4 | NR | KAF1948084.1 | 147558 | g2375 | i0 | 59.5 | 1.09223300970874 | 37 | 15 | 53.9 | 0 | 90 | 200 | 9 | 45 | KAF1948084.1 hypothetical protein CC80DRAFT_57283 [Byssothecium circinans] | diamond | 225 | 45.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Massarinaceae | Byssothecium | Byssothecium circinans | |
| 32745242 | 32745242 | PRJEB6055_S_NODE_1880_length_223_cov_5.643617_g1856_i0 | PRJEB6055 | 1880 | 223 | 5.643617 | 12.58526591 | Saccharomycetaceae | 4893 | Fungi | Fungi | 54.3 | 6.08e-7 | NR | KAF4001137.1 | 4932 | g1856 | i0 | 52.5 | 4.0762331838565 | 61 | 19 | 82.1 | 1 | 12 | 194 | 56 | 106 | KAF4001137.1 Protein TAR1 domain protein [Saccharomyces cerevisiae] | diamond | 909 | 54.7 | 0.992687385740402 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Saccharomyces | Saccharomyces cerevisiae |
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);;