contig_metadata
25 rows where bioproject = "PRJNA846486", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3384092 | 3384092 | PRJNA846486_P_NODE_73163_length_171_cov_1.909836_g73067_i0 | PRJNA846486 | 73163 | 171 | 1.909836 | 3.26581956 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 163 | 6.34e-36 | NTclustered | gi|60597103|gb|AY809212.1| | 6182 | g73067 | i0 | 98.901 | 15.4795321637427 | 91 | 1 | 100 | 0 | 81 | 171 | 140 | 230 | Schistosoma japonicum SJCHGC04513 protein mRNA, partial cds | blastn | 2647 | 163 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 5936419 | 5936419 | PRJNA846486_P_NODE_34805_length_227_cov_11.000000_g34709_i0 | PRJNA846486 | 34805 | 227 | 11 | 24.97 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 409 | 1.04e-109 | NTclustered | gi|60698688|gb|AY915747.1| | 6182 | g34709 | i0 | 99.119 | 2.36563876651982 | 227 | 2 | 100 | 0 | 1 | 227 | 347 | 121 | Schistosoma japonicum SJCHGC09661 protein mRNA, partial cds | blastn | 537 | 409 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 8486189 | 8486189 | PRJNA846486_P_NODE_91447_length_163_cov_0.912281_g91351_i0 | PRJNA846486 | 91447 | 163 | 0.912281 | 1.48701803 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 54.7 | 0.004 | NTclustered | gi|28316820|gb|AY222866.1| | 6182 | g91351 | i0 | 100 | 0.699386503067485 | 29 | 0 | 30 | 0 | 14 | 42 | 334 | 362 | Schistosoma japonicum clone ZZD1204 mRNA sequence | blastn | 114 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 11036906 | 11036906 | PRJNA846486_P_NODE_26309_length_255_cov_1.247573_g26213_i0 | PRJNA846486 | 26309 | 255 | 1.247573 | 3.18131115 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 460 | 3.25e-125 | NTclustered | gi|60600058|gb|AY810684.1| | 6182 | g26213 | i0 | 99.216 | 5.83529411764706 | 255 | 2 | 100 | 0 | 1 | 255 | 247 | 501 | Schistosoma japonicum SJCHGC04723 protein mRNA, partial cds | blastn | 1488 | 460 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 14861117 | 14861117 | PRJNA846486_P_NODE_10192_length_387_cov_2.426036_g10097_i0 | PRJNA846486 | 10192 | 387 | 2.426036 | 9.38875932 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 219 | 3.44e-52 | NTclustered | gi|60698656|gb|AY915745.1| | 6182 | g10097 | i0 | 97.638 | 6.23255813953488 | 127 | 3 | 47 | 0 | 1 | 127 | 353 | 227 | Schistosoma japonicum SJCHGC09658 protein mRNA, partial cds | blastn | 2412 | 219 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 14861236 | 14861236 | PRJNA846486_P_NODE_6832_length_465_cov_1.673077_g6739_i0 | PRJNA846486 | 6832 | 465 | 1.673077 | 7.77980805 | Pacifides sp. n. ML-2020 | 2771503 | Platyhelminthes | Platyhelminthes | 226 | 2.52e-54 | NTclustered | gi|1900854572|gb|MT994578.1| | 2771503 | g6739 | i0 | 76.629 | 70.3354838709677 | 445 | 83 | 95 | 16 | 24 | 463 | 926 | 1354 | Pacifides sp. n. ML-2020 isolate ML3 large subunit ribosomal RNA gene, partial sequence | blastn | 32706 | 226 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Cercyridae | Pacifides | Pacifides sp. n. ML-2020 | |
| 19082947 | 19082947 | PRJNA846486_P_NODE_21175_length_279_cov_1.552174_g21079_i0 | PRJNA846486 | 21175 | 279 | 1.552174 | 4.33056546 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 60.2 | 1.54e-4 | NTclustered | gi|2224869|gb|U53001.1|DLU53001 | 27895 | g21079 | i0 | 100 | 11.663082437276 | 32 | 0 | 11 | 0 | 39 | 70 | 111 | 80 | Dendrocoelum lacteum ribosomal RNA large subunit gene, partial sequence | blastn | 3254 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dendrocoelidae | Dendrocoelum | Dendrocoelum lacteum | |
| 23785620 | 23785620 | PRJNA846486_P_NODE_75539_length_169_cov_1.733333_g75443_i0 | PRJNA846486 | 75539 | 169 | 1.733333 | 2.92933277 | Schmidtea mediterranea | 79327 | Platyhelminthes | Platyhelminthes | 313 | 5.859999999999999e-81 | NTclustered | gi|546143622|ref|NC_022448.1| | 79327 | g75443 | i0 | 100 | 9.00591715976331 | 169 | 0 | 100 | 0 | 1 | 169 | 23184 | 23352 | Schmidtea mediterranea mitochondrion, complete genome | blastn | 1522 | 313 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Schmidtea | Schmidtea mediterranea | |
| 25059491 | 25059491 | PRJNA846486_P_NODE_65760_length_178_cov_3.472868_g65664_i0 | PRJNA846486 | 65760 | 178 | 3.472868 | 6.18170504 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 274 | 2.95e-69 | NTclustered | gi|56757963|gb|AY815390.1| | 6182 | g65664 | i0 | 94.413 | 95.4325842696629 | 179 | 8 | 100 | 2 | 1 | 178 | 1806 | 1983 | Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds | blastn | 16987 | 274 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 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);;