contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA255848" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1057010 | 1057010 | PRJNA255848_P_NODE_34221_length_169_cov_1.275000_g33903_i0 | PRJNA255848 | 34221 | 169 | 1.275 | 2.15475 | Schistosoma | 6181 | Platyhelminthes | Platyhelminthes | 313 | 5.859999999999999e-81 | NTclustered | gi|28273285|gb|AY157173.1| | 6183 | g33903 | i0 | 100 | 89.8934911242604 | 169 | 0 | 100 | 0 | 1 | 169 | 2051 | 1883 | Schistosoma mansoni 28S large subunit ribosomal RNA gene, partial sequence | blastn | 15192 | 313 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 1643473 | 1643473 | PRJNA255848_P_NODE_29182_length_184_cov_1.385185_g28864_i0 | PRJNA255848 | 29182 | 184 | 1.3851850000000001 | 2.5487404 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 279 | 6.61e-71 | NTclustered | gi|3282532|gb|AF025674.1| | 6183 | g28864 | i0 | 94.944 | 93.5869565217391 | 178 | 9 | 97 | 0 | 1 | 178 | 2797 | 2974 | Schistosoma mansoni SR2 subfamily A non-LTR retrotransposon containing an insertion of a SR2 subfamily B non-LTR retrotransposon | blastn | 17220 | 279 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 10572671 | 10572671 | PRJNA255848_P_NODE_14889_length_259_cov_1.885714_g14571_i0 | PRJNA255848 | 14889 | 259 | 1.885714 | 4.88399926 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 477 | 3.2799999999999986e-130 | NTclustered | gi|1084307458|ref|XR_001974607.1| | 6183 | g14571 | i0 | 100 | 98.5868725868726 | 258 | 0 | 99 | 0 | 2 | 259 | 1441 | 1184 | Schistosoma mansoni ribosomal RNA rRNA | blastn | 25534 | 477 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 15671463 | 15671463 | PRJNA255848_P_NODE_35673_length_167_cov_0.864407_g35355_i0 | PRJNA255848 | 35673 | 167 | 0.864407 | 1.44355969 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 296 | 5.86e-76 | NTclustered | gi|1084302595|ref|XM_018788890.1| | 6183 | g35355 | i0 | 98.795 | 1.98802395209581 | 166 | 2 | 99 | 0 | 1 | 166 | 1078 | 1243 | Schistosoma mansoni putative glutamate synthase partial mRNA | blastn | 332 | 296 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 15671526 | 15671526 | PRJNA255848_P_NODE_47893_length_161_cov_0.910714_g47575_i0 | PRJNA255848 | 47893 | 161 | 0.910714 | 1.46624954 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 298 | 1.56e-76 | NTclustered | gi|1084294336|ref|XM_018796014.1| | 6183 | g47575 | i0 | 100 | 4.31055900621118 | 161 | 0 | 100 | 0 | 1 | 161 | 1648 | 1488 | Schistosoma mansoni putative o-linked n-acetylglucosamine transferase, ogt partial mRNA | blastn | 694 | 298 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 16945923 | 16945923 | PRJNA255848_P_NODE_13494_length_274_cov_2.408889_g13176_i0 | PRJNA255848 | 13494 | 274 | 2.408889 | 6.60035586 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 507 | 4.47e-139 | NTclustered | gi|28273285|gb|AY157173.1| | 6183 | g13176 | i0 | 100 | 96.6569343065693 | 274 | 0 | 100 | 0 | 1 | 274 | 2749 | 2476 | Schistosoma mansoni 28S large subunit ribosomal RNA gene, partial sequence | blastn | 26484 | 507 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 16946021 | 16946021 | PRJNA255848_P_NODE_39274_length_165_cov_0.879310_g38956_i0 | PRJNA255848 | 39274 | 165 | 0.87931 | 1.4508615 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 119 | 1.34e-22 | NTclustered | gi|60598747|gb|AY810034.1| | 6182 | g38956 | i0 | 90.11 | 1.55151515151515 | 91 | 9 | 55 | 0 | 75 | 165 | 101 | 11 | Schistosoma japonicum SJCHGC06689 protein mRNA, partial cds | blastn | 256 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 18220444 | 18220444 | PRJNA255848_P_NODE_7895_length_379_cov_2.006061_g7577_i0 | PRJNA255848 | 7895 | 379 | 2.006061 | 7.60297119 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 701 | 0 | NTclustered | gi|1495840396|gb|MK085970.1| | 6183 | g7577 | i0 | 100 | 98.868073878628 | 379 | 0 | 100 | 0 | 1 | 379 | 466 | 844 | Schistosoma mansoni voucher LVBI12FC1 large subunit ribosomal RNA gene, partial sequence | blastn | 37471 | 701 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 22733792 | 22733792 | PRJNA255848_P_NODE_36838_length_166_cov_1.418803_g36520_i0 | PRJNA255848 | 36838 | 166 | 1.418803 | 2.35521298 | Schistosomatidae | 31245 | Platyhelminthes | Platyhelminthes | 307 | 2.69e-79 | NTclustered | gi|1805255|gb|U65657.1|SMU65657 | 6183 | g36520 | i0 | 100 | 100.006024096386 | 166 | 0 | 100 | 0 | 1 | 166 | 1802 | 1637 | Schistosoma mansoni 18S ribosomal RNA gene, complete sequence | blastn | 16601 | 307 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 24008828 | 24008828 | PRJNA255848_P_NODE_20239_length_221_cov_2.168605_g19921_i0 | PRJNA255848 | 20239 | 221 | 2.168605 | 4.79261705 | Schistosoma | 6181 | Platyhelminthes | Platyhelminthes | 409 | 1.0100000000000001e-109 | NTclustered | gi|28273285|gb|AY157173.1| | 6183 | g19921 | i0 | 100 | 101.203619909502 | 221 | 0 | 100 | 0 | 1 | 221 | 1867 | 1647 | Schistosoma mansoni 28S large subunit ribosomal RNA gene, partial sequence | blastn | 22366 | 409 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 24594890 | 24594890 | PRJNA255848_P_NODE_34920_length_167_cov_1.296610_g34602_i0 | PRJNA255848 | 34920 | 167 | 1.29661 | 2.1653387 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 309 | 7.53e-80 | NTclustered | gi|74325485|gb|DQ137574.1| | 6183 | g34602 | i0 | 100 | 92.1796407185629 | 167 | 0 | 100 | 0 | 1 | 167 | 5 | 171 | Schistosoma mansoni clone 153AAT microsatellite sequence | blastn | 15394 | 309 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 24594933 | 24594933 | PRJNA255848_P_NODE_43880_length_163_cov_0.894737_g43562_i0 | PRJNA255848 | 43880 | 163 | 0.894737 | 1.45842131 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 250 | 4.49e-62 | NTclustered | gi|1084302811|ref|XM_018789011.1| | 6183 | g43562 | i0 | 98.582 | 5.57668711656442 | 141 | 2 | 87 | 0 | 1 | 141 | 160 | 20 | Schistosoma mansoni pbs lyase heat-like protein partial mRNA | blastn | 909 | 250 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 25282893 | 25282893 | PRJNA255848_P_NODE_11880_length_296_cov_1.230769_g11562_i0 | PRJNA255848 | 11880 | 296 | 1.230769 | 3.64307624 | Schistosoma | 6181 | Platyhelminthes | Platyhelminthes | 547 | 2.8799999999999986e-151 | NTclustered | gi|1495840396|gb|MK085970.1| | 6183 | g11562 | i0 | 100 | 99.1587837837838 | 296 | 0 | 100 | 0 | 1 | 296 | 1193 | 898 | Schistosoma mansoni voucher LVBI12FC1 large subunit ribosomal RNA gene, partial sequence | blastn | 29351 | 547 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 25282908 | 25282908 | PRJNA255848_P_NODE_12800_length_283_cov_1.833333_g12482_i0 | PRJNA255848 | 12800 | 283 | 1.833333 | 5.18833239 | Schistosoma | 6181 | Platyhelminthes | Platyhelminthes | 523 | 4.5999999999999983e-144 | NTclustered | gi|2497639026|gb|OQ883999.1| | 6183 | g12482 | i0 | 100 | 100.314487632509 | 283 | 0 | 100 | 0 | 1 | 283 | 512 | 794 | Schistosoma mansoni isolate S4 small subunit ribosomal RNA gene, partial sequence | blastn | 28389 | 523 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni |
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);;