contig_metadata
27 rows where analysis = "diamond", bioproject = "PRJNA1031674" and tax_kingdom = "Metazoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2717241 | 2717241 | PRJNA1031674_P_NODE_26503_length_243_cov_1.811765_g26292_i0 | PRJNA1031674 | 26503 | 243 | 1.811765 | 4.40258895 | Chironomus riparius | 315576 | Arthropoda | Arthropoda | 157 | 1.86e-42 | NR | CAG9799755.1 | 315576 | g26292 | i0 | 90 | 0.987654320987654 | 80 | 8 | 98.8 | 0 | 241 | 2 | 258 | 337 | CAG9799755.1 unnamed protein product [Chironomus riparius] | diamond | 240 | 157 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Chironomidae | Chironomus | Chironomus riparius | |
| 26591654 | 26591654 | PRJNA1031674_P_NODE_12121_length_286_cov_1.873239_g11910_i0 | PRJNA1031674 | 12121 | 286 | 1.873239 | 5.35746354 | Myxine glutinosa | 7769 | Chordata | Chordata | 57.4 | 4.28e-7 | NR | XP_067954193.1 | 7769 | g11910 | i0 | 59.6 | 2.67482517482518 | 47 | 19 | 49.3 | 0 | 286 | 146 | 97 | 143 | XP_067954193.1 F-box/LRR-repeat protein 14-like [Myxine glutinosa] | diamond | 765 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Myxini | Myxiniformes | Myxinidae | Myxine | Myxine glutinosa | |
| 26774043 | 26774043 | PRJNA1031674_P_NODE_19301_length_261_cov_2.984043_g19090_i0 | PRJNA1031674 | 19301 | 261 | 2.984043 | 7.78835223 | Delphacidae | 33362 | Arthropoda | Arthropoda | 65.5 | 4.93e-10 | NR | XP_039276123.1 | 108931 | g19090 | i0 | 88.2 | 6.8735632183908 | 34 | 4 | 39.1 | 0 | 198 | 97 | 2757 | 2790 | XP_039276123.1 LOW QUALITY PROTEIN: obscurin [Nilaparvata lugens] | diamond | 1794 | 65.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hemiptera | Delphacidae | Nilaparvata | Nilaparvata lugens | |
| 27003280 | 27003280 | PRJNA1031674_P_NODE_16422_length_272_cov_1.859296_g16211_i0 | PRJNA1031674 | 16422 | 272 | 1.859296 | 5.05728512 | Nyctereutes procyonoides | 34880 | Chordata | Chordata | 57 | 4.62e-7 | NR | CAD7676231.1 | 34880 | g16211 | i0 | 74.3 | 0.386029411764706 | 35 | 9 | 38.6 | 0 | 80 | 184 | 109 | 143 | CAD7676231.1 unnamed protein product [Nyctereutes procyonoides] | diamond | 105 | 57 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Canidae | Nyctereutes | Nyctereutes procyonoides | |
| 27066619 | 27066619 | PRJNA1031674_P_NODE_24702_length_246_cov_5.578035_g24491_i0 | PRJNA1031674 | 24702 | 246 | 5.578035 | 13.7219661 | Pristionchus fissidentatus | 1538716 | Nematoda | Nematoda | 49.7 | 1.23e-4 | NR | GMT33030.1 | 1538716 | g24491 | i0 | 37.7 | 0.841463414634146 | 69 | 37 | 76.8 | 2 | 12 | 200 | 153 | 221 | GMT33030.1 hypothetical protein PFISCL1PPCAC_24327, partial [Pristionchus fissidentatus] | diamond | 207 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus fissidentatus | |
| 27856354 | 27856354 | PRJNA1031674_P_NODE_3405_length_431_cov_4.614525_g3195_i0 | PRJNA1031674 | 3405 | 431 | 4.614525 | 19.88860275 | Sus scrofa | 9823 | Chordata | Chordata | 288 | 5.49e-93 | NR | XP_020938199.1 | 9823 | g3195 | i0 | 100 | 1.9907192575406 | 143 | 0 | 99.5 | 0 | 2 | 430 | 130 | 272 | XP_020938199.1 ribonuclease inhibitor isoform X2 [Sus scrofa] | diamond | 858 | 288 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Suidae | Sus | Sus scrofa | |
| 28100903 | 28100903 | PRJNA1031674_P_NODE_11945_length_287_cov_1.299065_g11734_i0 | PRJNA1031674 | 11945 | 287 | 1.299065 | 3.72831655 | Acropora | 6127 | Cnidaria | other_Eukaryota | 43.5 | 0.0332 | NR | KAK2574017.1 | 6130 | g11734 | i0 | 37.5 | 2.50871080139373 | 80 | 35 | 82.6 | 4 | 282 | 46 | 62 | 127 | KAK2574017.1 Sodium-dependent dopamine transporter [Acropora cervicornis] | diamond | 720 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora cervicornis | |
| 28227088 | 28227088 | PRJNA1031674_P_NODE_19686_length_260_cov_1.620321_g19475_i0 | PRJNA1031674 | 19686 | 260 | 1.620321 | 4.2128346 | Chordata | 7711 | Chordata | Chordata | 98.2 | 7.61e-22 | NR | KAJ1132056.1 | 8319 | g19475 | i0 | 61.6 | 34.7307692307692 | 86 | 33 | 99.2 | 0 | 1 | 258 | 112 | 197 | KAJ1132056.1 hypothetical protein NDU88_010386 [Pleurodeles waltl] | diamond | 9030 | 98.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Caudata | Salamandridae | Pleurodeles | Pleurodeles waltl | |
| 28424880 | 28424880 | PRJNA1031674_P_NODE_12426_length_285_cov_1.886792_g12215_i0 | PRJNA1031674 | 12426 | 285 | 1.886792 | 5.3773572 | Tetranychus urticae | 32264 | Arthropoda | Arthropoda | 68.9 | 3.67e-11 | NR | XP_015782160.1 | 32264 | g12215 | i0 | 80.8 | 1.09473684210526 | 52 | 10 | 54.7 | 0 | 128 | 283 | 1 | 52 | XP_015782160.1 NEDD8-activating enzyme E1 regulatory subunit [Tetranychus urticae] | diamond | 312 | 68.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Trombidiformes | Tetranychidae | Tetranychus | Tetranychus urticae | |
| 28803389 | 28803389 | PRJNA1031674_P_NODE_25028_length_246_cov_0.890173_g24817_i0 | PRJNA1031674 | 25028 | 246 | 0.890173 | 2.18982558 | Ceuthophilus sp. XZ-2 | 3073481 | Arthropoda | Arthropoda | 124 | 1.2699999999999998e-31 | NR | AUO15581.1 | 2057961 | g24817 | i0 | 64.6 | 1 | 82 | 29 | 100 | 0 | 246 | 1 | 275 | 356 | AUO15581.1 hexamerin-like protein 3, partial [Ceuthophilus sp. XZ-2017] | diamond | 246 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Orthoptera | Rhaphidophoridae | Ceuthophilus | Ceuthophilus sp. XZ-2017 | |
| 29403568 | 29403568 | PRJNA1031674_P_NODE_14109_length_280_cov_1.478261_g13898_i0 | PRJNA1031674 | 14109 | 280 | 1.478261 | 4.1391308 | Bufotes viridis | 30338 | Chordata | Chordata | 43.5 | 0.021 | NR | CAK8621390.1 | 30338 | g13898 | i0 | 44.8 | 0.621428571428571 | 58 | 23 | 52.5 | 2 | 20 | 166 | 56 | 113 | CAK8621390.1 DEP domain-containing protein 4 [Bufotes viridis] | diamond | 174 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 29592589 | 29592589 | PRJNA1031674_P_NODE_19930_length_259_cov_1.655914_g19719_i0 | PRJNA1031674 | 19930 | 259 | 1.655914 | 4.28881726 | Tetranychus evansi | 178897 | Arthropoda | Arthropoda | 84.7 | 7.99e-17 | NR | AYV89258.1 | 178897 | g19719 | i0 | 43.5 | 0.984555984555985 | 85 | 48 | 98.5 | 0 | 256 | 2 | 1635 | 1719 | AYV89258.1 apolipophorins-like [Tetranychus evansi] | diamond | 255 | 84.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Trombidiformes | Tetranychidae | Tetranychus | Tetranychus evansi | |
| 29710960 | 29710960 | PRJNA1031674_P_NODE_19490_length_261_cov_1.319149_g19279_i0 | PRJNA1031674 | 19490 | 261 | 1.319149 | 3.44297889 | Metazoa | 33208 | Arthropoda | Arthropoda | 42.7 | 0.0449 | NR | KAL1439429.1 | 34631 | g19279 | i0 | 55.9 | 0.919540229885057 | 34 | 12 | 35.6 | 1 | 256 | 164 | 367 | 400 | KAL1439429.1 hypothetical protein MTO96_010245 [Rhipicephalus appendiculatus] | diamond | 240 | 43.1 | 0.990719257540603 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Ixodida | Ixodidae | Rhipicephalus | Rhipicephalus appendiculatus | |
| 29932601 | 29932601 | PRJNA1031674_P_NODE_11531_length_288_cov_1.432558_g11320_i0 | PRJNA1031674 | 11531 | 288 | 1.432558 | 4.12576704 | Gymnophiona | 8445 | Chordata | Chordata | 43.9 | 0.0253 | NR | XP_033775004.1 | 260995 | g11320 | i0 | 64.3 | 0.875 | 28 | 10 | 29.2 | 0 | 288 | 205 | 547 | 574 | XP_033775004.1 signal recognition particle receptor subunit alpha isoform X2 [Geotrypetes seraphini] | diamond | 252 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Gymnophiona | Dermophiidae | Geotrypetes | Geotrypetes seraphini | |
| 30224632 | 30224632 | PRJNA1031674_P_NODE_24152_length_247_cov_2.304598_g23941_i0 | PRJNA1031674 | 24152 | 247 | 2.304598 | 5.69235706 | Monomorium pharaonis | 307658 | Arthropoda | Arthropoda | 57.4 | 2.76e-7 | NR | XP_036142150.1 | 307658 | g23941 | i0 | 80.6 | 0.437246963562753 | 36 | 7 | 43.7 | 0 | 125 | 232 | 917 | 952 | XP_036142150.1 uncharacterized protein LOC118645380 [Monomorium pharaonis] | diamond | 108 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hymenoptera | Formicidae | Monomorium | Monomorium pharaonis | |
| 30320043 | 30320043 | PRJNA1031674_P_NODE_24232_length_247_cov_1.758621_g24021_i0 | PRJNA1031674 | 24232 | 247 | 1.758621 | 4.34379387 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 42.7 | 0.0406 | NR | XP_052225375.1 | 45954 | g24021 | i0 | 45.7 | 0.425101214574899 | 35 | 19 | 42.5 | 0 | 234 | 130 | 574 | 608 | XP_052225375.1 disintegrin and metalloproteinase domain-containing protein 12-like isoform X1 [Dreissena polymorpha] | diamond | 105 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 30320045 | 30320045 | PRJNA1031674_P_NODE_25332_length_245_cov_2.284884_g25121_i0 | PRJNA1031674 | 25332 | 245 | 2.284884 | 5.5979658 | Periplaneta americana | 6978 | Arthropoda | Arthropoda | 65.5 | 1.22e-10 | NR | KAJ4428229.1 | 6978 | g25121 | i0 | 53.4 | 5.68163265306122 | 58 | 24 | 67.3 | 1 | 2 | 166 | 127 | 184 | KAJ4428229.1 hypothetical protein ANN_24245 [Periplaneta americana] | diamond | 1392 | 65.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Blattodea | Blattidae | Periplaneta | Periplaneta americana | |
| 30667014 | 30667014 | PRJNA1031674_P_NODE_18873_length_263_cov_1.621053_g18662_i0 | PRJNA1031674 | 18873 | 263 | 1.621053 | 4.26336939 | Sus scrofa | 9823 | Chordata | Chordata | 174 | 4.89e-50 | NR | XP_020938199.1 | 9823 | g18662 | i0 | 100 | 2.97718631178707 | 87 | 0 | 99.2 | 0 | 261 | 1 | 344 | 430 | XP_020938199.1 ribonuclease inhibitor isoform X2 [Sus scrofa] | diamond | 783 | 174 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Suidae | Sus | Sus scrofa | |
| 31235646 | 31235646 | PRJNA1031674_P_NODE_8375_length_310_cov_3.227848_g8164_i0 | PRJNA1031674 | 8375 | 310 | 3.227848 | 10.0063288 | Polypedilum vanderplanki | 319348 | Arthropoda | Arthropoda | 46.2 | 0.00432 | NR | KAG5670686.1 | 319348 | g8164 | i0 | 45.8 | 1.80967741935484 | 48 | 25 | 45.5 | 1 | 142 | 2 | 159 | 206 | KAG5670686.1 hypothetical protein PVAND_000933 [Polypedilum vanderplanki] | diamond | 561 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Chironomidae | Polypedilum | Polypedilum vanderplanki | |
| 31267430 | 31267430 | PRJNA1031674_P_NODE_22715_length_250_cov_0.870056_g22504_i0 | PRJNA1031674 | 22715 | 250 | 0.870056 | 2.17514 | Fragariocoptes setiger | 1670756 | Arthropoda | Arthropoda | 61.2 | 1.26e-8 | NR | KAG9508647.1 | 1670756 | g22504 | i0 | 65 | 1.968 | 40 | 14 | 48 | 0 | 130 | 249 | 192 | 231 | KAG9508647.1 E3 ubiquitin-protein ligase NEDD4, partial [Fragariocoptes setiger] | diamond | 492 | 61.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Trombidiformes | Phytoptidae | Fragariocoptes | Fragariocoptes setiger | |
| 31552309 | 31552309 | PRJNA1031674_P_NODE_10976_length_290_cov_1.331797_g10765_i0 | PRJNA1031674 | 10976 | 290 | 1.331797 | 3.8622113 | Cordylochernes scorpioides | 51811 | Arthropoda | Arthropoda | 110 | 1.43e-25 | NR | UYV63435.1 | 51811 | g10765 | i0 | 58.3 | 16.2206896551724 | 96 | 36 | 99.3 | 2 | 3 | 290 | 1135 | 1226 | UYV63435.1 hypothetical protein LAZ67_2004061 [Cordylochernes scorpioides] | diamond | 4704 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Pseudoscorpiones | Chernetidae | Cordylochernes | Cordylochernes scorpioides | |
| 31868250 | 31868250 | PRJNA1031674_P_NODE_16117_length_273_cov_1.730000_g15906_i0 | PRJNA1031674 | 16117 | 273 | 1.73 | 4.7229 | Pristionchus entomophagus | 358040 | Nematoda | Nematoda | 42.7 | 0.0491 | NR | GMS94646.1 | 358040 | g15906 | i0 | 40 | 0.494505494505495 | 45 | 26 | 48.4 | 1 | 206 | 75 | 98 | 142 | GMS94646.1 hypothetical protein PENTCL1PPCAC_16821, partial [Pristionchus entomophagus] | diamond | 135 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus entomophagus | |
| 32089875 | 32089875 | PRJNA1031674_P_NODE_17298_length_269_cov_1.571429_g17087_i0 | PRJNA1031674 | 17298 | 269 | 1.571429 | 4.22714401 | Uroleucon formosanum | 796250 | Arthropoda | Arthropoda | 158 | 1.29e-44 | NR | KAL4121220.1 | 796250 | g17087 | i0 | 89.9 | 0.992565055762082 | 89 | 9 | 99.3 | 0 | 3 | 269 | 73 | 161 | KAL4121220.1 hypothetical protein QTP88_013777 [Uroleucon formosanum] | diamond | 267 | 158 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hemiptera | Aphididae | Uroleucon | Uroleucon formosanum | |
| 32216517 | 32216517 | PRJNA1031674_P_NODE_16638_length_271_cov_2.474747_g16427_i0 | PRJNA1031674 | 16638 | 271 | 2.474747 | 6.70656437 | Diaphorina citri | 121845 | Arthropoda | Arthropoda | 52.8 | 1.53e-5 | NR | KAI5731814.1 | 121845 | g16427 | i0 | 53.8 | 3.86346863468635 | 39 | 18 | 43.2 | 0 | 154 | 270 | 181 | 219 | KAI5731814.1 hypothetical protein M8J77_016486 [Diaphorina citri] | diamond | 1047 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hemiptera | Psyllidae | Diaphorina | Diaphorina citri | |
| 32366839 | 32366839 | PRJNA1031674_P_NODE_19919_length_259_cov_1.655914_g19708_i0 | PRJNA1031674 | 19919 | 259 | 1.655914 | 4.28881726 | Ixodidae | 6939 | Arthropoda | Arthropoda | 46.2 | 0.00269 | NR | CAL6190457.1 | 34612 | g19708 | i0 | 76 | 1.11196911196911 | 25 | 6 | 29 | 0 | 9 | 83 | 186 | 210 | CAL6190457.1 unnamed protein product, partial [Ixodes hexagonus] | diamond | 288 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Ixodida | Ixodidae | Ixodes | Ixodes hexagonus | |
| 32374780 | 32374780 | PRJNA1031674_P_NODE_24959_length_246_cov_0.890173_g24748_i0 | PRJNA1031674 | 24959 | 246 | 0.890173 | 2.18982558 | Polypterus senegalus | 55291 | Chordata | Chordata | 71.6 | 6.09e-13 | NR | XP_039599867.1 | 55291 | g24748 | i0 | 66.7 | 9.45121951219512 | 48 | 16 | 58.5 | 0 | 3 | 146 | 139 | 186 | XP_039599867.1 thioredoxin domain-containing protein 9 [Polypterus senegalus] | diamond | 2325 | 72 | 0.994444444444444 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 32469788 | 32469788 | PRJNA1031674_P_NODE_27239_length_242_cov_0.911243_g27028_i0 | PRJNA1031674 | 27239 | 242 | 0.911243 | 2.20520806 | Eufriesea mexicana | 516756 | Arthropoda | Arthropoda | 42.7 | 0.0351 | NR | XP_017759095.1 | 516756 | g27028 | i0 | 36.7 | 0.743801652892562 | 60 | 28 | 65.7 | 2 | 186 | 28 | 79 | 135 | XP_017759095.1 PREDICTED: insulin-like growth factor-binding protein-related protein 1 [Eufriesea mexicana] | diamond | 180 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hymenoptera | Apidae | Eufriesea | Eufriesea mexicana |
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);;