contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJNA263496" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3607706 | 3607706 | PRJNA263496_P_NODE_10643_length_242_cov_0.989637_g10390_i0 | PRJNA263496 | 10643 | 242 | 0.989637 | 2.39492154 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 127 | 4.84e-34 | NR | XP_063676167.1 | 2820187 | g10390 | i0 | 83.5 | 0.979338842975207 | 79 | 13 | 97.9 | 0 | 237 | 1 | 211 | 289 | XP_063676167.1 large ribosomal subunit protein uL18-like [Bolinopsis microptera] | diamond | 237 | 127 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 5472689 | 5472689 | PRJNA263496_P_NODE_21445_length_167_cov_0.864407_g21192_i0 | PRJNA263496 | 21445 | 167 | 0.864407 | 1.44355969 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 116 | 5.909999999999999e-32 | NR | XP_063681480.1 | 2820187 | g21192 | i0 | 94.5 | 0.988023952095808 | 55 | 3 | 98.8 | 0 | 167 | 3 | 35 | 89 | XP_063681480.1 small ribosomal subunit protein uS8-like [Bolinopsis microptera] | diamond | 165 | 116 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 14398251 | 14398251 | PRJNA263496_P_NODE_18772_length_179_cov_1.361538_g18519_i0 | PRJNA263496 | 18772 | 179 | 1.361538 | 2.43715302 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 112 | 4.1800000000000005e-27 | NR | XP_063687467.1 | 2820187 | g18519 | i0 | 91.5 | 0.988826815642458 | 59 | 5 | 98.9 | 0 | 179 | 3 | 365 | 423 | XP_063687467.1 large ribosomal subunit protein uL30-like [Bolinopsis microptera] | diamond | 177 | 112 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 15084780 | 15084780 | PRJNA263496_P_NODE_6352_length_326_cov_1.057762_g6099_i0 | PRJNA263496 | 6352 | 326 | 1.057762 | 3.44830412 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 190 | 4.21e-60 | NR | XP_063694823.1 | 2820187 | g6099 | i0 | 94.1 | 0.929447852760736 | 101 | 6 | 92.9 | 0 | 305 | 3 | 1 | 101 | XP_063694823.1 large ribosomal subunit protein uL14 isoform X2 [Bolinopsis microptera] | diamond | 303 | 190 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 16946345 | 16946345 | PRJNA263496_P_NODE_11794_length_228_cov_1.324022_g11541_i0 | PRJNA263496 | 11794 | 228 | 1.324022 | 3.01877016 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 161 | 8.76e-49 | NR | XP_063693088.1 | 2820187 | g11541 | i0 | 96 | 0.986842105263158 | 75 | 3 | 98.7 | 0 | 226 | 2 | 60 | 134 | XP_063693088.1 large ribosomal subunit protein uL5-like [Bolinopsis microptera] | diamond | 225 | 161 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 27232040 | 27232040 | PRJNA263496_P_NODE_15903_length_196_cov_1.034014_g15650_i0 | PRJNA263496 | 15903 | 196 | 1.034014 | 2.02666744 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 88.6 | 6.76e-20 | NR | XP_063695262.1 | 2820187 | g15650 | i0 | 73.6 | 1.62244897959184 | 53 | 14 | 81.1 | 0 | 1 | 159 | 142 | 194 | XP_063695262.1 elongation factor 1-delta-like [Bolinopsis microptera] | diamond | 318 | 88.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 27390273 | 27390273 | PRJNA263496_P_NODE_13903_length_210_cov_0.950311_g13650_i0 | PRJNA263496 | 13903 | 210 | 0.950311 | 1.9956531 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 124 | 3.15e-32 | NR | XP_063689673.1 | 2820187 | g13650 | i0 | 85.5 | 0.985714285714286 | 69 | 10 | 98.6 | 0 | 209 | 3 | 312 | 380 | XP_063689673.1 large ribosomal subunit protein uL3-like [Bolinopsis microptera] | diamond | 207 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 27926865 | 27926865 | PRJNA263496_P_NODE_23945_length_163_cov_0.894737_g23692_i0 | PRJNA263496 | 23945 | 163 | 0.894737 | 1.45842131 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 100 | 3.9099999999999996e-24 | NR | XP_063678349.1 | 2820187 | g23692 | i0 | 88.7 | 0.975460122699387 | 53 | 6 | 97.5 | 0 | 3 | 161 | 71 | 123 | XP_063678349.1 large ribosomal subunit protein uL2-like [Bolinopsis microptera] | diamond | 159 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 27958437 | 27958437 | PRJNA263496_P_NODE_12905_length_218_cov_1.207101_g12652_i0 | PRJNA263496 | 12905 | 218 | 1.207101 | 2.63148018 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 79.7 | 2.54e-15 | NR | XP_063674738.1 | 2820187 | g12652 | i0 | 64 | 1.03211009174312 | 75 | 15 | 99.1 | 3 | 216 | 1 | 1125 | 1190 | XP_063674738.1 RRP12-like protein [Bolinopsis microptera] | diamond | 225 | 79.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 28305735 | 28305735 | PRJNA263496_P_NODE_24726_length_162_cov_0.902655_g24473_i0 | PRJNA263496 | 24726 | 162 | 0.902655 | 1.4623011 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 89.4 | 9.84e-20 | NR | XP_063692358.1 | 2820187 | g24473 | i0 | 73.1 | 0.962962962962963 | 52 | 14 | 96.3 | 0 | 7 | 162 | 20 | 71 | XP_063692358.1 thioredoxin-like protein 1 [Bolinopsis microptera] | diamond | 156 | 89.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 29379275 | 29379275 | PRJNA263496_P_NODE_21949_length_166_cov_0.871795_g21696_i0 | PRJNA263496 | 21949 | 166 | 0.871795 | 1.4471797 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 87 | 3.28e-18 | NR | XP_063681657.1 | 2820187 | g21696 | i0 | 81.5 | 0.975903614457831 | 54 | 10 | 97.6 | 0 | 166 | 5 | 1347 | 1400 | XP_063681657.1 cilia- and flagella-associated protein 43-like [Bolinopsis microptera] | diamond | 162 | 87 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 30168611 | 30168611 | PRJNA263496_P_NODE_15832_length_196_cov_1.387755_g15579_i0 | PRJNA263496 | 15832 | 196 | 1.387755 | 2.7199998 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 112 | 4.59e-27 | NR | XP_063695316.1 | 2820187 | g15579 | i0 | 85 | 0.918367346938776 | 60 | 9 | 91.8 | 0 | 180 | 1 | 389 | 448 | XP_063695316.1 zinc finger protein OZF-like [Bolinopsis microptera] | diamond | 180 | 112 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 30484835 | 30484835 | PRJNA263496_P_NODE_21833_length_166_cov_0.871795_g21580_i0 | PRJNA263496 | 21833 | 166 | 0.871795 | 1.4471797 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 90.1 | 2.59e-19 | NR | XP_063689885.1 | 2820187 | g21580 | i0 | 68.5 | 0.975903614457831 | 54 | 17 | 97.6 | 0 | 3 | 164 | 657 | 710 | XP_063689885.1 puromycin-sensitive aminopeptidase-like isoform X2 [Bolinopsis microptera] | diamond | 162 | 90.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 31179527 | 31179527 | PRJNA263496_P_NODE_25555_length_161_cov_0.910714_g25302_i0 | PRJNA263496 | 25555 | 161 | 0.910714 | 1.46624954 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 102 | 1.4499999999999998e-23 | NR | XP_063686698.1 | 2820187 | g25302 | i0 | 86.8 | 0.987577639751553 | 53 | 7 | 98.8 | 0 | 2 | 160 | 423 | 475 | XP_063686698.1 uncharacterized protein LOC134820060 [Bolinopsis microptera] | diamond | 159 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 32350493 | 32350493 | PRJNA263496_P_NODE_11859_length_227_cov_2.859551_g11606_i0 | PRJNA263496 | 11859 | 227 | 2.859551 | 6.49118077 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 143 | 6.55e-41 | NR | XP_063678359.1 | 2820187 | g11606 | i0 | 90.5 | 0.977973568281938 | 74 | 7 | 97.8 | 0 | 1 | 222 | 159 | 232 | XP_063678359.1 uncharacterized protein LOC134814223 [Bolinopsis microptera] | diamond | 222 | 143 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 32350500 | 32350500 | PRJNA263496_P_NODE_22999_length_164_cov_1.695652_g22746_i0 | PRJNA263496 | 22999 | 164 | 1.695652 | 2.78086928 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 105 | 1.04e-26 | NR | XP_063694693.1 | 2820187 | g22746 | i0 | 98.1 | 0.98780487804878 | 54 | 1 | 98.8 | 0 | 163 | 2 | 113 | 166 | XP_063694693.1 small ribosomal subunit protein uS4-like [Bolinopsis microptera] | diamond | 162 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 32760649 | 32760649 | PRJNA263496_P_NODE_16520_length_192_cov_0.993007_g16267_i0 | PRJNA263496 | 16520 | 192 | 0.993007 | 1.90657344 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 108 | 2.12e-28 | NR | XP_063687836.1 | 2820187 | g16267 | i0 | 88.9 | 0.984375 | 63 | 7 | 98.4 | 0 | 191 | 3 | 37 | 99 | XP_063687836.1 large ribosomal subunit protein eL24-like [Bolinopsis microptera] | diamond | 189 | 108 | 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);;