contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJNA841653" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6334883 | 6334883 | PRJNA841653_P_NODE_43005_length_251_cov_28.129213_g42331_i0 | PRJNA841653 | 43005 | 251 | 28.129213 | 70.60432463 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 82.4 | 2.9e-11 | NTclustered | gi|1858375043|gb|MT622645.1| | 84095 | g42331 | i0 | 82.609 | 38.2151394422311 | 92 | 16 | 37 | 0 | 8 | 99 | 5960 | 6051 | Graffilla buccinicola small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 9592 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Rhabdocoela | Graffillidae | Graffilla | Graffilla buccinicola | |
| 11434607 | 11434607 | PRJNA841653_P_NODE_44629_length_250_cov_3348.129944_g43955_i0 | PRJNA841653 | 44629 | 250 | 3348.129944 | 8370.32486 | Rhabditophora | 147100 | Platyhelminthes | Platyhelminthes | 176 | 1.2899999999999999e-39 | NTclustered | gi|28273268|gb|AY157156.1| | 84079 | g43955 | i0 | 89.51 | 51.704 | 143 | 9 | 57 | 5 | 99 | 240 | 2894 | 2757 | Geocentrophora wagini 28S large subunit ribosomal RNA gene, partial sequence | blastn | 12926 | 176 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Lecithoepitheliata | Prorhynchidae | Geocentrophora | Geocentrophora wagini | |
| 18681496 | 18681496 | PRJNA841653_P_NODE_22155_length_346_cov_1.457875_g21481_i0 | PRJNA841653 | 22155 | 346 | 1.457875 | 5.0442475 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 204 | 8.539999999999999e-48 | NTclustered | gi|1116517974|gb|AY485340.2| | 6183 | g21481 | i0 | 83.186 | 82.2312138728324 | 226 | 34 | 65 | 4 | 10 | 233 | 6 | 229 | Schistosoma mansoni ubiquitin mRNA, partial cds | blastn | 28452 | 204 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 20357138 | 20357138 | PRJNA841653_P_NODE_38056_length_267_cov_1.438144_g37382_i0 | PRJNA841653 | 38056 | 267 | 1.438144 | 3.83984448 | Monogenea | 37945 | Platyhelminthes | Platyhelminthes | 99 | 3.09e-16 | NTclustered | gi|28273281|gb|AY157169.1| | 82849 | g37382 | i0 | 83.81 | 10.4794007490637 | 105 | 15 | 39 | 2 | 1 | 105 | 2439 | 2337 | Diclidophora denticulata 28S large subunit ribosomal RNA gene, partial sequence | blastn | 2798 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Mazocraeidea | Diclidophoridae | Diclidophora | Diclidophora denticulata | |
| 22507838 | 22507838 | PRJNA841653_P_NODE_63978_length_226_cov_24.732026_g63304_i0 | PRJNA841653 | 63978 | 226 | 24.732026 | 55.89437876 | Temnosewellia minor | 216952 | Platyhelminthes | Platyhelminthes | 150 | 6.93e-32 | NTclustered | gi|28273276|gb|AY157164.1| | 216952 | g63304 | i0 | 89.167 | 55.8318584070796 | 120 | 13 | 53 | 0 | 3 | 122 | 2666 | 2785 | Temnosewellia minor 28S large subunit ribosomal RNA gene, partial sequence | blastn | 12618 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Rhabdocoela | Temnocephalidae | Temnosewellia | Temnosewellia minor |
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);;