contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA846486" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27244395 | 27244395 | PRJNA846486_P_NODE_90883_length_163_cov_0.912281_g90787_i0 | PRJNA846486 | 90883 | 163 | 0.912281 | 1.48701803 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 47.4 | 3.26e-5 | NR | AAM80477.1 | 6182 | g90787 | i0 | 87.5 | 0.441717791411043 | 24 | 3 | 44.2 | 0 | 57 | 128 | 56 | 79 | AAM80477.1 Hm1 protein [Schistosoma japonicum] | diamond | 72 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 27528686 | 27528686 | PRJNA846486_P_NODE_12483_length_352_cov_1.537954_g12387_i0 | PRJNA846486 | 12483 | 352 | 1.537954 | 5.41359808 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 185 | 1.6400000000000002e-58 | NR | AAX31034.1 | 6182 | g12387 | i0 | 100 | 0.724431818181818 | 85 | 0 | 72.4 | 0 | 2 | 256 | 5 | 89 | AAX31034.1 unknown [Schistosoma japonicum] | diamond | 255 | 185 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 28254810 | 28254810 | PRJNA846486_P_NODE_27386_length_251_cov_0.881188_g27290_i0 | PRJNA846486 | 27386 | 251 | 0.881188 | 2.21178188 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 67.4 | 1.48e-11 | NR | AAX25032.2 | 6182 | g27290 | i0 | 59.6 | 0.561752988047809 | 47 | 19 | 56.2 | 0 | 176 | 36 | 90 | 136 | AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] | diamond | 141 | 67.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 28381214 | 28381214 | PRJNA846486_P_NODE_93466_length_162_cov_0.920354_g93370_i0 | PRJNA846486 | 93466 | 162 | 0.920354 | 1.49097348 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 69.7 | 4.78e-14 | NR | AAX30332.1 | 6182 | g93370 | i0 | 79.5 | 2.90740740740741 | 39 | 8 | 72.2 | 0 | 1 | 117 | 28 | 66 | AAX30332.1 SJCHGC03023 protein [Schistosoma japonicum] | diamond | 471 | 69.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 28475974 | 28475974 | PRJNA846486_P_NODE_2626_length_702_cov_2.124043_g2550_i0 | PRJNA846486 | 2626 | 702 | 2.124043 | 14.91078186 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 104 | 6.8e-24 | NR | AAX25032.2 | 6182 | g2550 | i0 | 45.3 | 0.594017094017094 | 139 | 66 | 59.4 | 2 | 419 | 3 | 1 | 129 | AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] | diamond | 417 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 28610663 | 28610663 | PRJNA846486_P_NODE_48927_length_200_cov_0.841060_g48831_i0 | PRJNA846486 | 48927 | 200 | 0.84106 | 1.68212 | root | 1 | Root_unresolved | Root_unresolved | 73.6 | 3.13e-15 | NR | AAX30328.2 | 6182 | g48831 | i0 | 69.1 | 1.905 | 55 | 14 | 82.5 | 2 | 166 | 2 | 23 | 74 | AAX30328.2 SJCHGC03018 protein, partial [Schistosoma japonicum] | diamond | 381 | 73.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 29202289 | 29202289 | PRJNA846486_P_NODE_88769_length_164_cov_0.904348_g88673_i0 | PRJNA846486 | 88769 | 164 | 0.904348 | 1.48313072 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 41.6 | 0.00416 | NR | AAX30326.1 | 6182 | g88673 | i0 | 70.8 | 1.07926829268293 | 24 | 7 | 43.9 | 0 | 47 | 118 | 34 | 57 | AAX30326.1 SJCHGC03015 protein [Schistosoma japonicum] | diamond | 177 | 42 | 0.990476190476191 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 29959954 | 29959954 | PRJNA846486_P_NODE_4571_length_556_cov_2.733728_g4483_i0 | PRJNA846486 | 4571 | 556 | 2.733728 | 15.19952768 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 48.1 | 5.73e-4 | NR | AAM80477.1 | 6182 | g4483 | i0 | 82.1 | 0.151079136690647 | 28 | 5 | 15.1 | 0 | 471 | 554 | 34 | 61 | AAM80477.1 Hm1 protein [Schistosoma japonicum] | diamond | 84 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 30971160 | 30971160 | PRJNA846486_P_NODE_78894_length_168_cov_0.873950_g78798_i0 | PRJNA846486 | 78894 | 168 | 0.87395 | 1.468236 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 81.6 | 1.77e-17 | NR | AAX25963.2 | 6182 | g78798 | i0 | 80 | 0.892857142857143 | 50 | 8 | 89.3 | 1 | 154 | 5 | 102 | 149 | AAX25963.2 SJCHGC04741 protein, partial [Schistosoma japonicum] | diamond | 150 | 81.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 31508652 | 31508652 | PRJNA846486_P_NODE_87496_length_164_cov_1.547826_g87400_i0 | PRJNA846486 | 87496 | 164 | 1.547826 | 2.53843464 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 80.9 | 2.43e-18 | NR | AAX30328.2 | 6182 | g87400 | i0 | 82.6 | 2.63414634146341 | 46 | 8 | 84.1 | 0 | 7 | 144 | 26 | 71 | AAX30328.2 SJCHGC03018 protein, partial [Schistosoma japonicum] | diamond | 432 | 80.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 32236461 | 32236461 | PRJNA846486_P_NODE_13638_length_338_cov_2.238754_g13542_i0 | PRJNA846486 | 13638 | 338 | 2.238754 | 7.56698852 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 41.6 | 0.0296 | NR | ABA40899.1 | 6182 | g13542 | i0 | 62.5 | 0.284023668639053 | 32 | 10 | 26.6 | 1 | 190 | 101 | 11 | 42 | ABA40899.1 SJCHGC09658 protein, partial [Schistosoma japonicum] | diamond | 96 | 41.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 32236480 | 32236480 | PRJNA846486_P_NODE_94998_length_159_cov_186.672727_g94902_i0 | PRJNA846486 | 94998 | 159 | 186.672727 | 296.80963593 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 62.4 | 1.29e-10 | NR | AAW27122.1 | 6182 | g94902 | i0 | 96.4 | 0.528301886792453 | 28 | 1 | 52.8 | 0 | 3 | 86 | 22 | 49 | AAW27122.1 SJCHGC01951 protein [Schistosoma japonicum] | diamond | 84 | 62.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 32276375 | 32276375 | PRJNA846486_P_NODE_65098_length_179_cov_1.523077_g65002_i0 | PRJNA846486 | 65098 | 179 | 1.523077 | 2.72630783 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 70.5 | 3.47e-13 | NR | CAH8527181.1 | 6188 | g65002 | i0 | 58.1 | 20.5977653631285 | 62 | 23 | 98.9 | 1 | 178 | 2 | 76 | 137 | CAH8527181.1 unnamed protein product [Schistosoma rodhaini] | diamond | 3687 | 71.2 | 0.990168539325843 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma rodhaini | |
| 32299746 | 32299746 | PRJNA846486_P_NODE_21579_length_277_cov_1.421053_g21483_i0 | PRJNA846486 | 21579 | 277 | 1.421053 | 3.93631681 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 160 | 9.1e-49 | NR | AAP06429.1 | 6182 | g21483 | i0 | 87.5 | 1.90613718411552 | 88 | 11 | 95.3 | 0 | 6 | 269 | 27 | 114 | AAP06429.1 hypothetical protein [Schistosoma japonicum] | diamond | 528 | 161 | 0.993788819875776 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 32331394 | 32331394 | PRJNA846486_P_NODE_62219_length_182_cov_1.827068_g62123_i0 | PRJNA846486 | 62219 | 182 | 1.827068 | 3.32526376 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 61.2 | 5.18e-10 | NR | AAX28135.2 | 6182 | g62123 | i0 | 96.9 | 0.527472527472527 | 32 | 1 | 52.7 | 0 | 145 | 50 | 102 | 133 | AAX28135.2 SJCHGC07585 protein, partial [Schistosoma japonicum] | diamond | 96 | 61.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 32772885 | 32772885 | PRJNA846486_P_NODE_79540_length_168_cov_0.873950_g79444_i0 | PRJNA846486 | 79540 | 168 | 0.87395 | 1.468236 | Cichlidogyrus casuarinus | 1844966 | Platyhelminthes | Platyhelminthes | 95.5 | 3.62e-22 | NR | KAL3309138.1 | 1844966 | g79444 | i0 | 74.1 | 0.964285714285714 | 54 | 14 | 96.4 | 0 | 163 | 2 | 6 | 59 | KAL3309138.1 Microtubule-associated protein RP/EB member 2 [Cichlidogyrus casuarinus] | diamond | 162 | 95.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Dactylogyridea | Ancyrocephalidae | Cichlidogyrus | Cichlidogyrus casuarinus |
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);;