contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA724011" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27336709 | 27336709 | PRJNA724011_P_NODE_18763_length_683_cov_4.080328_g17758_i0 | PRJNA724011 | 18763 | 683 | 4.080328 | 27.86864024 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 75.9 | 1.16e-13 | NR | XP_063680833.1 | 2820187 | g17758 | i0 | 41.7 | 0.36896046852123 | 84 | 49 | 36.9 | 0 | 488 | 237 | 31 | 114 | XP_063680833.1 LITAF domain-containing protein-like [Bolinopsis microptera] | diamond | 252 | 75.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 27999976 | 27999976 | PRJNA724011_P_NODE_81625_length_274_cov_1.293532_g80602_i0 | PRJNA724011 | 81625 | 274 | 1.293532 | 3.54427768 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 51.6 | 4.31e-5 | NR | XP_063689484.1 | 2820187 | g80602 | i0 | 35.2 | 0.996350364963504 | 91 | 57 | 99.6 | 1 | 274 | 2 | 671 | 759 | XP_063689484.1 LOW QUALITY PROTEIN: sister chromatid cohesion protein PDS5 homolog A-like [Bolinopsis microptera] | diamond | 273 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 29073484 | 29073484 | PRJNA724011_P_NODE_83468_length_270_cov_1.563452_g82445_i0 | PRJNA724011 | 83468 | 270 | 1.563452 | 4.2213204 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 55.8 | 1.26e-6 | NR | XP_063674741.1 | 2820187 | g82445 | i0 | 33 | 2.85555555555556 | 97 | 55 | 96.7 | 2 | 261 | 1 | 282 | 378 | XP_063674741.1 glutathione synthetase-like [Bolinopsis microptera] | diamond | 771 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 30115220 | 30115220 | PRJNA724011_P_NODE_24372_length_576_cov_2.339960_g23356_i0 | PRJNA724011 | 24372 | 576 | 2.33996 | 13.4781696 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 46.6 | 0.0339 | NR | XP_063675471.1 | 2820187 | g23356 | i0 | 24.7 | 0.463541666666667 | 89 | 63 | 44.3 | 1 | 547 | 293 | 647 | 735 | XP_063675471.1 leucine-zipper-like transcriptional regulator 1 homolog [Bolinopsis microptera] | diamond | 267 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 30589182 | 30589182 | PRJNA724011_P_NODE_54333_length_349_cov_1.115942_g53310_i0 | PRJNA724011 | 54333 | 349 | 1.115942 | 3.89463758 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 58.2 | 2.04e-7 | NR | XP_063681198.1 | 2820187 | g53310 | i0 | 47.3 | 2.64756446991404 | 55 | 27 | 47.3 | 1 | 329 | 165 | 157 | 209 | XP_063681198.1 growth factor receptor-bound protein 2-like [Bolinopsis microptera] | diamond | 924 | 58.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 30683906 | 30683906 | PRJNA724011_P_NODE_22153_length_613_cov_5.766667_g21140_i0 | PRJNA724011 | 22153 | 613 | 5.766667 | 35.34966871 | Mnemiopsis leidyi | 27923 | Ctenophora | other_Eukaryota | 94.7 | 2.27e-20 | NR | AEY80353.1 | 27923 | g21140 | i0 | 45 | 1.79119086460033 | 80 | 44 | 39.2 | 0 | 54 | 293 | 4 | 83 | AEY80353.1 CRP class LIM protein ML02959a [Mnemiopsis leidyi] | diamond | 1098 | 94.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Mnemiopsis | Mnemiopsis leidyi | |
| 30873577 | 30873577 | PRJNA724011_P_NODE_12654_length_869_cov_17.483668_g11756_i0 | PRJNA724011 | 12654 | 869 | 17.483668 | 151.93307492 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 270 | 2.329999999999999e-87 | NR | XP_063687402.1 | 2820187 | g11756 | i0 | 68.6 | 0.669735327963176 | 194 | 60 | 67 | 1 | 43 | 624 | 1 | 193 | XP_063687402.1 peroxiredoxin-like [Bolinopsis microptera] | diamond | 582 | 270 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 31136510 | 31136510 | PRJNA724011_P_NODE_96675_length_249_cov_0.875000_g95652_i0 | PRJNA724011 | 96675 | 249 | 0.875 | 2.17875 | Pleurobrachia | 34498 | Ctenophora | other_Eukaryota | 75.5 | 1.17e-13 | NR | AEX15556.1 | 34499 | g95652 | i0 | 40.7 | 5.92771084337349 | 81 | 47 | 96.4 | 1 | 242 | 3 | 580 | 660 | AEX15556.1 piwi protein 2 [Pleurobrachia bachei] | diamond | 1476 | 75.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Cydippida | Pleurobrachiidae | Pleurobrachia | Pleurobrachia bachei | |
| 31347786 | 31347786 | PRJNA724011_P_NODE_16276_length_747_cov_1.492582_g15302_i0 | PRJNA724011 | 16276 | 747 | 1.492582 | 11.14958754 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 70.5 | 1.05e-9 | NR | XP_063686427.1 | 2820187 | g15302 | i0 | 31.6 | 0.622489959839357 | 155 | 102 | 62.2 | 1 | 1 | 465 | 253 | 403 | XP_063686427.1 uncharacterized protein LOC134820135 [Bolinopsis microptera] | diamond | 465 | 70.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 32518463 | 32518463 | PRJNA724011_P_NODE_17819_length_707_cov_3.924290_g16823_i0 | PRJNA724011 | 17819 | 707 | 3.92429 | 27.7447303 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 75.9 | 1.36e-13 | NR | XP_063680833.1 | 2820187 | g16823 | i0 | 41.7 | 0.356435643564356 | 84 | 49 | 35.6 | 0 | 488 | 237 | 31 | 114 | XP_063680833.1 LITAF domain-containing protein-like [Bolinopsis microptera] | diamond | 252 | 75.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 32739122 | 32739122 | PRJNA724011_P_NODE_85000_length_267_cov_1.587629_g83977_i0 | PRJNA724011 | 85000 | 267 | 1.587629 | 4.23896943 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 55.5 | 8.28e-7 | NR | XP_063692935.1 | 2820187 | g83977 | i0 | 36.4 | 0.865168539325843 | 77 | 40 | 86.5 | 1 | 249 | 19 | 134 | 201 | XP_063692935.1 calmodulin-A-like [Bolinopsis microptera] | diamond | 231 | 55.5 | 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);;