contig_metadata
11 rows where bioproject = "PRJNA1146029" and tax_phylum = "Nemertea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9218023 | 9218023 | PRJNA1146029_P_NODE_13868_length_265_cov_2.890625_g13587_i0 | PRJNA1146029 | 13868 | 265 | 2.890625 | 7.66015625 | Cerebratulus lacteus | 6221 | Nemertea | other_Eukaryota | 62.1 | 4.02e-5 | NTclustered | gi|937555908|gb|KR336530.1| | 6221 | g13587 | i0 | 97.222 | 0.135849056603774 | 36 | 1 | 14 | 0 | 14 | 49 | 429 | 394 | Cerebratulus lacteus tropomyosin mRNA, complete cds | blastn | 36 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nemertea | Pilidiophora | Heteronemertea | Lineidae | Cerebratulus | Cerebratulus lacteus | |
| 11768822 | 11768822 | PRJNA1146029_P_NODE_21530_length_242_cov_0.911243_g21249_i0 | PRJNA1146029 | 21530 | 242 | 0.911243 | 2.20520806 | Lineus longissimus | 88925 | Nemertea | other_Eukaryota | 114 | 1.03e-28 | NR | XP_064620275.1 | 88925 | g21249 | i0 | 73.1 | 1.66115702479339 | 67 | 18 | 83.1 | 0 | 2 | 202 | 258 | 324 | XP_064620275.1 ADP-ribose pyrophosphatase, mitochondrial-like isoform X2 [Lineus longissimus] | diamond | 402 | 114 | 1 | Eukaryota | Opisthokonta | Metazoa | Nemertea | Pilidiophora | Heteronemertea | Lineidae | Lineus | Lineus longissimus | |
| 11768930 | 11768930 | PRJNA1146029_P_NODE_8350_length_313_cov_1.604167_g8069_i0 | PRJNA1146029 | 8350 | 313 | 1.604167 | 5.02104271 | Lineus viridis | 56195 | Nemertea | other_Eukaryota | 193 | 1.91e-60 | NR | ABZ04260.1 | 56195 | g8069 | i0 | 90.4 | 0.996805111821086 | 104 | 10 | 99.7 | 0 | 2 | 313 | 6 | 109 | ABZ04260.1 ribosomal protein rps8 [Lineus viridis] | diamond | 312 | 193 | 1 | Eukaryota | Opisthokonta | Metazoa | Nemertea | Pilidiophora | Heteronemertea | Lineidae | Lineus | Lineus viridis | |
| 27986574 | 27986574 | PRJNA1146029_P_NODE_16765_length_250_cov_0.870056_g16484_i0 | PRJNA1146029 | 16765 | 250 | 0.870056 | 2.17514 | Lineus longissimus | 88925 | Nemertea | other_Eukaryota | 152 | 1.26e-41 | NR | XP_064625307.1 | 88925 | g16484 | i0 | 78.3 | 0.996 | 83 | 18 | 99.6 | 0 | 2 | 250 | 289 | 371 | XP_064625307.1 protein wntless homolog [Lineus longissimus] | diamond | 249 | 152 | 1 | Eukaryota | Opisthokonta | Metazoa | Nemertea | Pilidiophora | Heteronemertea | Lineidae | Lineus | Lineus longissimus | |
| 28365268 | 28365268 | PRJNA1146029_P_NODE_19846_length_245_cov_0.895349_g19565_i0 | PRJNA1146029 | 19846 | 245 | 0.895349 | 2.19360505 | Lineus longissimus | 88925 | Nemertea | other_Eukaryota | 54.7 | 2.39e-6 | NR | XP_064625174.1 | 88925 | g19565 | i0 | 55.2 | 1.64081632653061 | 67 | 19 | 82 | 2 | 201 | 1 | 1217 | 1272 | XP_064625174.1 microtubule-associated serine/threonine-protein kinase 2-like isoform X14 [Lineus longissimus] | diamond | 402 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nemertea | Pilidiophora | Heteronemertea | Lineidae | Lineus | Lineus longissimus | |
| 29996458 | 29996458 | PRJNA1146029_P_NODE_14251_length_263_cov_1.326316_g13970_i0 | PRJNA1146029 | 14251 | 263 | 1.326316 | 3.48821108 | Metazoa | 33208 | Nemertea | other_Eukaryota | 158 | 9.439999999999999e-43 | NR | XP_064651861.1 | 88925 | g13970 | i0 | 85.5 | 4.74524714828897 | 83 | 12 | 94.7 | 0 | 249 | 1 | 61 | 143 | XP_064651861.1 protein argonaute-2-like isoform X1 [Lineus longissimus] | diamond | 1248 | 159 | 0.993710691823899 | Eukaryota | Opisthokonta | Metazoa | Nemertea | Pilidiophora | Heteronemertea | Lineidae | Lineus | Lineus longissimus | |
| 30038935 | 30038935 | PRJNA1146029_P_NODE_10011_length_290_cov_1.262673_g9730_i0 | PRJNA1146029 | 10011 | 290 | 1.262673 | 3.6617517 | Lineus longissimus | 88925 | Nemertea | other_Eukaryota | 51.2 | 7.23e-5 | NR | XP_064626611.1 | 88925 | g9730 | i0 | 44 | 1.55172413793103 | 50 | 28 | 51.7 | 0 | 3 | 152 | 10454 | 10503 | XP_064626611.1 uncharacterized protein LOC135487134 isoform X8 [Lineus longissimus] | diamond | 450 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nemertea | Pilidiophora | Heteronemertea | Lineidae | Lineus | Lineus longissimus | |
| 31872183 | 31872183 | PRJNA1146029_P_NODE_19117_length_246_cov_0.890173_g18836_i0 | PRJNA1146029 | 19117 | 246 | 0.890173 | 2.18982558 | Lineus longissimus | 88925 | Nemertea | other_Eukaryota | 67 | 1.05e-10 | NR | XP_064627142.1 | 88925 | g18836 | i0 | 66 | 3.0609756097561 | 50 | 17 | 61 | 0 | 227 | 78 | 458 | 507 | XP_064627142.1 catalase-like [Lineus longissimus] | diamond | 753 | 67 | 1 | Eukaryota | Opisthokonta | Metazoa | Nemertea | Pilidiophora | Heteronemertea | Lineidae | Lineus | Lineus longissimus | |
| 31903815 | 31903815 | PRJNA1146029_P_NODE_20237_length_244_cov_0.900585_g19956_i0 | PRJNA1146029 | 20237 | 244 | 0.900585 | 2.1974274 | Lineus longissimus | 88925 | Nemertea | other_Eukaryota | 90.1 | 6.42e-19 | NR | XP_064619050.1 | 88925 | g19956 | i0 | 60.3 | 0.836065573770492 | 68 | 26 | 82.4 | 1 | 203 | 3 | 1 | 68 | XP_064619050.1 stabilizer of axonemal microtubules 2-like isoform X2 [Lineus longissimus] | diamond | 204 | 90.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nemertea | Pilidiophora | Heteronemertea | Lineidae | Lineus | Lineus longissimus | |
| 31903819 | 31903819 | PRJNA1146029_P_NODE_6197_length_354_cov_1.330961_g5919_i0 | PRJNA1146029 | 6197 | 354 | 1.330961 | 4.71160194 | Lineus longissimus | 88925 | Nemertea | other_Eukaryota | 46.6 | 0.00616 | NR | XP_064624395.1 | 88925 | g5919 | i0 | 27.5 | 0.923728813559322 | 109 | 70 | 92.4 | 3 | 6 | 332 | 1094 | 1193 | XP_064624395.1 uncharacterized protein LOC135485929 [Lineus longissimus] | diamond | 327 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nemertea | Pilidiophora | Heteronemertea | Lineidae | Lineus | Lineus longissimus | |
| 32631078 | 32631078 | PRJNA1146029_P_NODE_1340_length_770_cov_1.338594_g1095_i0 | PRJNA1146029 | 1340 | 770 | 1.338594 | 10.3071738 | Lineus longissimus | 88925 | Nemertea | other_Eukaryota | 82 | 1.14e-14 | NR | XP_064624363.1 | 88925 | g1095 | i0 | 43.2 | 1.58571428571429 | 81 | 46 | 31.6 | 0 | 770 | 528 | 91 | 171 | XP_064624363.1 selenoprotein Pb-like isoform X1 [Lineus longissimus] | diamond | 1221 | 82 | 1 | Eukaryota | Opisthokonta | Metazoa | Nemertea | Pilidiophora | Heteronemertea | Lineidae | Lineus | Lineus longissimus |
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);;