contig_metadata
11 rows where bioproject = "PRJNA743294" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3273224 | 3273224 | PRJNA743294_P_NODE_12403_length_452_cov_2.686016_g11947_i0 | PRJNA743294 | 12403 | 452 | 2.686016 | 12.14079232 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 157 | 3.6999999999999995e-44 | NR | XP_063676953.1 | 2820187 | g11947 | i0 | 52.9 | 1.0287610619469 | 155 | 68 | 99.6 | 3 | 3 | 452 | 22 | 176 | XP_063676953.1 procathepsin L-like [Bolinopsis microptera] | diamond | 465 | 157 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 8375377 | 8375377 | PRJNA743294_P_NODE_35807_length_282_cov_1.224880_g35351_i0 | PRJNA743294 | 35807 | 282 | 1.22488 | 3.4541616 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 144 | 1.67e-41 | NR | XP_063680454.1 | 2820187 | g35351 | i0 | 72 | 2.96808510638298 | 93 | 26 | 98.9 | 0 | 2 | 280 | 3 | 95 | XP_063680454.1 large ribosomal subunit protein uL13-like [Bolinopsis microptera] | diamond | 837 | 144 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 10926020 | 10926020 | PRJNA743294_P_NODE_3849_length_771_cov_1.879656_g3454_i0 | PRJNA743294 | 3849 | 771 | 1.879656 | 14.49214776 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 208 | 2.21e-57 | NR | XP_063686310.1 | 2820187 | g3454 | i0 | 76.1 | 3.2295719844358 | 142 | 33 | 54.9 | 1 | 208 | 630 | 247 | 388 | XP_063686310.1 kinesin-like protein KIF17 isoform X5 [Bolinopsis microptera] | diamond | 2490 | 208 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 27021021 | 27021021 | PRJNA743294_P_NODE_42082_length_263_cov_1.431579_g41626_i0 | PRJNA743294 | 42082 | 263 | 1.431579 | 3.76505277 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 68.9 | 1.05e-12 | NR | XP_063680833.1 | 2820187 | g41626 | i0 | 40.8 | 1.7680608365019 | 76 | 45 | 86.7 | 0 | 36 | 263 | 31 | 106 | XP_063680833.1 LITAF domain-containing protein-like [Bolinopsis microptera] | diamond | 465 | 68.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 27526573 | 27526573 | PRJNA743294_P_NODE_49923_length_249_cov_0.886364_g49467_i0 | PRJNA743294 | 49923 | 249 | 0.886364 | 2.20704636 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 45.8 | 0.00334 | NR | XP_063678177.1 | 2820187 | g49467 | i0 | 37.3 | 2.4578313253012 | 75 | 46 | 89.2 | 1 | 23 | 244 | 1144 | 1218 | XP_063678177.1 phospholipid-transporting ATPase ABCA3-like isoform X1 [Bolinopsis microptera] | diamond | 612 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 27653006 | 27653006 | PRJNA743294_P_NODE_27664_length_315_cov_1.264463_g27208_i0 | PRJNA743294 | 27664 | 315 | 1.264463 | 3.98305845 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 52.4 | 3.21e-5 | NR | XP_063682838.1 | 2820187 | g27208 | i0 | 48.9 | 4.22857142857143 | 47 | 22 | 42.9 | 1 | 199 | 65 | 253 | 299 | XP_063682838.1 activator of 90 kDa heat shock protein ATPase homolog 1-like isoform X1 [Bolinopsis microptera] | diamond | 1332 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 27905225 | 27905225 | PRJNA743294_P_NODE_47985_length_251_cov_0.876404_g47529_i0 | PRJNA743294 | 47985 | 251 | 0.876404 | 2.19977404 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 55.1 | 5.31e-7 | NR | XP_063675060.1 | 2820187 | g47529 | i0 | 47.7 | 1.1593625498008 | 44 | 23 | 52.6 | 0 | 246 | 115 | 104 | 147 | XP_063675060.1 uncharacterized protein LOC134811879 [Bolinopsis microptera] | diamond | 291 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 29547165 | 29547165 | PRJNA743294_P_NODE_58990_length_230_cov_2.127389_g58534_i0 | PRJNA743294 | 58990 | 230 | 2.127389 | 4.8929947 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 135 | 1.83e-36 | NR | XP_063691691.1 | 2820187 | g58534 | i0 | 79.7 | 0.965217391304348 | 74 | 15 | 96.5 | 0 | 225 | 4 | 185 | 258 | XP_063691691.1 arginine kinase-like isoform X2 [Bolinopsis microptera] | diamond | 222 | 135 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 29894759 | 29894759 | PRJNA743294_P_NODE_15211_length_411_cov_4.505917_g14755_i0 | PRJNA743294 | 15211 | 411 | 4.505917 | 18.51931887 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 98.2 | 5.98e-22 | NR | XP_063681689.1 | 2820187 | g14755 | i0 | 43.8 | 1.86861313868613 | 128 | 69 | 92.7 | 2 | 410 | 30 | 72 | 197 | XP_063681689.1 piwi-like protein 1 [Bolinopsis microptera] | diamond | 768 | 98.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 30242327 | 30242327 | PRJNA743294_P_NODE_52212_length_246_cov_1.803468_g51756_i0 | PRJNA743294 | 52212 | 246 | 1.803468 | 4.43653128 | Bolinopsis microptera | 2820187 | Ctenophora | other_Eukaryota | 84.3 | 8.24e-17 | NR | XP_063694466.1 | 2820187 | g51756 | i0 | 70.6 | 4.36585365853659 | 51 | 15 | 62.2 | 0 | 2 | 154 | 459 | 509 | XP_063694466.1 V-type proton ATPase subunit B [Bolinopsis microptera] | diamond | 1074 | 84.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis microptera | |
| 32234246 | 32234246 | PRJNA743294_P_NODE_44678_length_256_cov_2.879781_g44222_i0 | PRJNA743294 | 44678 | 256 | 2.879781 | 7.37223936 | Bolinopsis infundibulum | 140455 | Ctenophora | other_Eukaryota | 54.3 | 3.61e-6 | NR | AQX17833.1 | 140455 | g44222 | i0 | 37.3 | 0.97265625 | 83 | 51 | 97.3 | 1 | 4 | 252 | 180 | 261 | AQX17833.1 tyrosine aminotransferase [Bolinopsis infundibulum] | diamond | 249 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Ctenophora | Tentaculata | Lobata | Bolinopsidae | Bolinopsis | Bolinopsis infundibulum |
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);;