contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA1010662" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18006693 | 18006693 | PRJNA1010662_P_NODE_675_length_606_cov_4.052065_g619_i0 | PRJNA1010662 | 675 | 606 | 4.052065 | 24.5555139 | root | 1 | Root_unresolved | Root_unresolved | 210 | 3.46e-63 | NR | CUU98813.1 | 85433 | g619 | i0 | 56.5 | 14.7079207920792 | 200 | 78 | 94.6 | 2 | 606 | 34 | 173 | 372 | CUU98813.1 hypothetical transcript [Hymenolepis microstoma] | diamond | 8913 | 210 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis microstoma | |
| 19280467 | 19280467 | PRJNA1010662_P_NODE_6436_length_217_cov_2.160714_g6377_i0 | PRJNA1010662 | 6436 | 217 | 2.160714 | 4.68874938 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 116 | 2.94e-31 | NR | PAA86685.1 | 282301 | g6377 | i0 | 73.9 | 19.0506912442396 | 69 | 18 | 95.4 | 0 | 9 | 215 | 79 | 147 | PAA86685.1 hypothetical protein BOX15_Mlig021346g2 [Macrostomum lignano] | diamond | 4134 | 117 | 0.991452991452991 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 20556118 | 20556118 | PRJNA1010662_P_NODE_8177_length_199_cov_1.380000_g8118_i0 | PRJNA1010662 | 8177 | 199 | 1.38 | 2.7462 | root | 1 | Root_unresolved | Root_unresolved | 104 | 1.41e-25 | NR | VDL59718.1 | 6216 | g8118 | i0 | 75.4 | 10.7788944723618 | 65 | 16 | 98 | 0 | 195 | 1 | 170 | 234 | VDL59718.1 unnamed protein product [Hymenolepis diminuta] | diamond | 2145 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis diminuta | |
| 26932139 | 26932139 | PRJNA1010662_P_NODE_5802_length_226_cov_1.542373_g5743_i0 | PRJNA1010662 | 5802 | 226 | 1.542373 | 3.48576298 | Schistosomatidae | 31245 | Platyhelminthes | Platyhelminthes | 57.8 | 1.49e-7 | NR | CAH8532628.1 | 39320 | g5743 | i0 | 38.7 | 4.97787610619469 | 75 | 38 | 99.6 | 1 | 226 | 2 | 13 | 79 | CAH8532628.1 unnamed protein product [Heterobilharzia americana] | diamond | 1125 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Heterobilharzia | Heterobilharzia americana | |
| 27879903 | 27879903 | PRJNA1010662_P_NODE_14285_length_166_cov_0.880342_g14226_i0 | PRJNA1010662 | 14285 | 166 | 0.880342 | 1.46136772 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 77.4 | 7.24e-15 | NR | KAL3315165.1 | 1844966 | g14226 | i0 | 70.6 | 1.89759036144578 | 51 | 15 | 92.2 | 0 | 3 | 155 | 341 | 391 | KAL3315165.1 hypothetical protein Ciccas_006212 [Cichlidogyrus casuarinus] | diamond | 315 | 77.8 | 0.994858611825193 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Dactylogyridea | Ancyrocephalidae | Cichlidogyrus | Cichlidogyrus casuarinus | |
| 28732463 | 28732463 | PRJNA1010662_P_NODE_10567_length_180_cov_1.969466_g10508_i0 | PRJNA1010662 | 10567 | 180 | 1.969466 | 3.5450388 | Paragonimus | 34503 | Platyhelminthes | Platyhelminthes | 51.6 | 1.18e-5 | NR | KAF8565673.1 | 34504 | g10508 | i0 | 53.7 | 1.36666666666667 | 41 | 18 | 66.7 | 1 | 15 | 134 | 302 | 342 | KAF8565673.1 hypothetical protein P879_07354, partial [Paragonimus westermani] | diamond | 246 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus westermani | |
| 28921701 | 28921701 | PRJNA1010662_P_NODE_1908_length_366_cov_5.962145_g1849_i0 | PRJNA1010662 | 1908 | 366 | 5.962145 | 21.8214507 | Cyclophyllidea | 6201 | Platyhelminthes | Platyhelminthes | 52.8 | 3.55e-5 | NR | CDS37392.1 | 6211 | g1849 | i0 | 41 | 1.87704918032787 | 78 | 34 | 60.7 | 4 | 283 | 62 | 206 | 275 | CDS37392.1 calbindin 32 [Echinococcus multilocularis] | diamond | 687 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus multilocularis | |
| 29016924 | 29016924 | PRJNA1010662_P_NODE_16128_length_163_cov_0.903509_g16069_i0 | PRJNA1010662 | 16128 | 163 | 0.903509 | 1.47271967 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 69.3 | 5.35e-12 | NR | KAF8563514.1 | 34504 | g16069 | i0 | 48.1 | 244.490797546012 | 54 | 28 | 99.4 | 0 | 2 | 163 | 894 | 947 | KAF8563514.1 hypothetical protein P879_07973 [Paragonimus westermani] | diamond | 39852 | 69.7 | 0.994261119081779 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus westermani | |
| 31171717 | 31171717 | PRJNA1010662_P_NODE_8895_length_192_cov_1.895105_g8836_i0 | PRJNA1010662 | 8895 | 192 | 1.895105 | 3.6386016 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 56.6 | 2.27e-8 | NR | PAA58301.1 | 282301 | g8836 | i0 | 38.1 | 1.8125 | 63 | 38 | 98.4 | 1 | 4 | 192 | 33 | 94 | PAA58301.1 hypothetical protein BOX15_Mlig001673g1 [Macrostomum lignano] | diamond | 348 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 31575722 | 31575722 | PRJNA1010662_P_NODE_1516_length_413_cov_1.700549_g1457_i0 | PRJNA1010662 | 1516 | 413 | 1.700549 | 7.02326737 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 78.6 | 3.06e-15 | NR | VDD79404.1 | 53468 | g1457 | i0 | 58.3 | 3.11622276029056 | 60 | 25 | 43.6 | 0 | 181 | 2 | 4 | 63 | VDD79404.1 unnamed protein product [Mesocestoides corti] | diamond | 1287 | 78.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Mesocestoididae | Mesocestoides | Mesocestoides corti | |
| 32595501 | 32595501 | PRJNA1010662_P_NODE_15360_length_164_cov_0.904348_g15301_i0 | PRJNA1010662 | 15360 | 164 | 0.904348 | 1.48313072 | Paragonimus kellicotti | 100269 | Platyhelminthes | Platyhelminthes | 51.2 | 5.13e-6 | NR | KAF6771045.1 | 100269 | g15301 | i0 | 46.2 | 0.951219512195122 | 52 | 28 | 95.1 | 0 | 160 | 5 | 11 | 62 | KAF6771045.1 hypothetical protein AHF37_10406 [Paragonimus kellicotti] | diamond | 156 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus kellicotti | |
| 32619353 | 32619353 | PRJNA1010662_P_NODE_4100_length_260_cov_1.966825_g4041_i0 | PRJNA1010662 | 4100 | 260 | 1.966825 | 5.113745 | Hymenolepididae | 6214 | Platyhelminthes | Platyhelminthes | 51.6 | 2.72e-5 | NR | CDS31946.1 | 85433 | g4041 | i0 | 40.5 | 2.59615384615385 | 74 | 38 | 84.2 | 3 | 35 | 253 | 179 | 247 | CDS31946.1 calbindin 32 [Hymenolepis microstoma] | diamond | 675 | 52 | 0.992307692307692 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis microstoma | |
| 32682150 | 32682150 | PRJNA1010662_P_NODE_4540_length_249_cov_2.180000_g4481_i0 | PRJNA1010662 | 4540 | 249 | 2.18 | 5.4282 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 59.3 | 4.91e-8 | NR | VUZ55083.1 | 6216 | g4481 | i0 | 42.5 | 3.89156626506024 | 80 | 45 | 95.2 | 1 | 245 | 9 | 111 | 190 | VUZ55083.1 unnamed protein product [Hymenolepis diminuta] | diamond | 969 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis diminuta |
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);;