contig_metadata
5 rows where bioproject = "PRJNA688736" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10871859 | 10871859 | PRJNA688736_P_NODE_33389_length_278_cov_1.082927_g33104_i0 | PRJNA688736 | 33389 | 278 | 1.082927 | 3.01053706 | Lineus longissimus | 88925 | Nemertea | other_Eukaryota | 170 | 7.5900000000000005e-50 | NR | XP_064652273.1 | 88925 | g33104 | i0 | 79.1 | 13.7158273381295 | 91 | 19 | 98.2 | 0 | 5 | 277 | 259 | 349 | XP_064652273.1 cathepsin B-like [Lineus longissimus] | diamond | 3813 | 170 | 1 | Eukaryota | Opisthokonta | Metazoa | Nemertea | Pilidiophora | Heteronemertea | Lineidae | Lineus | Lineus longissimus | |
| 14696737 | 14696737 | PRJNA688736_P_NODE_34152_length_274_cov_2.890547_g33867_i0 | PRJNA688736 | 34152 | 274 | 2.890547 | 7.92009878 | Cerebratulus lacteus | 6221 | Nemertea | other_Eukaryota | 139 | 1.88e-28 | NTclustered | gi|659835143|gb|KJ701250.1| | 6221 | g33867 | i0 | 83.673 | 2.05109489051095 | 147 | 24 | 54 | 0 | 53 | 199 | 15 | 161 | Cerebratulus lacteus ribosomal protein S29 mRNA, partial cds | blastn | 562 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Nemertea | Pilidiophora | Heteronemertea | Lineidae | Cerebratulus | Cerebratulus lacteus | |
| 29671297 | 29671297 | PRJNA688736_P_NODE_48450_length_244_cov_0.912281_g48165_i0 | PRJNA688736 | 48450 | 244 | 0.912281 | 2.22596564 | Lineus longissimus | 88925 | Nemertea | other_Eukaryota | 70.9 | 4.64e-12 | NR | XP_064627340.1 | 88925 | g48165 | i0 | 58.1 | 1.77049180327869 | 74 | 29 | 91 | 1 | 243 | 22 | 430 | 501 | XP_064627340.1 heme transporter FLVCR2-like isoform X2 [Lineus longissimus] | diamond | 432 | 70.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nemertea | Pilidiophora | Heteronemertea | Lineidae | Lineus | Lineus longissimus | |
| 30947075 | 30947075 | PRJNA688736_P_NODE_51254_length_237_cov_2.359756_g50969_i0 | PRJNA688736 | 51254 | 237 | 2.359756 | 5.59262172 | Metazoa | 33208 | Nemertea | other_Eukaryota | 45.1 | 0.00517 | NR | XP_064625900.1 | 88925 | g50969 | i0 | 80 | 3.65822784810127 | 25 | 5 | 31.6 | 0 | 162 | 236 | 1 | 25 | XP_064625900.1 protein-L-isoaspartate O-methyltransferase domain-containing protein 1-like [Lineus longissimus] | diamond | 867 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nemertea | Pilidiophora | Heteronemertea | Lineidae | Lineus | Lineus longissimus | |
| 32010529 | 32010529 | PRJNA688736_P_NODE_6778_length_563_cov_2.471429_g6496_i0 | PRJNA688736 | 6778 | 563 | 2.471429 | 13.91414527 | Lineus viridis | 56195 | Nemertea | other_Eukaryota | 202 | 7.73e-64 | NR | ABZ04243.1 | 56195 | g6496 | i0 | 80 | 5.04085257548845 | 125 | 25 | 66.6 | 0 | 34 | 408 | 1 | 125 | ABZ04243.1 ribosomal protein rpl35a [Lineus viridis] | diamond | 2838 | 202 | 1 | Eukaryota | Opisthokonta | Metazoa | Nemertea | Pilidiophora | Heteronemertea | Lineidae | Lineus | Lineus viridis |
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);;