contig_metadata
14 rows where bioproject = "PRJNA316313", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 387423 | 387423 | PRJNA316313_P_NODE_354781_length_175_cov_6.246377_g353395_i0 | PRJNA316313 | 354781 | 175 | 6.246377 | 10.93115975 | Hirudo verbana | 311461 | Annelida | Annelida | 58.4 | 3.17e-4 | NTclustered | gi|2918369714|emb|OZ237790.1| | 311461 | g353395 | i0 | 100 | 0.337142857142857 | 31 | 0 | 18 | 0 | 12 | 42 | 1763905 | 1763935 | Hirudo verbana genome assembly, chromosome: 12 | blastn | 59 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 1661052 | 1661052 | PRJNA316313_P_NODE_172782_length_187_cov_3.953333_g171396_i0 | PRJNA316313 | 172782 | 187 | 3.953333 | 7.39273271 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.004 | NTclustered | gi|2920003508|emb|OZ238866.1| | 1046305 | g171396 | i0 | 94.286 | 1.32085561497326 | 35 | 2 | 19 | 0 | 11 | 45 | 8198829 | 8198863 | Ailoscolex lacteospumosus genome assembly, chromosome: 7 | blastn | 247 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 1661823 | 1661823 | PRJNA316313_P_NODE_316202_length_187_cov_2.300000_g314816_i0 | PRJNA316313 | 316202 | 187 | 2.3 | 4.301 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.016 | NTclustered | gi|2918369710|emb|OZ237789.1| | 311461 | g314816 | i0 | 100 | 0.149732620320856 | 28 | 0 | 15 | 0 | 144 | 171 | 4858016 | 4857989 | Hirudo verbana genome assembly, chromosome: 11 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 4215677 | 4215677 | PRJNA316313_P_NODE_56084_length_251_cov_4.892523_g54698_i0 | PRJNA316313 | 56084 | 251 | 4.892523 | 12.28023273 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.023 | NTclustered | gi|2920003563|emb|OZ238869.1| | 1046305 | g54698 | i0 | 100 | 0.111553784860558 | 28 | 0 | 11 | 0 | 63 | 90 | 22827350 | 22827377 | Ailoscolex lacteospumosus genome assembly, chromosome: 10 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 14416196 | 14416196 | PRJNA316313_P_NODE_3332_length_1079_cov_5.595010_g2617_i0 | PRJNA316313 | 3332 | 1079 | 5.59501 | 60.3701579 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 58.4 | 0.002 | NTclustered | gi|2920003418|emb|OZ238863.1| | 1046305 | g2617 | i0 | 100 | 0.0287303058387396 | 31 | 0 | 3 | 0 | 597 | 627 | 4571068 | 4571038 | Ailoscolex lacteospumosus genome assembly, chromosome: 4 | blastn | 31 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 15689081 | 15689081 | PRJNA316313_P_NODE_177433_length_187_cov_3.853333_g176047_i0 | PRJNA316313 | 177433 | 187 | 3.853333 | 7.20573271 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.004 | NTclustered | gi|2918369613|emb|OZ237779.1| | 311461 | g176047 | i0 | 94.444 | 0.342245989304813 | 36 | 1 | 19 | 1 | 141 | 175 | 4198548 | 4198513 | Hirudo verbana genome assembly, chromosome: 1 | blastn | 64 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 15690357 | 15690357 | PRJNA316313_P_NODE_392493_length_154_cov_2.957265_g391107_i0 | PRJNA316313 | 392493 | 154 | 2.957265 | 4.5541881 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.013 | NTclustered | gi|2920003545|emb|OZ238868.1| | 1046305 | g391107 | i0 | 100 | 0.181818181818182 | 28 | 0 | 18 | 0 | 68 | 95 | 20960038 | 20960011 | Ailoscolex lacteospumosus genome assembly, chromosome: 9 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 16965727 | 16965727 | PRJNA316313_P_NODE_59254_length_246_cov_4.918660_g57868_i0 | PRJNA316313 | 59254 | 246 | 4.91866 | 12.0999036 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.022 | NTclustered | gi|2918369710|emb|OZ237789.1| | 311461 | g57868 | i0 | 100 | 0.113821138211382 | 28 | 0 | 11 | 0 | 11 | 38 | 1714550 | 1714523 | Hirudo verbana genome assembly, chromosome: 11 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 18238625 | 18238625 | PRJNA316313_P_NODE_285115_length_187_cov_2.526667_g283729_i0 | PRJNA316313 | 285115 | 187 | 2.526667 | 4.72486729 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 56.5 | 0.001 | NTclustered | gi|2920003623|emb|OZ238873.1| | 1046305 | g283729 | i0 | 96.97 | 6.86631016042781 | 33 | 1 | 18 | 0 | 114 | 146 | 19452236 | 19452268 | Ailoscolex lacteospumosus genome assembly, chromosome: 14 | blastn | 1284 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 21470525 | 21470525 | PRJNA316313_P_NODE_82137_length_220_cov_3.786885_g80751_i0 | PRJNA316313 | 82137 | 220 | 3.786885 | 8.331147 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 62.1 | 3.24e-5 | NTclustered | gi|2918369706|emb|OZ237788.1| | 311461 | g80751 | i0 | 97.222 | 19.6272727272727 | 36 | 1 | 20 | 0 | 149 | 184 | 8652084 | 8652049 | Hirudo verbana genome assembly, chromosome: 10 | blastn | 4318 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 24614434 | 24614434 | PRJNA316313_P_NODE_50540_length_261_cov_2.232143_g49154_i0 | PRJNA316313 | 50540 | 261 | 2.232143 | 5.82589323 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.007 | NTclustered | gi|2918369706|emb|OZ237788.1| | 311461 | g49154 | i0 | 100 | 0.111111111111111 | 29 | 0 | 11 | 0 | 233 | 261 | 5794703 | 5794675 | Hirudo verbana genome assembly, chromosome: 10 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 24614907 | 24614907 | PRJNA316313_S_NODE_1880_length_170_cov_1.466165_g1877_i0 | PRJNA316313 | 1880 | 170 | 1.466165 | 2.4924805 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 60.2 | 8.5e-5 | NTclustered | gi|2920003508|emb|OZ238866.1| | 1046305 | g1877 | i0 | 100 | 29.3235294117647 | 32 | 0 | 19 | 0 | 103 | 134 | 3886152 | 3886121 | Ailoscolex lacteospumosus genome assembly, chromosome: 7 | blastn | 4985 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 29442688 | 29442688 | PRJNA316313_P_NODE_361570_length_171_cov_3.783582_g360184_i0 | PRJNA316313 | 361570 | 171 | 3.783582 | 6.46992522 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 41.2 | 0.0491 | NR | KAK2157615.1 | 53620 | g360184 | i0 | 48.7 | 0.684210526315789 | 39 | 20 | 68.4 | 0 | 30 | 146 | 68 | 106 | KAK2157615.1 hypothetical protein LSH36_188g08013 [Paralvinella palmiformis] | diamond | 117 | 41.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 30674806 | 30674806 | PRJNA316313_S_NODE_1093_length_209_cov_1.133721_g1090_i0 | PRJNA316313 | 1093 | 209 | 1.133721 | 2.36947689 | Eisenia andrei | 168636 | Annelida | Annelida | 57.4 | 1.45e-7 | NR | AEB92227.1 | 168636 | g1090 | i0 | 45.2 | 0.889952153110048 | 62 | 32 | 86.1 | 1 | 180 | 1 | 120 | 181 | AEB92227.1 P43 [Eisenia andrei] | diamond | 186 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Eisenia | Eisenia andrei |
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);;