contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJNA1215774" and tax_clade = "Opisthokonta"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5434734 | 5434734 | PRJNA1215774_P_NODE_74885_length_247_cov_0.885057_g74565_i0 | PRJNA1215774 | 74885 | 247 | 0.885057 | 2.18609079 | Vermiconidia calcicola | 1690605 | Fungi | Fungi | 141 | 2.99e-39 | NR | KAK3714659.1 | 1690605 | g74565 | i0 | 81.5 | 0.983805668016194 | 81 | 15 | 98.4 | 0 | 245 | 3 | 168 | 248 | KAK3714659.1 hypothetical protein LTR37_007639 [Vermiconidia calcicola] | diamond | 243 | 141 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Extremaceae | Vermiconidia | Vermiconidia calcicola | |
| 13085191 | 13085191 | PRJNA1215774_P_NODE_78051_length_245_cov_0.895349_g77731_i0 | PRJNA1215774 | 78051 | 245 | 0.895349 | 2.19360505 | Cyphobasidiales sp. Tagirdzhanova- | 2801448 | Fungi | Fungi | 167 | 3.5499999999999996e-47 | NR | CAD6589179.1 | 2778381 | g77731 | i0 | 97.5 | 2.97551020408163 | 81 | 2 | 99.2 | 0 | 1 | 243 | 233 | 313 | CAD6589179.1 MAG: NADH dehydrogenase [ubiquinone] flavoprotein 1, mitochondrial [Cyphobasidiales sp. Tagirdzhanova-0007] | diamond | 729 | 167 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cyphobasidiales | Cyphobasidiales sp. Tagirdzhanova-0007 | |||
| 19457631 | 19457631 | PRJNA1215774_P_NODE_81216_length_243_cov_0.905882_g80896_i0 | PRJNA1215774 | 81216 | 243 | 0.905882 | 2.20129326 | Pseudocercospora musae | 113226 | Fungi | Fungi | 121 | 1.11e-32 | NR | KXT17177.1 | 113226 | g80896 | i0 | 70.7 | 1.01234567901235 | 82 | 23 | 100 | 1 | 1 | 243 | 69 | 150 | KXT17177.1 hypothetical protein AC579_331 [Pseudocercospora musae] | diamond | 246 | 121 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Pseudocercospora | Pseudocercospora musae | |
| 20733071 | 20733071 | PRJNA1215774_P_NODE_84097_length_241_cov_0.916667_g83777_i0 | PRJNA1215774 | 84097 | 241 | 0.916667 | 2.20916747 | Dothideomycetes | 147541 | Fungi | Fungi | 140 | 1.84e-36 | NR | KAF1353193.1 | 147560 | g83777 | i0 | 88.8 | 6.95850622406639 | 80 | 9 | 99.6 | 0 | 2 | 241 | 352 | 431 | KAF1353193.1 hypothetical protein BDV97DRAFT_290659 [Delphinella strobiligena] | diamond | 1677 | 140 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Dothioraceae | Delphinella | Delphinella strobiligena | |
| 23283641 | 23283641 | PRJNA1215774_P_NODE_72259_length_249_cov_0.875000_g71939_i0 | PRJNA1215774 | 72259 | 249 | 0.875 | 2.17875 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 56.2 | 5.61e-8 | NR | XP_069228720.1 | 1052096 | g71939 | i0 | 84.8 | 0.397590361445783 | 33 | 5 | 39.8 | 0 | 4 | 102 | 68 | 100 | XP_069228720.1 uncharacterized protein WHR41_05990 [Cladosporium halotolerans] | diamond | 99 | 56.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 26660875 | 26660875 | PRJNA1215774_P_NODE_71781_length_249_cov_0.875000_g71461_i0 | PRJNA1215774 | 71781 | 249 | 0.875 | 2.17875 | Rhizoctonia solani AG-1 IA | 983506 | Fungi | Fungi | 40 | 0.0449 | NR | ELU38413.1 | 983506 | g71461 | i0 | 38.2 | 0.662650602409639 | 55 | 32 | 63.9 | 1 | 36 | 194 | 4 | 58 | ELU38413.1 hypothetical protein AG1IA_07557 [Rhizoctonia solani AG-1 IA] | diamond | 165 | 40 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Ceratobasidiaceae | Rhizoctonia | Rhizoctonia solani | |
| 26946025 | 26946025 | PRJNA1215774_P_NODE_58182_length_275_cov_2.059406_g57862_i0 | PRJNA1215774 | 58182 | 275 | 2.059406 | 5.6633665 | Staurois parvus | 386267 | Chordata | Chordata | 53.1 | 1.63e-6 | NR | CAI9557087.1 | 386267 | g57862 | i0 | 65.7 | 0.763636363636364 | 35 | 10 | 36 | 1 | 144 | 242 | 24 | 58 | CAI9557087.1 unnamed protein product, partial [Staurois parvus] | diamond | 210 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 27072651 | 27072651 | PRJNA1215774_P_NODE_53042_length_289_cov_1.425926_g52722_i0 | PRJNA1215774 | 53042 | 289 | 1.425926 | 4.12092614 | Extremus antarcticus | 702011 | Fungi | Fungi | 155 | 4.56e-45 | NR | KAK3051725.1 | 702011 | g52722 | i0 | 79.2 | 1.99307958477509 | 96 | 20 | 99.7 | 0 | 288 | 1 | 77 | 172 | KAK3051725.1 Peroxisomal membrane protein PMP27 [Extremus antarcticus] | diamond | 576 | 155 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Extremaceae | Extremus | Extremus antarcticus | |
| 27198876 | 27198876 | PRJNA1215774_P_NODE_83302_length_242_cov_0.911243_g82982_i0 | PRJNA1215774 | 83302 | 242 | 0.911243 | 2.20520806 | Pseudozyma flocculosa PF-1 | 1277687 | Fungi | Fungi | 71.6 | 2.4e-12 | NR | XP_007880128.1 | 1277687 | g82982 | i0 | 67.1 | 0.979338842975207 | 79 | 20 | 90.5 | 2 | 242 | 24 | 479 | 557 | XP_007880128.1 uncharacterized protein PFL1_04412 [Pseudozyma flocculosa PF-1] | diamond | 237 | 71.6 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Pseudozyma | Pseudozyma flocculosa | |
| 27293920 | 27293920 | PRJNA1215774_P_NODE_56823_length_279_cov_1.179612_g56503_i0 | PRJNA1215774 | 56823 | 279 | 1.179612 | 3.29111748 | Polypterus senegalus | 55291 | Chordata | Chordata | 67.4 | 9.44e-11 | NR | KAG2460242.1 | 55291 | g56503 | i0 | 54.4 | 7.3010752688172 | 68 | 31 | 73.1 | 0 | 265 | 62 | 178 | 245 | KAG2460242.1 TCB1 transposase, partial [Polypterus senegalus] | diamond | 2037 | 67.8 | 0.994100294985251 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 27818223 | 27818223 | PRJNA1215774_P_NODE_76784_length_246_cov_0.890173_g76464_i0 | PRJNA1215774 | 76784 | 246 | 0.890173 | 2.18982558 | Metazoa | 33208 | Arthropoda | Arthropoda | 45.1 | 0.00556 | NR | GBM92731.1 | 182803 | g76464 | i0 | 40.7 | 7.6219512195122 | 59 | 34 | 72 | 1 | 62 | 238 | 58 | 115 | GBM92731.1 Putative uncharacterized transposon-derived protein F54H12.3 [Araneus ventricosus] | diamond | 1875 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Araneae | Araneidae | Araneus | Araneus ventricosus | |
| 28272643 | 28272643 | PRJNA1215774_P_NODE_77766_length_245_cov_0.895349_g77446_i0 | PRJNA1215774 | 77766 | 245 | 0.895349 | 2.19360505 | Chelonus insularis | 460826 | Arthropoda | Arthropoda | 61.2 | 1.16e-8 | NR | XP_034949608.1 | 460826 | g77446 | i0 | 47.7 | 0.795918367346939 | 65 | 34 | 79.6 | 0 | 49 | 243 | 295 | 359 | XP_034949608.1 ankyrin-1-like [Chelonus insularis] | diamond | 195 | 61.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hymenoptera | Braconidae | Chelonus | Chelonus insularis | |
| 28765126 | 28765126 | PRJNA1215774_P_NODE_73827_length_248_cov_0.880000_g73507_i0 | PRJNA1215774 | 73827 | 248 | 0.88 | 2.1824 | Sordariomycetes | 147550 | Fungi | Fungi | 87.8 | 4.71e-18 | NR | KAH7131341.1 | 307937 | g73507 | i0 | 75 | 2.93951612903226 | 56 | 14 | 67.7 | 0 | 248 | 81 | 2 | 57 | KAH7131341.1 hypothetical protein EDB81DRAFT_808390 [Dactylonectria macrodidyma] | diamond | 729 | 87.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Nectriaceae | Dactylonectria | Dactylonectria macrodidyma | |
| 30104177 | 30104177 | PRJNA1215774_P_NODE_77712_length_245_cov_0.895349_g77392_i0 | PRJNA1215774 | 77712 | 245 | 0.895349 | 2.19360505 | Extremus antarcticus | 702011 | Fungi | Fungi | 79.3 | 1.06e-15 | NR | KAK3051989.1 | 702011 | g77392 | i0 | 83.7 | 1.01632653061224 | 43 | 7 | 52.7 | 0 | 130 | 2 | 1 | 43 | KAK3051989.1 p23 chaperone protein wos2 [Extremus antarcticus] | diamond | 249 | 79.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Extremaceae | Extremus | Extremus antarcticus | |
| 30407755 | 30407755 | PRJNA1215774_P_NODE_59893_length_271_cov_1.555556_g59573_i0 | PRJNA1215774 | 59893 | 271 | 1.555556 | 4.21555676 | Recurvomyces | 701936 | Fungi | Fungi | 47.4 | 0.00115 | NR | XP_064697173.1 | 574656 | g59573 | i0 | 63.3 | 1.61623616236162 | 30 | 11 | 33.2 | 0 | 140 | 51 | 219 | 248 | XP_064697173.1 uncharacterized protein LTS14_002532 [Recurvomyces mirabilis] | diamond | 438 | 47.8 | 0.99163179916318 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Recurvomyces | Recurvomyces mirabilis | |
| 30736123 | 30736123 | PRJNA1215774_P_NODE_70734_length_250_cov_0.870056_g70414_i0 | PRJNA1215774 | 70734 | 250 | 0.870056 | 2.17514 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 53.1 | 8.32e-6 | NR | CAF1004559.1 | 104777 | g70414 | i0 | 44.7 | 0.564 | 47 | 26 | 56.4 | 0 | 18 | 158 | 434 | 480 | CAF1004559.1 unnamed protein product [Brachionus calyciflorus] | diamond | 141 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 31494934 | 31494934 | PRJNA1215774_P_NODE_74676_length_247_cov_0.885057_g74356_i0 | PRJNA1215774 | 74676 | 247 | 0.885057 | 2.18609079 | Histoplasma ohiense (nom. inval.) | 2902605 | Fungi | Fungi | 41.2 | 0.0366 | NR | KAG5301112.1 | 2902605 | g74356 | i0 | 33.3 | 0.801619433198381 | 66 | 42 | 77.7 | 2 | 15 | 206 | 25 | 90 | KAG5301112.1 hypothetical protein I7I48_01013 [Histoplasma ohiense (nom. inval.)] | diamond | 198 | 41.2 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Onygenales | Ajellomycetaceae | Histoplasma | Histoplasma ohiense (nom. inval.) | |
| 31526540 | 31526540 | PRJNA1215774_P_NODE_78296_length_245_cov_0.895349_g77976_i0 | PRJNA1215774 | 78296 | 245 | 0.895349 | 2.19360505 | Lepidopterella palustris CBS 459.81 | 1314670 | Fungi | Fungi | 49.7 | 9.89e-6 | NR | OCK72762.1 | 1314670 | g77976 | i0 | 60.5 | 0.52653061224489806 | 43 | 17 | 52.7 | 0 | 180 | 52 | 2 | 44 | OCK72762.1 hypothetical protein K432DRAFT_315083, partial [Lepidopterella palustris CBS 459.81] | diamond | 129 | 49.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mytilinidiales | Argynnaceae | Lepidopterella | Lepidopterella palustris | |
| 31811112 | 31811112 | PRJNA1215774_P_NODE_65137_length_258_cov_1.664865_g64817_i0 | PRJNA1215774 | 65137 | 258 | 1.664865 | 4.2953517 | Termitomyces sp. T112 | 1850345 | Fungi | Fungi | 55.1 | 1.8e-6 | NR | KAG5720399.1 | 1850345 | g64817 | i0 | 80 | 0.348837209302326 | 30 | 6 | 34.9 | 0 | 2 | 91 | 294 | 323 | KAG5720399.1 hypothetical protein E4T56_gene7366 [Termitomyces sp. T112] | diamond | 90 | 55.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Lyophyllaceae | Termitomyces | Termitomyces sp. T112 | |
| 31842552 | 31842552 | PRJNA1215774_P_NODE_54937_length_284_cov_1.255924_g54617_i0 | PRJNA1215774 | 54937 | 284 | 1.255924 | 3.56682416 | Engystomops pustulosus | 76066 | Chordata | Chordata | 80.1 | 4.55e-15 | NR | KAG8571490.1 | 76066 | g54617 | i0 | 54.3 | 12.9084507042254 | 94 | 43 | 99.3 | 0 | 2 | 283 | 1011 | 1104 | KAG8571490.1 hypothetical protein GDO81_011667 [Engystomops pustulosus] | diamond | 3666 | 80.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Leptodactylidae | Engystomops | Engystomops pustulosus | |
| 31861366 | 31861366 | PRJNA1215774_P_NODE_84597_length_241_cov_0.916667_g84277_i0 | PRJNA1215774 | 84597 | 241 | 0.916667 | 2.20916747 | Aspergillus | 5052 | Fungi | Fungi | 137 | 2.36e-37 | NR | XP_043134603.1 | 182096 | g84277 | i0 | 84.6 | 2.91286307053942 | 78 | 12 | 97.1 | 0 | 240 | 7 | 255 | 332 | XP_043134603.1 uncharacterized protein ACHE_30068A [Aspergillus chevalieri] | diamond | 702 | 137 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus chevalieri | |
| 32064101 | 32064101 | PRJNA1215774_P_NODE_61898_length_266_cov_1.595855_g61578_i0 | PRJNA1215774 | 61898 | 266 | 1.595855 | 4.2449743 | Lecanosticta acicola | 111012 | Fungi | Fungi | 63.9 | 1.54e-9 | NR | CAK3734120.1 | 111012 | g61578 | i0 | 52.3 | 2.41353383458647 | 65 | 29 | 73.3 | 2 | 195 | 1 | 191 | 253 | CAK3734120.1 unnamed protein product [Lecanosticta acicola] | diamond | 642 | 63.9 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Mycosphaerellaceae | Lecanosticta | Lecanosticta acicola | |
| 32064102 | 32064102 | PRJNA1215774_P_NODE_64058_length_261_cov_1.250000_g63738_i0 | PRJNA1215774 | 64058 | 261 | 1.25 | 3.2625 | Cladophialophora immunda | 569365 | Fungi | Fungi | 45.8 | 0.00365 | NR | OQU98288.1 | 569365 | g63738 | i0 | 34.9 | 1.44827586206897 | 63 | 35 | 70.1 | 2 | 72 | 254 | 109 | 167 | OQU98288.1 hypothetical protein CLAIMM_04094 isoform 1 [Cladophialophora immunda] | diamond | 378 | 45.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Herpotrichiellaceae | Cladophialophora | Cladophialophora immunda | |
| 32444174 | 32444174 | PRJNA1215774_P_NODE_84919_length_241_cov_0.916667_g84599_i0 | PRJNA1215774 | 84919 | 241 | 0.916667 | 2.20916747 | Cyphobasidiales sp. Tagirdzhanova- | 2801448 | Fungi | Fungi | 102 | 3.1e-23 | NR | CAD6579666.1 | 2778381 | g84599 | i0 | 51.9 | 0.983402489626556 | 79 | 38 | 98.3 | 0 | 3 | 239 | 354 | 432 | CAD6579666.1 MAG: hypothetical protein CYPHOPRED_000977 [Cyphobasidiales sp. Tagirdzhanova-0007] | diamond | 237 | 102 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Cystobasidiomycetes | Cyphobasidiales | Cyphobasidiales sp. Tagirdzhanova-0007 | |||
| 32507427 | 32507427 | PRJNA1215774_P_NODE_80039_length_244_cov_0.900585_g79719_i0 | PRJNA1215774 | 80039 | 244 | 0.900585 | 2.1974274 | Polypterus senegalus | 55291 | Chordata | Chordata | 82 | 3.06e-16 | NR | KAG2456550.1 | 55291 | g79719 | i0 | 72.9 | 9.24590163934426 | 48 | 13 | 59 | 0 | 243 | 100 | 280 | 327 | KAG2456550.1 TCB1 transposase, partial [Polypterus senegalus] | diamond | 2256 | 82 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus |
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);;