contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA379145" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13827441 | 13827441 | PRJNA379145_P_NODE_22951_length_533_cov_2.320000_g20979_i0 | PRJNA379145 | 22951 | 533 | 2.32 | 12.3656 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 210 | 8.439999999999999e-66 | NR | XP_063685016.1 | 2820187 | g20979 | i0 | 61 | 2.67354596622889 | 164 | 62 | 91.2 | 1 | 532 | 47 | 48 | 211 | XP_063685016.1 ras-related protein Rab-14-like [Bolinopsis microptera] | diamond | 1425 | 210 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 15101908 | 15101908 | PRJNA379145_P_NODE_9912_length_957_cov_7.064935_g8769_i0 | PRJNA379145 | 9912 | 957 | 7.064935 | 67.61142795 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 104 | 1.18e-20 | NR | XP_063688692.1 | 2820187 | g8769 | i0 | 28.8 | 1.47962382445141 | 236 | 130 | 64.3 | 8 | 869 | 255 | 111 | 339 | XP_063688692.1 multiple C2 and transmembrane domain-containing protein 1-like isoform X2 [Bolinopsis microptera] | diamond | 1416 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 26916766 | 26916766 | PRJNA379145_P_NODE_38662_length_315_cov_1.627660_g36511_i0 | PRJNA379145 | 38662 | 315 | 1.62766 | 5.127129 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 45.4 | 0.00939 | NR | XP_063676184.1 | 2820187 | g36511 | i0 | 44.4 | 0.514285714285714 | 54 | 24 | 46.7 | 2 | 313 | 167 | 266 | 318 | XP_063676184.1 uncharacterized protein LOC134812626 isoform X2 [Bolinopsis microptera] | diamond | 162 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 26948298 | 26948298 | PRJNA379145_P_NODE_50842_length_229_cov_1.494898_g48688_i0 | PRJNA379145 | 50842 | 229 | 1.494898 | 3.42331642 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 55.1 | 1.35e-6 | NR | XP_063685476.1 | 2820187 | g48688 | i0 | 42.7 | 2.93449781659389 | 82 | 38 | 98.3 | 3 | 5 | 229 | 201 | 280 | XP_063685476.1 uncharacterized protein LOC134819450 [Bolinopsis microptera] | diamond | 672 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 27169485 | 27169485 | PRJNA379145_P_NODE_12862_length_816_cov_5.065134_g11428_i0 | PRJNA379145 | 12862 | 816 | 5.065134 | 41.33149344 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 48.5 | 0.00433 | NR | XP_063689247.1 | 2820187 | g11428 | i0 | 55.3 | 0.139705882352941 | 38 | 17 | 14 | 0 | 65 | 178 | 34 | 71 | XP_063689247.1 neo-calmodulin-like [Bolinopsis microptera] | diamond | 114 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 27327890 | 27327890 | PRJNA379145_P_NODE_18003_length_644_cov_4.000000_g16227_i0 | PRJNA379145 | 18003 | 644 | 4 | 25.76 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 88.6 | 1.17e-18 | NR | XP_063675789.1 | 2820187 | g16227 | i0 | 37.6 | 0.433229813664596 | 93 | 58 | 43.3 | 0 | 24 | 302 | 19 | 111 | XP_063675789.1 GEL complex subunit OPTI-like [Bolinopsis microptera] | diamond | 279 | 88.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 27643853 | 27643853 | PRJNA379145_P_NODE_49844_length_234_cov_2.154229_g47690_i0 | PRJNA379145 | 49844 | 234 | 2.154229 | 5.04089586 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 102 | 3.3e-23 | NR | XP_063695142.1 | 2820187 | g47690 | i0 | 58.9 | 2.84615384615385 | 73 | 30 | 93.6 | 0 | 6 | 224 | 443 | 515 | XP_063695142.1 uncharacterized protein LOC134826617 isoform X2 [Bolinopsis microptera] | diamond | 666 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 27833023 | 27833023 | PRJNA379145_P_NODE_61964_length_182_cov_1.617450_g59810_i0 | PRJNA379145 | 61964 | 182 | 1.61745 | 2.943759 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 75.9 | 2.79e-15 | NR | XP_063693109.1 | 2820187 | g59810 | i0 | 91.4 | 55.9450549450549 | 35 | 3 | 57.7 | 0 | 181 | 77 | 145 | 179 | XP_063693109.1 ADP-ribosylation factor 1 isoform X2 [Bolinopsis microptera] | diamond | 10182 | 75.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 28401400 | 28401400 | PRJNA379145_P_NODE_40446_length_299_cov_2.116541_g38295_i0 | PRJNA379145 | 40446 | 299 | 2.116541 | 6.32845759 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 79.3 | 4.91e-15 | NR | XP_063681920.1 | 2820187 | g38295 | i0 | 55.9 | 0.591973244147157 | 59 | 26 | 59.2 | 0 | 177 | 1 | 118 | 176 | XP_063681920.1 uncharacterized protein LOC134816850 [Bolinopsis microptera] | diamond | 177 | 79.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 28906339 | 28906339 | PRJNA379145_P_NODE_18428_length_634_cov_3.886855_g16634_i0 | PRJNA379145 | 18428 | 634 | 3.886855 | 24.6426607 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 87.4 | 2.95e-18 | NR | XP_063675789.1 | 2820187 | g16634 | i0 | 37.6 | 0.44006309148265 | 93 | 58 | 44 | 0 | 24 | 302 | 19 | 111 | XP_063675789.1 GEL complex subunit OPTI-like [Bolinopsis microptera] | diamond | 279 | 87.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 28906411 | 28906411 | PRJNA379145_P_NODE_60808_length_186_cov_1.464052_g58654_i0 | PRJNA379145 | 60808 | 186 | 1.464052 | 2.72313672 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 62 | 2.83e-9 | NR | XP_063674213.1 | 2820187 | g58654 | i0 | 52 | 1.59677419354839 | 50 | 23 | 80.6 | 1 | 13 | 162 | 432 | 480 | XP_063674213.1 cholesterol 24-hydroxylase-like [Bolinopsis microptera] | diamond | 297 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 29222498 | 29222498 | PRJNA379145_P_NODE_33649_length_368_cov_1.689552_g31505_i0 | PRJNA379145 | 33649 | 368 | 1.689552 | 6.21755136 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 59.7 | 1.81e-7 | NR | XP_063684366.1 | 2820187 | g31505 | i0 | 49.1 | 0.464673913043478 | 57 | 28 | 46.5 | 1 | 289 | 119 | 378 | 433 | XP_063684366.1 uncharacterized protein LOC134818658 [Bolinopsis microptera] | diamond | 171 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 30959678 | 30959678 | PRJNA379145_P_NODE_26014_length_478_cov_2.177528_g23964_i0 | PRJNA379145 | 26014 | 478 | 2.177528 | 10.40858384 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 160 | 6.1e-45 | NR | XP_063681920.1 | 2820187 | g23964 | i0 | 60 | 0.721757322175732 | 115 | 46 | 72.2 | 0 | 477 | 133 | 53 | 167 | XP_063681920.1 uncharacterized protein LOC134816850 [Bolinopsis microptera] | diamond | 345 | 160 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 32161560 | 32161560 | PRJNA379145_P_NODE_28998_length_431_cov_3.022613_g26897_i0 | PRJNA379145 | 28998 | 431 | 3.022613 | 13.02746203 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 48.9 | 0.00176 | NR | XP_063690777.1 | 2820187 | g26897 | i0 | 30.8 | 1.35034802784223 | 104 | 65 | 71 | 2 | 105 | 410 | 360 | 458 | XP_063690777.1 uncharacterized protein LOC134823294 isoform X1 [Bolinopsis microptera] | diamond | 582 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 32761540 | 32761540 | PRJNA379145_P_NODE_10440_length_928_cov_5.043575_g9254_i0 | PRJNA379145 | 10440 | 928 | 5.043575 | 46.804376 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 48.9 | 0.0112 | NR | XP_063674139.1 | 2820187 | g9254 | i0 | 26.4 | 1.23168103448276 | 129 | 84 | 41.4 | 3 | 866 | 483 | 20 | 138 | XP_063674139.1 transmembrane protein 150A-like [Bolinopsis microptera] | diamond | 1143 | 48.9 | 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);;