contig_metadata
26 rows where bioproject = "PRJNA1200128", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1601686 | 1601686 | PRJNA1200128_S_NODE_11442_length_242_cov_1.809045_g11333_i0 | PRJNA1200128 | 11442 | 242 | 1.809045 | 4.3778889 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 97.1 | 9.93e-16 | NTclustered | gi|56753506|gb|AY813225.1| | 6182 | g11333 | i0 | 98.182 | 23.6280991735537 | 55 | 1 | 23 | 0 | 1 | 55 | 825 | 771 | Schistosoma japonicum SJCHGC06004 protein mRNA, complete cds | blastn | 5718 | 97.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 1601693 | 1601693 | PRJNA1200128_S_NODE_12702_length_234_cov_1.732984_g12593_i0 | PRJNA1200128 | 12702 | 234 | 1.732984 | 4.05518256 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 370 | 5.09e-98 | NTclustered | gi|60698656|gb|AY915745.1| | 6182 | g12593 | i0 | 97.674 | 12.1410256410256 | 215 | 5 | 92 | 0 | 20 | 234 | 467 | 253 | Schistosoma japonicum SJCHGC09658 protein mRNA, partial cds | blastn | 2841 | 370 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 1601734 | 1601734 | PRJNA1200128_S_NODE_21742_length_198_cov_548.677419_g21633_i0 | PRJNA1200128 | 21742 | 198 | 548.677419 | 1086.38128962 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 285 | 1.55e-72 | NTclustered | gi|56757963|gb|AY815390.1| | 6182 | g21633 | i0 | 99.363 | 96.6969696969697 | 157 | 1 | 79 | 0 | 42 | 198 | 1305 | 1461 | Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds | blastn | 19146 | 285 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 2877901 | 2877901 | PRJNA1200128_S_NODE_1823_length_488_cov_619.253933_g1717_i0 | PRJNA1200128 | 1823 | 488 | 619.253933 | 3021.95919304 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 544 | 6.44e-150 | NTclustered | gi|56757963|gb|AY815390.1| | 6182 | g1717 | i0 | 98.387 | 128.463114754098 | 310 | 4 | 100 | 1 | 1 | 309 | 1461 | 1152 | Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds | blastn | 62690 | 544 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 2878057 | 2878057 | PRJNA1200128_S_NODE_963_length_769_cov_7.870523_g891_i0 | PRJNA1200128 | 963 | 769 | 7.870523 | 60.52432187 | Diplorchis hangzhouensis | 1131906 | Platyhelminthes | Platyhelminthes | 54.7 | 0.021 | NTclustered | gi|379771686|gb|JQ038227.1| | 1131906 | g891 | i0 | 100 | 0.0377113133940182 | 29 | 0 | 4 | 0 | 142 | 170 | 5389 | 5361 | Diplorchis hangzhouensis mitochondrion sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Polystomatidea | Polystomatidae | Diplorchis | Diplorchis hangzhouensis | |
| 9255086 | 9255086 | PRJNA1200128_S_NODE_42228_length_159_cov_1.112069_g42119_i0 | PRJNA1200128 | 42228 | 159 | 1.112069 | 1.76818971 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 117 | 4.600000000000001e-22 | NTclustered | gi|56758417|gb|AY815617.1| | 6182 | g42119 | i0 | 97.101 | 42.3333333333333 | 69 | 2 | 43 | 0 | 91 | 159 | 275 | 343 | Schistosoma japonicum SJCHGC04625 protein mRNA, complete cds | blastn | 6731 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 14356147 | 14356147 | PRJNA1200128_S_NODE_9212_length_259_cov_5.587963_g9103_i0 | PRJNA1200128 | 9212 | 259 | 5.587963 | 14.47282417 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 457 | 4.279999999999999e-124 | NTclustered | gi|60698688|gb|AY915747.1| | 6182 | g9103 | i0 | 98.456 | 2.32046332046332 | 259 | 4 | 100 | 0 | 1 | 259 | 57 | 315 | Schistosoma japonicum SJCHGC09661 protein mRNA, partial cds | blastn | 601 | 457 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 22003820 | 22003820 | PRJNA1200128_S_NODE_35358_length_169_cov_1.150794_g35249_i0 | PRJNA1200128 | 35358 | 169 | 1.150794 | 1.94484186 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 291 | 2.75e-74 | NTclustered | gi|60698656|gb|AY915745.1| | 6182 | g35249 | i0 | 97.647 | 12.0710059171598 | 170 | 3 | 100 | 1 | 1 | 169 | 222 | 53 | Schistosoma japonicum SJCHGC09658 protein mRNA, partial cds | blastn | 2040 | 291 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 22003903 | 22003903 | PRJNA1200128_S_NODE_9258_length_259_cov_1.740741_g9149_i0 | PRJNA1200128 | 9258 | 259 | 1.740741 | 4.50851919 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 237 | 6.0700000000000005e-58 | NTclustered | gi|20386492|gb|AF500622.1| | 6182 | g9149 | i0 | 89.119 | 0.745173745173745 | 193 | 18 | 74 | 2 | 29 | 220 | 483 | 293 | Schistosoma japonicum hepato-portal schistosomula protein (M9) mRNA, complete cds | blastn | 193 | 237 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 26977660 | 26977660 | PRJNA1200128_S_NODE_24862_length_190_cov_1.863946_g24753_i0 | PRJNA1200128 | 24862 | 190 | 1.863946 | 3.5414974 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 74.3 | 7.96e-16 | NR | AAM80478.1 | 6182 | g24753 | i0 | 72.3 | 12.4263157894737 | 47 | 13 | 74.2 | 0 | 180 | 40 | 1 | 47 | AAM80478.1 Hm2 protein [Schistosoma japonicum] | diamond | 2361 | 74.7 | 0.994645247657296 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 28114710 | 28114710 | PRJNA1200128_S_NODE_20545_length_202_cov_1.477987_g20436_i0 | PRJNA1200128 | 20545 | 202 | 1.477987 | 2.98553374 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 73.6 | 7.65e-15 | NR | AAX24812.2 | 6182 | g20436 | i0 | 64.7 | 2.03465346534653 | 51 | 18 | 75.7 | 0 | 18 | 170 | 1 | 51 | AAX24812.2 SJCHGC04011 protein, partial [Schistosoma japonicum] | diamond | 411 | 73.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 28399021 | 28399021 | PRJNA1200128_S_NODE_43266_length_157_cov_2.473684_g43157_i0 | PRJNA1200128 | 43266 | 157 | 2.473684 | 3.88368388 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 101 | 1.4e-25 | NR | AAM55226.1 | 6182 | g43157 | i0 | 90 | 0.955414012738854 | 50 | 5 | 95.5 | 0 | 3 | 152 | 112 | 161 | AAM55226.1 CA protein [Schistosoma japonicum] | diamond | 150 | 101 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 29314680 | 29314680 | PRJNA1200128_S_NODE_45469_length_155_cov_0.919643_g45360_i0 | PRJNA1200128 | 45469 | 155 | 0.919643 | 1.42544665 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 44.3 | 0.00188 | NR | AAW25703.1 | 6182 | g45360 | i0 | 78.3 | 0.445161290322581 | 23 | 5 | 44.5 | 0 | 80 | 12 | 33 | 55 | AAW25703.1 SJCHGC03999 protein [Schistosoma japonicum] | diamond | 69 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 29567125 | 29567125 | PRJNA1200128_S_NODE_6590_length_288_cov_1.563265_g6481_i0 | PRJNA1200128 | 6590 | 288 | 1.563265 | 4.5022032 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 92 | 6.71e-21 | NR | AAX25032.2 | 6182 | g6481 | i0 | 64.6 | 0.677083333333333 | 65 | 23 | 67.7 | 0 | 59 | 253 | 58 | 122 | AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] | diamond | 195 | 92 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 29977726 | 29977726 | PRJNA1200128_S_NODE_13231_length_231_cov_2.223404_g13122_i0 | PRJNA1200128 | 13231 | 231 | 2.223404 | 5.13606324 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 103 | 1.37e-26 | NR | AAP06205.1 | 6182 | g13122 | i0 | 78.7 | 2.8961038961039 | 75 | 12 | 97.4 | 2 | 230 | 6 | 43 | 113 | AAP06205.1 hypothetical protein [Schistosoma japonicum] | diamond | 669 | 103 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 30198734 | 30198734 | PRJNA1200128_S_NODE_3512_length_361_cov_2.616352_g3403_i0 | PRJNA1200128 | 3512 | 361 | 2.616352 | 9.44503072 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 60.1 | 1.56e-8 | NR | AAX30334.2 | 6182 | g3403 | i0 | 69 | 0.698060941828255 | 42 | 13 | 34.9 | 0 | 127 | 2 | 67 | 108 | AAX30334.2 SJCHGC03026 protein, partial [Schistosoma japonicum] | diamond | 252 | 60.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 30451949 | 30451949 | PRJNA1200128_S_NODE_12713_length_234_cov_1.722513_g12604_i0 | PRJNA1200128 | 12713 | 234 | 1.722513 | 4.03068042 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 48.1 | 2.36e-4 | NR | AAX25032.2 | 6182 | g12604 | i0 | 61.5 | 0.5 | 39 | 15 | 50 | 0 | 63 | 179 | 149 | 187 | AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] | diamond | 117 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 30546527 | 30546527 | PRJNA1200128_S_NODE_5393_length_308_cov_2.373585_g5284_i0 | PRJNA1200128 | 5393 | 308 | 2.373585 | 7.3106418 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 66.2 | 7.18e-12 | NR | AAX31080.1 | 6182 | g5284 | i0 | 80 | 0.38961038961039 | 40 | 8 | 39 | 0 | 189 | 308 | 1 | 40 | AAX31080.1 SJCHGC09793 protein [Schistosoma japonicum] | diamond | 120 | 66.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 30988970 | 30988970 | PRJNA1200128_S_NODE_27954_length_183_cov_1.342857_g27845_i0 | PRJNA1200128 | 27954 | 183 | 1.342857 | 2.45742831 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 48.9 | 4.21e-5 | NR | AAX25839.2 | 6182 | g27845 | i0 | 57.1 | 1.19672131147541 | 42 | 18 | 68.9 | 0 | 17 | 142 | 5 | 46 | AAX25839.2 SJCHGC09516 protein, partial [Schistosoma japonicum] | diamond | 219 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 31020523 | 31020523 | PRJNA1200128_S_NODE_9495_length_257_cov_1.537383_g9386_i0 | PRJNA1200128 | 9495 | 257 | 1.537383 | 3.95107431 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 47.4 | 1.12e-4 | NR | AAX30470.1 | 6182 | g9386 | i0 | 71.9 | 1.1673151750972799 | 32 | 9 | 37.4 | 0 | 160 | 255 | 11 | 42 | AAX30470.1 SJCHGC03833 protein [Schistosoma japonicum] | diamond | 300 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 31083657 | 31083657 | PRJNA1200128_S_NODE_39895_length_162_cov_1.184874_g39786_i0 | PRJNA1200128 | 39895 | 162 | 1.184874 | 1.91949588 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 43.9 | 0.00245 | NR | AAX30334.2 | 6182 | g39786 | i0 | 80.8 | 0.481481481481481 | 26 | 5 | 48.1 | 0 | 37 | 114 | 40 | 65 | AAX30334.2 SJCHGC03026 protein, partial [Schistosoma japonicum] | diamond | 78 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 31114977 | 31114977 | PRJNA1200128_S_NODE_19255_length_206_cov_1.251534_g19146_i0 | PRJNA1200128 | 19255 | 206 | 1.251534 | 2.57816004 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 40.8 | 0.0461 | NR | AAX24812.2 | 6182 | g19146 | i0 | 71.4 | 0.407766990291262 | 28 | 8 | 40.8 | 0 | 167 | 84 | 44 | 71 | AAX24812.2 SJCHGC04011 protein, partial [Schistosoma japonicum] | diamond | 84 | 40.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 31716083 | 31716083 | PRJNA1200128_S_NODE_27337_length_184_cov_2.354610_g27228_i0 | PRJNA1200128 | 27337 | 184 | 2.35461 | 4.3324824 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 45.8 | 9.36e-4 | NR | AAX25032.2 | 6182 | g27228 | i0 | 51.1 | 0.766304347826087 | 47 | 23 | 76.6 | 0 | 43 | 183 | 90 | 136 | AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] | diamond | 141 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 31779208 | 31779208 | PRJNA1200128_S_NODE_3377_length_367_cov_1.608025_g3268_i0 | PRJNA1200128 | 3377 | 367 | 1.608025 | 5.90145175 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 118 | 1.08e-30 | NR | AAX25032.2 | 6182 | g3268 | i0 | 70.2 | 0.686648501362398 | 84 | 25 | 68.7 | 0 | 104 | 355 | 104 | 187 | AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] | diamond | 252 | 118 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 32095682 | 32095682 | PRJNA1200128_S_NODE_15278_length_221_cov_1.320225_g15169_i0 | PRJNA1200128 | 15278 | 221 | 1.320225 | 2.91769725 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 48.5 | 2.53e-4 | NR | AAX28387.3 | 6182 | g15169 | i0 | 53.1 | 3.47511312217195 | 64 | 27 | 82.8 | 2 | 218 | 36 | 99 | 162 | AAX28387.3 SJCHGC01615 protein, partial [Schistosoma japonicum] | diamond | 768 | 48.9 | 0.991820040899796 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 32349106 | 32349106 | PRJNA1200128_S_NODE_43699_length_157_cov_1.236842_g43590_i0 | PRJNA1200128 | 43699 | 157 | 1.236842 | 1.94184194 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 51.2 | 6.25e-6 | NR | AAX25032.2 | 6182 | g43590 | i0 | 62.5 | 0.611464968152866 | 32 | 12 | 61.1 | 0 | 2 | 97 | 103 | 134 | AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] | diamond | 96 | 51.2 | 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);;