contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJNA564013" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9476720 | 9476720 | PRJNA564013_P_NODE_173208_length_331_cov_2.407407_g170358_i0 | PRJNA564013 | 173208 | 331 | 2.407407 | 7.96851717 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 248 | 3.7e-61 | NTclustered | gi|60698656|gb|AY915745.1| | 6182 | g170358 | i0 | 98.571 | 7.29607250755287 | 140 | 2 | 42 | 0 | 153 | 292 | 467 | 328 | Schistosoma japonicum SJCHGC09658 protein mRNA, partial cds | blastn | 2415 | 248 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 12030755 | 12030755 | PRJNA564013_P_NODE_348330_length_199_cov_12.442029_g345478_i0 | PRJNA564013 | 348330 | 199 | 12.442029 | 24.75963771 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 52.8 | 0.017 | NTclustered | gi|687688146|emb|LK600640.1| | 57078 | g345478 | i0 | 100 | 0.14070351758794 | 28 | 0 | 14 | 0 | 38 | 65 | 487 | 514 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_scaffold0190466 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 19678538 | 19678538 | PRJNA564013_P_NODE_371576_length_176_cov_21.443478_g368724_i0 | PRJNA564013 | 371576 | 176 | 21.443478 | 37.74052128 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 291 | 2.89e-74 | NTclustered | gi|56757963|gb|AY815390.1| | 6182 | g368724 | i0 | 97.11 | 122.3125 | 173 | 3 | 100 | 2 | 1 | 171 | 2334 | 2162 | Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds | blastn | 21527 | 291 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 24776000 | 24776000 | PRJNA564013_P_NODE_254680_length_257_cov_7.617347_g251828_i0 | PRJNA564013 | 254680 | 257 | 7.617347 | 19.57658179 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 374 | 4.3899999999999995e-99 | NTclustered | gi|60698688|gb|AY915747.1| | 6182 | g251828 | i0 | 98.131 | 1.98832684824903 | 214 | 4 | 83 | 0 | 23 | 236 | 165 | 378 | Schistosoma japonicum SJCHGC09661 protein mRNA, partial cds | blastn | 511 | 374 | 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);;