contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA532380" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26697637 | 26697637 | PRJNA532380_P_NODE_10781_length_281_cov_1.547414_g10456_i0 | PRJNA532380 | 10781 | 281 | 1.547414 | 4.34823334 | Patellaria atrata CBS 1 | 703506 | Fungi | Fungi | 65.9 | 4.37e-10 | NR | KAF2836456.1 | 1346257 | g10456 | i0 | 40 | 2.04982206405694 | 95 | 53 | 99.3 | 3 | 2 | 280 | 702 | 794 | KAF2836456.1 hypothetical protein M501DRAFT_939401 [Patellaria atrata CBS 101060] | diamond | 576 | 65.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Patellariales | Patellariaceae | Patellaria | Patellaria atrata | |
| 27140457 | 27140457 | PRJNA532380_P_NODE_19582_length_203_cov_1.681818_g19257_i0 | PRJNA532380 | 19582 | 203 | 1.681818 | 3.41409054 | Thermomyces lanuginosus | 5541 | Fungi | Fungi | 53.9 | 2.44e-6 | NR | XP_069267121.1 | 5541 | g19257 | i0 | 43.6 | 0.812807881773399 | 55 | 31 | 81.3 | 0 | 185 | 21 | 273 | 327 | XP_069267121.1 uncharacterized protein VTN49DRAFT_5202 [Thermomyces lanuginosus] | diamond | 165 | 53.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Trichocomaceae | Thermomyces | Thermomyces lanuginosus | |
| 27425463 | 27425463 | PRJNA532380_P_NODE_10903_length_279_cov_1.869565_g10578_i0 | PRJNA532380 | 10903 | 279 | 1.869565 | 5.21608635 | Dipodascopsis uninucleata | 27313 | Fungi | Fungi | 49.3 | 2.78e-4 | NR | KAK9453400.1 | 27313 | g10578 | i0 | 37.7 | 0.655913978494624 | 61 | 38 | 65.6 | 0 | 227 | 45 | 291 | 351 | KAK9453400.1 general substrate transporter [Dipodascopsis uninucleata] | diamond | 183 | 49.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lipomycetes | Lipomycetales | Lipomycetaceae | Dipodascopsis | Dipodascopsis uninucleata | |
| 28277544 | 28277544 | PRJNA532380_P_NODE_29886_length_166_cov_0.888889_g29561_i0 | PRJNA532380 | 29886 | 166 | 0.888889 | 1.47555574 | Hymenoscyphus albidus | 595503 | Fungi | Fungi | 42 | 0.0239 | NR | CAG8973437.1 | 595503 | g29561 | i0 | 37.5 | 0.867469879518072 | 48 | 30 | 86.7 | 0 | 150 | 7 | 22 | 69 | CAG8973437.1 hypothetical protein HYALB_00006463 [Hymenoscyphus albidus] | diamond | 144 | 42 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Leotiomycetes | Helotiales | Helotiaceae | Hymenoscyphus | Hymenoscyphus albidus | |
| 28482292 | 28482292 | PRJNA532380_P_NODE_22086_length_191_cov_1.161972_g21761_i0 | PRJNA532380 | 22086 | 191 | 1.161972 | 2.21936652 | Fungi | 4751 | Fungi | Fungi | 49.3 | 9.08e-5 | NR | XP_064717056.1 | 278026 | g21761 | i0 | 36.1 | 3.69109947643979 | 61 | 39 | 95.8 | 0 | 3 | 185 | 122 | 182 | XP_064717056.1 polyadenylate-binding protein [Arxiozyma heterogenica] | diamond | 705 | 49.7 | 0.991951710261569 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Arxiozyma | Arxiozyma heterogenica | |
| 29256306 | 29256306 | PRJNA532380_P_NODE_24829_length_179_cov_1.200000_g24504_i0 | PRJNA532380 | 24829 | 179 | 1.2 | 2.148 | Meristemomyces frigidus | 1508187 | Fungi | Fungi | 72.8 | 3.96e-13 | NR | KAK5127274.1 | 1508187 | g24504 | i0 | 64 | 1.81005586592179 | 50 | 18 | 83.8 | 0 | 178 | 29 | 240 | 289 | KAK5127274.1 hypothetical protein LTR08_004463 [Meristemomyces frigidus] | diamond | 324 | 72.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Meristemomyces | Meristemomyces frigidus | |
| 29603493 | 29603493 | PRJNA532380_P_NODE_26270_length_173_cov_1.258065_g25945_i0 | PRJNA532380 | 26270 | 173 | 1.258065 | 2.17645245 | Viridothelium virens | 1048519 | Fungi | Fungi | 42.4 | 0.0203 | NR | KAF2229703.1 | 1048519 | g25945 | i0 | 30.8 | 0.901734104046243 | 52 | 36 | 90.2 | 0 | 3 | 158 | 524 | 575 | KAF2229703.1 hypothetical protein EV356DRAFT_374176 [Viridothelium virens] | diamond | 156 | 42.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Trypetheliales | Trypetheliaceae | Viridothelium | Viridothelium virens | |
| 29729889 | 29729889 | PRJNA532380_P_NODE_18570_length_209_cov_1.300000_g18245_i0 | PRJNA532380 | 18570 | 209 | 1.3 | 2.717 | Dissoconium aciculare CBS 342.82 | 1314786 | Fungi | Fungi | 47 | 7.52e-4 | NR | XP_033460454.1 | 1314786 | g18245 | i0 | 37.5 | 0.688995215311005 | 48 | 30 | 68.9 | 0 | 204 | 61 | 401 | 448 | XP_033460454.1 thiamine diphosphate-binding protein [Dissoconium aciculare CBS 342.82] | diamond | 144 | 47 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Dissoconiaceae | Dissoconium | Dissoconium aciculare | |
| 30646076 | 30646076 | PRJNA532380_P_NODE_26213_length_173_cov_1.508065_g25888_i0 | PRJNA532380 | 26213 | 173 | 1.508065 | 2.60895245 | Lipomyces kononenkoae | 34357 | Fungi | Fungi | 57.4 | 6.84e-8 | NR | KAK9235501.1 | 34357 | g25888 | i0 | 60.5 | 0.745664739884393 | 43 | 17 | 74.6 | 0 | 155 | 27 | 4 | 46 | KAK9235501.1 hypothetical protein V1525DRAFT_409743 [Lipomyces kononenkoae] | diamond | 129 | 57.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lipomycetes | Lipomycetales | Lipomycetaceae | Lipomyces | Lipomyces kononenkoae | |
| 31483397 | 31483397 | PRJNA532380_P_NODE_17856_length_213_cov_1.268293_g17531_i0 | PRJNA532380 | 17856 | 213 | 1.268293 | 2.70146409 | Eukaryota | 2759 | Fungi | Fungi | 87.4 | 1.15e-20 | NR | XP_047761105.1 | 5499 | g17531 | i0 | 65.2 | 16.8591549295775 | 66 | 23 | 93 | 0 | 211 | 14 | 3 | 68 | XP_047761105.1 60S ribosomal protein L38 [Fulvia fulva] | diamond | 3591 | 87.8 | 0.995444191343964 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Fulvia | Fulvia fulva | |
| 31752630 | 31752630 | PRJNA532380_P_NODE_28717_length_168_cov_0.873950_g28392_i0 | PRJNA532380 | 28717 | 168 | 0.87395 | 1.468236 | Lophiotrema nucula | 690887 | Fungi | Fungi | 52.8 | 3.98e-6 | NR | KAF2107152.1 | 690887 | g28392 | i0 | 72.7 | 0.589285714285714 | 33 | 9 | 58.9 | 0 | 70 | 168 | 223 | 255 | KAF2107152.1 hypothetical protein BDV96DRAFT_306056 [Lophiotrema nucula] | diamond | 99 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Lophiotremataceae | Lophiotrema | Lophiotrema nucula | |
| 32827242 | 32827242 | PRJNA532380_P_NODE_29320_length_167_cov_0.881356_g28995_i0 | PRJNA532380 | 29320 | 167 | 0.881356 | 1.47186452 | Geotrichum galactomycetum | 27317 | Fungi | Fungi | 61.2 | 3.92e-9 | NR | KAF5102898.1 | 27317 | g28995 | i0 | 52.7 | 0.988023952095808 | 55 | 25 | 98.8 | 1 | 2 | 166 | 77 | 130 | KAF5102898.1 hypothetical protein D0Z00_000156 [Geotrichum galactomycetum] | diamond | 165 | 61.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Dipodascaceae | Geotrichum | Geotrichum galactomycetum |
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);;