contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA796639" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9708716 | 9708716 | PRJNA796639_P_NODE_2368_length_364_cov_1.305842_g2243_i0 | PRJNA796639 | 2368 | 364 | 1.305842 | 4.75326488 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 226 | 5.74e-66 | NR | TNN09810.1 | 6182 | g2243 | i0 | 100 | 1.99450549450549 | 121 | 0 | 99.7 | 0 | 364 | 2 | 1373 | 1493 | TNN09810.1 hypothetical protein EWB00_005944, partial [Schistosoma japonicum] | diamond | 726 | 226 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 12260030 | 12260030 | PRJNA796639_P_NODE_5610_length_251_cov_0.865169_g5485_i0 | PRJNA796639 | 5610 | 251 | 0.865169 | 2.17157419 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 132 | 1.69e-33 | NR | TNN07314.1 | 6182 | g5485 | i0 | 100 | 0.776892430278884 | 65 | 0 | 77.7 | 0 | 251 | 57 | 1161 | 1225 | TNN07314.1 putative ATP-dependent RNA helicase YTHDC2 [Schistosoma japonicum] | diamond | 195 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 26768973 | 26768973 | PRJNA796639_P_NODE_5261_length_257_cov_1.538043_g5136_i0 | PRJNA796639 | 5261 | 257 | 1.538043 | 3.95277051 | Schistosoma rodhaini | 6188 | Platyhelminthes | Platyhelminthes | 58.2 | 1.65e-7 | NR | CAH8668888.1 | 6188 | g5136 | i0 | 42.1 | 5.32295719844358 | 76 | 32 | 74.7 | 2 | 1 | 192 | 712 | 787 | CAH8668888.1 unnamed protein product [Schistosoma rodhaini] | diamond | 1368 | 58.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma rodhaini | |
| 26895850 | 26895850 | PRJNA796639_P_NODE_6801_length_246_cov_0.890173_g6676_i0 | PRJNA796639 | 6801 | 246 | 0.890173 | 2.18982558 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 159 | 3.889999999999999e-43 | NR | KAH8862618.1 | 6182 | g6676 | i0 | 100 | 1.97560975609756 | 81 | 0 | 98.8 | 0 | 246 | 4 | 434 | 514 | KAH8862618.1 Anaphase-promoting complex subunit 2 [Schistosoma japonicum] | diamond | 486 | 159 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 27726805 | 27726805 | PRJNA796639_P_NODE_1704_length_429_cov_1.224719_g1579_i0 | PRJNA796639 | 1704 | 429 | 1.224719 | 5.25404451 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 53.5 | 4.19e-5 | NR | PAA83033.1 | 282301 | g1579 | i0 | 33.1 | 2.66433566433566 | 133 | 82 | 88.1 | 3 | 45 | 422 | 241 | 373 | PAA83033.1 hypothetical protein BOX15_Mlig003939g2 [Macrostomum lignano] | diamond | 1143 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 27969801 | 27969801 | PRJNA796639_P_NODE_7125_length_244_cov_0.900585_g7000_i0 | PRJNA796639 | 7125 | 244 | 0.900585 | 2.1974274 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 144 | 1.39e-39 | NR | TNN10749.1 | 6182 | g7000 | i0 | 100 | 0.823770491803279 | 67 | 0 | 82.4 | 0 | 42 | 242 | 237 | 303 | TNN10749.1 D-aspartate oxidase [Schistosoma japonicum] | diamond | 201 | 144 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 28317199 | 28317199 | PRJNA796639_P_NODE_7726_length_241_cov_0.916667_g7601_i0 | PRJNA796639 | 7726 | 241 | 0.916667 | 2.20916747 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 174 | 1.0599999999999999e-52 | NR | TNN08041.1 | 6182 | g7601 | i0 | 100 | 0.995850622406639 | 80 | 0 | 99.6 | 0 | 2 | 241 | 77 | 156 | TNN08041.1 1-acyl-sn-glycerol-3-phosphate acyltransferase epsilon [Schistosoma japonicum] | diamond | 240 | 174 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 28348711 | 28348711 | PRJNA796639_P_NODE_7746_length_241_cov_0.916667_g7621_i0 | PRJNA796639 | 7746 | 241 | 0.916667 | 2.20916747 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 146 | 3.4599999999999995e-42 | NR | KAH8864801.1 | 6182 | g7621 | i0 | 100 | 3.48547717842324 | 70 | 0 | 87.1 | 0 | 30 | 239 | 1 | 70 | KAH8864801.1 Glycine dehydrogenase [Schistosoma japonicum] | diamond | 840 | 146 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 28569672 | 28569672 | PRJNA796639_P_NODE_4827_length_268_cov_1.184615_g4702_i0 | PRJNA796639 | 4827 | 268 | 1.184615 | 3.1747682 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 73.6 | 5.72e-13 | NR | KAH8867588.1 | 6182 | g4702 | i0 | 100 | 0.828358208955224 | 37 | 0 | 41.4 | 0 | 189 | 79 | 332 | 368 | KAH8867588.1 hypothetical protein KSF78_0003740 [Schistosoma japonicum] | diamond | 222 | 73.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 29138336 | 29138336 | PRJNA796639_P_NODE_5909_length_250_cov_0.870056_g5784_i0 | PRJNA796639 | 5909 | 250 | 0.870056 | 2.17514 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 87 | 7.66e-19 | NR | KAH8873933.1 | 6182 | g5784 | i0 | 100 | 0.96 | 40 | 0 | 48 | 0 | 249 | 130 | 182 | 221 | KAH8873933.1 hypothetical protein KSF78_0008216 [Schistosoma japonicum] | diamond | 240 | 87 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 29295927 | 29295927 | PRJNA796639_P_NODE_6829_length_246_cov_0.890173_g6704_i0 | PRJNA796639 | 6829 | 246 | 0.890173 | 2.18982558 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 160 | 1.1799999999999999e-43 | NR | TNN10466.1 | 6182 | g6704 | i0 | 98.8 | 0.98780487804878 | 81 | 1 | 98.8 | 0 | 3 | 245 | 1051 | 1131 | TNN10466.1 Protein transport protein [Schistosoma japonicum] | diamond | 243 | 160 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 32834961 | 32834961 | PRJNA796639_P_NODE_6940_length_245_cov_0.895349_g6815_i0 | PRJNA796639 | 6940 | 245 | 0.895349 | 2.19360505 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 114 | 3.45e-27 | NR | TNN11829.1 | 6182 | g6815 | i0 | 55.6 | 3.03673469387755 | 124 | 12 | 99.2 | 1 | 243 | 1 | 191 | 314 | TNN11829.1 Serine rich adhesin for platelets isoform 4 [Schistosoma japonicum] | diamond | 744 | 114 | 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);;