contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA293022" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27168803 | 27168803 | PRJNA293022_P_NODE_74202_length_165_cov_0.896552_g73465_i0 | PRJNA293022 | 74202 | 165 | 0.896552 | 1.4793108 | Sarocladium implicatum | 1610689 | Fungi | Fungi | 55.1 | 3.28e-8 | NR | KAH8175438.1 | 1610689 | g73465 | i0 | 62.5 | 0.872727272727273 | 48 | 13 | 87.3 | 1 | 145 | 2 | 38 | 80 | KAH8175438.1 hypothetical protein LIA77_03856 [Sarocladium implicatum] | diamond | 144 | 55.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium implicatum | |
| 27706387 | 27706387 | PRJNA293022_P_NODE_67404_length_169_cov_0.866667_g66667_i0 | PRJNA293022 | 67404 | 169 | 0.866667 | 1.46466723 | Lithohypha guttulata | 1690604 | Fungi | Fungi | 109 | 2.17e-27 | NR | XP_064758989.1 | 1690604 | g66667 | i0 | 98.2 | 0.976331360946746 | 55 | 1 | 97.6 | 0 | 3 | 167 | 9 | 63 | XP_064758989.1 Fe(2+) transporter [Lithohypha guttulata] | diamond | 165 | 109 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Trichomeriaceae | Lithohypha | Lithohypha guttulata | |
| 27990290 | 27990290 | PRJNA293022_P_NODE_33425_length_242_cov_1.455959_g32688_i0 | PRJNA293022 | 33425 | 242 | 1.455959 | 3.52342078 | Lipomyces doorenjongii | 383834 | Fungi | Fungi | 57 | 1.35e-7 | NR | KAK9350384.1 | 383834 | g32688 | i0 | 47.2 | 0.65702479338843 | 53 | 25 | 65.7 | 2 | 3 | 161 | 144 | 193 | KAK9350384.1 hypothetical protein V1523DRAFT_420004 [Lipomyces doorenjongii] | diamond | 159 | 57 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lipomycetes | Lipomycetales | Lipomycetaceae | Lipomyces | Lipomyces doorenjongii | |
| 28355025 | 28355025 | PRJNA293022_P_NODE_60586_length_178_cov_3.031008_g59849_i0 | PRJNA293022 | 60586 | 178 | 3.031008 | 5.39519424 | Fungi | 4751 | Fungi | Fungi | 59.3 | 8.47e-9 | NR | EGC42647.1 | 544711 | g59849 | i0 | 51.8 | 1.71910112359551 | 56 | 18 | 94.4 | 1 | 177 | 10 | 72 | 118 | EGC42647.1 transcript antisense to ribosomal RNA protein, partial [Histoplasma capsulatum var. duboisii H88] | diamond | 306 | 59.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Onygenales | Ajellomycetaceae | Histoplasma | Histoplasma capsulatum | |
| 29473867 | 29473867 | PRJNA293022_P_NODE_39950_length_221_cov_1.197674_g39213_i0 | PRJNA293022 | 39950 | 221 | 1.197674 | 2.64685954 | Eremomyces bilateralis CBS 781.7 | 1341166 | Fungi | Fungi | 43.9 | 0.0108 | NR | XP_033534099.1 | 1392243 | g39213 | i0 | 37.7 | 1.50678733031674 | 53 | 33 | 71.9 | 0 | 47 | 205 | 55 | 107 | XP_033534099.1 uncharacterized protein P152DRAFT_514115 [Eremomyces bilateralis CBS 781.70] | diamond | 333 | 43.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Eremomycetales | Eremomycetaceae | Eremomyces | Eremomyces bilateralis | |
| 30200343 | 30200343 | PRJNA293022_P_NODE_19152_length_326_cov_1.083032_g18415_i0 | PRJNA293022 | 19152 | 326 | 1.083032 | 3.53068432 | Pneumocystis carinii B8 | 4754 | Fungi | Fungi | 79.3 | 5.74e-15 | NR | XP_018226470.1 | 1408658 | g18415 | i0 | 41.4 | 4.0398773006135 | 87 | 51 | 80.1 | 0 | 262 | 2 | 73 | 159 | XP_018226470.1 hypothetical protein T552_01232 [Pneumocystis carinii B80] | diamond | 1317 | 79.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pneumocystomycetes | Pneumocystales | Pneumocystaceae | Pneumocystis | Pneumocystis carinii | |
| 30250017 | 30250017 | PRJNA293022_P_NODE_68972_length_168_cov_0.873950_g68235_i0 | PRJNA293022 | 68972 | 168 | 0.87395 | 1.468236 | Aspergillus | 5052 | Fungi | Fungi | 96.7 | 1.35e-21 | NR | TPR07377.1 | 5061 | g68235 | i0 | 80 | 8.75 | 55 | 11 | 98.2 | 0 | 166 | 2 | 101 | 155 | TPR07377.1 Glycosyl hydrolase 92 family protein [Aspergillus niger] | diamond | 1470 | 97.4 | 0.992813141683778 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus niger | |
| 30863987 | 30863987 | PRJNA293022_P_NODE_39474_length_222_cov_1.994220_g38737_i0 | PRJNA293022 | 39474 | 222 | 1.99422 | 4.4271684 | Sclerophora amabilis | 2939403 | Fungi | Fungi | 42.7 | 0.0286 | NR | KAI9846520.1 | 2939403 | g38737 | i0 | 38.1 | 0.851351351351351 | 63 | 32 | 75.7 | 2 | 209 | 42 | 228 | 290 | KAI9846520.1 MAG: hypothetical protein M1837_003941 [Sclerophora amabilis] | diamond | 189 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Coniocybomycetes | Coniocybales | Coniocybaceae | Sclerophora | Sclerophora amabilis | |
| 31179710 | 31179710 | PRJNA293022_P_NODE_76015_length_164_cov_0.904348_g75278_i0 | PRJNA293022 | 76015 | 164 | 0.904348 | 1.48313072 | Aspergillus sclerotialis | 2070753 | Fungi | Fungi | 107 | 1.7000000000000002e-27 | NR | RJE20856.1 | 2070753 | g75278 | i0 | 96.3 | 0.98780487804878 | 54 | 2 | 98.8 | 0 | 163 | 2 | 33 | 86 | RJE20856.1 hypothetical protein PHISCL_06803 [Aspergillus sclerotialis] | diamond | 162 | 107 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus sclerotialis | |
| 31274866 | 31274866 | PRJNA293022_P_NODE_79555_length_162_cov_0.920354_g78818_i0 | PRJNA293022 | 79555 | 162 | 0.920354 | 1.49097348 | Elaphomyces granulatus | 519963 | Fungi | Fungi | 43.1 | 0.00905 | NR | OXV06751.1 | 519963 | g78818 | i0 | 55.3 | 0.703703703703704 | 38 | 17 | 70.4 | 0 | 161 | 48 | 50 | 87 | OXV06751.1 hypothetical protein Egran_05482 [Elaphomyces granulatus] | diamond | 114 | 43.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Elaphomycetaceae | Elaphomyces | Elaphomyces granulatus | |
| 31450783 | 31450783 | PRJNA293022_P_NODE_68616_length_168_cov_1.563025_g67879_i0 | PRJNA293022 | 68616 | 168 | 1.563025 | 2.625882 | Glomerellales | 1028384 | Fungi | Fungi | 70.5 | 1.99e-12 | NR | KAG7133977.1 | 100787 | g67879 | i0 | 51.9 | 2.89285714285714 | 54 | 26 | 96.4 | 0 | 165 | 4 | 13 | 66 | KAG7133977.1 40S ribosomal protein S21 like [Verticillium longisporum] | diamond | 486 | 71.2 | 0.990168539325843 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Glomerellales | Plectosphaerellaceae | Verticillium | Verticillium longisporum | |
| 32494853 | 32494853 | PRJNA293022_P_NODE_62079_length_176_cov_1.732283_g61342_i0 | PRJNA293022 | 62079 | 176 | 1.732283 | 3.04881808 | Saccharomycetaceae | 4893 | Fungi | Fungi | 49.3 | 3.76e-5 | NR | XP_003678526.1 | 27288 | g61342 | i0 | 57.4 | 2.76136363636364 | 54 | 22 | 92 | 1 | 163 | 2 | 113 | 165 | XP_003678526.1 60S ribosomal protein eL6 [Naumovozyma castellii] | diamond | 486 | 49.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Naumovozyma | Naumovozyma castellii | |
| 32872776 | 32872776 | PRJNA293022_P_NODE_69600_length_168_cov_0.873950_g68863_i0 | PRJNA293022 | 69600 | 168 | 0.87395 | 1.468236 | Eukaryota | 2759 | Fungi | Fungi | 63.2 | 1.99e-10 | NR | KAI5809860.1 | 61495 | g68863 | i0 | 56.6 | 6.69642857142857 | 53 | 23 | 94.6 | 0 | 160 | 2 | 11 | 63 | KAI5809860.1 ribosomal protein S17-domain-containing protein [Peziza echinospora] | diamond | 1125 | 63.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pezizomycetes | Pezizales | Pezizaceae | Peziza | Peziza echinospora |
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);;