contig_metadata
12 rows where bioproject = "PRJNA533114" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3056464 | 3056464 | PRJNA533114_P_NODE_77123_length_276_cov_1.108374_g76871_i0 | PRJNA533114 | 77123 | 276 | 1.108374 | 3.05911224 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 52.8 | 0.025 | NTclustered | gi|2700946227|ref|XR_010161231.1| | 2820187 | g76871 | i0 | 100 | 0.101449275362319 | 28 | 0 | 10 | 0 | 74 | 101 | 479 | 452 | PREDICTED: Bolinopsis microptera uncharacterized LOC134822878 (LOC134822878), ncRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 15145697 | 15145697 | PRJNA533114_P_NODE_9392_length_734_cov_9.172466_g9167_i0 | PRJNA533114 | 9392 | 734 | 9.172466 | 67.32590044 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 152 | 1.1e-39 | NR | XP_063680754.1 | 2820187 | g9167 | i0 | 49.6 | 1.14441416893733 | 137 | 69 | 56 | 0 | 55 | 465 | 2 | 138 | XP_063680754.1 nucleoredoxin-like [Bolinopsis microptera] | diamond | 840 | 152 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 15807856 | 15807856 | PRJNA533114_P_NODE_48053_length_339_cov_1.187970_g47801_i0 | PRJNA533114 | 48053 | 339 | 1.18797 | 4.0272183 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 125 | 3.9299999999999997e-31 | NR | XP_063683508.1 | 2820187 | g47801 | i0 | 54.9 | 1.82300884955752 | 102 | 46 | 90.3 | 0 | 335 | 30 | 287 | 388 | XP_063683508.1 putative phospholipase B-like 2 [Bolinopsis microptera] | diamond | 618 | 125 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 26950892 | 26950892 | PRJNA533114_P_NODE_110862_length_245_cov_0.895349_g110610_i0 | PRJNA533114 | 110862 | 245 | 0.895349 | 2.19360505 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 73.9 | 3.78e-13 | NR | XP_063695210.1 | 2820187 | g110610 | i0 | 57.6 | 0.808163265306122 | 66 | 26 | 78.4 | 1 | 8 | 199 | 174 | 239 | XP_063695210.1 uncharacterized protein LOC134826670 [Bolinopsis microptera] | diamond | 198 | 73.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 27299067 | 27299067 | PRJNA533114_P_NODE_94523_length_251_cov_0.865169_g94271_i0 | PRJNA533114 | 94523 | 251 | 0.865169 | 2.17157419 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 104 | 6e-24 | NR | XP_063686440.1 | 2820187 | g94271 | i0 | 56.6 | 1.9840637450199201 | 83 | 35 | 99.2 | 1 | 251 | 3 | 79 | 160 | XP_063686440.1 uncharacterized protein LOC134820148 [Bolinopsis microptera] | diamond | 498 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 27804354 | 27804354 | PRJNA533114_P_NODE_42144_length_358_cov_5.003509_g41892_i0 | PRJNA533114 | 42144 | 358 | 5.003509 | 17.91256222 | Mnemiopsis leidyi | 27923 | Ctenophora | other_Eukaryota | 87 | 1.87e-17 | NR | AEY80344.1 | 27923 | g41892 | i0 | 57.8 | 1.60055865921788 | 64 | 27 | 53.6 | 0 | 279 | 88 | 4 | 67 | AEY80344.1 LASP class LIM protein ML038835b [Mnemiopsis leidyi] | diamond | 573 | 87 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Mnemiopsis | Mnemiopsis leidyi | |
| 29193757 | 29193757 | PRJNA533114_P_NODE_98209_length_249_cov_1.522727_g97957_i0 | PRJNA533114 | 98209 | 249 | 1.522727 | 3.79159023 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 46.2 | 0.00242 | NR | XP_063673926.1 | 2820187 | g97957 | i0 | 37 | 0.650602409638554 | 54 | 34 | 65.1 | 0 | 28 | 189 | 29 | 82 | XP_063673926.1 uncharacterized protein LOC134811117 isoform X2 [Bolinopsis microptera] | diamond | 162 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 29288106 | 29288106 | PRJNA533114_P_NODE_72149_length_283_cov_2.919048_g71897_i0 | PRJNA533114 | 72149 | 283 | 2.919048 | 8.26090584 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 56.6 | 7.67e-7 | NR | XP_063684330.1 | 2820187 | g71897 | i0 | 35.7 | 0.890459363957597 | 84 | 43 | 84.8 | 2 | 1 | 240 | 20 | 96 | XP_063684330.1 tRNA:m(4)X modification enzyme TRM13 homolog [Bolinopsis microptera] | diamond | 252 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 29288139 | 29288139 | PRJNA533114_P_NODE_91389_length_254_cov_1.104972_g91137_i0 | PRJNA533114 | 91389 | 254 | 1.104972 | 2.80662888 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 68.9 | 2.52e-11 | NR | XP_063683451.1 | 2820187 | g91137 | i0 | 50 | 0.637795275590551 | 54 | 27 | 63.8 | 0 | 163 | 2 | 53 | 106 | XP_063683451.1 ATP-binding cassette sub-family G member 8-like [Bolinopsis microptera] | diamond | 162 | 68.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 29382939 | 29382939 | PRJNA533114_P_NODE_26709_length_441_cov_1.073370_g26457_i0 | PRJNA533114 | 26709 | 441 | 1.07337 | 4.7335617 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 52.4 | 1.12e-4 | NR | XP_063679135.1 | 2820187 | g26457 | i0 | 25.7 | 0.979591836734694 | 144 | 98 | 98 | 3 | 434 | 3 | 6 | 140 | XP_063679135.1 actin-like [Bolinopsis microptera] | diamond | 432 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 30140529 | 30140529 | PRJNA533114_P_NODE_91932_length_253_cov_1.283333_g91680_i0 | PRJNA533114 | 91932 | 253 | 1.283333 | 3.24683249 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 110 | 5.06e-26 | NR | XP_063677815.1 | 2820187 | g91680 | i0 | 59.5 | 2.98814229249012 | 84 | 34 | 99.6 | 0 | 2 | 253 | 415 | 498 | XP_063677815.1 xaa-Pro dipeptidase-like isoform X1 [Bolinopsis microptera] | diamond | 756 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 31784242 | 31784242 | PRJNA533114_P_NODE_112317_length_244_cov_0.900585_g112065_i0 | PRJNA533114 | 112317 | 244 | 0.900585 | 2.1974274 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 51.6 | 1.64e-5 | NR | XP_063688191.1 | 2820187 | g112065 | i0 | 35 | 0.983606557377049 | 80 | 52 | 98.4 | 0 | 3 | 242 | 16 | 95 | XP_063688191.1 uncharacterized protein LOC134821379 [Bolinopsis microptera] | diamond | 240 | 51.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);;