contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA1061474" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26655310 | 26655310 | PRJNA1061474_P_NODE_50761_length_247_cov_0.885057_g50515_i0 | PRJNA1061474 | 50761 | 247 | 0.885057 | 2.18609079 | Mycena chlorophos | 658473 | Fungi | Fungi | 70.1 | 9.36e-12 | NR | GAT44000.1 | 658473 | g50515 | i0 | 58.2 | 4.66396761133603 | 55 | 23 | 66.8 | 0 | 165 | 1 | 1064 | 1118 | GAT44000.1 predicted protein [Mycena chlorophos] | diamond | 1152 | 70.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Mycena | Mycena chlorophos | |
| 27129881 | 27129881 | PRJNA1061474_P_NODE_54582_length_244_cov_0.865497_g54336_i0 | PRJNA1061474 | 54582 | 244 | 0.865497 | 2.11181268 | Naganishia vaughanmartiniae | 1424756 | Fungi | Fungi | 47.4 | 8.77e-4 | NR | KAJ9120286.1 | 1424756 | g54336 | i0 | 33.8 | 2.82786885245902 | 77 | 41 | 82.4 | 1 | 13 | 213 | 14 | 90 | KAJ9120286.1 hypothetical protein QFC22_003186 [Naganishia vaughanmartiniae] | diamond | 690 | 47.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Naganishia | Naganishia vaughanmartiniae | |
| 29395674 | 29395674 | PRJNA1061474_P_NODE_54089_length_244_cov_0.900585_g53843_i0 | PRJNA1061474 | 54089 | 244 | 0.900585 | 2.1974274 | Serendipita | 358905 | Fungi | Fungi | 107 | 5.98e-25 | NR | KAG8787182.1 | 2600211 | g53843 | i0 | 63.1 | 3.06147540983607 | 84 | 25 | 98.4 | 2 | 244 | 5 | 39 | 120 | KAG8787182.1 hypothetical protein FRC16_001585 [Serendipita sp. 398] | diamond | 747 | 107 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Sebacinales | Serendipitaceae | Serendipita | Serendipita sp. 398 | |
| 29814255 | 29814255 | PRJNA1061474_P_NODE_50311_length_247_cov_0.885057_g50065_i0 | PRJNA1061474 | 50311 | 247 | 0.885057 | 2.18609079 | Serendipita indica DSM 11827 | 1109443 | Fungi | Fungi | 46.6 | 0.00169 | NR | CAG7846316.1 | 1109443 | g50065 | i0 | 37.2 | 0.947368421052632 | 78 | 41 | 92.3 | 2 | 12 | 239 | 372 | 443 | CAG7846316.1 U3 small nucleolar RNA-associated protein 21 homolog Short=U3 snoRNA-associated protein 21 [Serendipita indica DSM 11827] | diamond | 234 | 46.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Sebacinales | Serendipitaceae | Serendipita | Serendipita indica | |
| 30690667 | 30690667 | PRJNA1061474_P_NODE_45253_length_251_cov_1.297753_g45007_i0 | PRJNA1061474 | 45253 | 251 | 1.297753 | 3.25736003 | Eukaryota | 2759 | Fungi | Fungi | 120 | 1.2e-31 | NR | XP_007877451.1 | 1277687 | g45007 | i0 | 63.9 | 2.97609561752988 | 83 | 30 | 99.2 | 0 | 250 | 2 | 56 | 138 | XP_007877451.1 uncharacterized protein PFL1_01750 [Pseudozyma flocculosa PF-1] | diamond | 747 | 120 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Pseudozyma | Pseudozyma flocculosa | |
| 31078306 | 31078306 | PRJNA1061474_P_NODE_56175_length_242_cov_0.911243_g55929_i0 | PRJNA1061474 | 56175 | 242 | 0.911243 | 2.20520806 | Ceraceosorus guamensis | 1522189 | Fungi | Fungi | 63.9 | 1.01e-9 | NR | XP_025368166.1 | 1522189 | g55929 | i0 | 85.3 | 0.793388429752066 | 34 | 5 | 42.1 | 0 | 103 | 2 | 1 | 34 | XP_025368166.1 mitochondrial carrier [Ceraceosorus guamensis] | diamond | 192 | 63.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Ceraceosorales | Ceraceosoraceae | Ceraceosorus | Ceraceosorus guamensis | |
| 31489420 | 31489420 | PRJNA1061474_P_NODE_48956_length_248_cov_0.880000_g48710_i0 | PRJNA1061474 | 48956 | 248 | 0.88 | 2.1824 | Russula emetica | 152958 | Fungi | Fungi | 58.2 | 1.06e-7 | NR | KAF8497162.1 | 152958 | g48710 | i0 | 87.5 | 0.774193548387097 | 32 | 4 | 38.7 | 0 | 246 | 151 | 103 | 134 | KAF8497162.1 RF-1 domain-containing protein [Russula emetica] | diamond | 192 | 58.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Russulaceae | Russula | Russula emetica | |
| 31742091 | 31742091 | PRJNA1061474_P_NODE_48037_length_249_cov_0.875000_g47791_i0 | PRJNA1061474 | 48037 | 249 | 0.875 | 2.17875 | Gloeopeniophorella convolvens | 205761 | Fungi | Fungi | 64.3 | 7.75e-10 | NR | KAI0263049.1 | 205761 | g47791 | i0 | 54.5 | 8.72289156626506 | 66 | 29 | 78.3 | 1 | 27 | 221 | 30 | 95 | KAI0263049.1 NAD-P-binding protein [Gloeopeniophorella convolvens] | diamond | 2172 | 64.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Gloeopeniophorella | Gloeopeniophorella convolvens | ||
| 32565138 | 32565138 | PRJNA1061474_P_NODE_50599_length_247_cov_0.885057_g50353_i0 | PRJNA1061474 | 50599 | 247 | 0.885057 | 2.18609079 | Leucoagaricus sp. SymC.cos | 1714833 | Fungi | Fungi | 108 | 6.160000000000001e-27 | NR | KXN84977.1 | 1714833 | g50353 | i0 | 67.1 | 1.9919028340081 | 82 | 7 | 99.6 | 1 | 2 | 247 | 43 | 104 | KXN84977.1 Mitochondrial inner membrane protease ATP23 [Leucoagaricus sp. SymC.cos] | diamond | 492 | 108 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Agaricaceae | Leucoagaricus | Leucoagaricus sp. SymC.cos | |
| 32650807 | 32650807 | PRJNA1061474_P_NODE_41240_length_273_cov_1.155000_g40994_i0 | PRJNA1061474 | 41240 | 273 | 1.155 | 3.15315 | Eukaryota | 2759 | Fungi | Fungi | 113 | 1.0400000000000002e-27 | NR | KAI8461260.1 | 170000 | g40994 | i0 | 59.3 | 12 | 91 | 36 | 100 | 1 | 273 | 1 | 165 | 254 | KAI8461260.1 ribosomal protein L4 domain-containing protein [Phakopsora pachyrhizi] | diamond | 3276 | 114 | 0.991228070175439 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Phakopsoraceae | Phakopsora | Phakopsora pachyrhizi | |
| 32816692 | 32816692 | PRJNA1061474_P_NODE_50500_length_247_cov_0.885057_g50254_i0 | PRJNA1061474 | 50500 | 247 | 0.885057 | 2.18609079 | Malassezia pachydermatis | 77020 | Fungi | Fungi | 56.2 | 6.72e-7 | NR | KAL4400617.1 | 77020 | g50254 | i0 | 50 | 0.510121457489879 | 42 | 21 | 51 | 0 | 151 | 26 | 1 | 42 | KAL4400617.1 Plasma membrane sulfite pump involved in sulfite metabolism [Malassezia pachydermatis] | diamond | 126 | 56.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia pachydermatis |
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);;