contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA263496" and tax_phylum = "Ascomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5472357 | 5472357 | PRJNA263496_P_NODE_1105_length_883_cov_1.949640_g959_i0 | PRJNA263496 | 1105 | 883 | 1.94964 | 17.2153212 | Fungi | 4751 | Fungi | Fungi | 371 | 1.28e-123 | NR | NP_594440.1 | 4896 | g959 | i0 | 60.2 | 112.984144960362 | 294 | 112 | 99.9 | 1 | 882 | 1 | 4 | 292 | NP_594440.1 translation elongation factor EF-1 alpha Ef1a-b [Schizosaccharomyces pombe] | diamond | 99765 | 374 | 0.991978609625668 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Schizosaccharomycetes | Schizosaccharomycetales | Schizosaccharomycetaceae | Schizosaccharomyces | Schizosaccharomyces pombe | |
| 9297071 | 9297071 | PRJNA263496_P_NODE_12168_length_224_cov_2.485714_g11915_i0 | PRJNA263496 | 12168 | 224 | 2.485714 | 5.56799936 | Opisthokonta | 33154 | Fungi | Fungi | 113 | 7.9e-30 | NR | KAJ1337677.1 | 5520 | g11915 | i0 | 80.3 | 869.008928571429 | 66 | 13 | 88.4 | 0 | 3 | 200 | 110 | 175 | KAJ1337677.1 histone H4 [Microdochium nivale] | diamond | 194658 | 114 | 0.991228070175439 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Xylariales | Microdochiaceae | Microdochium | Microdochium nivale | |
| 29473701 | 29473701 | PRJNA263496_P_NODE_22470_length_165_cov_0.879310_g22217_i0 | PRJNA263496 | 22470 | 165 | 0.87931 | 1.4508615 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 53.1 | 2.67e-6 | NR | XP_069232173.1 | 1052096 | g22217 | i0 | 59.3 | 0.981818181818182 | 54 | 3 | 98.2 | 1 | 3 | 164 | 4 | 38 | XP_069232173.1 uncharacterized protein WHR41_02285 [Cladosporium halotolerans] | diamond | 162 | 53.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 29789579 | 29789579 | PRJNA263496_P_NODE_24331_length_163_cov_0.894737_g24078_i0 | PRJNA263496 | 24331 | 163 | 0.894737 | 1.45842131 | Plenodomus tracheiphilus IPT5 | 1408161 | Fungi | Fungi | 120 | 5.54e-33 | NR | KAF2851163.1 | 1408161 | g24078 | i0 | 98.1 | 2.92638036809816 | 53 | 1 | 97.5 | 0 | 159 | 1 | 86 | 138 | KAF2851163.1 AN1-type zinc finger protein-like protein [Plenodomus tracheiphilus IPT5] | diamond | 477 | 120 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Leptosphaeriaceae | Plenodomus | Plenodomus tracheiphilus | |
| 30421958 | 30421958 | PRJNA263496_P_NODE_13453_length_213_cov_1.451220_g13200_i0 | PRJNA263496 | 13453 | 213 | 1.45122 | 3.0910986 | Fusarium flagelliforme | 2675880 | Fungi | Fungi | 42.4 | 0.0322 | NR | XP_045977701.1 | 2675880 | g13200 | i0 | 32.7 | 0.732394366197183 | 52 | 35 | 73.2 | 0 | 164 | 9 | 45 | 96 | XP_045977701.1 uncharacterized protein B0J16DRAFT_389244 [Fusarium flagelliforme] | diamond | 156 | 42.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Fusarium | Fusarium flagelliforme | |
| 32273338 | 32273338 | PRJNA263496_P_NODE_20358_length_170_cov_1.685950_g20105_i0 | PRJNA263496 | 20358 | 170 | 1.68595 | 2.866115 | Fungi | 4751 | Fungi | Fungi | 74.7 | 9.04e-15 | NR | EFQ91734.1 | 861557 | g20105 | i0 | 61.8 | 14.4882352941176 | 55 | 21 | 97.1 | 0 | 168 | 4 | 54 | 108 | EFQ91734.1 hypothetical protein PTT_11324 [Pyrenophora teres f. teres 0-1] | diamond | 2463 | 75.1 | 0.994673768308922 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Pyrenophora | Pyrenophora teres | |
| 32305061 | 32305061 | PRJNA263496_P_NODE_23219_length_164_cov_0.886957_g22966_i0 | PRJNA263496 | 23219 | 164 | 0.886957 | 1.45460948 | Eukaryota | 2759 | Fungi | Fungi | 40.8 | 0.0479 | NR | KAG9802206.1 | 46634 | g22966 | i0 | 67.9 | 2.70731707317073 | 28 | 9 | 51.2 | 0 | 88 | 5 | 137 | 164 | KAG9802206.1 eukaryotic translation initiation factor 3, partial [Aureobasidium melanogenum] | diamond | 444 | 41.2 | 0.990291262135922 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Saccotheciaceae | Aureobasidium | Aureobasidium melanogenum |
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);;