contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJEB673" and tax_clade = "Amoebozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7787252 | 7787252 | PRJEB673_P_NODE_1407_length_798_cov_2.159895_g1186_i0 | PRJEB673 | 1407 | 798 | 2.159895 | 17.2359621 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 239 | 9.12e-71 | NR | BAF75925.1 | 5791 | g1186 | i0 | 71.2 | 11.1052631578947 | 153 | 44 | 57.5 | 0 | 459 | 1 | 268 | 420 | BAF75925.1 heat shock protein 90, partial [Physarum polycephalum] | diamond | 8862 | 239 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum polycephalum | ||
| 11198607 | 11198607 | PRJEB673_P_NODE_5569_length_376_cov_1.337243_g5220_i0 | PRJEB673 | 5569 | 376 | 1.337243 | 5.02803368 | Eumycetozoa | 142796 | Evosea | other_Eukaryota | 104 | 3.39e-26 | NR | KYQ89188.1 | 361077 | g5220 | i0 | 51.5 | 2.52925531914894 | 101 | 49 | 80.6 | 0 | 20 | 322 | 3 | 103 | KYQ89188.1 40S ribosomal protein S26 [Tieghemostelium lacteum] | diamond | 951 | 105 | 0.990476190476191 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Raperosteliaceae | Tieghemostelium | Tieghemostelium lacteum | ||
| 21811724 | 21811724 | PRJEB673_P_NODE_8778_length_237_cov_1.742574_g8429_i0 | PRJEB673 | 8778 | 237 | 1.742574 | 4.12990038 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 132 | 4.82e-35 | NR | XP_635383.1 | 352472 | g8429 | i0 | 76.9 | 6.05063291139241 | 78 | 18 | 98.7 | 0 | 1 | 234 | 305 | 382 | XP_635383.1 S-adenosylmethionine synthetase [Dictyostelium discoideum AX4] | diamond | 1434 | 133 | 0.992481203007519 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 26590619 | 26590619 | PRJEB673_P_NODE_6501_length_341_cov_1.751634_g6152_i0 | PRJEB673 | 6501 | 341 | 1.751634 | 5.97307194 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 73.2 | 6.73e-14 | NR | 1F2K_A | 5755 | g6152 | i0 | 75.6 | 0.395894428152493 | 45 | 11 | 39.6 | 0 | 205 | 339 | 62 | 106 | 1F2K_A Chain A, PROFILIN II [Acanthamoeba castellanii] | diamond | 135 | 73.2 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 27286962 | 27286962 | PRJEB673_P_NODE_2563_length_615_cov_4.634483_g2269_i0 | PRJEB673 | 2563 | 615 | 4.634483 | 28.50207045 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 45.4 | 0.0114 | NR | XP_004351526.1 | 1257118 | g2269 | i0 | 44.9 | 0.239024390243902 | 49 | 27 | 23.9 | 0 | 560 | 414 | 26 | 74 | XP_004351526.1 selT/selW/selH selenoprotein domain containing protein [Acanthamoeba castellanii str. Neff] | diamond | 147 | 45.4 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 27571207 | 27571207 | PRJEB673_P_NODE_9124_length_211_cov_1.352273_g8775_i0 | PRJEB673 | 9124 | 211 | 1.352273 | 2.85329603 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 86.3 | 8.04e-18 | NR | PRP80070.1 | 1890364 | g8775 | i0 | 49.3 | 0.981042654028436 | 69 | 35 | 98.1 | 0 | 208 | 2 | 275 | 343 | PRP80070.1 glutathione S-transferase domain-containing protein [Planoprotostelium fungivorum] | diamond | 207 | 86.3 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 27697911 | 27697911 | PRJEB673_P_NODE_10864_length_168_cov_1.195489_g10515_i0 | PRJEB673 | 10864 | 168 | 1.195489 | 2.00842152 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 89.4 | 5.04e-19 | NR | XP_004350624.1 | 261658 | g10515 | i0 | 77.8 | 7.71428571428571 | 54 | 12 | 96.4 | 0 | 166 | 5 | 443 | 496 | XP_004350624.1 elongation factor 2 [Cavenderia fasciculata] | diamond | 1296 | 89.4 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 27918458 | 27918458 | PRJEB673_P_NODE_4785_length_421_cov_2.152850_g4437_i0 | PRJEB673 | 4785 | 421 | 2.15285 | 9.0634985 | Tieghemostelium lacteum | 361077 | Evosea | other_Eukaryota | 146 | 5.539999999999999e-42 | NR | KYR02504.1 | 361077 | g4437 | i0 | 52.9 | 1.9667458432304 | 138 | 65 | 98.3 | 0 | 418 | 5 | 1 | 138 | KYR02504.1 actin binding protein [Tieghemostelium lacteum] | diamond | 828 | 146 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Raperosteliaceae | Tieghemostelium | Tieghemostelium lacteum | ||
| 28928935 | 28928935 | PRJEB673_P_NODE_8908_length_225_cov_3.126316_g8559_i0 | PRJEB673 | 8908 | 225 | 3.126316 | 7.034211 | Dictyostelium discoideum AX4 | 352472 | Evosea | other_Eukaryota | 48.5 | 4.58e-5 | NR | XP_639052.1 | 352472 | g8559 | i0 | 45.3 | 1.72 | 64 | 35 | 85.3 | 0 | 196 | 5 | 1 | 64 | XP_639052.1 ribosomal acidic phosphoprotein P2 [Dictyostelium discoideum AX4] | diamond | 387 | 48.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 28992386 | 28992386 | PRJEB673_P_NODE_8948_length_222_cov_0.983957_g8599_i0 | PRJEB673 | 8948 | 222 | 0.983957 | 2.18438454 | Tieghemostelium lacteum | 361077 | Evosea | other_Eukaryota | 87 | 5.24e-19 | NR | KYQ94221.1 | 361077 | g8599 | i0 | 54.3 | 0.945945945945946 | 70 | 30 | 94.6 | 1 | 212 | 3 | 1 | 68 | KYQ94221.1 hypothetical protein DLAC_04516 [Tieghemostelium lacteum] | diamond | 210 | 87 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Raperosteliaceae | Tieghemostelium | Tieghemostelium lacteum | ||
| 29497244 | 29497244 | PRJEB673_P_NODE_10070_length_181_cov_1.643836_g9721_i0 | PRJEB673 | 10070 | 181 | 1.643836 | 2.97534316 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 76.3 | 1.41e-14 | NR | XP_004356622.1 | 1257118 | g9721 | i0 | 59.3 | 0.977900552486188 | 59 | 24 | 97.8 | 0 | 179 | 3 | 69 | 127 | XP_004356622.1 mitochondrial phosphate transporter, putative [Acanthamoeba castellanii str. Neff] | diamond | 177 | 76.3 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 30382092 | 30382092 | PRJEB673_P_NODE_4073_length_485_cov_2.051111_g3739_i0 | PRJEB673 | 4073 | 485 | 2.051111 | 9.94788835 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 47.8 | 8.41e-4 | NR | XP_004351526.1 | 1257118 | g3739 | i0 | 46.9 | 0.303092783505155 | 49 | 26 | 30.3 | 0 | 458 | 312 | 26 | 74 | XP_004351526.1 selT/selW/selH selenoprotein domain containing protein [Acanthamoeba castellanii str. Neff] | diamond | 147 | 47.8 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 30760905 | 30760905 | PRJEB673_P_NODE_8754_length_239_cov_19.549020_g8405_i0 | PRJEB673 | 8754 | 239 | 19.54902 | 46.7221578 | Entamoeba invadens IP1 | 370355 | Evosea | other_Eukaryota | 48.1 | 4.54e-4 | NR | XP_004255455.1 | 370355 | g8405 | i0 | 29.5 | 1.93305439330544 | 78 | 44 | 94.1 | 2 | 226 | 2 | 772 | 841 | XP_004255455.1 protein serine/threonine kinase, putative [Entamoeba invadens IP1] | diamond | 462 | 48.1 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba invadens | |||
| 31645796 | 31645796 | PRJEB673_P_NODE_12977_length_150_cov_1.391304_g12628_i0 | PRJEB673 | 12977 | 150 | 1.391304 | 2.086956 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 61.6 | 2.21e-9 | NR | PRP76100.1 | 1890364 | g12628 | i0 | 55.6 | 4.54 | 45 | 20 | 90 | 0 | 6 | 140 | 221 | 265 | PRP76100.1 4-hydroxyphenylpyruvate dioxygenase-like [Planoprotostelium fungivorum] | diamond | 681 | 61.6 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 31986592 | 31986592 | PRJEB673_P_NODE_11778_length_158_cov_1.951220_g11429_i0 | PRJEB673 | 11778 | 158 | 1.95122 | 3.0829276 | Dictyosteliaceae | 2058185 | Evosea | other_Eukaryota | 97.8 | 3.1499999999999995e-23 | NR | XP_003287730.1 | 5786 | g11429 | i0 | 80.8 | 59.2405063291139 | 52 | 10 | 98.7 | 0 | 156 | 1 | 144 | 195 | XP_003287730.1 40S ribosomal protein S2 [Dictyostelium purpureum] | diamond | 9360 | 97.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum |
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);;