contig_metadata
27 rows where analysis = "diamond", bioproject = "PRJNA719595" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20319808 | 20319808 | PRJNA719595_P_NODE_8476_length_246_cov_0.901734_g8441_i0 | PRJNA719595 | 8476 | 246 | 0.901734 | 2.21826564 | Agaricomycetes | 155619 | Fungi | Fungi | 161 | 8.99e-44 | NR | KAH8120070.1 | 127956 | g8441 | i0 | 94.9 | 19.9878048780488 | 78 | 4 | 95.1 | 0 | 246 | 13 | 953 | 1030 | KAH8120070.1 P-loop containing nucleoside triphosphate hydrolase protein [Phellopilus nigrolimitatus] | diamond | 4917 | 162 | 0.993827160493827 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Hymenochaetales | Hymenochaetaceae | Phellopilus | Phellopilus nigrolimitatus | |
| 24936015 | 24936015 | PRJNA719595_P_NODE_6820_length_252_cov_0.871508_g6785_i0 | PRJNA719595 | 6820 | 252 | 0.871508 | 2.19620016 | Diptera | 7147 | Arthropoda | Arthropoda | 126 | 3.99e-32 | NR | XP_004518446.1 | 7213 | g6785 | i0 | 74.4 | 47.3571428571429 | 78 | 20 | 92.9 | 0 | 238 | 5 | 159 | 236 | XP_004518446.1 vacuolar protein sorting-associated protein 26B-like [Ceratitis capitata] | diamond | 11934 | 126 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Tephritidae | Ceratitis | Ceratitis capitata | |
| 24936064 | 24936064 | PRJNA719595_P_NODE_8860_length_244_cov_0.912281_g8825_i0 | PRJNA719595 | 8860 | 244 | 0.912281 | 2.22596564 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 122 | 3.1599999999999997e-32 | NR | KAK0051780.1 | 112525 | g8825 | i0 | 77.5 | 31.5 | 80 | 18 | 98.4 | 0 | 5 | 244 | 162 | 241 | KAK0051780.1 40S ribosomal protein S2 [Biomphalaria pfeifferi] | diamond | 7686 | 123 | 0.991869918699187 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria pfeifferi | ||
| 26650759 | 26650759 | PRJNA719595_P_NODE_8861_length_244_cov_0.912281_g8826_i0 | PRJNA719595 | 8861 | 244 | 0.912281 | 2.22596564 | Ascomycota | 4890 | Fungi | Fungi | 107 | 5.84e-25 | NR | XP_020069790.1 | 983966 | g8826 | i0 | 65.4 | 4.97950819672131 | 81 | 27 | 98.4 | 1 | 242 | 3 | 234 | 314 | XP_020069790.1 uncharacterized protein CYBJADRAFT_128708 [Cyberlindnera jadinii NRRL Y-1542] | diamond | 1215 | 107 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Phaffomycetales | Phaffomycetaceae | Cyberlindnera | Cyberlindnera jadinii | |
| 26650760 | 26650760 | PRJNA719595_P_NODE_9101_length_243_cov_0.917647_g9066_i0 | PRJNA719595 | 9101 | 243 | 0.917647 | 2.22988221 | Trombidiformes | 83136 | Arthropoda | Arthropoda | 107 | 6.77e-26 | NR | RWS23265.1 | 299467 | g9066 | i0 | 58.8 | 6.91358024691358 | 80 | 33 | 98.8 | 0 | 3 | 242 | 67 | 146 | RWS23265.1 peptide chain release factor 1-like: mitochondrial isoform X2 [Leptotrombidium deliense] | diamond | 1680 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Trombidiformes | Trombiculidae | Leptotrombidium | Leptotrombidium deliense | |
| 26777815 | 26777815 | PRJNA719595_P_NODE_9421_length_242_cov_0.923077_g9386_i0 | PRJNA719595 | 9421 | 242 | 0.923077 | 2.23384634 | Polyporales | 5303 | Fungi | Fungi | 80.1 | 2.64e-16 | NR | XP_047892774.1 | 139415 | g9386 | i0 | 51.3 | 3.96694214876033 | 80 | 38 | 99.2 | 1 | 240 | 1 | 101 | 179 | XP_047892774.1 40S ribosomal protein S8 [Fomitopsis serialis] | diamond | 960 | 80.9 | 0.990111248454882 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Fomitopsidaceae | Fomitopsis | Fomitopsis serialis | |
| 26798812 | 26798812 | PRJNA719595_P_NODE_8341_length_246_cov_0.901734_g8306_i0 | PRJNA719595 | 8341 | 246 | 0.901734 | 2.21826564 | Aphelenchoides fujianensis | 1052528 | Nematoda | Nematoda | 52 | 2.16e-5 | NR | KAI6219037.1 | 1052528 | g8306 | i0 | 34.1 | 1 | 82 | 52 | 100 | 2 | 1 | 246 | 323 | 402 | KAI6219037.1 Plus3 domain-containing protein [Aphelenchoides fujianensis] | diamond | 246 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides fujianensis | |
| 27020402 | 27020402 | PRJNA719595_P_NODE_4762_length_292_cov_1.068493_g4727_i0 | PRJNA719595 | 4762 | 292 | 1.068493 | 3.11999956 | Ranitomeya imitator | 111125 | Chordata | Chordata | 70.1 | 1.45e-11 | NR | CAJ0964204.1 | 111125 | g4727 | i0 | 73 | 1.15068493150685 | 37 | 10 | 38 | 0 | 150 | 40 | 15 | 51 | CAJ0964204.1 unnamed protein product [Ranitomeya imitator] | diamond | 336 | 70.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Dendrobatidae | Ranitomeya | Ranitomeya imitator | |
| 27241617 | 27241617 | PRJNA719595_P_NODE_8523_length_246_cov_0.901734_g8488_i0 | PRJNA719595 | 8523 | 246 | 0.901734 | 2.21826564 | Phycomyces blakesleeanus | 4837 | Fungi | Fungi | 52 | 2.08e-5 | NR | KAL0093496.1 | 4837 | g8488 | i0 | 38.4 | 4.35365853658537 | 73 | 42 | 85.4 | 2 | 36 | 245 | 389 | 461 | KAL0093496.1 hypothetical protein F4703DRAFT_1730878, partial [Phycomyces blakesleeanus] | diamond | 1071 | 52 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Phycomycetaceae | Phycomyces | Phycomyces blakesleeanus | |
| 27305012 | 27305012 | PRJNA719595_P_NODE_3523_length_334_cov_0.896552_g3488_i0 | PRJNA719595 | 3523 | 334 | 0.896552 | 2.99448368 | Fennellomyces sp. T- | 1329386 | Fungi | Fungi | 48.9 | 6.2e-4 | NR | KAI8137181.1 | 1329386 | g3488 | i0 | 58.5 | 0.368263473053892 | 41 | 16 | 36.8 | 1 | 7 | 129 | 217 | 256 | KAI8137181.1 NRDE protein-domain-containing protein [Fennellomyces sp. T-0311] | diamond | 123 | 48.9 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Lichtheimiaceae | Fennellomyces | Fennellomyces sp. T-0311 | |
| 28031265 | 28031265 | PRJNA719595_P_NODE_8445_length_246_cov_0.901734_g8410_i0 | PRJNA719595 | 8445 | 246 | 0.901734 | 2.21826564 | Sugiyamaella lignohabitans | 796027 | Fungi | Fungi | 51.6 | 1.75e-5 | NR | XP_018738447.1 | 796027 | g8410 | i0 | 35.4 | 0.963414634146341 | 79 | 49 | 95.1 | 2 | 244 | 11 | 122 | 199 | XP_018738447.1 Aim41p [Sugiyamaella lignohabitans] | diamond | 237 | 51.6 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Trichomonascaceae | Sugiyamaella | Sugiyamaella lignohabitans | |
| 28252105 | 28252105 | PRJNA719595_P_NODE_6486_length_253_cov_0.866667_g6451_i0 | PRJNA719595 | 6486 | 253 | 0.866667 | 2.19266751 | Torulaspora globosa | 48254 | Fungi | Fungi | 87.4 | 9.67e-19 | NR | YP_009155514.1 | 48254 | g6451 | i0 | 63.1 | 0.770750988142292 | 65 | 24 | 77.1 | 0 | 56 | 250 | 1 | 65 | YP_009155514.1 cytochrome c oxidase subunit 2 [Torulaspora globosa] | diamond | 195 | 87.4 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Torulaspora | Torulaspora globosa | |
| 28346895 | 28346895 | PRJNA719595_P_NODE_8126_length_247_cov_0.896552_g8091_i0 | PRJNA719595 | 8126 | 247 | 0.896552 | 2.21448344 | Ylistrum balloti | 509963 | Mollusca | Mollusca | 42.4 | 0.0333 | NR | XP_060069831.1 | 509963 | g8091 | i0 | 51.3 | 0.473684210526316 | 39 | 19 | 47.4 | 0 | 203 | 87 | 56 | 94 | XP_060069831.1 neo-calmodulin-like [Ylistrum balloti] | diamond | 117 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Ylistrum | Ylistrum balloti | |
| 28473323 | 28473323 | PRJNA719595_P_NODE_6186_length_257_cov_1.597826_g6151_i0 | PRJNA719595 | 6186 | 257 | 1.597826 | 4.10641282 | Spodoptera frugiperda | 7108 | Arthropoda | Arthropoda | 43.1 | 0.0124 | NR | KAF9791410.1 | 7108 | g6151 | i0 | 62.2 | 1.93774319066148 | 37 | 11 | 39.7 | 1 | 115 | 14 | 52 | 88 | KAF9791410.1 hypothetical protein SFRURICE_015995 [Spodoptera frugiperda] | diamond | 498 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Noctuidae | Spodoptera | Spodoptera frugiperda | |
| 28473325 | 28473325 | PRJNA719595_P_NODE_7566_length_249_cov_0.886364_g7531_i0 | PRJNA719595 | 7566 | 249 | 0.886364 | 2.20704636 | Sphaerosporella brunnea | 1250544 | Fungi | Fungi | 64.3 | 1.04e-9 | NR | KAA8912777.1 | 1250544 | g7531 | i0 | 44.8 | 2.4578313253012 | 58 | 32 | 69.9 | 0 | 13 | 186 | 75 | 132 | KAA8912777.1 fungal transcriptional regulatory protein [Sphaerosporella brunnea] | diamond | 612 | 64.3 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pezizomycetes | Pezizales | Pyronemataceae | Sphaerosporella | Sphaerosporella brunnea | |
| 28957533 | 28957533 | PRJNA719595_P_NODE_8708_length_245_cov_0.906977_g8673_i0 | PRJNA719595 | 8708 | 245 | 0.906977 | 2.22209365 | Metazoa | 33208 | Arthropoda | Arthropoda | 102 | 4.789999999999999e-23 | NR | KAL3217357.1 | 6941 | g8673 | i0 | 67.6 | 6.12244897959184 | 71 | 23 | 86.9 | 0 | 225 | 13 | 128 | 198 | KAL3217357.1 hypothetical protein MRX96_032478 [Rhipicephalus microplus] | diamond | 1500 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Ixodida | Ixodidae | Rhipicephalus | Rhipicephalus microplus | |
| 29367856 | 29367856 | PRJNA719595_P_NODE_6029_length_260_cov_1.657754_g5994_i0 | PRJNA719595 | 6029 | 260 | 1.657754 | 4.3101604 | Insecta | 50557 | Arthropoda | Arthropoda | 113 | 2.26e-29 | NR | CAK9830547.1 | 597843 | g5994 | i0 | 72.3 | 1.92692307692308 | 83 | 22 | 95.8 | 1 | 8 | 256 | 1 | 82 | CAK9830547.1 60S ribosomal protein L17 [Anthophora retusa] | diamond | 501 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hymenoptera | Apidae | Anthophora | Anthophora retusa | |
| 29389008 | 29389008 | PRJNA719595_P_NODE_7369_length_250_cov_0.881356_g7334_i0 | PRJNA719595 | 7369 | 250 | 0.881356 | 2.20339 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 172 | 1.13e-49 | NR | XP_069228240.1 | 1052096 | g7334 | i0 | 94 | 0.996 | 83 | 5 | 99.6 | 0 | 250 | 2 | 352 | 434 | XP_069228240.1 uncharacterized protein WHR41_06539 [Cladosporium halotolerans] | diamond | 249 | 172 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 29462175 | 29462175 | PRJNA719595_P_NODE_7910_length_248_cov_0.891429_g7875_i0 | PRJNA719595 | 7910 | 248 | 0.891429 | 2.21074392 | Calliphoridae | 7371 | Arthropoda | Arthropoda | 58.9 | 7.84e-8 | NR | XP_065369578.1 | 7373 | g7875 | i0 | 48 | 2.41935483870968 | 50 | 26 | 60.5 | 0 | 150 | 1 | 159 | 208 | XP_065369578.1 protein 5NUC isoform X1 [Calliphora vicina] | diamond | 600 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Calliphoridae | Calliphora | Calliphora vicina | |
| 29809679 | 29809679 | PRJNA719595_P_NODE_7651_length_249_cov_0.886364_g7616_i0 | PRJNA719595 | 7651 | 249 | 0.886364 | 2.20704636 | root | 1 | Root_unresolved | Root_unresolved | 47.4 | 6.88e-4 | NR | XP_024665956.1 | 45607 | g7616 | i0 | 38.2 | 1.98795180722892 | 68 | 36 | 80.7 | 2 | 207 | 7 | 120 | 182 | XP_024665956.1 JmjC domain-containing protein 7 [Wickerhamiella sorbophila] | diamond | 495 | 47.8 | 0.99163179916318 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Trichomonascaceae | Wickerhamiella | Wickerhamiella sorbophila | |
| 30209780 | 30209780 | PRJNA719595_P_NODE_6532_length_253_cov_0.866667_g6497_i0 | PRJNA719595 | 6532 | 253 | 0.866667 | 2.19266751 | Batrachochytrium salamandrivorans | 1357716 | Fungi | Fungi | 106 | 6.99e-27 | NR | KAH6566911.1 | 1357716 | g6497 | i0 | 59 | 3.90118577075099 | 83 | 34 | 98.4 | 0 | 249 | 1 | 34 | 116 | KAH6566911.1 hypothetical protein BASA62_006437 [Batrachochytrium salamandrivorans] | diamond | 987 | 106 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium salamandrivorans | ||
| 30620667 | 30620667 | PRJNA719595_P_NODE_7273_length_250_cov_0.881356_g7238_i0 | PRJNA719595 | 7273 | 250 | 0.881356 | 2.20339 | Fragariocoptes setiger | 1670756 | Arthropoda | Arthropoda | 64.7 | 1.03e-10 | NR | KAG9510839.1 | 1670756 | g7238 | i0 | 76.5 | 0.408 | 34 | 8 | 40.8 | 0 | 242 | 141 | 129 | 162 | KAG9510839.1 Coiled-coil-helix-coiled-coil-helix domain-containing protein 2, partial [Fragariocoptes setiger] | diamond | 102 | 64.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Trombidiformes | Phytoptidae | Fragariocoptes | Fragariocoptes setiger | |
| 30936854 | 30936854 | PRJNA719595_P_NODE_7534_length_249_cov_0.886364_g7499_i0 | PRJNA719595 | 7534 | 249 | 0.886364 | 2.20704636 | Monosiga brevicollis MX1 | 431895 | Root_unresolved | Root_unresolved | 117 | 5.88e-29 | NR | XP_001749101.1 | 431895 | g7499 | i0 | 59.8 | 2.96385542168675 | 82 | 33 | 98.8 | 0 | 3 | 248 | 324 | 405 | XP_001749101.1 uncharacterized protein MONBRDRAFT_33947 [Monosiga brevicollis MX1] | diamond | 738 | 117 | 1 | Eukaryota | Opisthokonta | Choanoflagellata | Craspedida | Salpingoecidae | Monosiga | Monosiga brevicollis | |||
| 30999980 | 30999980 | PRJNA719595_P_NODE_8454_length_246_cov_0.901734_g8419_i0 | PRJNA719595 | 8454 | 246 | 0.901734 | 2.21826564 | Bombyx mori | 7091 | Arthropoda | Arthropoda | 45.1 | 0.00566 | NR | XP_004926831.3 | 7091 | g8419 | i0 | 75 | 0.292682926829268 | 24 | 6 | 29.3 | 0 | 148 | 77 | 105 | 128 | XP_004926831.3 putative uncharacterized transposon-derived protein F52C9.6 [Bombyx mori] | diamond | 72 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Bombycidae | Bombyx | Bombyx mori | |
| 31769195 | 31769195 | PRJNA719595_P_NODE_6837_length_252_cov_0.871508_g6802_i0 | PRJNA719595 | 6837 | 252 | 0.871508 | 2.19620016 | root | 1 | Root_unresolved | Root_unresolved | 49.3 | 2.08e-4 | NR | XP_022100316.1 | 133434 | g6802 | i0 | 35.8 | 3.20238095238095 | 81 | 32 | 95.2 | 2 | 8 | 247 | 723 | 784 | XP_022100316.1 uncharacterized protein LOC110984425 [Acanthaster planci] | diamond | 807 | 49.7 | 0.991951710261569 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 32075172 | 32075172 | PRJNA719595_P_NODE_8118_length_247_cov_0.896552_g8083_i0 | PRJNA719595 | 8118 | 247 | 0.896552 | 2.21448344 | Basidiobolus ranarum | 34480 | Fungi | Fungi | 70.1 | 6.29e-13 | NR | KAK9696832.1 | 34480 | g8083 | i0 | 73.5 | 0.595141700404858 | 49 | 13 | 59.5 | 0 | 3 | 149 | 103 | 151 | KAK9696832.1 60S ribosomal protein L11, partial [Basidiobolus ranarum] | diamond | 147 | 70.1 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Basidiobolomycetes | Basidiobolales | Basidiobolaceae | Basidiobolus | Basidiobolus ranarum | |
| 32360223 | 32360223 | PRJNA719595_P_NODE_8619_length_245_cov_0.906977_g8584_i0 | PRJNA719595 | 8619 | 245 | 0.906977 | 2.22209365 | Caenorhabditis brenneri | 135651 | Nematoda | Nematoda | 64.3 | 2.7e-10 | NR | EGT34389.1 | 135651 | g8584 | i0 | 51.9 | 4.44489795918367 | 54 | 26 | 66.1 | 0 | 1 | 162 | 122 | 175 | EGT34389.1 hypothetical protein CAEBREN_23279 [Caenorhabditis brenneri] | diamond | 1089 | 64.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis brenneri |
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);;