contig_metadata
20 rows where analysis = "blastn", bioproject = "PRJNA494251" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 475490 | 475490 | PRJNA494251_P_NODE_38621_length_250_cov_0.870056_g38307_i0 | PRJNA494251 | 38621 | 250 | 0.870056 | 2.17514 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 58.4 | 4.87e-4 | NTclustered | gi|2920003371|emb|OZ238862.1| | 1046305 | g38307 | i0 | 97.143 | 1.084 | 35 | 0 | 14 | 1 | 44 | 78 | 1751400 | 1751433 | Ailoscolex lacteospumosus genome assembly, chromosome: 3 | blastn | 271 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 475536 | 475536 | PRJNA494251_P_NODE_43341_length_246_cov_0.890173_g43027_i0 | PRJNA494251 | 43341 | 246 | 0.890173 | 2.18982558 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 58.4 | 4.78e-4 | NTclustered | gi|2920003257|emb|OZ238860.1| | 1046305 | g43027 | i0 | 97.143 | 8.02845528455285 | 35 | 0 | 14 | 1 | 4 | 37 | 163785 | 163819 | Ailoscolex lacteospumosus genome assembly, chromosome: 1 | blastn | 1975 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 1750068 | 1750068 | PRJNA494251_P_NODE_15062_length_357_cov_1.626761_g14749_i0 | PRJNA494251 | 15062 | 357 | 1.626761 | 5.80753677 | Hirudo verbana | 311461 | Annelida | Annelida | 62.1 | 5.62e-5 | NTclustered | gi|2918369620|emb|OZ237782.1| | 311461 | g14749 | i0 | 100 | 0.092436974789916 | 33 | 0 | 9 | 0 | 160 | 192 | 3865546 | 3865578 | Hirudo verbana genome assembly, chromosome: 4 | blastn | 33 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 1750222 | 1750222 | PRJNA494251_P_NODE_27242_length_282_cov_1.248804_g26928_i0 | PRJNA494251 | 27242 | 282 | 1.248804 | 3.52162728 | Helobdella robusta | 6412 | Annelida | Annelida | 54.7 | 0.007 | NTclustered | gi|219521937|gb|AC171127.2| | 6412 | g26928 | i0 | 100 | 0.205673758865248 | 29 | 0 | 10 | 0 | 60 | 88 | 38333 | 38305 | Helobdella robusta clone CH306-1A1, complete sequence | blastn | 58 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 2382386 | 2382386 | PRJNA494251_P_NODE_15002_length_358_cov_1.080702_g14689_i0 | PRJNA494251 | 15002 | 358 | 1.080702 | 3.86891316 | Clitellata | 42113 | Annelida | Annelida | 56.5 | 0.003 | NTclustered | gi|2918369702|emb|OZ237787.1| | 311461 | g14689 | i0 | 92.308 | 1.10055865921788 | 39 | 3 | 11 | 0 | 1 | 39 | 11072463 | 11072425 | Hirudo verbana genome assembly, chromosome: 9 | blastn | 394 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 3026070 | 3026070 | PRJNA494251_P_NODE_1563_length_943_cov_2.587356_g1350_i0 | PRJNA494251 | 1563 | 943 | 2.587356 | 24.39876708 | Pristina longiseta | 188231 | Annelida | Annelida | 891 | 0 | NTclustered | gi|2169792353|gb|OM001222.1| | 188231 | g1350 | i0 | 97.154 | 55.5705196182397 | 527 | 15 | 56 | 0 | 50 | 576 | 527 | 1 | Pristina longiseta voucher CW649 large subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 52403 | 891 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Pristina | Pristina longiseta | |
| 3658119 | 3658119 | PRJNA494251_P_NODE_9423_length_434_cov_1.706371_g9118_i0 | PRJNA494251 | 9423 | 434 | 1.706371 | 7.40565014 | Metazoa | 33208 | Annelida | Annelida | 213 | 1.82e-50 | NTclustered | gi|158187717|gb|EU124943.1| | 6344 | g9118 | i0 | 82.47 | 62.6958525345622 | 251 | 36 | 57 | 8 | 62 | 309 | 346 | 101 | Arenicola marina ribosomal protein rps18 mRNA, partial cds | blastn | 27210 | 213 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Arenicolidae | Arenicola | Arenicola marina | ||
| 4301977 | 4301977 | PRJNA494251_P_NODE_11524_length_398_cov_1.960000_g11218_i0 | PRJNA494251 | 11524 | 398 | 1.96 | 7.8008 | Enchytraeus albidus | 6390 | Annelida | Annelida | 111 | 6.2e-20 | NTclustered | gi|1068288781|gb|KU728843.1| | 6390 | g11218 | i0 | 78.142 | 8.34924623115578 | 183 | 35 | 45 | 5 | 219 | 398 | 394 | 574 | Enchytraeus albidus cytochrome b gene, complete cds; mitochondrial | blastn | 3323 | 111 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Enchytraeida | Enchytraeidae | Enchytraeus | Enchytraeus albidus | |
| 8128487 | 8128487 | PRJNA494251_P_NODE_4207_length_614_cov_2.441774_g3917_i0 | PRJNA494251 | 4207 | 614 | 2.441774 | 14.99249236 | Hirudo verbana | 311461 | Annelida | Annelida | 60.2 | 3.64e-4 | NTclustered | gi|2918369702|emb|OZ237787.1| | 311461 | g3917 | i0 | 94.737 | 0.719869706840391 | 38 | 2 | 6 | 0 | 466 | 503 | 1192910 | 1192873 | Hirudo verbana genome assembly, chromosome: 9 | blastn | 442 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 9403284 | 9403284 | PRJNA494251_P_NODE_27928_length_279_cov_1.990291_g27614_i0 | PRJNA494251 | 27928 | 279 | 1.990291 | 5.55291189 | Hirudo verbana | 311461 | Annelida | Annelida | 58.4 | 5.52e-4 | NTclustered | gi|2918369621|emb|OZ237783.1| | 311461 | g27614 | i0 | 94.595 | 0.132616487455197 | 37 | 2 | 13 | 0 | 138 | 174 | 11999200 | 11999236 | Hirudo verbana genome assembly, chromosome: 5 | blastn | 37 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 11953854 | 11953854 | PRJNA494251_P_NODE_13770_length_370_cov_1.959596_g13462_i0 | PRJNA494251 | 13770 | 370 | 1.959596 | 7.2505052 | Hirudo verbana | 311461 | Annelida | Annelida | 63.9 | 1.62e-5 | NTclustered | gi|2918369702|emb|OZ237787.1| | 311461 | g13462 | i0 | 95 | 1.60810810810811 | 40 | 2 | 11 | 0 | 272 | 311 | 3560319 | 3560280 | Hirudo verbana genome assembly, chromosome: 9 | blastn | 595 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 13229284 | 13229284 | PRJNA494251_P_NODE_40151_length_248_cov_1.760000_g39837_i0 | PRJNA494251 | 40151 | 248 | 1.76 | 4.3648 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.022 | NTclustered | gi|2918369621|emb|OZ237783.1| | 311461 | g39837 | i0 | 96.875 | 0.241935483870968 | 32 | 0 | 13 | 1 | 213 | 244 | 6785207 | 6785177 | Hirudo verbana genome assembly, chromosome: 5 | blastn | 60 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 14504208 | 14504208 | PRJNA494251_P_NODE_42752_length_246_cov_1.312139_g42438_i0 | PRJNA494251 | 42752 | 246 | 1.312139 | 3.22786194 | Hirudo verbana | 311461 | Annelida | Annelida | 69.4 | 2.21e-7 | NTclustered | gi|2918369720|emb|OZ237792.1| | 311461 | g42438 | i0 | 86.364 | 0.268292682926829 | 66 | 6 | 26 | 3 | 160 | 223 | 562353 | 562289 | Hirudo verbana genome assembly, chromosome: 14 | blastn | 66 | 69.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 14504235 | 14504235 | PRJNA494251_P_NODE_45552_length_244_cov_0.900585_g45238_i0 | PRJNA494251 | 45552 | 244 | 0.900585 | 2.1974274 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.006 | NTclustered | gi|2918369613|emb|OZ237779.1| | 311461 | g45238 | i0 | 96.875 | 0.131147540983607 | 32 | 1 | 13 | 0 | 195 | 226 | 13365659 | 13365690 | Hirudo verbana genome assembly, chromosome: 1 | blastn | 32 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 17684662 | 17684662 | PRJNA494251_P_NODE_36194_length_252_cov_2.581006_g35880_i0 | PRJNA494251 | 36194 | 252 | 2.581006 | 6.50413512 | Metazoa | 33208 | Annelida | Annelida | 56.5 | 0.002 | NTclustered | gi|2918369706|emb|OZ237788.1| | 311461 | g35880 | i0 | 90.476 | 0.297619047619048 | 42 | 4 | 17 | 0 | 26 | 67 | 4221708 | 4221749 | Hirudo verbana genome assembly, chromosome: 10 | blastn | 75 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 19601326 | 19601326 | PRJNA494251_P_NODE_38216_length_250_cov_0.870056_g37902_i0 | PRJNA494251 | 38216 | 250 | 0.870056 | 2.17514 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.023 | NTclustered | gi|2920003623|emb|OZ238873.1| | 1046305 | g37902 | i0 | 100 | 0.112 | 28 | 0 | 11 | 0 | 9 | 36 | 13691372 | 13691345 | Ailoscolex lacteospumosus genome assembly, chromosome: 14 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 20233314 | 20233314 | PRJNA494251_P_NODE_31316_length_267_cov_1.891753_g31002_i0 | PRJNA494251 | 31316 | 267 | 1.891753 | 5.05098051 | Clitellata | 42113 | Annelida | Annelida | 62.1 | 4.06e-5 | NTclustered | gi|2918369614|emb|OZ237780.1| | 311461 | g31002 | i0 | 97.222 | 2.52059925093633 | 36 | 1 | 13 | 0 | 231 | 266 | 2048571 | 2048606 | Hirudo verbana genome assembly, chromosome: 2 | blastn | 673 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 20876869 | 20876869 | PRJNA494251_P_NODE_14797_length_360_cov_1.069686_g14485_i0 | PRJNA494251 | 14797 | 360 | 1.069686 | 3.8508696 | Aeolosoma sp. GG-2011 | 1071604 | Annelida | Annelida | 217 | 1.14e-51 | NTclustered | gi|342220097|gb|HQ691208.1| | 1071604 | g14485 | i0 | 80.132 | 12.4888888888889 | 302 | 51 | 83 | 8 | 8 | 305 | 176 | 472 | Aeolosoma sp. GG-2011 16S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 4496 | 217 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Aeolosomatidae | Aeolosoma | Aeolosoma sp. GG-2011 | |
| 23427734 | 23427734 | PRJNA494251_P_NODE_28399_length_278_cov_0.770732_g28085_i0 | PRJNA494251 | 28399 | 278 | 0.770732 | 2.14263496 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.007 | NTclustered | gi|2918369643|emb|OZ237784.1| | 311461 | g28085 | i0 | 100 | 0.10431654676259 | 29 | 0 | 10 | 0 | 155 | 183 | 1411823 | 1411795 | Hirudo verbana genome assembly, chromosome: 6 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 23427967 | 23427967 | PRJNA494251_P_NODE_51039_length_233_cov_2.425000_g50725_i0 | PRJNA494251 | 51039 | 233 | 2.425 | 5.65025 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.006 | NTclustered | gi|2920003623|emb|OZ238873.1| | 1046305 | g50725 | i0 | 94.444 | 0.274678111587983 | 36 | 1 | 15 | 1 | 141 | 175 | 16275015 | 16275050 | Ailoscolex lacteospumosus genome assembly, chromosome: 14 | blastn | 64 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus |
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);;