contig_metadata
12 rows where bioproject = "PRJNA345071", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8046546 | 8046546 | PRJNA345071_P_NODE_1227_length_488_cov_3.342169_g1187_i0 | PRJNA345071 | 1227 | 488 | 3.342169 | 16.30978472 | Lineus viridis | 56195 | Nemertea | other_Eukaryota | 234 | 2.15e-75 | NR | ABZ04260.1 | 56195 | g1187 | i0 | 77.3 | 2.79098360655738 | 150 | 34 | 92.2 | 0 | 452 | 3 | 1 | 150 | ABZ04260.1 ribosomal protein rps8 [Lineus viridis] | diamond | 1362 | 234 | 1 | Eukaryota | Opisthokonta | Metazoa | Nemertea | Pilidiophora | Heteronemertea | Lineidae | Lineus | Lineus viridis | |
| 9321296 | 9321296 | PRJNA345071_P_NODE_188_length_1015_cov_2.719745_g164_i0 | PRJNA345071 | 188 | 1015 | 2.719745 | 27.60541175 | Lineus longissimus | 88925 | Nemertea | other_Eukaryota | 259 | 3.12e-75 | NR | XP_064629748.1 | 88925 | g164 | i0 | 49.2 | 0.697536945812808 | 236 | 116 | 69.5 | 3 | 3 | 707 | 689 | 921 | XP_064629748.1 deleted in malignant brain tumors 1 protein-like [Lineus longissimus] | diamond | 708 | 259 | 1 | Eukaryota | Opisthokonta | Metazoa | Nemertea | Pilidiophora | Heteronemertea | Lineidae | Lineus | Lineus longissimus | |
| 11871926 | 11871926 | PRJNA345071_P_NODE_230_length_943_cov_2.109195_g201_i0 | PRJNA345071 | 230 | 943 | 2.109195 | 19.88970885 | Lineus longissimus | 88925 | Nemertea | other_Eukaryota | 248 | 2.69e-71 | NR | XP_064629748.1 | 88925 | g201 | i0 | 50 | 0.699893955461294 | 220 | 106 | 69.7 | 3 | 943 | 287 | 705 | 921 | XP_064629748.1 deleted in malignant brain tumors 1 protein-like [Lineus longissimus] | diamond | 660 | 248 | 1 | Eukaryota | Opisthokonta | Metazoa | Nemertea | Pilidiophora | Heteronemertea | Lineidae | Lineus | Lineus longissimus | |
| 13146942 | 13146942 | PRJNA345071_P_NODE_291_length_856_cov_1.867178_g256_i0 | PRJNA345071 | 291 | 856 | 1.867178 | 15.98304368 | Lineus longissimus | 88925 | Nemertea | other_Eukaryota | 238 | 3.48e-68 | NR | XP_064629748.1 | 88925 | g256 | i0 | 43.4 | 2.63901869158878 | 249 | 136 | 86.6 | 3 | 71 | 811 | 676 | 921 | XP_064629748.1 deleted in malignant brain tumors 1 protein-like [Lineus longissimus] | diamond | 2259 | 238 | 1 | Eukaryota | Opisthokonta | Metazoa | Nemertea | Pilidiophora | Heteronemertea | Lineidae | Lineus | Lineus longissimus | |
| 20794778 | 20794778 | PRJNA345071_P_NODE_5957_length_274_cov_2.601990_g5917_i0 | PRJNA345071 | 5957 | 274 | 2.60199 | 7.1294526 | Lineus viridis | 56195 | Nemertea | other_Eukaryota | 167 | 8.609999999999999e-37 | NTclustered | gi|166952326|gb|EU302557.1| | 56195 | g5917 | i0 | 79.654 | 23.6897810218978 | 231 | 47 | 84 | 0 | 30 | 260 | 18 | 248 | Lineus viridis ribosomal protein rpl37a mRNA, complete cds | blastn | 6491 | 167 | 1 | Eukaryota | Opisthokonta | Metazoa | Nemertea | Pilidiophora | Heteronemertea | Lineidae | Lineus | Lineus viridis | |
| 24619560 | 24619560 | PRJNA345071_P_NODE_5900_length_275_cov_2.138614_g5860_i0 | PRJNA345071 | 5900 | 275 | 2.138614 | 5.8811885 | Metazoa | 33208 | Nemertea | other_Eukaryota | 117 | 9.969999999999998e-31 | NR | ABZ04228.1 | 56195 | g5860 | i0 | 74.6 | 3.67636363636364 | 67 | 17 | 73.1 | 0 | 73 | 273 | 1 | 67 | ABZ04228.1 ribosomal protein rpl13a [Lineus viridis] | diamond | 1011 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Nemertea | Pilidiophora | Heteronemertea | Lineidae | Lineus | Lineus viridis | |
| 28179949 | 28179949 | PRJNA345071_P_NODE_5406_length_283_cov_2.690476_g5366_i0 | PRJNA345071 | 5406 | 283 | 2.690476 | 7.61404708 | Lineus longissimus | 88925 | Nemertea | other_Eukaryota | 97.1 | 5.08e-21 | NR | XP_064629748.1 | 88925 | g5366 | i0 | 46.2 | 0.985865724381625 | 93 | 48 | 98.6 | 1 | 280 | 2 | 756 | 846 | XP_064629748.1 deleted in malignant brain tumors 1 protein-like [Lineus longissimus] | diamond | 279 | 97.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nemertea | Pilidiophora | Heteronemertea | Lineidae | Lineus | Lineus longissimus | |
| 28938052 | 28938052 | PRJNA345071_P_NODE_7988_length_252_cov_0.871508_g7948_i0 | PRJNA345071 | 7988 | 252 | 0.871508 | 2.19620016 | Lineus longissimus | 88925 | Nemertea | other_Eukaryota | 59.3 | 6.08e-8 | NR | XP_064623817.1 | 88925 | g7948 | i0 | 51.5 | 0.80952380952381 | 68 | 33 | 81 | 0 | 248 | 45 | 1188 | 1255 | XP_064623817.1 1-phosphatidylinositol 4,5-bisphosphate phosphodiesterase beta-4-like isoform X2 [Lineus longissimus] | diamond | 204 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nemertea | Pilidiophora | Heteronemertea | Lineidae | Lineus | Lineus longissimus | |
| 29600723 | 29600723 | PRJNA345071_P_NODE_4470_length_301_cov_1.355263_g4430_i0 | PRJNA345071 | 4470 | 301 | 1.355263 | 4.07934163 | Lineus longissimus | 88925 | Nemertea | other_Eukaryota | 94.4 | 5.68e-20 | NR | XP_064629748.1 | 88925 | g4430 | i0 | 50.6 | 1.62458471760797 | 81 | 34 | 79.7 | 2 | 243 | 4 | 675 | 750 | XP_064629748.1 deleted in malignant brain tumors 1 protein-like [Lineus longissimus] | diamond | 489 | 94.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nemertea | Pilidiophora | Heteronemertea | Lineidae | Lineus | Lineus longissimus | |
| 29885369 | 29885369 | PRJNA345071_P_NODE_191_length_1007_cov_2.528908_g167_i0 | PRJNA345071 | 191 | 1007 | 2.528908 | 25.46610356 | Lineus longissimus | 88925 | Nemertea | other_Eukaryota | 233 | 9.37e-66 | NR | XP_064629748.1 | 88925 | g167 | i0 | 45.8 | 0.741807348560079 | 249 | 127 | 72.7 | 7 | 943 | 212 | 676 | 921 | XP_064629748.1 deleted in malignant brain tumors 1 protein-like [Lineus longissimus] | diamond | 747 | 233 | 1 | Eukaryota | Opisthokonta | Metazoa | Nemertea | Pilidiophora | Heteronemertea | Lineidae | Lineus | Lineus longissimus | |
| 32097858 | 32097858 | PRJNA345071_P_NODE_8358_length_250_cov_1.322034_g8318_i0 | PRJNA345071 | 8358 | 250 | 1.322034 | 3.305085 | Lineus longissimus | 88925 | Nemertea | other_Eukaryota | 86.3 | 8.92e-18 | NR | XP_064652273.1 | 88925 | g8318 | i0 | 56.3 | 0.852 | 71 | 30 | 85.2 | 1 | 215 | 3 | 39 | 108 | XP_064652273.1 cathepsin B-like [Lineus longissimus] | diamond | 213 | 86.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nemertea | Pilidiophora | Heteronemertea | Lineidae | Lineus | Lineus longissimus | |
| 32414450 | 32414450 | PRJNA345071_P_NODE_7159_length_258_cov_1.572973_g7119_i0 | PRJNA345071 | 7159 | 258 | 1.572973 | 4.05827034 | Lineus longissimus | 88925 | Nemertea | other_Eukaryota | 72.4 | 8.98e-13 | NR | XP_064638471.1 | 88925 | g7119 | i0 | 39.5 | 1 | 86 | 48 | 100 | 1 | 258 | 1 | 199 | 280 | XP_064638471.1 sodium/potassium-transporting ATPase subunit beta-2-like [Lineus longissimus] | diamond | 258 | 72.4 | 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);;