contig_metadata
25 rows where analysis = "blastn", bioproject = "PRJNA450343" and tax_phylum = "Platyhelminthes"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 439079 | 439079 | PRJNA450343_P_NODE_2301_length_358_cov_6.025890_g2233_i0 | PRJNA450343 | 2301 | 358 | 6.02589 | 21.5726862 | Planocera multitentaculata | 31247 | Platyhelminthes | Platyhelminthes | 662 | 0 | NTclustered | gi|1782648251|dbj|LC503532.1| | 31247 | g2233 | i0 | 100 | 44.427374301676 | 358 | 0 | 100 | 0 | 1 | 358 | 11 | 368 | Planocera multitentaculata mitochondrial DNA, nearly complete genome | blastn | 15905 | 662 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Polycladida | Planoceridae | Planocera | Planocera multitentaculata | |
| 2989686 | 2989686 | PRJNA450343_P_NODE_523_length_792_cov_5.444145_g476_i0 | PRJNA450343 | 523 | 792 | 5.444145 | 43.1176284 | Planocera multitentaculata | 31247 | Platyhelminthes | Platyhelminthes | 1441 | 0 | NTclustered | gi|1782648251|dbj|LC503532.1| | 31247 | g476 | i0 | 99.495 | 7.16287878787879 | 792 | 4 | 100 | 0 | 1 | 792 | 5476 | 6267 | Planocera multitentaculata mitochondrial DNA, nearly complete genome | blastn | 5673 | 1441 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Polycladida | Planoceridae | Planocera | Planocera multitentaculata | |
| 4266079 | 4266079 | PRJNA450343_P_NODE_4424_length_253_cov_1.250000_g4356_i0 | PRJNA450343 | 4424 | 253 | 1.25 | 3.1625 | Planocera multitentaculata | 31247 | Platyhelminthes | Platyhelminthes | 455 | 1.5e-123 | NTclustered | gi|1782648251|dbj|LC503532.1| | 31247 | g4356 | i0 | 99.206 | 8.64426877470356 | 252 | 2 | 99 | 0 | 1 | 252 | 6958 | 7209 | Planocera multitentaculata mitochondrial DNA, nearly complete genome | blastn | 2187 | 455 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Polycladida | Planoceridae | Planocera | Planocera multitentaculata | |
| 4266085 | 4266085 | PRJNA450343_P_NODE_5264_length_231_cov_1.686813_g5196_i0 | PRJNA450343 | 5264 | 231 | 1.686813 | 3.89653803 | Microplana scharffi | 391273 | Platyhelminthes | Platyhelminthes | 150 | 7.109999999999999e-32 | NTclustered | gi|2724174755|gb|PP729467.1| | 391273 | g5196 | i0 | 85.816 | 5.3030303030303 | 141 | 20 | 61 | 0 | 90 | 230 | 10 | 150 | Microplana scharffi voucher MNHN JL471 translation elongation factor 1-alpha (EF1) gene, complete cds | blastn | 1225 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Geoplanidae | Microplana | Microplana scharffi | |
| 4266087 | 4266087 | PRJNA450343_P_NODE_544_length_772_cov_2.582296_g497_i0 | PRJNA450343 | 544 | 772 | 2.582296 | 19.93532512 | Planocera reticulata | 6168 | Platyhelminthes | Platyhelminthes | 361 | 1.13e-94 | NTclustered | gi|1782648238|dbj|LC503531.1| | 6168 | g497 | i0 | 75.722 | 4.69170984455959 | 762 | 161 | 97 | 20 | 19 | 766 | 5440 | 6191 | Planocera reticulata mitochondrial DNA, nearly complete genome | blastn | 3622 | 361 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Polycladida | Planoceridae | Planocera | Planocera reticulata | |
| 4266095 | 4266095 | PRJNA450343_P_NODE_664_length_700_cov_2.382488_g610_i0 | PRJNA450343 | 664 | 700 | 2.382488 | 16.677416 | Planocera multitentaculata | 31247 | Platyhelminthes | Platyhelminthes | 1266 | 0 | NTclustered | gi|1782648251|dbj|LC503532.1| | 31247 | g610 | i0 | 99.286 | 19.3314285714286 | 700 | 5 | 100 | 0 | 1 | 700 | 11365 | 12064 | Planocera multitentaculata mitochondrial DNA, nearly complete genome | blastn | 13532 | 1266 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Polycladida | Planoceridae | Planocera | Planocera multitentaculata | |
| 4920667 | 4920667 | PRJNA450343_P_NODE_1664_length_427_cov_66.325397_g1596_i0 | PRJNA450343 | 1664 | 427 | 66.325397 | 283.20944519 | Polycladida | 6163 | Platyhelminthes | Platyhelminthes | 789 | 0 | NTclustered | gi|28273265|gb|AY157153.1| | 82852 | g1596 | i0 | 100 | 100.229508196721 | 427 | 0 | 100 | 0 | 1 | 427 | 3078 | 2652 | Notoplana australis 28S large subunit ribosomal RNA gene, partial sequence | blastn | 42798 | 789 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Polycladida | Notoplanidae | Notoplana | Notoplana australis | |
| 6195545 | 6195545 | PRJNA450343_P_NODE_13765_length_161_cov_0.910714_g13697_i0 | PRJNA450343 | 13765 | 161 | 0.910714 | 1.46624954 | Polycladida | 6163 | Platyhelminthes | Platyhelminthes | 65.8 | 1.72e-6 | NTclustered | gi|1841753|gb|U83575.1|SZU83575 | 46768 | g13697 | i0 | 100 | 0.869565217391304 | 35 | 0 | 22 | 0 | 127 | 161 | 51 | 17 | Stylochus zebra spliced leader RNA gene, complete sequence | blastn | 140 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Polycladida | Stylochidae | Stylochus | Stylochus zebra | |
| 8092225 | 8092225 | PRJNA450343_P_NODE_14207_length_155_cov_2.396226_g14139_i0 | PRJNA450343 | 14207 | 155 | 2.396226 | 3.7141503 | Hoploplana elisabelloi | 1714492 | Platyhelminthes | Platyhelminthes | 165 | 1.57e-36 | NTclustered | gi|944542428|ref|NC_028200.1| | 1714492 | g14139 | i0 | 89.844 | 1.03225806451613 | 128 | 13 | 83 | 0 | 15 | 142 | 131 | 4 | Hoploplana elisabelloi (nomen nudum) mitochondrion, complete genome | blastn | 160 | 165 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Polycladida | Hoploplanidae | Hoploplana | Hoploplana elisabelloi | |
| 8092261 | 8092261 | PRJNA450343_P_NODE_667_length_699_cov_10.092308_g613_i0 | PRJNA450343 | 667 | 699 | 10.092308 | 70.54523292 | Planocera multitentaculata | 31247 | Platyhelminthes | Platyhelminthes | 1273 | 0 | NTclustered | gi|1782648251|dbj|LC503532.1| | 31247 | g613 | i0 | 99.57 | 4.95135908440629 | 698 | 3 | 99 | 0 | 2 | 699 | 15563 | 14866 | Planocera multitentaculata mitochondrial DNA, nearly complete genome | blastn | 3461 | 1273 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Polycladida | Planoceridae | Planocera | Planocera multitentaculata | |
| 10642941 | 10642941 | PRJNA450343_P_NODE_5909_length_220_cov_1.099415_g5841_i0 | PRJNA450343 | 5909 | 220 | 1.099415 | 2.418713 | Planocera multitentaculata | 31247 | Platyhelminthes | Platyhelminthes | 390 | 3.629999999999999e-104 | NTclustered | gi|1782648251|dbj|LC503532.1| | 31247 | g5841 | i0 | 99.078 | 1.98636363636364 | 217 | 2 | 99 | 0 | 1 | 217 | 10297 | 10513 | Planocera multitentaculata mitochondrial DNA, nearly complete genome | blastn | 437 | 390 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Polycladida | Planoceridae | Planocera | Planocera multitentaculata | |
| 11295634 | 11295634 | PRJNA450343_P_NODE_309_length_1009_cov_19.690625_g271_i0 | PRJNA450343 | 309 | 1009 | 19.690625 | 198.67840625 | Planocera | 6167 | Platyhelminthes | Platyhelminthes | 623 | 1.73e-173 | NTclustered | gi|1782648251|dbj|LC503532.1| | 31247 | g271 | i0 | 85.323 | 49.5391476709613 | 620 | 71 | 60 | 17 | 395 | 1004 | 2100 | 2709 | Planocera multitentaculata mitochondrial DNA, nearly complete genome | blastn | 49985 | 623 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Polycladida | Planoceridae | Planocera | Planocera multitentaculata | |
| 11917797 | 11917797 | PRJNA450343_P_NODE_3430_length_289_cov_1.275000_g3362_i0 | PRJNA450343 | 3430 | 289 | 1.275 | 3.68475 | Planocera reticulata | 6168 | Platyhelminthes | Platyhelminthes | 534 | 2.18e-147 | NTclustered | gi|1782648238|dbj|LC503531.1| | 6168 | g3362 | i0 | 100 | 7.98961937716263 | 289 | 0 | 100 | 0 | 1 | 289 | 14983 | 14695 | Planocera reticulata mitochondrial DNA, nearly complete genome | blastn | 2309 | 534 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Polycladida | Planoceridae | Planocera | Planocera reticulata | |
| 12571396 | 12571396 | PRJNA450343_P_NODE_2130_length_374_cov_38.726154_g2062_i0 | PRJNA450343 | 2130 | 374 | 38.726154 | 144.83581596 | Polycladida | 6163 | Platyhelminthes | Platyhelminthes | 652 | 0 | NTclustered | gi|1735571208|gb|MN421937.1| | 107733 | g2062 | i0 | 99.174 | 91.7245989304813 | 363 | 2 | 97 | 1 | 11 | 372 | 1 | 363 | Leptoplana tremellaris isolate Egger et al. 2015 small subunit ribosomal RNA gene, partial sequence | blastn | 34305 | 654 | 0.996941896024465 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Polycladida | Leptoplanidae | Leptoplana | Leptoplana tremellaris | |
| 13192611 | 13192611 | PRJNA450343_P_NODE_2311_length_357_cov_3.016234_g2243_i0 | PRJNA450343 | 2311 | 357 | 3.016234 | 10.76795538 | Planocera multitentaculata | 31247 | Platyhelminthes | Platyhelminthes | 643 | 4.379999999999998e-180 | NTclustered | gi|1782648251|dbj|LC503532.1| | 31247 | g2243 | i0 | 99.16 | 2.97759103641457 | 357 | 3 | 100 | 0 | 1 | 357 | 9366 | 9010 | Planocera multitentaculata mitochondrial DNA, nearly complete genome | blastn | 1063 | 643 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Polycladida | Planoceridae | Planocera | Planocera multitentaculata | |
| 13192630 | 13192630 | PRJNA450343_P_NODE_4371_length_254_cov_1.736585_g4303_i0 | PRJNA450343 | 4371 | 254 | 1.736585 | 4.4109259 | Planocera multitentaculata | 31247 | Platyhelminthes | Platyhelminthes | 468 | 1.93e-127 | NTclustered | gi|1782648251|dbj|LC503532.1| | 31247 | g4303 | i0 | 100 | 7.83464566929134 | 253 | 0 | 99 | 0 | 1 | 253 | 3691 | 3943 | Planocera multitentaculata mitochondrial DNA, nearly complete genome | blastn | 1990 | 468 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Polycladida | Planoceridae | Planocera | Planocera multitentaculata | |
| 13192633 | 13192633 | PRJNA450343_P_NODE_4711_length_244_cov_1.394872_g4643_i0 | PRJNA450343 | 4711 | 244 | 1.394872 | 3.40348768 | Opisthorchis viverrini | 6198 | Platyhelminthes | Platyhelminthes | 95.3 | 3.61e-15 | NTclustered | gi|684394421|ref|XM_009172631.1| | 6198 | g4643 | i0 | 92.424 | 11.6024590163934 | 66 | 5 | 27 | 0 | 1 | 66 | 1374 | 1439 | Opisthorchis viverrini hypothetical protein partial mRNA | blastn | 2831 | 95.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 14467687 | 14467687 | PRJNA450343_P_NODE_2432_length_348_cov_1.598662_g2364_i0 | PRJNA450343 | 2432 | 348 | 1.598662 | 5.56334376 | Planocera multitentaculata | 31247 | Platyhelminthes | Platyhelminthes | 638 | 1.99e-178 | NTclustered | gi|1863067187|dbj|LC516525.1| | 31247 | g2364 | i0 | 99.713 | 45.0833333333333 | 348 | 1 | 100 | 0 | 1 | 348 | 435 | 88 | Planocera multitentaculata Pmalpha01 mitochondrial COI gene for cytochrome c oxidase subunit I, partial cds | blastn | 15689 | 638 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Polycladida | Planoceridae | Planocera | Planocera multitentaculata | |
| 14467699 | 14467699 | PRJNA450343_P_NODE_4912_length_239_cov_1.763158_g4844_i0 | PRJNA450343 | 4912 | 239 | 1.763158 | 4.21394762 | Planocera multitentaculata | 31247 | Platyhelminthes | Platyhelminthes | 424 | 3.95e-114 | NTclustered | gi|1782648251|dbj|LC503532.1| | 31247 | g4844 | i0 | 98.739 | 2.91213389121339 | 238 | 3 | 99 | 0 | 2 | 239 | 11100 | 11337 | Planocera multitentaculata mitochondrial DNA, nearly complete genome | blastn | 696 | 424 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Polycladida | Planoceridae | Planocera | Planocera multitentaculata | |
| 18290733 | 18290733 | PRJNA450343_P_NODE_775_length_643_cov_4.971380_g715_i0 | PRJNA450343 | 775 | 643 | 4.97138 | 31.9659734 | Planocera multitentaculata | 31247 | Platyhelminthes | Platyhelminthes | 1140 | 0 | NTclustered | gi|1782648251|dbj|LC503532.1| | 31247 | g715 | i0 | 98.903 | 17.3017107309487 | 638 | 7 | 99 | 0 | 1 | 638 | 12271 | 12908 | Planocera multitentaculata mitochondrial DNA, nearly complete genome | blastn | 11125 | 1140 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Polycladida | Planoceridae | Planocera | Planocera multitentaculata | |
| 19564849 | 19564849 | PRJNA450343_P_NODE_296_length_1025_cov_44.973361_g259_i0 | PRJNA450343 | 296 | 1025 | 44.973361 | 460.97695025 | Planocera multitentaculata | 31247 | Platyhelminthes | Platyhelminthes | 1879 | 0 | NTclustered | gi|1782648251|dbj|LC503532.1| | 31247 | g259 | i0 | 99.902 | 51.0721951219512 | 1020 | 1 | 99 | 0 | 1 | 1020 | 1690 | 2709 | Planocera multitentaculata mitochondrial DNA, nearly complete genome | blastn | 52349 | 1879 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Polycladida | Planoceridae | Planocera | Planocera multitentaculata | |
| 20840681 | 20840681 | PRJNA450343_P_NODE_437_length_859_cov_4.314815_g393_i0 | PRJNA450343 | 437 | 859 | 4.314815 | 37.06426085 | Planocera multitentaculata | 31247 | Platyhelminthes | Platyhelminthes | 1565 | 0 | NTclustered | gi|1782648251|dbj|LC503532.1| | 31247 | g393 | i0 | 99.534 | 41.7392316647264 | 859 | 4 | 100 | 0 | 1 | 859 | 708 | 1566 | Planocera multitentaculata mitochondrial DNA, nearly complete genome | blastn | 35854 | 1565 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Polycladida | Planoceridae | Planocera | Planocera multitentaculata | |
| 20840709 | 20840709 | PRJNA450343_P_NODE_8297_length_188_cov_1.467626_g8229_i0 | PRJNA450343 | 8297 | 188 | 1.467626 | 2.75913688 | Planocera multitentaculata | 31247 | Platyhelminthes | Platyhelminthes | 339 | 1.1e-88 | NTclustered | gi|1782648251|dbj|LC503532.1| | 31247 | g8229 | i0 | 100 | 9.74468085106383 | 183 | 0 | 97 | 0 | 6 | 188 | 14505 | 14687 | Planocera multitentaculata mitochondrial DNA, nearly complete genome | blastn | 1832 | 339 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Polycladida | Planoceridae | Planocera | Planocera multitentaculata | |
| 23391292 | 23391292 | PRJNA450343_P_NODE_5519_length_226_cov_1.937853_g5451_i0 | PRJNA450343 | 5519 | 226 | 1.937853 | 4.37954778 | Planocera multitentaculata | 31247 | Platyhelminthes | Platyhelminthes | 418 | 1.7199999999999998e-112 | NTclustered | gi|1782648251|dbj|LC503532.1| | 31247 | g5451 | i0 | 100 | 8.84513274336283 | 226 | 0 | 100 | 0 | 1 | 226 | 14212 | 14437 | Planocera multitentaculata mitochondrial DNA, nearly complete genome | blastn | 1999 | 418 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Polycladida | Planoceridae | Planocera | Planocera multitentaculata | |
| 23391299 | 23391299 | PRJNA450343_P_NODE_719_length_672_cov_8.019262_g613_i1 | PRJNA450343 | 719 | 672 | 8.019262 | 53.88944064 | Planocera multitentaculata | 31247 | Platyhelminthes | Platyhelminthes | 1125 | 0 | NTclustered | gi|1782648251|dbj|LC503532.1| | 31247 | g613 | i1 | 96.875 | 12.4508928571429 | 672 | 21 | 100 | 0 | 1 | 672 | 15537 | 14866 | Planocera multitentaculata mitochondrial DNA, nearly complete genome | blastn | 8367 | 1125 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Polycladida | Planoceridae | Planocera | Planocera multitentaculata |
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);;