contig_metadata
15 rows where bioproject = "PRJNA565584" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2410482 | 2410482 | PRJNA565584_P_NODE_47122_length_434_cov_2.121884_g45971_i0 | PRJNA565584 | 47122 | 434 | 2.121884 | 9.20897656 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 121 | 1.08e-28 | NR | XP_063674629.1 | 2820187 | g45971 | i0 | 57.3 | 0.988479262672811 | 143 | 61 | 98.8 | 0 | 5 | 433 | 639 | 781 | XP_063674629.1 LOW QUALITY PROTEIN: major vault protein-like [Bolinopsis microptera] | diamond | 429 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 17132414 | 17132414 | PRJNA565584_P_NODE_125574_length_278_cov_1.634146_g124422_i0 | PRJNA565584 | 125574 | 278 | 1.634146 | 4.54292588 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 178 | 4.05e-40 | NTclustered | gi|2700955194|ref|XM_063817774.1| | 2820187 | g124422 | i0 | 78.339 | 65.1546762589928 | 277 | 58 | 99 | 2 | 2 | 277 | 470 | 745 | PREDICTED: Bolinopsis microptera tubulin alpha-1A chain-like (LOC134811063), mRNA | blastn | 18113 | 178 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 27142323 | 27142323 | PRJNA565584_P_NODE_87622_length_317_cov_2.430328_g86470_i0 | PRJNA565584 | 87622 | 317 | 2.430328 | 7.70413976 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 59.3 | 1.28e-7 | NR | XP_063695447.1 | 2820187 | g86470 | i0 | 43.1 | 1.2397476340694 | 65 | 36 | 60.6 | 1 | 219 | 28 | 269 | 333 | XP_063695447.1 digestive cysteine proteinase 2-like [Bolinopsis microptera] | diamond | 393 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 27427216 | 27427216 | PRJNA565584_P_NODE_17383_length_772_cov_9.995708_g16305_i0 | PRJNA565584 | 17383 | 772 | 9.995708 | 77.16686576 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 268 | 2.9399999999999985e-87 | NR | XP_063687402.1 | 2820187 | g16305 | i0 | 68.6 | 0.753886010362694 | 194 | 60 | 75.4 | 1 | 62 | 643 | 1 | 193 | XP_063687402.1 peroxiredoxin-like [Bolinopsis microptera] | diamond | 582 | 268 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 27490312 | 27490312 | PRJNA565584_P_NODE_58463_length_389_cov_0.958861_g57312_i0 | PRJNA565584 | 58463 | 389 | 0.958861 | 3.72996929 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 79 | 3.3e-14 | NR | XP_063679678.1 | 2820187 | g57312 | i0 | 49.2 | 7.51156812339332 | 63 | 32 | 48.6 | 0 | 198 | 386 | 267 | 329 | XP_063679678.1 7SK snRNA methylphosphate capping enzyme-like [Bolinopsis microptera] | diamond | 2922 | 79 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 27837405 | 27837405 | PRJNA565584_P_NODE_56224_length_396_cov_2.777090_g55073_i0 | PRJNA565584 | 56224 | 396 | 2.77709 | 10.9972764 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 129 | 2.27e-32 | NR | XP_063675463.1 | 2820187 | g55073 | i0 | 70.2 | 0.636363636363636 | 84 | 25 | 63.6 | 0 | 253 | 2 | 9 | 92 | XP_063675463.1 peptidyl-prolyl cis-trans isomerase FKBP4-like [Bolinopsis microptera] | diamond | 252 | 129 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 28153494 | 28153494 | PRJNA565584_P_NODE_67465_length_362_cov_0.948097_g66314_i0 | PRJNA565584 | 67465 | 362 | 0.948097 | 3.43211114 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 120 | 2.13e-30 | NR | XP_063681920.1 | 2820187 | g66314 | i0 | 49.2 | 0.977900552486188 | 118 | 58 | 97.8 | 1 | 361 | 8 | 63 | 178 | XP_063681920.1 uncharacterized protein LOC134816850 [Bolinopsis microptera] | diamond | 354 | 120 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 29321475 | 29321475 | PRJNA565584_P_NODE_81309_length_330_cov_0.992218_g80157_i0 | PRJNA565584 | 81309 | 330 | 0.992218 | 3.2743194 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 48.5 | 9.58e-4 | NR | XP_063693375.1 | 2820187 | g80157 | i0 | 31.8 | 0.772727272727273 | 85 | 56 | 77.3 | 1 | 2 | 256 | 165 | 247 | XP_063693375.1 insulin-degrading enzyme-like [Bolinopsis microptera] | diamond | 255 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 29636826 | 29636826 | PRJNA565584_P_NODE_187470_length_247_cov_0.885057_g186318_i0 | PRJNA565584 | 187470 | 247 | 0.885057 | 2.18609079 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 55.1 | 5.97e-7 | NR | XP_063677063.1 | 2820187 | g186318 | i0 | 44.3 | 0.850202429149798 | 70 | 38 | 85 | 1 | 36 | 245 | 94 | 162 | XP_063677063.1 calmodulin-A-like [Bolinopsis microptera] | diamond | 210 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 29763402 | 29763402 | PRJNA565584_P_NODE_66491_length_364_cov_2.113402_g65340_i0 | PRJNA565584 | 66491 | 364 | 2.113402 | 7.69278328 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 60.1 | 8.94e-8 | NR | XP_063676167.1 | 2820187 | g65340 | i0 | 41.8 | 1.60714285714286 | 98 | 42 | 80.8 | 1 | 2 | 295 | 204 | 286 | XP_063676167.1 large ribosomal subunit protein uL18-like [Bolinopsis microptera] | diamond | 585 | 60.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 29889931 | 29889931 | PRJNA565584_P_NODE_101731_length_296_cov_1.636771_g100579_i0 | PRJNA565584 | 101731 | 296 | 1.636771 | 4.84484216 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 144 | 2.9e-41 | NR | XP_063680454.1 | 2820187 | g100579 | i0 | 67.3 | 10.9256756756757 | 98 | 32 | 99.3 | 0 | 295 | 2 | 31 | 128 | XP_063680454.1 large ribosomal subunit protein uL13-like [Bolinopsis microptera] | diamond | 3234 | 144 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 29984708 | 29984708 | PRJNA565584_P_NODE_61031_length_380_cov_2.006515_g59880_i0 | PRJNA565584 | 61031 | 380 | 2.006515 | 7.624757 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 59.3 | 6.08e-8 | NR | XP_063683552.1 | 2820187 | g59880 | i0 | 51.1 | 0.718421052631579 | 45 | 22 | 35.5 | 0 | 200 | 66 | 110 | 154 | XP_063683552.1 cell death-inducing p53-target protein 1 homolog [Bolinopsis microptera] | diamond | 273 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 30774597 | 30774597 | PRJNA565584_P_NODE_127354_length_277_cov_1.509804_g126202_i0 | PRJNA565584 | 127354 | 277 | 1.509804 | 4.18215708 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 95.1 | 2.17e-20 | NR | XP_063678953.1 | 2820187 | g126202 | i0 | 64.1 | 0.844765342960289 | 78 | 21 | 76.9 | 1 | 214 | 2 | 41 | 118 | XP_063678953.1 dynamin-1-like protein [Bolinopsis microptera] | diamond | 234 | 95.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 32007723 | 32007723 | PRJNA565584_P_NODE_57818_length_391_cov_1.081761_g56667_i0 | PRJNA565584 | 57818 | 391 | 1.081761 | 4.22968551 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 53.5 | 2.28e-5 | NR | XP_063676941.1 | 2820187 | g56667 | i0 | 47.7 | 0.966751918158568 | 88 | 38 | 63.7 | 2 | 390 | 142 | 140 | 224 | XP_063676941.1 uncharacterized protein LOC134813184 [Bolinopsis microptera] | diamond | 378 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 32166040 | 32166040 | PRJNA565584_P_NODE_24118_length_636_cov_1.637655_g22985_i0 | PRJNA565584 | 24118 | 636 | 1.637655 | 10.4154858 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 99.8 | 1.06e-22 | NR | XP_063690143.1 | 2820187 | g22985 | i0 | 38.3 | 3.71698113207547 | 128 | 73 | 58 | 4 | 541 | 173 | 19 | 145 | XP_063690143.1 selenoprotein F-like isoform X2 [Bolinopsis microptera] | diamond | 2364 | 99.8 | 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);;