contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA785164" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3317000 | 3317000 | PRJNA785164_P_NODE_18803_length_446_cov_0.825737_g18338_i0 | PRJNA785164 | 18803 | 446 | 0.825737 | 3.68278702 | Priapulus caudatus | 37621 | Priapulida | other_Eukaryota | 188 | 6.26e-53 | NR | XP_014669719.1 | 37621 | g18338 | i0 | 64.2 | 20.9058295964126 | 148 | 52 | 99.6 | 1 | 3 | 446 | 435 | 581 | XP_014669719.1 PREDICTED: glutamine--fructose-6-phosphate aminotransferase [isomerizing] 2-like isoform X2 [Priapulus caudatus] | diamond | 9324 | 188 | 1 | Eukaryota | Opisthokonta | Metazoa | Priapulida | Priapulimorpha | Priapulimorphida | Priapulidae | Priapulus | Priapulus caudatus | |
| 28001418 | 28001418 | PRJNA785164_P_NODE_43965_length_272_cov_1.025126_g43500_i0 | PRJNA785164 | 43965 | 272 | 1.025126 | 2.78834272 | Pristionchus fissidentatus | 1538716 | Nematoda | Nematoda | 42.7 | 0.0493 | NR | GMT28504.1 | 1538716 | g43500 | i0 | 48.8 | 0.452205882352941 | 41 | 18 | 43 | 2 | 265 | 149 | 123 | 162 | GMT28504.1 hypothetical protein PFISCL1PPCAC_19801, partial [Pristionchus fissidentatus] | diamond | 123 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus fissidentatus | |
| 28095951 | 28095951 | PRJNA785164_P_NODE_50965_length_251_cov_1.426966_g50500_i0 | PRJNA785164 | 50965 | 251 | 1.426966 | 3.58168466 | Trinorchestia longiramus | 1923959 | Arthropoda | Arthropoda | 51.6 | 3.08e-5 | NR | KAF2353244.1 | 1923959 | g50500 | i0 | 37.5 | 4.49402390438247 | 64 | 36 | 76.5 | 1 | 250 | 59 | 528 | 587 | KAF2353244.1 Transposase type 1 [Trinorchestia longiramus] | diamond | 1128 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Amphipoda | Talitridae | Trinorchestia | Trinorchestia longiramus | |
| 28253776 | 28253776 | PRJNA785164_P_NODE_61946_length_241_cov_0.916667_g61481_i0 | PRJNA785164 | 61946 | 241 | 0.916667 | 2.20916747 | Xenia sp. Carnegie-2 | 86540 | Cnidaria | other_Eukaryota | 53.1 | 4.01e-6 | NR | XP_046841369.1 | 2897299 | g61481 | i0 | 30.7 | 0.933609958506224 | 75 | 50 | 90.9 | 1 | 21 | 239 | 25 | 99 | XP_046841369.1 LOW QUALITY PROTEIN: ras-like GTP-binding protein rhoA [Xenia sp. Carnegie-2017] | diamond | 225 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 28452694 | 28452694 | PRJNA785164_P_NODE_39866_length_285_cov_2.533019_g39401_i0 | PRJNA785164 | 39866 | 285 | 2.533019 | 7.21910415 | root | 1 | Root_unresolved | Root_unresolved | 192 | 2.81e-57 | NR | 6ZQK_A | 10090 | g39401 | i0 | 100 | 9.89473684210526 | 94 | 0 | 98.9 | 0 | 3 | 284 | 151 | 244 | 6ZQK_A Chain A, heavy chain [Mus musculus] | diamond | 2820 | 192 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 28569500 | 28569500 | PRJNA785164_P_NODE_48647_length_257_cov_2.467391_g48182_i0 | PRJNA785164 | 48647 | 257 | 2.467391 | 6.34119487 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 52.8 | 1.19e-5 | NR | CAF0745865.1 | 104777 | g48182 | i0 | 41.2 | 0.992217898832685 | 85 | 35 | 99.2 | 3 | 255 | 1 | 18 | 87 | CAF0745865.1 unnamed protein product [Brachionus calyciflorus] | diamond | 255 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 28799618 | 28799618 | PRJNA785164_P_NODE_57127_length_245_cov_1.732558_g56662_i0 | PRJNA785164 | 57127 | 245 | 1.732558 | 4.2447671 | root | 1 | Root_unresolved | Root_unresolved | 48.5 | 3.37e-4 | NR | KAK9399344.1 | 8729 | g56662 | i0 | 32.9 | 4.02857142857143 | 82 | 53 | 98 | 2 | 243 | 4 | 133 | 214 | KAK9399344.1 F-box/LRR-repeat protein 13-like [Crotalus adamanteus] | diamond | 987 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Viperidae | Crotalus | Crotalus adamanteus | |
| 28926062 | 28926062 | PRJNA785164_P_NODE_56768_length_246_cov_0.890173_g56303_i0 | PRJNA785164 | 56768 | 246 | 0.890173 | 2.18982558 | Miridae | 30083 | Arthropoda | Arthropoda | 152 | 1.09e-40 | NR | KAF6204472.1 | 248454 | g56303 | i0 | 76.5 | 1.97560975609756 | 81 | 19 | 98.8 | 0 | 245 | 3 | 1097 | 1177 | KAF6204472.1 hypothetical protein GE061_002813 [Apolygus lucorum] | diamond | 486 | 152 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hemiptera | Miridae | Apolygus | Apolygus lucorum | |
| 28980210 | 28980210 | PRJNA785164_P_NODE_58248_length_244_cov_1.497076_g57783_i0 | PRJNA785164 | 58248 | 244 | 1.497076 | 3.65286544 | Homalodisca vitripennis | 197043 | Arthropoda | Arthropoda | 41.6 | 0.044 | NR | KAG8265275.1 | 197043 | g57783 | i0 | 39.1 | 0.848360655737705 | 69 | 36 | 77.5 | 2 | 31 | 219 | 51 | 119 | KAG8265275.1 hypothetical protein J6590_098403 [Homalodisca vitripennis] | diamond | 207 | 41.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hemiptera | Cicadellidae | Homalodisca | Homalodisca vitripennis | |
| 29106424 | 29106424 | PRJNA785164_P_NODE_40228_length_284_cov_1.521327_g39763_i0 | PRJNA785164 | 40228 | 284 | 1.521327 | 4.32056868 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 43.9 | 0.0223 | NR | XP_064393863.1 | 6063 | g39763 | i0 | 43.1 | 0.686619718309859 | 65 | 27 | 68.7 | 2 | 3 | 197 | 190 | 244 | XP_064393863.1 translation initiation factor eIF2 assembly protein-like [Halichondria panicea] | diamond | 195 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 29336633 | 29336633 | PRJNA785164_P_NODE_59669_length_243_cov_0.905882_g59204_i0 | PRJNA785164 | 59669 | 243 | 0.905882 | 2.20129326 | Rhabditida | 6236 | Nematoda | Nematoda | 87.8 | 4.89e-18 | NR | PIO71852.1 | 45464 | g59204 | i0 | 57.9 | 2.83950617283951 | 76 | 25 | 93.8 | 2 | 14 | 241 | 383 | 451 | PIO71852.1 kinase domain protein [Teladorsagia circumcincta] | diamond | 690 | 87.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Trichostrongylidae | Teladorsagia | Teladorsagia circumcincta | |
| 29526129 | 29526129 | PRJNA785164_P_NODE_53370_length_249_cov_0.875000_g52905_i0 | PRJNA785164 | 53370 | 249 | 0.875 | 2.17875 | Rodentia | 9989 | Chordata | Chordata | 100 | 1.47e-22 | NR | NP_001153420.2 | 10090 | g52905 | i0 | 98.1 | 9.74698795180723 | 52 | 1 | 62.7 | 0 | 94 | 249 | 660 | 711 | NP_001153420.2 alsin isoform 1 [Mus musculus] | diamond | 2427 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 29611209 | 29611209 | PRJNA785164_P_NODE_60970_length_242_cov_0.911243_g60505_i0 | PRJNA785164 | 60970 | 242 | 0.911243 | 2.20520806 | Alectoris rufa | 9079 | Chordata | Chordata | 44.3 | 0.0104 | NR | CAK6567603.1 | 9079 | g60505 | i0 | 56.7 | 0.371900826446281 | 30 | 13 | 37.2 | 0 | 153 | 242 | 486 | 515 | CAK6567603.1 unnamed protein product [Alectoris rufa] | diamond | 90 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Galliformes | Phasianidae | Alectoris | Alectoris rufa | |
| 29990534 | 29990534 | PRJNA785164_P_NODE_52711_length_250_cov_0.870056_g52246_i0 | PRJNA785164 | 52711 | 250 | 0.870056 | 2.17514 | Ovis ammon polii x Ovis aries | 2918886 | Chordata | Chordata | 45.4 | 0.00358 | NR | KAI4551542.1 | 2918886 | g52246 | i0 | 50 | 0.504 | 42 | 21 | 50.4 | 0 | 146 | 21 | 185 | 226 | KAI4551542.1 hypothetical protein MJT46_017794 [Ovis ammon polii x Ovis aries] | diamond | 126 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Ovis | Ovis ammon polii x Ovis aries | |
| 30653839 | 30653839 | PRJNA785164_P_NODE_55993_length_246_cov_2.606936_g55528_i0 | PRJNA785164 | 55993 | 246 | 2.606936 | 6.41306256 | Eumeta japonica | 151549 | Arthropoda | Arthropoda | 41.2 | 0.034 | NR | GBP06203.1 | 151549 | g55528 | i0 | 40 | 0.609756097560976 | 50 | 25 | 54.9 | 2 | 163 | 29 | 23 | 72 | GBP06203.1 hypothetical protein EVAR_3563_1 [Eumeta japonica] | diamond | 150 | 41.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Psychidae | Eumeta | Eumeta japonica | |
| 30852785 | 30852785 | PRJNA785164_P_NODE_52214_length_250_cov_0.870056_g51749_i0 | PRJNA785164 | 52214 | 250 | 0.870056 | 2.17514 | Metazoa | 33208 | Chordata | Chordata | 89.4 | 1.18e-18 | NR | XP_004402094.1 | 9708 | g51749 | i0 | 54.9 | 14.316 | 82 | 37 | 98.4 | 0 | 2 | 247 | 328 | 409 | XP_004402094.1 PREDICTED: GMP reductase 2 isoform X1 [Odobenus rosmarus divergens] | diamond | 3579 | 89.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Odobenidae | Odobenus | Odobenus rosmarus | |
| 31127525 | 31127525 | PRJNA785164_P_NODE_30595_length_330_cov_3.124514_g30130_i0 | PRJNA785164 | 30595 | 330 | 3.124514 | 10.3108962 | Hypanus sabinus | 79690 | Chordata | Chordata | 60.8 | 4.61e-8 | NR | XP_059823631.1 | 79690 | g30130 | i0 | 46 | 0.454545454545455 | 50 | 27 | 45.5 | 0 | 118 | 267 | 558 | 607 | XP_059823631.1 IQ calmodulin-binding motif-containing protein 1 isoform X1 [Hypanus sabinus] | diamond | 150 | 60.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Myliobatiformes | Dasyatidae | Hypanus | Hypanus sabinus | |
| 31159135 | 31159135 | PRJNA785164_P_NODE_30635_length_330_cov_1.844358_g30170_i0 | PRJNA785164 | 30635 | 330 | 1.844358 | 6.0863814 | Lasioglossum lativentre | 88531 | Arthropoda | Arthropoda | 51.2 | 9.84e-5 | NR | ALO64872.1 | 88531 | g30170 | i0 | 37 | 0.736363636363636 | 81 | 51 | 73.6 | 0 | 3 | 245 | 168 | 248 | ALO64872.1 cytochrome b [Lasioglossum lativentre] | diamond | 243 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hymenoptera | Halictidae | Lasioglossum | Lasioglossum lativentre | |
| 31602433 | 31602433 | PRJNA785164_P_NODE_27516_length_351_cov_1.107914_g27051_i0 | PRJNA785164 | 27516 | 351 | 1.107914 | 3.88877814 | Staurois parvus | 386267 | Chordata | Chordata | 53.5 | 2.55e-6 | NR | CAI9557087.1 | 386267 | g27051 | i0 | 63.9 | 0.615384615384615 | 36 | 11 | 29.1 | 1 | 151 | 50 | 24 | 59 | CAI9557087.1 unnamed protein product, partial [Staurois parvus] | diamond | 216 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 32076805 | 32076805 | PRJNA785164_P_NODE_42938_length_275_cov_1.396040_g42473_i0 | PRJNA785164 | 42938 | 275 | 1.39604 | 3.83911 | Plakobranchus ocellatus | 259542 | Mollusca | Mollusca | 44.7 | 0.0114 | NR | GFN77005.1 | 259542 | g42473 | i0 | 37.7 | 4.24363636363636 | 61 | 36 | 65.5 | 2 | 256 | 77 | 38 | 97 | GFN77005.1 RING finger protein 207-like [Plakobranchus ocellatus] | diamond | 1167 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Plakobranchus | Plakobranchus ocellatus | ||
| 32866267 | 32866267 | PRJNA785164_P_NODE_40340_length_284_cov_1.094787_g39875_i0 | PRJNA785164 | 40340 | 284 | 1.094787 | 3.10919508 | Folsomia candida | 158441 | Arthropoda | Arthropoda | 125 | 3.8699999999999997e-31 | NR | OXA59506.1 | 158441 | g39875 | i0 | 64.5 | 2.94718309859155 | 93 | 33 | 98.2 | 0 | 281 | 3 | 352 | 444 | OXA59506.1 Carbonyl reductase [NADPH] 1 [Folsomia candida] | diamond | 837 | 125 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Collembola | Entomobryomorpha | Isotomidae | Folsomia | Folsomia candida |
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);;