contig_metadata
9 rows where bioproject = "PRJNA520845" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 489140 | 489140 | PRJNA520845_P_NODE_17521_length_928_cov_6.835088_g16311_i0 | PRJNA520845 | 17521 | 928 | 6.835088 | 63.42961664 | Lineus viridis | 56195 | Nemertea | other_Eukaryota | 288 | 3.77e-94 | NR | ABZ04225.1 | 56195 | g16311 | i0 | 65.3 | 26.2790948275862 | 219 | 74 | 70.8 | 1 | 902 | 246 | 1 | 217 | ABZ04225.1 ribosomal protein rpl10a [Lineus viridis] | diamond | 24387 | 288 | 1 | Eukaryota | Opisthokonta | Metazoa | Nemertea | Pilidiophora | Heteronemertea | Lineidae | Lineus | Lineus viridis | |
| 1763929 | 1763929 | PRJNA520845_P_NODE_156122_length_298_cov_1.742222_g154623_i0 | PRJNA520845 | 156122 | 298 | 1.742222 | 5.19182156 | Cerebratulus lacteus | 6221 | Nemertea | other_Eukaryota | 134 | 9.61e-27 | NTclustered | gi|584614319|gb|KF887964.1| | 6221 | g154623 | i0 | 87.719 | 16.2818791946309 | 114 | 14 | 38 | 0 | 183 | 296 | 1429 | 1316 | Cerebratulus lacteus alpha-tubulin mRNA, complete cds | blastn | 4852 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Nemertea | Pilidiophora | Heteronemertea | Lineidae | Cerebratulus | Cerebratulus lacteus | |
| 9415361 | 9415361 | PRJNA520845_P_NODE_103708_length_365_cov_1.756849_g102209_i0 | PRJNA520845 | 103708 | 365 | 1.756849 | 6.41249885 | Lineus viridis | 56195 | Nemertea | other_Eukaryota | 185 | 3.269999999999999e-42 | NTclustered | gi|166952380|gb|EU302584.1| | 56195 | g102209 | i0 | 81.385 | 5.46849315068493 | 231 | 39 | 63 | 4 | 5 | 233 | 176 | 404 | Lineus viridis ribosomal protein rps27a mRNA, complete cds | blastn | 1996 | 185 | 1 | Eukaryota | Opisthokonta | Metazoa | Nemertea | Pilidiophora | Heteronemertea | Lineidae | Lineus | Lineus viridis | |
| 18339242 | 18339242 | PRJNA520845_P_NODE_116535_length_345_cov_1.661765_g115036_i0 | PRJNA520845 | 116535 | 345 | 1.661765 | 5.73308925 | Lineus longissimus | 88925 | Nemertea | other_Eukaryota | 54.7 | 0.009 | NTclustered | gi|2724570405|ref|XM_064763497.1| | 88925 | g115036 | i0 | 96.875 | 0.278260869565217 | 32 | 1 | 9 | 0 | 110 | 141 | 1721 | 1690 | PREDICTED: Lineus longissimus leucine-rich repeat-containing protein 43-like (LOC135483006), transcript variant X2, mRNA | blastn | 96 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nemertea | Pilidiophora | Heteronemertea | Lineidae | Lineus | Lineus longissimus | |
| 27976953 | 27976953 | PRJNA520845_P_NODE_263125_length_241_cov_1.839286_g261626_i0 | PRJNA520845 | 263125 | 241 | 1.839286 | 4.43267926 | Metazoa | 33208 | Nemertea | other_Eukaryota | 44.3 | 0.00991 | NR | XP_064652967.1 | 88925 | g261626 | i0 | 35.6 | 5.25311203319502 | 59 | 38 | 73.4 | 0 | 36 | 212 | 284 | 342 | XP_064652967.1 elongation factor 1-alpha [Lineus longissimus] | diamond | 1266 | 44.7 | 0.991051454138702 | Eukaryota | Opisthokonta | Metazoa | Nemertea | Pilidiophora | Heteronemertea | Lineidae | Lineus | Lineus longissimus | |
| 28656484 | 28656484 | PRJNA520845_P_NODE_76787_length_424_cov_1.025641_g75288_i0 | PRJNA520845 | 76787 | 424 | 1.025641 | 4.34871784 | Lineus longissimus | 88925 | Nemertea | other_Eukaryota | 206 | 9.28e-63 | NR | XP_064635732.1 | 88925 | g75288 | i0 | 66.2 | 1.96698113207547 | 139 | 47 | 98.3 | 0 | 419 | 3 | 196 | 334 | XP_064635732.1 protein arginine N-methyltransferase 1-like isoform X2 [Lineus longissimus] | diamond | 834 | 206 | 1 | Eukaryota | Opisthokonta | Metazoa | Nemertea | Pilidiophora | Heteronemertea | Lineidae | Lineus | Lineus longissimus | |
| 29303077 | 29303077 | PRJNA520845_P_NODE_268349_length_238_cov_2.333333_g266850_i0 | PRJNA520845 | 268349 | 238 | 2.333333 | 5.55333254 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 69.3 | 1.5e-11 | NR | XP_064621757.1 | 88925 | g266850 | i0 | 40.5 | 3.98319327731092 | 79 | 47 | 99.6 | 0 | 1 | 237 | 333 | 411 | XP_064621757.1 stress-induced-phosphoprotein 1-like isoform X2 [Lineus longissimus] | diamond | 948 | 69.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nemertea | Pilidiophora | Heteronemertea | Lineidae | Lineus | Lineus longissimus | |
| 29319325 | 29319325 | PRJNA520845_P_NODE_235489_length_247_cov_0.885057_g233990_i0 | PRJNA520845 | 235489 | 247 | 0.885057 | 2.18609079 | Lineus longissimus | 88925 | Nemertea | other_Eukaryota | 56.2 | 6.96e-7 | NR | XP_064630927.1 | 88925 | g233990 | i0 | 44.3 | 0.850202429149798 | 70 | 36 | 85 | 1 | 232 | 23 | 448 | 514 | XP_064630927.1 rho-related BTB domain-containing protein 1-like [Lineus longissimus] | diamond | 210 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nemertea | Pilidiophora | Heteronemertea | Lineidae | Lineus | Lineus longissimus | |
| 30092419 | 30092419 | PRJNA520845_P_NODE_266052_length_241_cov_0.916667_g264553_i0 | PRJNA520845 | 266052 | 241 | 0.916667 | 2.20916747 | Metazoa | 33208 | Nemertea | other_Eukaryota | 51.6 | 2.76e-5 | NR | XP_064642562.1 | 88925 | g264553 | i0 | 53.3 | 5.75103734439834 | 45 | 21 | 56 | 0 | 136 | 2 | 168 | 212 | XP_064642562.1 rap1 GTPase-activating protein 1-like isoform X12 [Lineus longissimus] | diamond | 1386 | 51.6 | 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);;