contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA1005695" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 153658 | 153658 | PRJNA1005695_P_NODE_40681_length_237_cov_4.353659_g39829_i0 | PRJNA1005695 | 40681 | 237 | 4.353659 | 10.31817183 | Brachycladium goliath | 1751714 | Platyhelminthes | Platyhelminthes | 204 | 5.549999999999999e-48 | NTclustered | gi|950639398|gb|KR703279.1| | 1751714 | g39829 | i0 | 82.553 | 24.9789029535865 | 235 | 38 | 99 | 1 | 3 | 237 | 7040 | 6809 | Brachycladium goliath voucher NHMUK:2014.9.12.1 external transcribed spacer 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, 28S ribosomal RNA gene, and external transcribed spacer, complete sequence | blastn | 5920 | 204 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Brachycladiidae | Brachycladium | Brachycladium goliath | |
| 1001193 | 1001193 | PRJNA1005695_P_NODE_9301_length_511_cov_5.315068_g8452_i0 | PRJNA1005695 | 9301 | 511 | 5.315068 | 27.15999748 | Testudotaenia | 246868 | Platyhelminthes | Platyhelminthes | 939 | 0 | NTclustered | gi|42734675|emb|AJ583456.1| | 246869 | g8452 | i0 | 99.804 | 100.483365949119 | 511 | 1 | 100 | 0 | 1 | 511 | 384 | 894 | Testudotaenia cf. testudo partial 28S rRNA gene | blastn | 51347 | 939 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Proteocephalidea | Proteocephalidae | Testudotaenia | Testudotaenia cf. testudo | |
| 2276208 | 2276208 | PRJNA1005695_P_NODE_22202_length_318_cov_7.873469_g21350_i0 | PRJNA1005695 | 22202 | 318 | 7.873469 | 25.03763142 | Plagiorchiida | 27871 | Platyhelminthes | Platyhelminthes | 505 | 1.8999999999999995e-138 | NTclustered | gi|28273287|gb|AY157175.1| | 116879 | g21350 | i0 | 95.298 | 100.399371069182 | 319 | 14 | 100 | 1 | 1 | 318 | 2380 | 2062 | Lepidophyllum steenstrupi 28S large subunit ribosomal RNA gene, partial sequence | blastn | 31927 | 505 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Zoogonidae | Lepidophyllum | Lepidophyllum steenstrupi | |
| 3979921 | 3979921 | PRJNA1005695_P_NODE_26704_length_289_cov_3.537037_g25852_i0 | PRJNA1005695 | 26704 | 289 | 3.537037 | 10.22203693 | Stenostomum leucops | 52061 | Platyhelminthes | Platyhelminthes | 503 | 6.139999999999998e-138 | NTclustered | gi|28273263|gb|AY157151.1| | 52061 | g25852 | i0 | 98.258 | 41.3148788927336 | 287 | 5 | 99 | 0 | 2 | 288 | 2121 | 1835 | Stenostomum leucops 28S large subunit ribosomal RNA gene, partial sequence | blastn | 11940 | 503 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum leucops | |||
| 4829030 | 4829030 | PRJNA1005695_P_NODE_12164_length_442_cov_3.016260_g11312_i0 | PRJNA1005695 | 12164 | 442 | 3.01626 | 13.3318692 | Stenostomum | 39238 | Platyhelminthes | Platyhelminthes | 785 | 0 | NTclustered | gi|209968685|gb|FJ384848.1| | 52061 | g11312 | i0 | 98.864 | 56.9705882352941 | 440 | 5 | 99 | 0 | 1 | 440 | 377 | 816 | Stenostomum leucops isolate K04_75 28S ribosomal RNA gene, partial sequence | blastn | 25181 | 785 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum leucops | |||
| 6531809 | 6531809 | PRJNA1005695_P_NODE_40326_length_240_cov_4.383234_g39474_i0 | PRJNA1005695 | 40326 | 240 | 4.383234 | 10.5197616 | Artyfechinostomum malayanum | 2750923 | Platyhelminthes | Platyhelminthes | 267 | 7.08e-67 | NTclustered | gi|2594663801|gb|OR509026.1| | 2750923 | g39474 | i0 | 87.554 | 74.5333333333333 | 233 | 26 | 97 | 2 | 2 | 233 | 8555 | 8785 | Artyfechinostomum malayanum isolate EMI3 external transcribed spacer, partial sequence; small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence; and non-transcribed intergenic spacer, partial sequence | blastn | 17888 | 267 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Echinostomatidae | Artyfechinostomum | Artyfechinostomum malayanum | |
| 11632284 | 11632284 | PRJNA1005695_P_NODE_9530_length_504_cov_4.055684_g8680_i0 | PRJNA1005695 | 9530 | 504 | 4.055684 | 20.44064736 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 52.8 | 0.049 | NTclustered | gi|687163270|emb|LN038880.1| | 99802 | g8680 | i0 | 100 | 0.0555555555555556 | 28 | 0 | 6 | 0 | 103 | 130 | 768 | 741 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0037985 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 12479910 | 12479910 | PRJNA1005695_P_NODE_20910_length_329_cov_4.781250_g20058_i0 | PRJNA1005695 | 20910 | 329 | 4.78125 | 15.7303125 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 606 | 5.269999999999998e-169 | NTclustered | gi|2104522515|gb|OK338507.1| | 2879638 | g20058 | i0 | 100 | 74.9422492401216 | 328 | 0 | 99 | 0 | 2 | 329 | 887 | 560 | Renicolidae sp. II_1_Chollas voucher Renicolid_II_1_Chollas large subunit ribosomal RNA gene, partial sequence | blastn | 24656 | 606 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Renicolidae | Renicolidae sp. II_1_Chollas | ||
| 15028917 | 15028917 | PRJNA1005695_P_NODE_33432_length_257_cov_3.945652_g32580_i0 | PRJNA1005695 | 33432 | 257 | 3.945652 | 10.14032564 | Plagiorchiida | 27871 | Platyhelminthes | Platyhelminthes | 316 | 7.51e-82 | NTclustered | gi|1799639269|gb|MN970006.1| | 465907 | g32580 | i0 | 89.02 | 35.7665369649805 | 255 | 28 | 99 | 0 | 3 | 257 | 7090 | 6836 | Fasciola jacksoni isolate Madu small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence; and non-transcribed intergenic spacer, partial sequence | blastn | 9192 | 316 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola jacksoni | |
| 20554633 | 20554633 | PRJNA1005695_P_NODE_20177_length_336_cov_1.741445_g19325_i0 | PRJNA1005695 | 20177 | 336 | 1.741445 | 5.8512552 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 52.8 | 0.032 | NTclustered | gi|690573720|emb|LN122496.1| | 99802 | g19325 | i0 | 94.286 | 0.104166666666667 | 35 | 1 | 10 | 1 | 238 | 272 | 480 | 513 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0114092 | blastn | 35 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 20554803 | 20554803 | PRJNA1005695_P_NODE_3797_length_819_cov_5.489276_g3142_i0 | PRJNA1005695 | 3797 | 819 | 5.489276 | 44.95717044 | Brachycladium goliath | 1751714 | Platyhelminthes | Platyhelminthes | 235 | 7.62e-57 | NTclustered | gi|1011058740|ref|NC_029757.1| | 1751714 | g3142 | i0 | 76.872 | 7.51526251526252 | 454 | 81 | 55 | 18 | 1 | 447 | 2438 | 2002 | Brachycladium goliath voucher NHMUK:2014.9.12.1 mitochondrion, complete genome | blastn | 6155 | 235 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Brachycladiidae | Brachycladium | Brachycladium goliath | |
| 21830299 | 21830299 | PRJNA1005695_P_NODE_2698_length_969_cov_36.142857_g2126_i0 | PRJNA1005695 | 2698 | 969 | 36.142857 | 350.22428433 | Brachycladium goliath | 1751714 | Platyhelminthes | Platyhelminthes | 363 | 3.9899999999999996e-95 | NTclustered | gi|1011058740|ref|NC_029757.1| | 1751714 | g2126 | i0 | 78.383 | 54.7884416924665 | 606 | 98 | 61 | 23 | 361 | 953 | 1989 | 2574 | Brachycladium goliath voucher NHMUK:2014.9.12.1 mitochondrion, complete genome | blastn | 53090 | 363 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Brachycladiidae | Brachycladium | Brachycladium goliath | |
| 21830429 | 21830429 | PRJNA1005695_P_NODE_39858_length_242_cov_1.822485_g39006_i0 | PRJNA1005695 | 39858 | 242 | 1.822485 | 4.4104137 | Schyzocotyle acheilognathi | 135513 | Platyhelminthes | Platyhelminthes | 448 | 2.3799999999999995e-121 | NTclustered | gi|1135451336|gb|KX589243.1| | 135513 | g39006 | i0 | 100 | 101.045454545455 | 242 | 0 | 100 | 0 | 1 | 242 | 9279 | 9038 | Schyzocotyle acheilognathi isolate IHB0601 mitochondrion, complete genome | blastn | 24453 | 448 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Bothriocephalidea | Bothriocephalidae | Schyzocotyle | Schyzocotyle acheilognathi | |
| 23105754 | 23105754 | PRJNA1005695_P_NODE_26679_length_289_cov_30.513889_g25827_i0 | PRJNA1005695 | 26679 | 289 | 30.513889 | 88.18513921 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 276 | 1.46e-69 | NTclustered | gi|1084307285|ref|XR_001974651.1| | 6183 | g25827 | i0 | 84.3 | 3.88927335640138 | 293 | 34 | 99 | 10 | 3 | 289 | 290 | 4 | Schistosoma mansoni SRP_RNA | blastn | 1124 | 276 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 25227425 | 25227425 | PRJNA1005695_P_NODE_7140_length_587_cov_4.013619_g6308_i0 | PRJNA1005695 | 7140 | 587 | 4.013619 | 23.55994353 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 942 | 0 | NTclustered | gi|2104522515|gb|OK338507.1| | 2879638 | g6308 | i0 | 96.809 | 103.114139693356 | 564 | 18 | 96 | 0 | 1 | 564 | 329 | 892 | Renicolidae sp. II_1_Chollas voucher Renicolid_II_1_Chollas large subunit ribosomal RNA gene, partial sequence | blastn | 60528 | 948 | 0.993670886075949 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Renicolidae | Renicolidae sp. II_1_Chollas |
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);;