contig_metadata
6 rows where bioproject = "PRJNA929922", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2529484 | 2529484 | PRJNA929922_P_NODE_64802_length_299_cov_1.022124_g64262_i0 | PRJNA929922 | 64802 | 299 | 1.022124 | 3.05615076 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2918369620|emb|OZ237782.1| | 311461 | g64262 | i0 | 94.444 | 0.8561872909699 | 36 | 2 | 12 | 0 | 32 | 67 | 13535190 | 13535225 | Hirudo verbana genome assembly, chromosome: 4 | blastn | 256 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 16210993 | 16210993 | PRJNA929922_S_NODE_2153_length_648_cov_5.029565_g1942_i0 | PRJNA929922 | 2153 | 648 | 5.029565 | 32.5915812 | Hirudo verbana | 311461 | Annelida | Annelida | 60.2 | 3.85e-4 | NTclustered | gi|2918369710|emb|OZ237789.1| | 311461 | g1942 | i0 | 100 | 1.07561728395062 | 32 | 0 | 5 | 0 | 467 | 498 | 1760047 | 1760016 | Hirudo verbana genome assembly, chromosome: 11 | blastn | 697 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 21309764 | 21309764 | PRJNA929922_P_NODE_88077_length_270_cov_0.928934_g87537_i0 | PRJNA929922 | 88077 | 270 | 0.928934 | 2.5081218 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.025 | NTclustered | gi|2920003456|emb|OZ238864.1| | 1046305 | g87537 | i0 | 100 | 0.103703703703704 | 28 | 0 | 10 | 0 | 235 | 262 | 24381203 | 24381176 | Ailoscolex lacteospumosus genome assembly, chromosome: 5 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 27821929 | 27821929 | PRJNA929922_P_NODE_73964_length_286_cov_1.446009_g73424_i0 | PRJNA929922 | 73964 | 286 | 1.446009 | 4.13558574 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 95.9 | 1.39e-20 | NR | CAH1776006.1 | 6347 | g73424 | i0 | 51.8 | 2.65384615384615 | 85 | 37 | 85 | 1 | 1 | 243 | 3277 | 3361 | CAH1776006.1 unnamed protein product [Owenia fusiformis] | diamond | 759 | 96.3 | 0.995846313603323 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 28295242 | 28295242 | PRJNA929922_P_NODE_65466_length_298_cov_1.026667_g64926_i0 | PRJNA929922 | 65466 | 298 | 1.026667 | 3.05946766 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 50.8 | 1.04e-4 | NR | CAH1778976.1 | 6347 | g64926 | i0 | 50 | 1.32885906040268 | 42 | 17 | 42.3 | 1 | 141 | 16 | 308 | 345 | CAH1778976.1 unnamed protein product [Owenia fusiformis] | diamond | 396 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 31858049 | 31858049 | PRJNA929922_P_NODE_106617_length_251_cov_0.865169_g106077_i0 | PRJNA929922 | 106617 | 251 | 0.865169 | 2.17157419 | Capitella teleta | 283909 | Annelida | Annelida | 67.4 | 7.9e-12 | NR | ELU02025.1 | 283909 | g106077 | i0 | 48.4 | 1.52988047808765 | 64 | 33 | 76.5 | 0 | 25 | 216 | 89 | 152 | ELU02025.1 hypothetical protein CAPTEDRAFT_91793 [Capitella teleta] | diamond | 384 | 67.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta |
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);;