contig_metadata
17 rows where bioproject = "PRJNA564013", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 548975 | 548975 | PRJNA564013_P_NODE_211201_length_295_cov_12.559829_g208350_i0 | PRJNA564013 | 211201 | 295 | 12.559829 | 37.05149555 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.008 | NTclustered | gi|2920003623|emb|OZ238873.1| | 1046305 | g208350 | i0 | 96.875 | 0.108474576271186 | 32 | 1 | 11 | 0 | 260 | 291 | 15988849 | 15988818 | Ailoscolex lacteospumosus genome assembly, chromosome: 14 | blastn | 32 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 551939 | 551939 | PRJNA564013_P_NODE_364101_length_188_cov_4.480315_g361249_i0 | PRJNA564013 | 364101 | 188 | 4.480315 | 8.4229922 | Hirudo verbana | 311461 | Annelida | Annelida | 56.5 | 0.001 | NTclustered | gi|2918369616|emb|OZ237781.1| | 311461 | g361249 | i0 | 96.97 | 2.11702127659574 | 33 | 1 | 18 | 0 | 156 | 188 | 11798340 | 11798308 | Hirudo verbana genome assembly, chromosome: 3 | blastn | 398 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 3101340 | 3101340 | PRJNA564013_P_NODE_288743_length_232_cov_22.532164_g285891_i0 | PRJNA564013 | 288743 | 232 | 22.532164 | 52.27462048 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.006 | NTclustered | gi|2918369697|emb|OZ237786.1| | 311461 | g285891 | i0 | 100 | 0.125 | 29 | 0 | 13 | 0 | 116 | 144 | 8356777 | 8356805 | Hirudo verbana genome assembly, chromosome: 8 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 4379323 | 4379323 | PRJNA564013_P_NODE_364664_length_187_cov_5.253968_g361812_i0 | PRJNA564013 | 364664 | 187 | 5.253968 | 9.82492016 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.016 | NTclustered | gi|2918369706|emb|OZ237788.1| | 311461 | g361812 | i0 | 100 | 0.149732620320856 | 28 | 0 | 15 | 0 | 54 | 81 | 5562842 | 5562869 | Hirudo verbana genome assembly, chromosome: 10 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 5651109 | 5651109 | PRJNA564013_P_NODE_139105_length_362_cov_2.760797_g136257_i0 | PRJNA564013 | 139105 | 362 | 2.760797 | 9.99408514 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.01 | NTclustered | gi|2920003623|emb|OZ238873.1| | 1046305 | g136257 | i0 | 94.444 | 0.0994475138121547 | 36 | 1 | 10 | 1 | 182 | 216 | 4661737 | 4661702 | Ailoscolex lacteospumosus genome assembly, chromosome: 14 | blastn | 36 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 6235465 | 6235465 | PRJNA564013_P_NODE_205165_length_301_cov_4.841667_g202314_i0 | PRJNA564013 | 205165 | 301 | 4.841667 | 14.57341767 | Aeolosoma | 55816 | Annelida | Annelida | 412 | 1.1199999999999997e-110 | NTclustered | gi|111559284|gb|DQ790019.1| | 397537 | g202314 | i0 | 93.863 | 123.162790697674 | 277 | 12 | 91 | 5 | 17 | 291 | 2166 | 2439 | Aeolosoma sp. THS-2006 28S large subunit ribosomal RNA gene, partial sequence | blastn | 37072 | 412 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Aeolosomatidae | Aeolosoma | Aeolosoma sp. THS-2006 | |
| 6927424 | 6927424 | PRJNA564013_P_NODE_230686_length_278_cov_2.428571_g227834_i0 | PRJNA564013 | 230686 | 278 | 2.428571 | 6.75142738 | Hirudo verbana | 311461 | Annelida | Annelida | 56.5 | 0.002 | NTclustered | gi|2918369714|emb|OZ237790.1| | 311461 | g227834 | i0 | 96.97 | 0.118705035971223 | 33 | 1 | 12 | 0 | 228 | 260 | 8611957 | 8611925 | Hirudo verbana genome assembly, chromosome: 12 | blastn | 33 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 8785036 | 8785036 | PRJNA564013_P_NODE_24267_length_759_cov_6.696275_g21865_i0 | PRJNA564013 | 24267 | 759 | 6.696275 | 50.82472725 | Opisthokonta | 33154 | Annelida | Annelida | 56.5 | 0.006 | NTclustered | gi|2918369621|emb|OZ237783.1| | 311461 | g21865 | i0 | 92.308 | 0.176548089591568 | 39 | 3 | 5 | 0 | 362 | 400 | 904524 | 904562 | Hirudo verbana genome assembly, chromosome: 5 | blastn | 134 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 9475199 | 9475199 | PRJNA564013_P_NODE_112448_length_392_cov_3.873112_g109606_i0 | PRJNA564013 | 112448 | 392 | 3.873112 | 15.18259904 | Helobdella robusta | 6412 | Annelida | Annelida | 52.8 | 0.037 | NTclustered | gi|675892139|ref|XM_009033324.1| | 6412 | g109606 | i0 | 100 | 0.0714285714285714 | 28 | 0 | 7 | 0 | 100 | 127 | 1090 | 1117 | Helobdella robusta hypothetical protein mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 9480676 | 9480676 | PRJNA564013_P_NODE_46408_length_576_cov_4.176699_g43663_i0 | PRJNA564013 | 46408 | 576 | 4.176699 | 24.05778624 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 60.2 | 3.4e-4 | NTclustered | gi|2920003651|emb|OZ238876.1| | 1046305 | g43663 | i0 | 87.719 | 0.0989583333333333 | 57 | 0 | 9 | 5 | 465 | 515 | 13012842 | 13012897 | Ailoscolex lacteospumosus genome assembly, chromosome: 17 | blastn | 57 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 14578402 | 14578402 | PRJNA564013_P_NODE_234932_length_274_cov_4.427230_g232080_i0 | PRJNA564013 | 234932 | 274 | 4.42723 | 12.1306102 | Helobdella robusta | 6412 | Annelida | Annelida | 56.5 | 0.002 | NTclustered | gi|675853979|ref|XM_009014302.1| | 6412 | g232080 | i0 | 96.97 | 0.521897810218978 | 33 | 1 | 12 | 0 | 201 | 233 | 277 | 245 | Helobdella robusta hypothetical protein partial mRNA | blastn | 143 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 15855285 | 15855285 | PRJNA564013_P_NODE_63993_length_502_cov_14.065760_g61191_i0 | PRJNA564013 | 63993 | 502 | 14.06576 | 70.6101152 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.049 | NTclustered | gi|2920003257|emb|OZ238860.1| | 1046305 | g61191 | i0 | 100 | 0.0557768924302789 | 28 | 0 | 6 | 0 | 186 | 213 | 29439068 | 29439095 | Ailoscolex lacteospumosus genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 17127932 | 17127932 | PRJNA564013_P_NODE_27554_length_718_cov_27.546423_g25050_i0 | PRJNA564013 | 27554 | 718 | 27.546423 | 197.78331714 | Hirudo verbana | 311461 | Annelida | Annelida | 86.1 | 7.08e-12 | NTclustered | gi|2918369714|emb|OZ237790.1| | 311461 | g25050 | i0 | 84.091 | 0.572423398328691 | 88 | 14 | 12 | 0 | 432 | 519 | 9064101 | 9064188 | Hirudo verbana genome assembly, chromosome: 12 | blastn | 411 | 86.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 18398489 | 18398489 | PRJNA564013_P_NODE_109475_length_396_cov_3.200000_g106634_i0 | PRJNA564013 | 109475 | 396 | 3.2 | 12.672 | Hirudo verbana | 311461 | Annelida | Annelida | 75 | 8.09e-9 | NTclustered | gi|2918369621|emb|OZ237783.1| | 311461 | g106634 | i0 | 95.652 | 2.14393939393939 | 46 | 2 | 12 | 0 | 8 | 53 | 12083643 | 12083688 | Hirudo verbana genome assembly, chromosome: 5 | blastn | 849 | 75 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 18402879 | 18402879 | PRJNA564013_P_NODE_311915_length_218_cov_2.484076_g309063_i0 | PRJNA564013 | 311915 | 218 | 2.484076 | 5.41528568 | Hirudo verbana | 311461 | Annelida | Annelida | 62.1 | 3.2e-5 | NTclustered | gi|2918369714|emb|OZ237790.1| | 311461 | g309063 | i0 | 100 | 17.5963302752294 | 33 | 0 | 15 | 0 | 176 | 208 | 3275789 | 3275821 | Hirudo verbana genome assembly, chromosome: 12 | blastn | 3836 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 28198278 | 28198278 | PRJNA564013_P_NODE_249286_length_262_cov_2.179104_g246434_i0 | PRJNA564013 | 249286 | 262 | 2.179104 | 5.70925248 | Opisthokonta | 33154 | Annelida | Annelida | 43.5 | 0.0221 | NR | KAI0242763.1 | 104711 | g246434 | i0 | 37.3 | 3.43511450381679 | 59 | 37 | 67.6 | 0 | 72 | 248 | 55 | 113 | KAI0242763.1 hypothetical protein LSAT2_011069 [Lamellibrachia satsuma] | diamond | 900 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 30079129 | 30079129 | PRJNA564013_P_NODE_318152_length_214_cov_5.712418_g315300_i0 | PRJNA564013 | 318152 | 214 | 5.712418 | 12.224574520000001 | Capitella teleta | 283909 | Annelida | Annelida | 74.3 | 1.91e-13 | NR | ELT88573.1 | 283909 | g315300 | i0 | 55.2 | 3.2803738317757 | 58 | 26 | 81.3 | 0 | 35 | 208 | 489 | 546 | ELT88573.1 hypothetical protein CAPTEDRAFT_218778 [Capitella teleta] | diamond | 702 | 74.3 | 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);;