contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA795983" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4608682 | 4608682 | PRJNA795983_S_NODE_784_length_1033_cov_3.650000_g721_i0 | PRJNA795983 | 784 | 1033 | 3.65 | 37.7045 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 1157 | 0 | NTclustered | gi|1369885|gb|L78441.1|SCM14332R | 6183 | g721 | i0 | 91.349 | 14.1926427879961 | 867 | 44 | 82 | 13 | 12 | 856 | 858 | 1 | Schistosoma mansoni 14-3-3-2 mRNA, 3' end of cds | blastn | 14661 | 1157 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 9708517 | 9708517 | PRJNA795983_S_NODE_6988_length_443_cov_4.143243_g6863_i0 | PRJNA795983 | 6988 | 443 | 4.143243 | 18.35456649 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 730 | 0 | NTclustered | gi|68479954|gb|DQ076149.1| | 6182 | g6863 | i0 | 96.804 | 0.988713318284424 | 438 | 13 | 99 | 1 | 2 | 439 | 449 | 13 | Schistosoma japonicum clone 1XA1 unknown mRNA | blastn | 438 | 730 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 10144981 | 10144981 | PRJNA795983_S_NODE_15328_length_335_cov_1.564885_g15203_i0 | PRJNA795983 | 15328 | 335 | 1.564885 | 5.24236475 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 243 | 1.75e-59 | NTclustered | gi|359318420|gb|JN968463.2| | 6161 | g15203 | i0 | 80.061 | 25.1970149253731 | 326 | 65 | 97 | 0 | 3 | 328 | 1606 | 1281 | Dugesia japonica glucose-regulated protein 78 (grp78) mRNA, complete cds | blastn | 8441 | 243 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia japonica | |
| 14808706 | 14808706 | PRJNA795983_S_NODE_31412_length_263_cov_1.721053_g31287_i0 | PRJNA795983 | 31412 | 263 | 1.721053 | 4.52636939 | Schmidtea mediterranea | 79327 | Platyhelminthes | Platyhelminthes | 220 | 6.22e-53 | NTclustered | gi|2029882162|gb|MT411562.1| | 79327 | g31287 | i0 | 84.375 | 51.8326996197719 | 224 | 35 | 85 | 0 | 38 | 261 | 496 | 273 | Schmidtea mediterranea BIP-1 (bip-1) mRNA, partial cds | blastn | 13632 | 220 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Schmidtea | Schmidtea mediterranea | |
| 16082508 | 16082508 | PRJNA795983_S_NODE_1833_length_746_cov_4.548291_g1734_i0 | PRJNA795983 | 1833 | 746 | 4.548291 | 33.93025086 | Schistosoma turkestanicum | 1163369 | Platyhelminthes | Platyhelminthes | 656 | 0 | NTclustered | gi|66732686|gb|DQ017265.1| | 1163369 | g1734 | i0 | 83.764 | 89.0187667560322 | 696 | 109 | 93 | 4 | 52 | 745 | 1200 | 507 | Orientobilharzia turkestanicum actin mRNA, complete cds | blastn | 66408 | 656 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma turkestanicum | |
| 22457402 | 22457402 | PRJNA795983_S_NODE_4018_length_546_cov_1.959831_g3896_i0 | PRJNA795983 | 4018 | 546 | 1.959831 | 10.70067726 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 409 | 2.7699999999999997e-109 | NTclustered | gi|226478901|emb|FN317215.1| | 6182 | g3896 | i0 | 81.653 | 48.029304029304 | 496 | 87 | 90 | 3 | 50 | 543 | 58 | 551 | Schistosoma japonicum isolate Anhui full length mRNA clone SJFCE0797|FSE_080_96_H12, complete sequence | blastn | 26224 | 409 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 22894140 | 22894140 | PRJNA795983_S_NODE_5558_length_481_cov_4.909314_g5433_i0 | PRJNA795983 | 5558 | 481 | 4.909314 | 23.61380034 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 394 | 6.76e-105 | NTclustered | gi|21308066|gb|AY067433.1| | 79327 | g5433 | i0 | 83.61 | 88.2661122661123 | 421 | 67 | 87 | 2 | 59 | 478 | 1 | 420 | Schmidtea mediterranea unknown mRNA sequence | blastn | 42456 | 394 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Schmidtea | Schmidtea mediterranea |
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);;