contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA1237347" and tax_phylum = "Ctenophora"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22015200 | 22015200 | PRJNA1237347_P_NODE_199538_length_434_cov_1.941828_g192966_i0 | PRJNA1237347 | 199538 | 434 | 1.941828 | 8.42753352 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 172 | 1.48e-46 | NR | XP_063689885.1 | 2820187 | g192966 | i0 | 79.4 | 22.963133640553 | 97 | 20 | 67.1 | 0 | 433 | 143 | 257 | 353 | XP_063689885.1 puromycin-sensitive aminopeptidase-like isoform X2 [Bolinopsis microptera] | diamond | 9966 | 172 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 26978112 | 26978112 | PRJNA1237347_P_NODE_307082_length_329_cov_1.597656_g300509_i0 | PRJNA1237347 | 307082 | 329 | 1.597656 | 5.25628824 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 140 | 1.68e-39 | NR | XP_063687402.1 | 2820187 | g300509 | i0 | 73.1 | 0.848024316109423 | 93 | 25 | 84.8 | 0 | 279 | 1 | 1 | 93 | XP_063687402.1 peroxiredoxin-like [Bolinopsis microptera] | diamond | 279 | 140 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 27009634 | 27009634 | PRJNA1237347_P_NODE_283802_length_346_cov_1.014652_g277229_i0 | PRJNA1237347 | 283802 | 346 | 1.014652 | 3.51069592 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 96.7 | 8.71e-21 | NR | XP_063687303.1 | 2820187 | g277229 | i0 | 43.8 | 1.04913294797688 | 121 | 62 | 99.7 | 1 | 1 | 345 | 83 | 203 | XP_063687303.1 kynurenine--oxoglutarate transaminase 3-like [Bolinopsis microptera] | diamond | 363 | 96.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 28051889 | 28051889 | PRJNA1237347_P_NODE_122285_length_598_cov_5.626667_g115768_i0 | PRJNA1237347 | 122285 | 598 | 5.626667 | 33.64746866 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 199 | 6.45e-61 | NR | XP_063678382.1 | 2820187 | g115768 | i0 | 50.5 | 4.65551839464883 | 186 | 92 | 93.3 | 0 | 558 | 1 | 3 | 188 | XP_063678382.1 ras-related protein Rab-2A-like isoform X2 [Bolinopsis microptera] | diamond | 2784 | 199 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 28778533 | 28778533 | PRJNA1237347_P_NODE_516547_length_246_cov_0.890173_g509974_i0 | PRJNA1237347 | 516547 | 246 | 0.890173 | 2.18982558 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 69.3 | 1.53e-11 | NR | XP_063679440.1 | 2820187 | g509974 | i0 | 43 | 2.81707317073171 | 79 | 45 | 96.3 | 0 | 10 | 246 | 231 | 309 | XP_063679440.1 gastric triacylglycerol lipase-like [Bolinopsis microptera] | diamond | 693 | 69.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 29662186 | 29662186 | PRJNA1237347_P_NODE_405910_length_277_cov_1.500000_g399337_i0 | PRJNA1237347 | 405910 | 277 | 1.5 | 4.155 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 76.6 | 1.47e-14 | NR | XP_063680299.1 | 2820187 | g399337 | i0 | 50.7 | 0.725631768953069 | 67 | 33 | 72.6 | 0 | 201 | 1 | 72 | 138 | XP_063680299.1 uncharacterized protein LOC134815669 [Bolinopsis microptera] | diamond | 201 | 76.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 30326419 | 30326419 | PRJNA1237347_P_NODE_363152_length_296_cov_1.717489_g356579_i0 | PRJNA1237347 | 363152 | 296 | 1.717489 | 5.08376744 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 55.8 | 1.83e-6 | NR | XP_063686232.1 | 2820187 | g356579 | i0 | 29.3 | 0.932432432432432 | 92 | 65 | 93.2 | 0 | 295 | 20 | 799 | 890 | XP_063686232.1 dynein axonemal heavy chain 6-like isoform X2 [Bolinopsis microptera] | diamond | 276 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 30389758 | 30389758 | PRJNA1237347_P_NODE_561713_length_234_cov_3.409938_g555139_i0 | PRJNA1237347 | 561713 | 234 | 3.409938 | 7.97925492 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 45.4 | 0.00124 | NR | XP_063678381.1 | 2820187 | g555139 | i0 | 36.1 | 0.782051282051282 | 61 | 29 | 65.4 | 2 | 58 | 210 | 13 | 73 | XP_063678381.1 DNA-directed RNA polymerase II subunit RPB9-like [Bolinopsis microptera] | diamond | 183 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 30609995 | 30609995 | PRJNA1237347_P_NODE_297093_length_336_cov_1.315589_g290520_i0 | PRJNA1237347 | 297093 | 336 | 1.315589 | 4.42037904 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 85.5 | 8.96e-18 | NR | XP_063694358.1 | 2820187 | g290520 | i0 | 50.6 | 0.723214285714286 | 81 | 39 | 71.4 | 1 | 2 | 241 | 117 | 197 | XP_063694358.1 osteoclast-stimulating factor 1-like [Bolinopsis microptera] | diamond | 243 | 85.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 30894871 | 30894871 | PRJNA1237347_P_NODE_430774_length_267_cov_1.278351_g424201_i0 | PRJNA1237347 | 430774 | 267 | 1.278351 | 3.41319717 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 73.9 | 4.8e-13 | NR | XP_063677777.1 | 2820187 | g424201 | i0 | 46.5 | 1.8876404494382 | 86 | 45 | 95.5 | 1 | 257 | 3 | 9 | 94 | XP_063677777.1 uncharacterized protein LOC134813828 [Bolinopsis microptera] | diamond | 504 | 73.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 30989727 | 30989727 | PRJNA1237347_P_NODE_521514_length_245_cov_0.895349_g514941_i0 | PRJNA1237347 | 521514 | 245 | 0.895349 | 2.19360505 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 92 | 1.52e-21 | NR | XP_063691174.1 | 2820187 | g514941 | i0 | 54.3 | 1.9469387755102 | 81 | 37 | 99.2 | 0 | 244 | 2 | 29 | 109 | XP_063691174.1 calmodulin-like isoform X5 [Bolinopsis microptera] | diamond | 477 | 92 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 31052599 | 31052599 | PRJNA1237347_P_NODE_169575_length_484_cov_1.223844_g163005_i0 | PRJNA1237347 | 169575 | 484 | 1.223844 | 5.92340496 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 47 | 0.0145 | NR | XP_063684909.1 | 2820187 | g163005 | i0 | 35.7 | 0.774793388429752 | 70 | 42 | 42.8 | 2 | 228 | 434 | 1892 | 1959 | XP_063684909.1 multiple epidermal growth factor-like domains protein 8 [Bolinopsis microptera] | diamond | 375 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 31495089 | 31495089 | PRJNA1237347_P_NODE_158576_length_505_cov_1.671296_g152015_i0 | PRJNA1237347 | 158576 | 505 | 1.671296 | 8.4400448 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 183 | 3.55e-51 | NR | XP_063688848.1 | 2820187 | g152015 | i0 | 66.7 | 2.80990099009901 | 141 | 44 | 82 | 1 | 87 | 500 | 170 | 310 | XP_063688848.1 asparagine--tRNA ligase, cytoplasmic-like isoform X2 [Bolinopsis microptera] | diamond | 1419 | 183 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 31842729 | 31842729 | PRJNA1237347_P_NODE_162477_length_497_cov_1.997642_g155916_i0 | PRJNA1237347 | 162477 | 497 | 1.997642 | 9.92828074 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 74.3 | 1.03e-12 | NR | XP_063689751.1 | 2820187 | g155916 | i0 | 31.8 | 0.947686116700201 | 157 | 96 | 93.6 | 4 | 495 | 31 | 81 | 228 | XP_063689751.1 uncharacterized protein LOC134822563 [Bolinopsis microptera] | diamond | 471 | 74.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 31906355 | 31906355 | PRJNA1237347_P_NODE_323317_length_319_cov_0.939024_g316744_i0 | PRJNA1237347 | 323317 | 319 | 0.939024 | 2.99548656 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 47 | 0.00299 | NR | XP_063680497.1 | 2820187 | g316744 | i0 | 33.7 | 1.87147335423198 | 101 | 56 | 94 | 4 | 311 | 12 | 595 | 685 | XP_063680497.1 LOW QUALITY PROTEIN: plexin-A4-like [Bolinopsis microptera] | diamond | 597 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 31937954 | 31937954 | PRJNA1237347_P_NODE_382157_length_287_cov_1.574766_g375584_i0 | PRJNA1237347 | 382157 | 287 | 1.574766 | 4.51957842 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 59.7 | 2.68e-8 | NR | XP_063688191.1 | 2820187 | g375584 | i0 | 33.7 | 0.993031358885017 | 95 | 63 | 99.3 | 0 | 3 | 287 | 2 | 96 | XP_063688191.1 uncharacterized protein LOC134821379 [Bolinopsis microptera] | diamond | 285 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 32570934 | 32570934 | PRJNA1237347_P_NODE_205159_length_426_cov_2.184136_g198587_i0 | PRJNA1237347 | 205159 | 426 | 2.184136 | 9.30441936 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 63.5 | 1.65e-8 | NR | XP_063677272.1 | 2820187 | g198587 | i0 | 31.5 | 2.41549295774648 | 111 | 60 | 70.4 | 4 | 420 | 121 | 2943 | 3048 | XP_063677272.1 E3 ubiquitin-protein ligase HERC2-like isoform X1 [Bolinopsis microptera] | diamond | 1029 | 63.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 32602142 | 32602142 | PRJNA1237347_P_NODE_207380_length_423_cov_2.011429_g200808_i0 | PRJNA1237347 | 207380 | 423 | 2.011429 | 8.50834467 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 63.5 | 2.12e-9 | NR | XP_063683346.1 | 2820187 | g200808 | i0 | 39.7 | 2 | 63 | 38 | 44.7 | 0 | 232 | 420 | 84 | 146 | XP_063683346.1 cell death-inducing p53-target protein 1 homolog [Bolinopsis microptera] | diamond | 846 | 63.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 32696389 | 32696389 | PRJNA1237347_P_NODE_128600_length_579_cov_1.521739_g122073_i0 | PRJNA1237347 | 128600 | 579 | 1.521739 | 8.81086881 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 61.6 | 2.7e-7 | NR | XP_063676350.1 | 2820187 | g122073 | i0 | 31.2 | 1.60621761658031 | 109 | 75 | 56.5 | 0 | 72 | 398 | 526 | 634 | XP_063676350.1 FACT complex subunit SSRP1-like [Bolinopsis microptera] | diamond | 930 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera |
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);;