contig_metadata
8 rows where bioproject = "PRJNA613025", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 591737 | 591737 | PRJNA613025_S_NODE_20441_length_216_cov_2.125749_g20287_i0 | PRJNA613025 | 20441 | 216 | 2.125749 | 4.59161784 | Palombiella stephensoni | 391282 | Platyhelminthes | Platyhelminthes | 67.6 | 6.81e-7 | NTclustered | gi|109631068|gb|DQ665988.1| | 391282 | g20287 | i0 | 97.436 | 10.0416666666667 | 39 | 1 | 18 | 0 | 124 | 162 | 1266 | 1304 | Palombiella stephensoni 28S ribosomal RNA gene, partial sequence | blastn | 2169 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Bdellouridae | Palombiella | Palombiella stephensoni | |
| 1867734 | 1867734 | PRJNA613025_S_NODE_22502_length_202_cov_3.000000_g22348_i0 | PRJNA613025 | 22502 | 202 | 3 | 6.06 | Macrostomum poznaniense | 2614303 | Platyhelminthes | Platyhelminthes | 374 | 3.3e-99 | NTclustered | gi|1837893560|gb|MT429061.1| | 2614303 | g22348 | i0 | 100 | 99.8613861386139 | 202 | 0 | 100 | 0 | 1 | 202 | 206 | 5 | Macrostomum poznaniense voucher MTP_LS_2365 large subunit ribosomal RNA gene, partial sequence | blastn | 20172 | 374 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum poznaniense | |
| 4419086 | 4419086 | PRJNA613025_S_NODE_12944_length_317_cov_2.869403_g12790_i0 | PRJNA613025 | 12944 | 317 | 2.869403 | 9.09600751 | Macrostomum poznaniense | 2614303 | Platyhelminthes | Platyhelminthes | 586 | 6.579999999999998e-163 | NTclustered | gi|1837893560|gb|MT429061.1| | 2614303 | g12790 | i0 | 100 | 100.271293375394 | 317 | 0 | 100 | 0 | 1 | 317 | 725 | 409 | Macrostomum poznaniense voucher MTP_LS_2365 large subunit ribosomal RNA gene, partial sequence | blastn | 31786 | 586 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum poznaniense | |
| 9520262 | 9520262 | PRJNA613025_S_NODE_29988_length_167_cov_1.330508_g29834_i0 | PRJNA613025 | 29988 | 167 | 1.330508 | 2.22194836 | Stenostomum leucops | 52061 | Platyhelminthes | Platyhelminthes | 309 | 7.53e-80 | NTclustered | gi|209968685|gb|FJ384848.1| | 52061 | g29834 | i0 | 100 | 50.8203592814371 | 167 | 0 | 100 | 0 | 1 | 167 | 22 | 188 | Stenostomum leucops isolate K04_75 28S ribosomal RNA gene, partial sequence | blastn | 8487 | 309 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum leucops | |||
| 15894924 | 15894924 | PRJNA613025_S_NODE_32633_length_163_cov_0.894737_g32479_i0 | PRJNA613025 | 32633 | 163 | 0.894737 | 1.45842131 | Gyratrix proavus | 1524983 | Platyhelminthes | Platyhelminthes | 165 | 1.67e-36 | NTclustered | gi|2070656566|gb|MZ599130.1| | 1524983 | g32479 | i0 | 85.897 | 63.1288343558282 | 156 | 20 | 95 | 2 | 9 | 163 | 1477 | 1323 | Gyratrix proavus isolate 86_KAT_M large subunit ribosomal RNA gene, partial sequence | blastn | 10290 | 165 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Rhabdocoela | Polycystididae | Gyratrix | Gyratrix proavus | |
| 24100654 | 24100654 | PRJNA613025_S_NODE_25379_length_186_cov_2.262774_g25225_i0 | PRJNA613025 | 25379 | 186 | 2.262774 | 4.20875964 | Macrostomum | 39217 | Platyhelminthes | Platyhelminthes | 337 | 3.9199999999999994e-88 | NTclustered | gi|848094824|gb|KP730496.1| | 52054 | g25225 | i0 | 99.459 | 90.9731182795699 | 185 | 1 | 99 | 0 | 1 | 185 | 37 | 221 | Macrostomum tuba voucher MTP LS 586 18S ribosomal RNA gene, partial sequence | blastn | 16921 | 337 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum tuba | |
| 26953558 | 26953558 | PRJNA613025_S_NODE_28082_length_174_cov_2.408000_g27928_i0 | PRJNA613025 | 28082 | 174 | 2.408 | 4.18992 | Trichobilharzia regenti | 157069 | Platyhelminthes | Platyhelminthes | 98.6 | 4.11e-23 | NR | CAH8870124.1 | 157069 | g27928 | i0 | 82.1 | 0.96551724137931 | 56 | 10 | 96.6 | 0 | 5 | 172 | 71 | 126 | CAH8870124.1 unnamed protein product [Trichobilharzia regenti] | diamond | 168 | 98.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Trichobilharzia | Trichobilharzia regenti | |
| 31547244 | 31547244 | PRJNA613025_S_NODE_26596_length_181_cov_0.863636_g26442_i0 | PRJNA613025 | 26596 | 181 | 0.863636 | 1.56318116 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 44.7 | 0.00345 | NR | AAX27390.2 | 6182 | g26442 | i0 | 39.7 | 13.4585635359116 | 58 | 33 | 96.1 | 1 | 175 | 2 | 315 | 370 | AAX27390.2 SJCHGC06130 protein, partial [Schistosoma japonicum] | diamond | 2436 | 45.1 | 0.991130820399113 | 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);;