contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA867519" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 848003 | 848003 | PRJNA867519_P_NODE_10381_length_353_cov_1.632143_g10227_i0 | PRJNA867519 | 10381 | 353 | 1.632143 | 5.76146479 | Schistosoma haematobium | 6185 | Platyhelminthes | Platyhelminthes | 60.2 | 1.99e-4 | NTclustered | gi|2318774084|ref|XM_012943401.2| | 6185 | g10227 | i0 | 97.143 | 0.410764872521246 | 35 | 1 | 10 | 0 | 16 | 50 | 107 | 73 | Schistosoma haematobium Peptide-N(4)-(N-acetyl-beta- glucosaminyl)asparagine amidase (NGLY1_1), partial mRNA | blastn | 145 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma haematobium | |
| 848104 | 848104 | PRJNA867519_P_NODE_24981_length_252_cov_2.424581_g24827_i0 | PRJNA867519 | 24981 | 252 | 2.424581 | 6.10994412 | Stenostomum sthenum | 1611831 | Platyhelminthes | Platyhelminthes | 436 | 5.4e-118 | NTclustered | gi|1215837197|ref|NC_035256.1| | 1611831 | g24827 | i0 | 98.016 | 77.4761904761905 | 252 | 4 | 100 | 1 | 1 | 252 | 8711 | 8961 | Stenostomum sthenum mitochondrion, complete genome | blastn | 19524 | 436 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum sthenum | |||
| 17426336 | 17426336 | PRJNA867519_P_NODE_27454_length_249_cov_0.875000_g27300_i0 | PRJNA867519 | 27454 | 249 | 0.875 | 2.17875 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 52.8 | 0.023 | NTclustered | gi|690496552|emb|LN043556.1| | 99802 | g27300 | i0 | 100 | 0.112449799196787 | 28 | 0 | 11 | 0 | 1 | 28 | 3551 | 3524 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0042488 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 19974778 | 19974778 | PRJNA867519_P_NODE_6156_length_438_cov_35.397260_g6002_i0 | PRJNA867519 | 6156 | 438 | 35.39726 | 155.0399988 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 730 | 0 | NTclustered | gi|68479954|gb|DQ076149.1| | 6182 | g6002 | i0 | 96.804 | 1 | 438 | 13 | 100 | 1 | 1 | 438 | 449 | 13 | Schistosoma japonicum clone 1XA1 unknown mRNA | blastn | 438 | 730 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 21639034 | 21639034 | PRJNA867519_P_NODE_31197_length_244_cov_0.900585_g31043_i0 | PRJNA867519 | 31197 | 244 | 0.900585 | 2.1974274 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 93.5 | 1.3e-14 | NTclustered | gi|1246719163|gb|MF383122.1| | 2039861 | g31043 | i0 | 90.141 | 26.0040983606557 | 71 | 7 | 29 | 0 | 146 | 216 | 1151 | 1221 | Sluysia triapertura isolate MR1645 28S ribosomal RNA gene, partial sequence | blastn | 6345 | 93.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Uteriporidae | Sluysia | Sluysia triapertura | |
| 22524827 | 22524827 | PRJNA867519_P_NODE_25698_length_251_cov_0.865169_g25544_i0 | PRJNA867519 | 25698 | 251 | 0.865169 | 2.17157419 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 54.7 | 0.006 | NTclustered | gi|690838780|emb|LN336351.1| | 99802 | g25544 | i0 | 100 | 0.115537848605578 | 29 | 0 | 12 | 0 | 67 | 95 | 597 | 625 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_contig0110926 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei |
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);;