contig_metadata
7 rows where bioproject = "PRJNA613025" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19718398 | 19718398 | PRJNA613025_S_NODE_26616_length_180_cov_12.648855_g26462_i0 | PRJNA613025 | 26616 | 180 | 12.648855 | 22.767939 | Hirudo verbana | 311461 | Annelida | Annelida | 60.2 | 9.13e-5 | NTclustered | gi|2918369616|emb|OZ237781.1| | 311461 | g26462 | i0 | 97.143 | 5.63888888888889 | 35 | 1 | 19 | 0 | 129 | 163 | 13955279 | 13955245 | Hirudo verbana genome assembly, chromosome: 3 | blastn | 1015 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 24818110 | 24818110 | PRJNA613025_S_NODE_26360_length_182_cov_0.917293_g26206_i0 | PRJNA613025 | 26360 | 182 | 0.917293 | 1.66947326 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.015 | NTclustered | gi|2920003508|emb|OZ238866.1| | 1046305 | g26206 | i0 | 100 | 0.153846153846154 | 28 | 0 | 15 | 0 | 129 | 156 | 20391295 | 20391322 | Ailoscolex lacteospumosus genome assembly, chromosome: 7 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 27365052 | 27365052 | PRJNA613025_S_NODE_15023_length_278_cov_26.231441_g14869_i0 | PRJNA613025 | 15023 | 278 | 26.231441 | 72.92340598 | Owenia fusiformis | 6347 | Annelida | Annelida | 51.6 | 2.98e-5 | NR | CAH1779999.1 | 6347 | g14869 | i0 | 49.2 | 2.85971223021583 | 59 | 30 | 63.7 | 0 | 32 | 208 | 167 | 225 | CAH1779999.1 unnamed protein product, partial [Owenia fusiformis] | diamond | 795 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 30314961 | 30314961 | PRJNA613025_S_NODE_26992_length_179_cov_1.176923_g26838_i0 | PRJNA613025 | 26992 | 179 | 1.176923 | 2.10669217 | Metazoa | 33208 | Annelida | Annelida | 45.1 | 0.00245 | NR | KAK2156594.1 | 53620 | g26838 | i0 | 48.9 | 4.12290502793296 | 45 | 21 | 72.1 | 1 | 48 | 176 | 602 | 646 | KAK2156594.1 hypothetical protein LSH36_209g04034 [Paralvinella palmiformis] | diamond | 738 | 45.4 | 0.993392070484582 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 30807011 | 30807011 | PRJNA613025_S_NODE_24914_length_189_cov_1.085714_g24760_i0 | PRJNA613025 | 24914 | 189 | 1.085714 | 2.05199946 | Dimorphilus gyrociliatus | 2664684 | Annelida | Annelida | 102 | 3.93e-26 | NR | CAD5112589.1 | 2664684 | g24760 | i0 | 77.4 | 4.92063492063492 | 62 | 14 | 98.4 | 0 | 188 | 3 | 46 | 107 | CAD5112589.1 DgyrCDS1802 [Dimorphilus gyrociliatus] | diamond | 930 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dimorphilus | Dimorphilus gyrociliatus | ||
| 30838581 | 30838581 | PRJNA613025_S_NODE_31854_length_164_cov_1.208696_g31700_i0 | PRJNA613025 | 31854 | 164 | 1.208696 | 1.98226144 | Lamellibrachia satsuma | 104711 | Annelida | Annelida | 41.2 | 0.0458 | NR | KAI0214404.1 | 104711 | g31700 | i0 | 38.9 | 0.658536585365854 | 36 | 22 | 65.9 | 0 | 27 | 134 | 719 | 754 | KAI0214404.1 hypothetical protein LSAT2_000500 [Lamellibrachia satsuma] | diamond | 108 | 41.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 30965100 | 30965100 | PRJNA613025_S_NODE_33314_length_162_cov_0.902655_g33160_i0 | PRJNA613025 | 33314 | 162 | 0.902655 | 1.4623011 | Ridgeia piscesae | 27915 | Annelida | Annelida | 55.1 | 5.41e-7 | NR | KAK2186890.1 | 27915 | g33160 | i0 | 52.8 | 2.87037037037037 | 53 | 25 | 98.1 | 0 | 160 | 2 | 338 | 390 | KAK2186890.1 hypothetical protein NP493_185g03042 [Ridgeia piscesae] | diamond | 465 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae |
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);;