contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJEB2368" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27910948 | 27910948 | PRJEB2368_P_NODE_10425_length_287_cov_1.216000_g10107_i0 | PRJEB2368 | 10425 | 287 | 1.216 | 3.48992 | Enterocytozoonidae | 27970 | Fungi | Fungi | 43.1 | 0.0276 | NR | OQS54364.1 | 646526 | g10107 | i0 | 83.3 | 0.501742160278746 | 24 | 4 | 25.1 | 0 | 284 | 213 | 13 | 36 | OQS54364.1 Rpl17 [Enterocytozoon hepatopenaei] | diamond | 144 | 43.1 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 28517606 | 28517606 | PRJEB2368_P_NODE_12827_length_194_cov_0.993631_g12508_i0 | PRJEB2368 | 12827 | 194 | 0.993631 | 1.92764414 | Tulasnella sp. 4 | 1905295 | Fungi | Fungi | 78.2 | 4.99e-15 | NR | KAG8906897.1 | 2600223 | g12508 | i0 | 66.7 | 4.5 | 57 | 19 | 88.1 | 0 | 24 | 194 | 281 | 337 | KAG8906897.1 hypothetical protein FRB99_005779 [Tulasnella sp. 403] | diamond | 873 | 78.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Tulasnellaceae | Tulasnella | Tulasnella sp. 403 | |
| 28864774 | 28864774 | PRJEB2368_P_NODE_12868_length_192_cov_2.445161_g12549_i0 | PRJEB2368 | 12868 | 192 | 2.445161 | 4.69470912 | Enterospora canceri | 1081671 | Fungi | Fungi | 102 | 2.6e-26 | NR | ORD94087.1 | 1081671 | g12549 | i0 | 74.6 | 0.984375 | 63 | 16 | 98.4 | 0 | 3 | 191 | 12 | 74 | ORD94087.1 RL30 [Enterospora canceri] | diamond | 189 | 102 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Enterospora | Enterospora canceri | |||
| 28991454 | 28991454 | PRJEB2368_P_NODE_7748_length_287_cov_1.884000_g7430_i0 | PRJEB2368 | 7748 | 287 | 1.884 | 5.40708 | Spraguea lophii 42_11 | 51541 | Fungi | Fungi | 60.1 | 5.01e-8 | NR | EPR79078.1 | 1358809 | g7430 | i0 | 86.2 | 0.303135888501742 | 29 | 4 | 30.3 | 0 | 201 | 287 | 167 | 195 | EPR79078.1 Glutaminyl-tRNA synthetase [Spraguea lophii 42_110] | diamond | 87 | 60.1 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Spragueidae | Spraguea | Spraguea lophii | |||
| 29590685 | 29590685 | PRJEB2368_P_NODE_1210_length_790_cov_3.034529_g993_i0 | PRJEB2368 | 1210 | 790 | 3.034529 | 23.9727791 | Diploschistes diacapsis | 150877 | Fungi | Fungi | 64.7 | 7.95e-8 | NR | KAI4142025.1 | 150877 | g993 | i0 | 31.6 | 1.51518987341772 | 136 | 85 | 51.3 | 3 | 782 | 378 | 98 | 226 | KAI4142025.1 MAG: hypothetical protein LQ340_007455 [Diploschistes diacapsis] | diamond | 1197 | 64.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Ostropales | Graphidaceae | Diploschistes | Diploschistes diacapsis | |
| 29717065 | 29717065 | PRJEB2368_P_NODE_9690_length_287_cov_1.372000_g9372_i0 | PRJEB2368 | 9690 | 287 | 1.372 | 3.93764 | Enterocytozoon bieneusi H348 | 481877 | Fungi | Fungi | 45.4 | 0.00655 | NR | EED43820.1 | 481877 | g9372 | i0 | 84 | 0.261324041811847 | 25 | 4 | 26.1 | 0 | 286 | 212 | 145 | 169 | EED43820.1 hypothetical membrane spanning protein [Enterocytozoon bieneusi H348] | diamond | 75 | 45.4 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Enterocytozoon | Enterocytozoon bieneusi | |||
| 30633299 | 30633299 | PRJEB2368_P_NODE_8173_length_287_cov_1.708000_g7855_i0 | PRJEB2368 | 8173 | 287 | 1.708 | 4.90196 | Enterospora canceri | 1081671 | Fungi | Fungi | 50.8 | 9.15e-5 | NR | ORD95157.1 | 1081671 | g7855 | i0 | 80 | 0.261324041811847 | 25 | 5 | 26.1 | 0 | 1 | 75 | 433 | 457 | ORD95157.1 putative isoleucine--tRNA ligase, cytoplasmic [Enterospora canceri] | diamond | 75 | 50.8 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Enterospora | Enterospora canceri | |||
| 31455316 | 31455316 | PRJEB2368_P_NODE_14296_length_166_cov_1.713178_g13977_i0 | PRJEB2368 | 14296 | 166 | 1.713178 | 2.84387548 | Pyronema omphalodes CBS 1 | 337075 | Fungi | Fungi | 92.8 | 2.33e-20 | NR | CCX05784.1 | 1076935 | g13977 | i0 | 71.2 | 4.69879518072289 | 52 | 15 | 94 | 0 | 1 | 156 | 242 | 293 | CCX05784.1 Similar to Exoglucanase 1; acc. no. P13860 [Pyronema omphalodes CBS 100304] | diamond | 780 | 92.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pezizomycetes | Pezizales | Pyronemataceae | Pyronema | Pyronema omphalodes | |
| 32562795 | 32562795 | PRJEB2368_P_NODE_7859_length_287_cov_1.832000_g7541_i0 | PRJEB2368 | 7859 | 287 | 1.832 | 5.25784 | Enterocytozoon bieneusi H348 | 481877 | Fungi | Fungi | 50.8 | 1.74e-5 | NR | EED44590.1 | 481877 | g7541 | i0 | 92 | 0.261324041811847 | 25 | 2 | 26.1 | 0 | 286 | 212 | 20 | 44 | EED44590.1 SSU ribosomal protein S17E [Enterocytozoon bieneusi H348] | diamond | 75 | 50.8 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Enterocytozoon | Enterocytozoon bieneusi |
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);;