contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA928559" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7281202 | 7281202 | PRJNA928559_P_NODE_187646_length_253_cov_1.266667_g186077_i0 | PRJNA928559 | 187646 | 253 | 1.266667 | 3.20466751 | Kytorhynchus sp. n. CEL-2014 | 1468206 | Platyhelminthes | Platyhelminthes | 75 | 4.9e-9 | NTclustered | gi|588313924|gb|KC869882.1| | 1468206 | g186077 | i0 | 85.915 | 0.280632411067194 | 71 | 8 | 28 | 2 | 164 | 233 | 2199 | 2130 | Kytorhynchus sp. n. CEL-2014 28S ribosomal RNA gene, partial sequence | blastn | 71 | 75 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Rhabdocoela | Kytorhynchidae | Kytorhynchus | Kytorhynchus sp. n. CEL-2014 | |
| 8557099 | 8557099 | PRJNA928559_P_NODE_58327_length_454_cov_17.737533_g56760_i0 | PRJNA928559 | 58327 | 454 | 17.737533 | 80.52839982 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 736 | 0 | NTclustered | gi|68479954|gb|DQ076149.1| | 6182 | g56760 | i0 | 96.622 | 0.977973568281938 | 444 | 13 | 98 | 2 | 1 | 443 | 454 | 12 | Schistosoma japonicum clone 1XA1 unknown mRNA | blastn | 444 | 736 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 9829844 | 9829844 | PRJNA928559_P_NODE_113368_length_335_cov_1.564885_g111799_i0 | PRJNA928559 | 113368 | 335 | 1.564885 | 5.24236475 | Macrogyrodactylus karibae | 696689 | Platyhelminthes | Platyhelminthes | 436 | 7.459999999999998e-118 | NTclustered | gi|1346678829|gb|MG973078.1| | 696689 | g111799 | i0 | 90.149 | 52.5462686567164 | 335 | 33 | 100 | 0 | 1 | 335 | 4992 | 5326 | Macrogyrodactylus karibae isolate M_ka small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 17603 | 436 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Gyrodactylidea | Gyrodactylidae | Macrogyrodactylus | Macrogyrodactylus karibae | |
| 10181682 | 10181682 | PRJNA928559_P_NODE_226728_length_205_cov_10.856061_g225159_i0 | PRJNA928559 | 226728 | 205 | 10.856061 | 22.25492505 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 130 | 8.04e-26 | NTclustered | gi|2620230845|gb|OR797296.1| | 132421 | g225159 | i0 | 84.173 | 45.6926829268293 | 139 | 17 | 67 | 5 | 68 | 204 | 5324 | 5459 | Arthurdendyus triangulatus small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 9367 | 130 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Geoplanidae | Arthurdendyus | Arthurdendyus triangulatus | |
| 14930661 | 14930661 | PRJNA928559_P_NODE_160272_length_277_cov_1.911765_g158703_i0 | PRJNA928559 | 160272 | 277 | 1.911765 | 5.29558905 | Clonorchis sinensis | 79923 | Platyhelminthes | Platyhelminthes | 106 | 1.93e-18 | NTclustered | gi|325459339|gb|HM020387.1| | 79923 | g158703 | i0 | 77.596 | 11.3321299638989 | 183 | 35 | 66 | 5 | 44 | 226 | 376 | 200 | Clonorchis sinensis secretory eggshell protein precursor (SEP18.7) mRNA, complete cds | blastn | 3139 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Clonorchis | Clonorchis sinensis | |
| 17830658 | 17830658 | PRJNA928559_P_NODE_6214_length_1199_cov_12.235346_g5280_i0 | PRJNA928559 | 6214 | 1199 | 12.235346 | 146.70179854 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 204 | 3.19e-47 | NTclustered | gi|667755613|gb|KJ887547.1| | 1524992 | g5280 | i0 | 87.931 | 15.6246872393661 | 174 | 20 | 15 | 1 | 234 | 407 | 1156 | 984 | Toia sp. TJ-2014 voucher DNA89LAN 28S ribosomal RNA gene, partial sequence | blastn | 18734 | 206 | 0.990291262135922 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Rhabdocoela | Cicerinidae | Toia | Toia sp. TJ-2014 | |
| 21305303 | 21305303 | PRJNA928559_P_NODE_195677_length_250_cov_0.881356_g194108_i0 | PRJNA928559 | 195677 | 250 | 0.881356 | 2.20339 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 52.8 | 0.023 | NTclustered | gi|690505019|emb|LN053604.1| | 99802 | g194108 | i0 | 100 | 0.224 | 28 | 0 | 11 | 0 | 215 | 242 | 2870 | 2897 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0052090 | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 22580185 | 22580185 | PRJNA928559_P_NODE_178598_length_260_cov_2.032086_g177029_i0 | PRJNA928559 | 178598 | 260 | 2.032086 | 5.2834236 | Macrogyrodactylus karibae | 696689 | Platyhelminthes | Platyhelminthes | 272 | 1.6699999999999996e-68 | NTclustered | gi|1346678829|gb|MG973078.1| | 696689 | g177029 | i0 | 85.769 | 25.8884615384615 | 260 | 34 | 99 | 3 | 1 | 258 | 6545 | 6287 | Macrogyrodactylus karibae isolate M_ka small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 6731 | 272 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Gyrodactylidea | Gyrodactylidae | Macrogyrodactylus | Macrogyrodactylus karibae | |
| 25128994 | 25128994 | PRJNA928559_P_NODE_170500_length_267_cov_3.474227_g168931_i0 | PRJNA928559 | 170500 | 267 | 3.474227 | 9.27618609 | Strongylostoma elongatum | 297429 | Platyhelminthes | Platyhelminthes | 113 | 1.1e-20 | NTclustered | gi|588313925|gb|KC869883.1| | 1468203 | g168931 | i0 | 75.889 | 72.2584269662921 | 253 | 43 | 92 | 17 | 2 | 247 | 1105 | 1346 | Strongylostoma elongatum spinosum 28S ribosomal RNA genes, partial sequence | blastn | 19293 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Rhabdocoela | Typhloplanidae | Strongylostoma | Strongylostoma elongatum | |
| 25130710 | 25130710 | PRJNA928559_P_NODE_87740_length_379_cov_5.274510_g86171_i0 | PRJNA928559 | 87740 | 379 | 5.27451 | 19.9903929 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 468 | 3.03e-127 | NTclustered | gi|68479954|gb|DQ076149.1| | 6182 | g86171 | i0 | 88.947 | 1.00263852242744 | 380 | 40 | 100 | 2 | 1 | 379 | 44 | 422 | Schistosoma japonicum clone 1XA1 unknown mRNA | blastn | 380 | 468 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum |
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);;