contig_metadata
8 rows where bioproject = "PRJEB55122", tax_kingdom = "Metazoa" and tax_phylum = "Annelida"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3946551 | 3946551 | PRJEB55122_P_NODE_15044_length_302_cov_1.509881_g14647_i0 | PRJEB55122 | 15044 | 302 | 1.509881 | 4.55984062 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.028 | NTclustered | gi|2918369706|emb|OZ237788.1| | 311461 | g14647 | i0 | 100 | 0.0927152317880795 | 28 | 0 | 9 | 0 | 30 | 57 | 8601539 | 8601566 | Hirudo verbana genome assembly, chromosome: 10 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 12874192 | 12874192 | PRJEB55122_P_NODE_19471_length_252_cov_4.783251_g19074_i0 | PRJEB55122 | 19471 | 252 | 4.783251 | 12.05379252 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.023 | NTclustered | gi|2918369614|emb|OZ237780.1| | 311461 | g19074 | i0 | 100 | 0.111111111111111 | 28 | 0 | 11 | 0 | 140 | 167 | 6340179 | 6340206 | Hirudo verbana genome assembly, chromosome: 2 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 16697127 | 16697127 | PRJEB55122_P_NODE_15234_length_299_cov_2.472000_g14837_i0 | PRJEB55122 | 15234 | 299 | 2.472 | 7.39128 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.028 | NTclustered | gi|2918369614|emb|OZ237780.1| | 311461 | g14837 | i0 | 100 | 0.187290969899666 | 28 | 0 | 9 | 0 | 1 | 28 | 15935477 | 15935450 | Hirudo verbana genome assembly, chromosome: 2 | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 20521510 | 20521510 | PRJEB55122_P_NODE_19177_length_256_cov_0.961353_g18780_i0 | PRJEB55122 | 19177 | 256 | 0.961353 | 2.46106368 | Protodriloides chaetifer | 254032 | Annelida | Annelida | 71.3 | 6.43e-8 | NTclustered | gi|172053651|gb|EU418875.1| | 254032 | g18780 | i0 | 95.455 | 0.3671875 | 44 | 2 | 17 | 0 | 196 | 239 | 2780 | 2737 | Protodriloides chaetifer 28S ribosomal RNA gene, partial sequence | blastn | 94 | 71.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Protodrilidae | Protodriloides | Protodriloides chaetifer | ||
| 22668680 | 22668680 | PRJEB55122_P_NODE_31638_length_185_cov_2.514706_g31241_i0 | PRJEB55122 | 31638 | 185 | 2.514706 | 4.6522061 | Clitellata | 42113 | Annelida | Annelida | 342 | 8.369999999999999e-90 | NTclustered | gi|342220100|gb|HQ691211.1| | 6398 | g31241 | i0 | 100 | 132.935135135135 | 185 | 0 | 100 | 0 | 1 | 185 | 203 | 19 | Lumbricus terrestris 18S ribosomal RNA gene, partial sequence | blastn | 24593 | 342 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Lumbricus | Lumbricus terrestris | |
| 27539213 | 27539213 | PRJEB55122_P_NODE_37044_length_169_cov_0.866667_g36647_i0 | PRJEB55122 | 37044 | 169 | 0.866667 | 1.46466723 | Capitella teleta | 283909 | Annelida | Annelida | 54.7 | 6.69e-7 | NR | ELT99409.1 | 283909 | g36647 | i0 | 51.9 | 1.95266272189349 | 54 | 25 | 94.1 | 1 | 3 | 161 | 200 | 253 | ELT99409.1 hypothetical protein CAPTEDRAFT_188524 [Capitella teleta] | diamond | 330 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 29749006 | 29749006 | PRJEB55122_P_NODE_29671_length_193_cov_1.444444_g29274_i0 | PRJEB55122 | 29671 | 193 | 1.444444 | 2.78777692 | Owenia fusiformis | 6347 | Annelida | Annelida | 44.3 | 0.0043 | NR | CAH1787106.1 | 6347 | g29274 | i0 | 37.3 | 1.2279792746114 | 51 | 32 | 79.3 | 0 | 191 | 39 | 81 | 131 | CAH1787106.1 unnamed protein product [Owenia fusiformis] | diamond | 237 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 31796621 | 31796621 | PRJEB55122_P_NODE_18577_length_261_cov_1.424528_g18180_i0 | PRJEB55122 | 18577 | 261 | 1.424528 | 3.71801808 | Polychaeta | 6341 | Annelida | Annelida | 78.6 | 4.61e-15 | NR | CAH1773255.1 | 6347 | g18180 | i0 | 70 | 4.20689655172414 | 50 | 14 | 56.3 | 1 | 149 | 3 | 9 | 58 | CAH1773255.1 unnamed protein product [Owenia fusiformis] | diamond | 1098 | 79.3 | 0.991172761664565 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis |
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);;