contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA1032461" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 167112 | 167112 | PRJNA1032461_S_NODE_8921_length_204_cov_1.832258_g8823_i0 | PRJNA1032461 | 8921 | 204 | 1.832258 | 3.73780632 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 99.8 | 8.49e-26 | NR | CAX78411.1 | 6182 | g8823 | i0 | 84.5 | 4.32352941176471 | 58 | 9 | 85.3 | 0 | 176 | 3 | 7 | 64 | CAX78411.1 40S ribosomal protein S28 [Schistosoma japonicum] | diamond | 882 | 99.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 5269969 | 5269969 | PRJNA1032461_S_NODE_5745_length_243_cov_1.757732_g5647_i0 | PRJNA1032461 | 5745 | 243 | 1.757732 | 4.27128876 | Dugesia japonica | 6161 | Platyhelminthes | Platyhelminthes | 155 | 4.2399999999999996e-42 | NR | ABY83101.1 | 6161 | g5647 | i0 | 100 | 0.987654320987654 | 80 | 0 | 98.8 | 0 | 242 | 3 | 306 | 385 | ABY83101.1 heat shock protein 70 [Dugesia japonica] | diamond | 240 | 155 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia japonica | |
| 27319725 | 27319725 | PRJNA1032461_S_NODE_503_length_628_cov_1.951641_g415_i0 | PRJNA1032461 | 503 | 628 | 1.951641 | 12.25630548 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 70.5 | 3.83e-11 | NR | AAX25032.2 | 6182 | g415 | i0 | 39.3 | 0.582802547770701 | 122 | 54 | 55.9 | 3 | 353 | 3 | 2 | 108 | AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] | diamond | 366 | 70.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 28014478 | 28014478 | PRJNA1032461_S_NODE_10385_length_192_cov_1.055944_g10287_i0 | PRJNA1032461 | 10385 | 192 | 1.055944 | 2.02741248 | Dugesia japonica | 6161 | Platyhelminthes | Platyhelminthes | 115 | 1.02e-31 | NR | AWM96393.1 | 6161 | g10287 | i0 | 85.7 | 0.984375 | 63 | 9 | 98.4 | 0 | 190 | 2 | 36 | 98 | AWM96393.1 HSP10 [Dugesia japonica] | diamond | 189 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia japonica | |
| 28677476 | 28677476 | PRJNA1032461_S_NODE_15127_length_168_cov_0.882353_g15029_i0 | PRJNA1032461 | 15127 | 168 | 0.882353 | 1.48235304 | Schmidtea mediterranea | 79327 | Platyhelminthes | Platyhelminthes | 85.5 | 5.18e-19 | NR | AFJ24764.1 | 79327 | g15029 | i0 | 84.6 | 0.928571428571429 | 52 | 7 | 92.9 | 1 | 5 | 160 | 61 | 111 | AFJ24764.1 Y box protein-1, partial [Schmidtea mediterranea] | diamond | 156 | 85.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Schmidtea | Schmidtea mediterranea | |
| 28803406 | 28803406 | PRJNA1032461_S_NODE_9108_length_203_cov_0.753247_g9010_i0 | PRJNA1032461 | 9108 | 203 | 0.753247 | 1.52909141 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 113 | 2.8199999999999997e-30 | NR | AAX28478.2 | 6182 | g9010 | i0 | 88.5 | 1.87684729064039 | 61 | 7 | 90.1 | 0 | 3 | 185 | 76 | 136 | AAX28478.2 SJCHGC03032 protein, partial [Schistosoma japonicum] | diamond | 381 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 29340523 | 29340523 | PRJNA1032461_S_NODE_12649_length_176_cov_2.456693_g12551_i0 | PRJNA1032461 | 12649 | 176 | 2.456693 | 4.32377968 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 45.1 | 3.24e-4 | NR | AAM80477.1 | 6182 | g12551 | i0 | 75 | 0.545454545454545 | 32 | 6 | 51.1 | 1 | 3 | 92 | 48 | 79 | AAM80477.1 Hm1 protein [Schistosoma japonicum] | diamond | 96 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 29584718 | 29584718 | PRJNA1032461_S_NODE_6530_length_231_cov_1.708791_g6432_i0 | PRJNA1032461 | 6530 | 231 | 1.708791 | 3.94730721 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 138 | 1.32e-39 | NR | THD27126.1 | 6192 | g6432 | i0 | 85.7 | 13 | 77 | 11 | 100 | 0 | 1 | 231 | 74 | 150 | THD27126.1 Large subunit ribosomal protein 31 [Fasciola hepatica] | diamond | 3003 | 138 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola hepatica | |
| 30572032 | 30572032 | PRJNA1032461_S_NODE_12593_length_177_cov_1.140625_g12495_i0 | PRJNA1032461 | 12593 | 177 | 1.140625 | 2.01890625 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 87.4 | 1e-19 | NR | AAX25032.2 | 6182 | g12495 | i0 | 87 | 0.779661016949153 | 46 | 6 | 78 | 0 | 138 | 1 | 86 | 131 | AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] | diamond | 138 | 87.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 32058191 | 32058191 | PRJNA1032461_S_NODE_10138_length_194_cov_0.889655_g10040_i0 | PRJNA1032461 | 10138 | 194 | 0.889655 | 1.7259307 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 90.5 | 2.77e-21 | NR | AAX30334.2 | 6182 | g10040 | i0 | 93.3 | 2.08762886597938 | 45 | 3 | 69.6 | 0 | 194 | 60 | 44 | 88 | AAX30334.2 SJCHGC03026 protein, partial [Schistosoma japonicum] | diamond | 405 | 90.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 32216524 | 32216524 | PRJNA1032461_S_NODE_17978_length_165_cov_1.198276_g17880_i0 | PRJNA1032461 | 17978 | 165 | 1.198276 | 1.9771554 | Dugesia japonica | 6161 | Platyhelminthes | Platyhelminthes | 60.8 | 3.67e-9 | NR | CAA68079.1 | 6161 | g17880 | i0 | 60.9 | 0.836363636363636 | 46 | 18 | 83.6 | 0 | 138 | 1 | 8 | 53 | CAA68079.1 Y-box protein [Dugesia japonica] | diamond | 138 | 60.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia japonica | |
| 32248406 | 32248406 | PRJNA1032461_S_NODE_1378_length_438_cov_1.478149_g1280_i0 | PRJNA1032461 | 1378 | 438 | 1.478149 | 6.47429262 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 47.4 | 3.83e-4 | NR | ABA40899.1 | 6182 | g1280 | i0 | 56.4 | 0.267123287671233 | 39 | 15 | 25.3 | 1 | 263 | 153 | 4 | 42 | ABA40899.1 SJCHGC09658 protein, partial [Schistosoma japonicum] | diamond | 117 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 32311682 | 32311682 | PRJNA1032461_S_NODE_7059_length_224_cov_1.571429_g6961_i0 | PRJNA1032461 | 7059 | 224 | 1.571429 | 3.52000096 | Fasciolopsis buskii | 27845 | Platyhelminthes | Platyhelminthes | 100 | 1.06e-23 | NR | KAA0200674.1 | 27845 | g6961 | i0 | 65.3 | 9.64285714285714 | 72 | 25 | 96.4 | 0 | 2 | 217 | 100 | 171 | KAA0200674.1 Ribosomal protein l4 [Fasciolopsis buskii] | diamond | 2160 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciolopsis | Fasciolopsis buskii |
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);;