contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA1061474" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4004889 | 4004889 | PRJNA1061474_P_NODE_34724_length_309_cov_1.593220_g34478_i0 | PRJNA1061474 | 34724 | 309 | 1.59322 | 4.9230498 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 201 | 1.5e-63 | NR | PRP73841.1 | 1890364 | g34478 | i0 | 94.1 | 0.990291262135922 | 102 | 6 | 99 | 0 | 307 | 2 | 9 | 110 | PRP73841.1 Rab5/RabF-family small GTPase [Planoprotostelium fungivorum] | diamond | 306 | 201 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 6556632 | 6556632 | PRJNA1061474_P_NODE_41526_length_271_cov_1.555556_g41280_i0 | PRJNA1061474 | 41526 | 271 | 1.555556 | 4.21555676 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 128 | 1.59e-34 | NR | PRP83381.1 | 1890364 | g41280 | i0 | 85.7 | 0.85239852398524 | 77 | 11 | 85.2 | 0 | 39 | 269 | 1 | 77 | PRP83381.1 ribosomal protein S3a, component of cytosolic 80S ribosome and 40S small subunit [Planoprotostelium fungivorum] | diamond | 231 | 128 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 24404837 | 24404837 | PRJNA1061474_P_NODE_48840_length_248_cov_0.880000_g48594_i0 | PRJNA1061474 | 48840 | 248 | 0.88 | 2.1824 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 94.7 | 2.06e-20 | NR | XP_004353032.1 | 1257118 | g48594 | i0 | 69.7 | 6.3991935483871 | 66 | 18 | 79.8 | 1 | 198 | 1 | 1860 | 1923 | XP_004353032.1 DEAD box RNA helicase, putative [Acanthamoeba castellanii str. Neff] | diamond | 1587 | 94.7 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 26774129 | 26774129 | PRJNA1061474_P_NODE_46421_length_250_cov_1.305085_g46175_i0 | PRJNA1061474 | 46421 | 250 | 1.305085 | 3.2627125 | Viridiplantae | 33090 | Evosea | other_Eukaryota | 104 | 5.65e-25 | NR | KYQ92109.1 | 361077 | g46175 | i0 | 51.2 | 2.952 | 82 | 40 | 98.4 | 0 | 247 | 2 | 155 | 236 | KYQ92109.1 hypothetical protein DLAC_06949 [Tieghemostelium lacteum] | diamond | 738 | 105 | 0.990476190476191 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Raperosteliaceae | Tieghemostelium | Tieghemostelium lacteum | ||
| 26908917 | 26908917 | PRJNA1061474_P_NODE_43722_length_259_cov_1.650538_g43476_i0 | PRJNA1061474 | 43722 | 259 | 1.650538 | 4.27489342 | Dictyostelium discoideum AX4 | 352472 | Evosea | other_Eukaryota | 44.7 | 0.00901 | NR | XP_643304.1 | 352472 | g43476 | i0 | 31.1 | 0.857142857142857 | 74 | 46 | 82.2 | 3 | 44 | 256 | 249 | 320 | XP_643304.1 cyclin-like F-box containing protein [Dictyostelium discoideum AX4] | diamond | 222 | 44.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 27256691 | 27256691 | PRJNA1061474_P_NODE_44823_length_253_cov_1.444444_g44577_i0 | PRJNA1061474 | 44823 | 253 | 1.444444 | 3.65444332 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 75.1 | 2.17e-14 | NR | PRP74054.1 | 1890364 | g44577 | i0 | 40.5 | 0.99604743083004 | 84 | 50 | 99.6 | 0 | 253 | 2 | 19 | 102 | PRP74054.1 hypothetical protein PROFUN_08678 [Planoprotostelium fungivorum] | diamond | 252 | 75.1 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 28551569 | 28551569 | PRJNA1061474_P_NODE_45467_length_251_cov_0.865169_g45221_i0 | PRJNA1061474 | 45467 | 251 | 0.865169 | 2.17157419 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 50.1 | 1.03e-4 | NR | PRP84918.1 | 1890364 | g45221 | i0 | 32.9 | 0.944223107569721 | 79 | 52 | 94.4 | 1 | 1 | 237 | 266 | 343 | PRP84918.1 hypothetical protein PROFUN_07572 [Planoprotostelium fungivorum] | diamond | 237 | 50.1 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 28583125 | 28583125 | PRJNA1061474_P_NODE_38107_length_290_cov_1.064516_g37861_i0 | PRJNA1061474 | 38107 | 290 | 1.064516 | 3.0870964 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 116 | 2.63e-30 | NR | PRP86688.1 | 1890364 | g37861 | i0 | 59.4 | 0.993103448275862 | 96 | 39 | 99.3 | 0 | 3 | 290 | 80 | 175 | PRP86688.1 hypothetical protein PROFUN_05167 [Planoprotostelium fungivorum] | diamond | 288 | 116 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 29561614 | 29561614 | PRJNA1061474_P_NODE_46390_length_250_cov_1.395480_g46144_i0 | PRJNA1061474 | 46390 | 250 | 1.39548 | 3.4887 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 116 | 2.15e-30 | NR | PRP83112.1 | 1890364 | g46144 | i0 | 70 | 0.96 | 80 | 24 | 96 | 0 | 240 | 1 | 105 | 184 | PRP83112.1 hypothetical protein PROFUN_09791 [Planoprotostelium fungivorum] | diamond | 240 | 116 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 29624424 | 29624424 | PRJNA1061474_P_NODE_52730_length_245_cov_0.895349_g52484_i0 | PRJNA1061474 | 52730 | 245 | 0.895349 | 2.19360505 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 142 | 8.27e-38 | NR | PRP74799.1 | 1890364 | g52484 | i0 | 79 | 0.991836734693878 | 81 | 17 | 99.2 | 0 | 243 | 1 | 241 | 321 | PRP74799.1 actin binding protein [Planoprotostelium fungivorum] | diamond | 243 | 142 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 30762256 | 30762256 | PRJNA1061474_P_NODE_47974_length_249_cov_0.875000_g47728_i0 | PRJNA1061474 | 47974 | 249 | 0.875 | 2.17875 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 115 | 7.8199999999999985e-28 | NR | PRP86321.1 | 1890364 | g47728 | i0 | 66.7 | 2.89156626506024 | 81 | 27 | 97.6 | 0 | 7 | 249 | 797 | 877 | PRP86321.1 hypothetical protein PROFUN_05462 [Planoprotostelium fungivorum] | diamond | 720 | 115 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 31038600 | 31038600 | PRJNA1061474_P_NODE_52235_length_245_cov_1.354651_g51989_i0 | PRJNA1061474 | 52235 | 245 | 1.354651 | 3.31889495 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 78.6 | 8.97e-15 | NR | XP_636911.1 | 352472 | g51989 | i0 | 71.2 | 2.05714285714286 | 52 | 15 | 63.7 | 0 | 86 | 241 | 21 | 72 | XP_636911.1 3-oxoacid CoA-transferase [Dictyostelium discoideum AX4] | diamond | 504 | 79 | 0.994936708860759 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 31457672 | 31457672 | PRJNA1061474_P_NODE_38016_length_290_cov_1.419355_g37770_i0 | PRJNA1061474 | 38016 | 290 | 1.419355 | 4.1161295 | Heterostelium album PN5 | 2086695 | Evosea | other_Eukaryota | 115 | 8.73e-29 | NR | XP_020431082.1 | 670386 | g37770 | i0 | 59.1 | 1.90344827586207 | 93 | 38 | 96.2 | 0 | 281 | 3 | 165 | 257 | XP_020431082.1 S60 ribosomal protein L32 [Heterostelium album PN500] | diamond | 552 | 115 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album |
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);;