contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA857143" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 843097 | 843097 | PRJNA857143_S_NODE_130641_length_282_cov_3.698565_g129548_i0 | PRJNA857143 | 130641 | 282 | 3.698565 | 10.4299533 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 67.6 | 9.29e-7 | NTclustered | gi|690633163|emb|LN178688.1| | 99802 | g129548 | i0 | 91.837 | 0.535460992907801 | 49 | 2 | 17 | 2 | 122 | 169 | 1124 | 1171 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0156785 | blastn | 151 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 2119057 | 2119057 | PRJNA857143_S_NODE_181382_length_248_cov_0.891429_g180289_i0 | PRJNA857143 | 181382 | 248 | 0.891429 | 2.21074392 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 52.8 | 0.022 | NTclustered | gi|690495900|emb|LN042475.1| | 99802 | g180289 | i0 | 100 | 0.112903225806452 | 28 | 0 | 11 | 0 | 18 | 45 | 3230 | 3257 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0041455 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 3395134 | 3395134 | PRJNA857143_S_NODE_83643_length_333_cov_5.326923_g82550_i0 | PRJNA857143 | 83643 | 333 | 5.326923 | 17.73865359 | Diplorchis hangzhouensis | 1131906 | Platyhelminthes | Platyhelminthes | 54.7 | 0.009 | NTclustered | gi|379771686|gb|JQ038227.1| | 1131906 | g82550 | i0 | 100 | 0.0870870870870871 | 29 | 0 | 9 | 0 | 138 | 166 | 5361 | 5389 | Diplorchis hangzhouensis mitochondrion sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Polystomatidea | Polystomatidae | Diplorchis | Diplorchis hangzhouensis | |
| 5946324 | 5946324 | PRJNA857143_S_NODE_126985_length_286_cov_1.107981_g125892_i0 | PRJNA857143 | 126985 | 286 | 1.107981 | 3.16882566 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 442 | 1.3399999999999994e-119 | NTclustered | gi|56757963|gb|AY815390.1| | 6182 | g125892 | i0 | 94.737 | 118.461538461538 | 285 | 13 | 99 | 1 | 4 | 286 | 1205 | 1489 | Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds | blastn | 33880 | 442 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 5947090 | 5947090 | PRJNA857143_S_NODE_197925_length_235_cov_2.407407_g196832_i0 | PRJNA857143 | 197925 | 235 | 2.407407 | 5.65740645 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 52.8 | 0.021 | NTclustered | gi|690843830|emb|LN342126.1| | 99802 | g196832 | i0 | 96.774 | 0.131914893617021 | 31 | 1 | 13 | 0 | 92 | 122 | 777 | 747 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_contig0115339 | blastn | 31 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 7613343 | 7613343 | PRJNA857143_S_NODE_28706_length_472_cov_1.172932_g27614_i0 | PRJNA857143 | 28706 | 472 | 1.172932 | 5.53623904 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 54.7 | 0.013 | NTclustered | gi|690518042|emb|LN068899.1| | 99802 | g27614 | i0 | 96.875 | 0.665254237288136 | 32 | 1 | 7 | 0 | 12 | 43 | 3369 | 3400 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0066497 | blastn | 314 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 15263252 | 15263252 | PRJNA857143_S_NODE_142352_length_272_cov_6.768844_g141259_i0 | PRJNA857143 | 142352 | 272 | 6.768844 | 18.41125568 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 52.8 | 0.025 | NTclustered | gi|690665069|emb|LN215076.1| | 99802 | g141259 | i0 | 100 | 0.411764705882353 | 28 | 0 | 10 | 0 | 128 | 155 | 1402 | 1375 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_contig0035947 | blastn | 112 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 25069313 | 25069313 | PRJNA857143_S_NODE_140120_length_274_cov_2.328358_g139027_i0 | PRJNA857143 | 140120 | 274 | 2.328358 | 6.37970092 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 52.8 | 0.025 | NTclustered | gi|687237152|emb|LK406577.1| | 57078 | g139027 | i0 | 100 | 0.102189781021898 | 28 | 0 | 10 | 0 | 242 | 269 | 2115 | 2088 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_scaffold0013130 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum |
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);;