contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA508758" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1760009 | 1760009 | PRJNA508758_P_NODE_6902_length_886_cov_2.785978_g6065_i0 | PRJNA508758 | 6902 | 886 | 2.785978 | 24.68376508 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 54.7 | 0.025 | NTclustered | gi|690652912|emb|LN201090.1| | 99802 | g6065 | i0 | 92.105 | 0.0428893905191874 | 38 | 3 | 4 | 0 | 249 | 286 | 148 | 185 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0171086 | blastn | 38 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 5588413 | 5588413 | PRJNA508758_P_NODE_4845_length_1107_cov_2.944874_g4250_i0 | PRJNA508758 | 4845 | 1107 | 2.944874 | 32.59975518 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 630 | 1.1399999999999997e-175 | NTclustered | gi|1369885|gb|L78441.1|SCM14332R | 6183 | g4250 | i0 | 85.455 | 7.59891598915989 | 605 | 88 | 79 | 0 | 331 | 935 | 605 | 1 | Schistosoma mansoni 14-3-3-2 mRNA, 3' end of cds | blastn | 8412 | 630 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 5588546 | 5588546 | PRJNA508758_P_NODE_6585_length_916_cov_6.512456_g5772_i0 | PRJNA508758 | 6585 | 916 | 6.512456 | 59.65409696 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 73.1 | 7.1e-8 | NTclustered | gi|690677799|emb|LN229752.1| | 99802 | g5772 | i0 | 92.308 | 6.50436681222707 | 52 | 2 | 5 | 2 | 765 | 814 | 476 | 425 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_contig0042753 | blastn | 5958 | 73.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 11963401 | 11963401 | PRJNA508758_P_NODE_49550_length_301_cov_1.785088_g48502_i0 | PRJNA508758 | 49550 | 301 | 1.785088 | 5.37311488 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 442 | 1.4199999999999995e-119 | NTclustered | gi|1116517974|gb|AY485340.2| | 6183 | g48502 | i0 | 96.617 | 327.468438538206 | 266 | 9 | 100 | 0 | 6 | 271 | 266 | 1 | Schistosoma mansoni ubiquitin mRNA, partial cds | blastn | 98568 | 442 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 24710946 | 24710946 | PRJNA508758_P_NODE_85400_length_243_cov_0.905882_g84352_i0 | PRJNA508758 | 85400 | 243 | 0.905882 | 2.20129326 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 54.7 | 0.006 | NTclustered | gi|686667920|emb|LK404588.1| | 57078 | g84352 | i0 | 100 | 0.119341563786008 | 29 | 0 | 12 | 0 | 131 | 159 | 29 | 1 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_scaffold0011199 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 25337039 | 25337039 | PRJNA508758_P_NODE_19080_length_461_cov_1.778351_g18033_i0 | PRJNA508758 | 19080 | 461 | 1.778351 | 8.19819811 | Tricladida | 6159 | Platyhelminthes | Platyhelminthes | 171 | 1.18e-37 | NTclustered | gi|109631049|gb|DQ665969.1| | 56553 | g18033 | i0 | 76.524 | 57.1822125813449 | 328 | 68 | 70 | 7 | 6 | 330 | 1104 | 1425 | Dugesia sicula 28S ribosomal RNA gene, partial sequence | blastn | 26361 | 171 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia sicula |
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);;