contig_metadata
16 rows where bioproject = "PRJNA1214993", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10534195 | 10534195 | PRJNA1214993_P_NODE_24009_length_245_cov_1.360465_g23823_i0 | PRJNA1214993 | 24009 | 245 | 1.360465 | 3.33313925 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 142 | 4.8e-40 | NR | AAX26044.2 | 6182 | g23823 | i0 | 82.7 | 327.257142857143 | 81 | 14 | 99.2 | 0 | 244 | 2 | 34 | 114 | AAX26044.2 SJCHGC03942 protein, partial [Schistosoma japonicum] | diamond | 80178 | 142 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 10534221 | 10534221 | PRJNA1214993_P_NODE_2949_length_614_cov_2.096118_g2770_i0 | PRJNA1214993 | 2949 | 614 | 2.096118 | 12.87016452 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 299 | 3.2299999999999995e-101 | NR | VZI45017.1 | 99802 | g2770 | i0 | 90.7 | 0.737785016286645 | 151 | 14 | 73.8 | 0 | 614 | 162 | 3 | 153 | VZI45017.1 unnamed protein product [Spirometra erinaceieuropaei] | diamond | 453 | 299 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 10534242 | 10534242 | PRJNA1214993_P_NODE_4809_length_486_cov_3.658596_g4624_i0 | PRJNA1214993 | 4809 | 486 | 3.658596 | 17.78077656 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 251 | 8.48e-83 | NR | THD26469.1 | 6192 | g4624 | i0 | 97.1 | 221.320987654321 | 136 | 4 | 84 | 0 | 439 | 32 | 36 | 171 | THD26469.1 histone H3 [Fasciola hepatica] | diamond | 107562 | 253 | 0.992094861660079 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola hepatica | |
| 10534255 | 10534255 | PRJNA1214993_P_NODE_609_length_1214_cov_6.673094_g515_i0 | PRJNA1214993 | 609 | 1214 | 6.673094 | 81.01136116 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 656 | 0 | NTclustered | gi|1369885|gb|L78441.1|SCM14332R | 6183 | g515 | i0 | 86.258 | 54.7537067545305 | 604 | 83 | 50 | 0 | 453 | 1056 | 605 | 2 | Schistosoma mansoni 14-3-3-2 mRNA, 3' end of cds | blastn | 66471 | 656 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 13084102 | 13084102 | PRJNA1214993_P_NODE_771_length_1106_cov_13.086157_g665_i0 | PRJNA1214993 | 771 | 1106 | 13.086157 | 144.73289642 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 651 | 0 | NTclustered | gi|1369885|gb|L78441.1|SCM14332R | 6183 | g665 | i0 | 86.213 | 8.66817359855335 | 602 | 81 | 79 | 2 | 330 | 930 | 601 | 1 | Schistosoma mansoni 14-3-3-2 mRNA, 3' end of cds | blastn | 9587 | 651 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 13798777 | 13798777 | PRJNA1214993_P_NODE_16391_length_276_cov_1.389163_g16205_i0 | PRJNA1214993 | 16391 | 276 | 1.389163 | 3.83408988 | Plagiostomum | 84130 | Platyhelminthes | Platyhelminthes | 139 | 1.8899999999999999e-28 | NTclustered | gi|1587089599|gb|MG882058.1| | 2544880 | g16205 | i0 | 86.364 | 44.8297101449275 | 132 | 12 | 47 | 5 | 145 | 273 | 929 | 1057 | Plagiostomum sp. n. MW-2019 isolate XK2 28S ribosomal RNA gene, partial sequence | blastn | 12373 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Prolecithophora | Plagiostomidae | Plagiostomum | Plagiostomum sp. n. MW-2019 | |
| 19456462 | 19456462 | PRJNA1214993_P_NODE_5956_length_439_cov_4.346995_g5771_i0 | PRJNA1214993 | 5956 | 439 | 4.346995 | 19.08330805 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 721 | 0 | NTclustered | gi|68479954|gb|DQ076149.1| | 6182 | g5771 | i0 | 96.355 | 1 | 439 | 15 | 100 | 1 | 1 | 439 | 12 | 449 | Schistosoma japonicum clone 1XA1 unknown mRNA | blastn | 439 | 721 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 26946013 | 26946013 | PRJNA1214993_P_NODE_7462_length_395_cov_1.198758_g7276_i0 | PRJNA1214993 | 7462 | 395 | 1.198758 | 4.7350941 | Fasciola gigantica | 46835 | Platyhelminthes | Platyhelminthes | 104 | 6.94e-24 | NR | AAL23917.1 | 46835 | g7276 | i0 | 44.2 | 0.979746835443038 | 129 | 66 | 94.2 | 3 | 374 | 3 | 69 | 196 | AAL23917.1 cathepsin L [Fasciola gigantica] | diamond | 387 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola gigantica | |
| 28051771 | 28051771 | PRJNA1214993_P_NODE_26545_length_233_cov_2.437500_g26359_i0 | PRJNA1214993 | 26545 | 233 | 2.4375 | 5.679375 | Hydatigera taeniaeformis | 6205 | Platyhelminthes | Platyhelminthes | 69.7 | 9.75e-12 | NR | VDM30535.1 | 6205 | g26359 | i0 | 56.6 | 1.3519313304721 | 53 | 23 | 68.2 | 0 | 224 | 66 | 175 | 227 | VDM30535.1 unnamed protein product [Hydatigera taeniaeformis] | diamond | 315 | 69.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Hydatigera | Hydatigera taeniaeformis | |
| 29933681 | 29933681 | PRJNA1214993_P_NODE_12031_length_318_cov_0.942857_g11845_i0 | PRJNA1214993 | 12031 | 318 | 0.942857 | 2.99828526 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 53.1 | 1.04e-5 | NR | CAH8555941.1 | 39320 | g11845 | i0 | 50.9 | 16.2924528301887 | 55 | 25 | 50 | 1 | 158 | 316 | 53 | 107 | CAH8555941.1 unnamed protein product [Heterobilharzia americana] | diamond | 5181 | 53.5 | 0.992523364485981 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Heterobilharzia | Heterobilharzia americana | |
| 30091302 | 30091302 | PRJNA1214993_P_NODE_8572_length_371_cov_2.087248_g8386_i0 | PRJNA1214993 | 8572 | 371 | 2.087248 | 7.74369008 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 57 | 3.1e-7 | NR | KAF6771429.1 | 100269 | g8386 | i0 | 32.4 | 6.78436657681941 | 68 | 46 | 55 | 0 | 7 | 210 | 87 | 154 | KAF6771429.1 hypothetical protein AHF37_09851 [Paragonimus kellicotti] | diamond | 2517 | 57.4 | 0.993031358885017 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus kellicotti | |
| 30818159 | 30818159 | PRJNA1214993_P_NODE_10914_length_333_cov_1.200000_g10728_i0 | PRJNA1214993 | 10914 | 333 | 1.2 | 3.996 | root | 1 | Root_unresolved | Root_unresolved | 82.8 | 1.02e-15 | NR | PAA60592.1 | 282301 | g10728 | i0 | 42.2 | 2.90990990990991 | 102 | 52 | 91.9 | 3 | 13 | 318 | 972 | 1066 | PAA60592.1 hypothetical protein BOX15_Mlig020147g1, partial [Macrostomum lignano] | diamond | 969 | 83.6 | 0.990430622009569 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 30849732 | 30849732 | PRJNA1214993_P_NODE_13734_length_298_cov_0.835556_g13548_i0 | PRJNA1214993 | 13734 | 298 | 0.835556 | 2.48995688 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 121 | 6.87e-33 | NR | PAA50452.1 | 282301 | g13548 | i0 | 78 | 13.4496644295302 | 82 | 18 | 82.6 | 0 | 52 | 297 | 1 | 82 | PAA50452.1 hypothetical protein BOX15_Mlig006462g4, partial [Macrostomum lignano] | diamond | 4008 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 31323740 | 31323740 | PRJNA1214993_P_NODE_19495_length_253_cov_2.561111_g19309_i0 | PRJNA1214993 | 19495 | 253 | 2.561111 | 6.47961083 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 122 | 4.43e-34 | NR | KAA0191047.1 | 27845 | g19309 | i0 | 64.3 | 10.9565217391304 | 84 | 30 | 99.6 | 0 | 253 | 2 | 2 | 85 | KAA0191047.1 Dynein molecular motor protein light chain [Fasciolopsis buskii] | diamond | 2772 | 123 | 0.991869918699187 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciolopsis | Fasciolopsis buskii | |
| 32064080 | 32064080 | PRJNA1214993_P_NODE_23898_length_246_cov_0.861272_g23712_i0 | PRJNA1214993 | 23898 | 246 | 0.861272 | 2.11872912 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 69.3 | 9.59e-12 | NR | PAA48259.1 | 282301 | g23712 | i0 | 41.5 | 2.90243902439024 | 82 | 41 | 92.7 | 2 | 238 | 11 | 201 | 281 | PAA48259.1 hypothetical protein BOX15_Mlig018716g2 [Macrostomum lignano] | diamond | 714 | 69.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 32809520 | 32809520 | PRJNA1214993_P_NODE_20840_length_251_cov_0.865169_g20654_i0 | PRJNA1214993 | 20840 | 251 | 0.865169 | 2.17157419 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 67 | 1.17e-10 | NR | VDD74042.1 | 53468 | g20654 | i0 | 40.7 | 6.50199203187251 | 81 | 46 | 96.8 | 1 | 7 | 249 | 327 | 405 | VDD74042.1 unnamed protein product [Mesocestoides corti] | diamond | 1632 | 67 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Mesocestoididae | Mesocestoides | Mesocestoides corti |
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);;