contig_metadata
10 rows where bioproject = "PRJNA1092581", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4022697 | 4022697 | PRJNA1092581_P_NODE_125924_length_204_cov_4.664122_g125391_i0 | PRJNA1092581 | 125924 | 204 | 4.664122 | 9.51480888 | Platynereis dumerilii | 6359 | Annelida | Annelida | 82.4 | 2.27e-11 | NTclustered | gi|146189520|emb|AM697674.1| | 6359 | g125391 | i0 | 93.103 | 5.63235294117647 | 58 | 1 | 27 | 2 | 149 | 204 | 209 | 153 | Platynereis dumerilii mRNA for hypothetical protein (ORF1), isolate 2 | blastn | 1149 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Phyllodocida | Nereididae | Platynereis | Platynereis dumerilii | |
| 4024891 | 4024891 | PRJNA1092581_P_NODE_94984_length_261_cov_1.648936_g94451_i0 | PRJNA1092581 | 94984 | 261 | 1.648936 | 4.30372296 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.007 | NTclustered | gi|2920003593|emb|OZ238871.1| | 1046305 | g94451 | i0 | 100 | 0.111111111111111 | 29 | 0 | 11 | 0 | 136 | 164 | 20733402 | 20733430 | Ailoscolex lacteospumosus genome assembly, chromosome: 12 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 5298828 | 5298828 | PRJNA1092581_P_NODE_121125_length_218_cov_9.524138_g120592_i0 | PRJNA1092581 | 121125 | 218 | 9.524138 | 20.76262084 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.019 | NTclustered | gi|2920003608|emb|OZ238872.1| | 1046305 | g120592 | i0 | 96.774 | 0.142201834862385 | 31 | 1 | 14 | 0 | 163 | 193 | 4071752 | 4071782 | Ailoscolex lacteospumosus genome assembly, chromosome: 13 | blastn | 31 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 5298998 | 5298998 | PRJNA1092581_P_NODE_14545_length_723_cov_4.983077_g14053_i0 | PRJNA1092581 | 14545 | 723 | 4.983077 | 36.02764671 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 60.2 | 4.32e-4 | NTclustered | gi|2920003578|emb|OZ238870.1| | 1046305 | g14053 | i0 | 100 | 0.558782849239281 | 32 | 0 | 4 | 0 | 559 | 590 | 20749211 | 20749180 | Ailoscolex lacteospumosus genome assembly, chromosome: 11 | blastn | 404 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 7849986 | 7849986 | PRJNA1092581_P_NODE_57727_length_350_cov_2.498195_g57194_i0 | PRJNA1092581 | 57727 | 350 | 2.498195 | 8.7436825 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 58.4 | 7.11e-4 | NTclustered | gi|2920003257|emb|OZ238860.1| | 1046305 | g57194 | i0 | 100 | 0.297142857142857 | 31 | 0 | 9 | 0 | 271 | 301 | 18983373 | 18983343 | Ailoscolex lacteospumosus genome assembly, chromosome: 1 | blastn | 104 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 9124302 | 9124302 | PRJNA1092581_P_NODE_34128_length_472_cov_2.601504_g33596_i0 | PRJNA1092581 | 34128 | 472 | 2.601504 | 12.27909888 | Metazoa | 33208 | Annelida | Annelida | 185 | 9.83e-57 | NR | ABW90355.1 | 6446 | g33596 | i0 | 65.5 | 13.2902542372881 | 142 | 49 | 90.3 | 0 | 459 | 34 | 27 | 168 | ABW90355.1 putative ribosomal protein L23a [Sipunculus nudus] | diamond | 6273 | 186 | 0.99462365591397806 | Eukaryota | Opisthokonta | Metazoa | Annelida | Sipuncula | Golfingiida | Sipunculidae | Sipunculus | Sipunculus nudus | |
| 9125475 | 9125475 | PRJNA1092581_P_NODE_77708_length_294_cov_3.357466_g77175_i0 | PRJNA1092581 | 77708 | 294 | 3.357466 | 9.87095004 | Hirudo verbana | 311461 | Annelida | Annelida | 60.2 | 1.63e-4 | NTclustered | gi|2918369720|emb|OZ237792.1| | 311461 | g77175 | i0 | 92.857 | 0.829931972789116 | 42 | 2 | 14 | 1 | 238 | 279 | 5905111 | 5905071 | Hirudo verbana genome assembly, chromosome: 14 | blastn | 244 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 12952053 | 12952053 | PRJNA1092581_P_NODE_97571_length_256_cov_10.038251_g97038_i0 | PRJNA1092581 | 97571 | 256 | 10.038251 | 25.69792256 | Amynthas corticis | 351238 | Annelida | Annelida | 436 | 5.5e-118 | NTclustered | gi|927371976|ref|NC_027832.1| | 351238 | g97038 | i0 | 100 | 85.59765625 | 236 | 0 | 92 | 0 | 21 | 256 | 10371 | 10606 | Amynthas corticis mitochondrion, complete genome | blastn | 21913 | 436 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Megascolecidae | Amynthas | Amynthas corticis | |
| 19323690 | 19323690 | PRJNA1092581_P_NODE_84356_length_280_cov_2.975845_g83823_i0 | PRJNA1092581 | 84356 | 280 | 2.975845 | 8.332366 | Polychaeta | 6341 | Annelida | Annelida | 78.6 | 4.17e-15 | NR | CAH1777065.1 | 6347 | g83823 | i0 | 68.6 | 1.08214285714286 | 51 | 16 | 54.6 | 0 | 119 | 271 | 70 | 120 | CAH1777065.1 unnamed protein product [Owenia fusiformis] | diamond | 303 | 78.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 26655825 | 26655825 | PRJNA1092581_P_NODE_64941_length_327_cov_2.448819_g64408_i0 | PRJNA1092581 | 64941 | 327 | 2.448819 | 8.00763813 | Helobdella robusta | 6412 | Annelida | Annelida | 58.9 | 2.11e-7 | NR | XP_009027794.1 | 6412 | g64408 | i0 | 41 | 5.91743119266055 | 83 | 49 | 76.1 | 0 | 325 | 77 | 156 | 238 | XP_009027794.1 hypothetical protein HELRODRAFT_187454 [Helobdella robusta] | diamond | 1935 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta |
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);;