contig_metadata
13 rows where bioproject = "PRJNA596870", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1844238 | 1844238 | PRJNA596870_P_NODE_38762_length_242_cov_0.911243_g38629_i0 | PRJNA596870 | 38762 | 242 | 0.911243 | 2.20520806 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.022 | NTclustered | gi|2918369706|emb|OZ237788.1| | 311461 | g38629 | i0 | 100 | 0.115702479338843 | 28 | 0 | 12 | 0 | 72 | 99 | 1192199 | 1192226 | Hirudo verbana genome assembly, chromosome: 10 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 5672248 | 5672248 | PRJNA596870_P_NODE_30565_length_250_cov_0.870056_g30432_i0 | PRJNA596870 | 30565 | 250 | 0.870056 | 2.17514 | Hirudo verbana | 311461 | Annelida | Annelida | 65.8 | 2.91e-6 | NTclustered | gi|2918369643|emb|OZ237784.1| | 311461 | g30432 | i0 | 90.385 | 20.284 | 52 | 1 | 21 | 3 | 137 | 187 | 12469245 | 12469293 | Hirudo verbana genome assembly, chromosome: 6 | blastn | 5071 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 11343823 | 11343823 | PRJNA596870_P_NODE_18649_length_308_cov_1.463830_g18516_i0 | PRJNA596870 | 18649 | 308 | 1.46383 | 4.5085964 | Metazoa | 33208 | Annelida | Annelida | 228 | 4.449999999999999e-55 | NTclustered | gi|675884945|ref|XM_009029727.1| | 6412 | g18516 | i0 | 82.09 | 167.438311688312 | 268 | 46 | 87 | 2 | 42 | 308 | 697 | 963 | Helobdella robusta hypothetical protein partial mRNA | blastn | 51571 | 228 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 12047625 | 12047625 | PRJNA596870_P_NODE_31790_length_249_cov_0.875000_g31657_i0 | PRJNA596870 | 31790 | 249 | 0.875 | 2.17875 | Hirudo verbana | 311461 | Annelida | Annelida | 56.5 | 0.002 | NTclustered | gi|2918369620|emb|OZ237782.1| | 311461 | g31657 | i0 | 100 | 0.120481927710843 | 30 | 0 | 12 | 0 | 218 | 247 | 12405256 | 12405227 | Hirudo verbana genome assembly, chromosome: 4 | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 20970418 | 20970418 | PRJNA596870_P_NODE_16637_length_323_cov_1.536000_g16504_i0 | PRJNA596870 | 16637 | 323 | 1.536 | 4.96128 | Opisthokonta | 33154 | Annelida | Annelida | 185 | 1.62e-56 | NR | AAD42071.1 | 34590 | g16504 | i0 | 84.1 | 318.018575851393 | 107 | 17 | 99.4 | 0 | 322 | 2 | 127 | 233 | AAD42071.1 beta-tubulin, partial [Chaetopterus variopedatus] | diamond | 102720 | 186 | 0.99462365591397806 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Chaetopteridae | Chaetopterus | Chaetopterus variopedatus | ||
| 22245799 | 22245799 | PRJNA596870_P_NODE_4838_length_548_cov_2.227368_g4706_i0 | PRJNA596870 | 4838 | 548 | 2.227368 | 12.20597664 | Hirudo verbana | 311461 | Annelida | Annelida | 56.5 | 0.004 | NTclustered | gi|2918369710|emb|OZ237789.1| | 311461 | g4706 | i0 | 100 | 0.0547445255474453 | 30 | 0 | 5 | 0 | 362 | 391 | 8590847 | 8590818 | Hirudo verbana genome assembly, chromosome: 11 | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 22817643 | 22817643 | PRJNA596870_P_NODE_13298_length_354_cov_2.156584_g13165_i0 | PRJNA596870 | 13298 | 354 | 2.156584 | 7.63430736 | Metazoa | 33208 | Annelida | Annelida | 132 | 3.4799999999999997e-37 | NR | ABW90366.1 | 6446 | g13165 | i0 | 80.2 | 3.08474576271186 | 91 | 18 | 77.1 | 0 | 274 | 2 | 1 | 91 | ABW90366.1 putative ribosomal protein L35 [Sipunculus nudus] | diamond | 1092 | 133 | 0.992481203007519 | Eukaryota | Opisthokonta | Metazoa | Annelida | Sipuncula | Golfingiida | Sipunculidae | Sipunculus | Sipunculus nudus | |
| 23520693 | 23520693 | PRJNA596870_P_NODE_2319_length_758_cov_3.654015_g2199_i0 | PRJNA596870 | 2319 | 758 | 3.654015 | 27.6974337 | Helobdella robusta | 6412 | Annelida | Annelida | 603 | 1.6699999999999999e-167 | NTclustered | gi|675877099|ref|XM_009025862.1| | 6412 | g2199 | i0 | 82.438 | 89.7295514511873 | 689 | 121 | 91 | 0 | 69 | 757 | 85 | 773 | Helobdella robusta hypothetical protein mRNA | blastn | 68015 | 603 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 23521000 | 23521000 | PRJNA596870_P_NODE_38759_length_242_cov_0.911243_g38626_i0 | PRJNA596870 | 38759 | 242 | 0.911243 | 2.20520806 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.022 | NTclustered | gi|2920003651|emb|OZ238876.1| | 1046305 | g38626 | i0 | 96.774 | 0.243801652892562 | 31 | 1 | 13 | 0 | 61 | 91 | 9497129 | 9497099 | Ailoscolex lacteospumosus genome assembly, chromosome: 17 | blastn | 59 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 31104096 | 31104096 | PRJNA596870_P_NODE_33055_length_248_cov_0.880000_g32922_i0 | PRJNA596870 | 33055 | 248 | 0.88 | 2.1824 | Metazoa | 33208 | Annelida | Annelida | 90.1 | 8.63e-19 | NR | KAK2162927.1 | 53620 | g32922 | i0 | 56.3 | 4.86290322580645 | 80 | 35 | 96.8 | 0 | 240 | 1 | 1806 | 1885 | KAK2162927.1 hypothetical protein LSH36_89g02118 [Paralvinella palmiformis] | diamond | 1206 | 90.9 | 0.991199119911991 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 32197941 | 32197941 | PRJNA596870_P_NODE_33858_length_247_cov_0.885057_g33725_i0 | PRJNA596870 | 33858 | 247 | 0.885057 | 2.18609079 | Ridgeia piscesae | 27915 | Annelida | Annelida | 52.8 | 1.13e-5 | NR | KAK2192521.1 | 27915 | g33725 | i0 | 74.2 | 0.376518218623482 | 31 | 8 | 37.7 | 0 | 171 | 79 | 266 | 296 | KAK2192521.1 hypothetical protein NP493_28g03019 [Ridgeia piscesae] | diamond | 93 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 32211365 | 32211365 | PRJNA596870_P_NODE_25878_length_267_cov_1.453608_g25745_i0 | PRJNA596870 | 25878 | 267 | 1.453608 | 3.88113336 | Metazoa | 33208 | Annelida | Annelida | 82.4 | 1.21e-16 | NR | CAH1796063.1 | 6347 | g25745 | i0 | 66.1 | 6.73033707865169 | 59 | 20 | 66.3 | 0 | 87 | 263 | 2 | 60 | CAH1796063.1 unnamed protein product [Owenia fusiformis] | diamond | 1797 | 83.2 | 0.990384615384615 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 32356394 | 32356394 | PRJNA596870_P_NODE_30699_length_250_cov_0.870056_g30566_i0 | PRJNA596870 | 30699 | 250 | 0.870056 | 2.17514 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 117 | 5.2399999999999995e-30 | NR | KAK2147523.1 | 53620 | g30566 | i0 | 69.9 | 1.692 | 73 | 22 | 87.6 | 0 | 219 | 1 | 10 | 82 | KAK2147523.1 hypothetical protein LSH36_548g00001 [Paralvinella palmiformis] | diamond | 423 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis |
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);;