contig_metadata
13 rows where bioproject = "PRJNA1192965" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9248416 | 9248416 | PRJNA1192965_P_NODE_1348_length_350_cov_1.021661_g1329_i0 | PRJNA1192965 | 1348 | 350 | 1.021661 | 3.5758135 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 189 | 3.5099999999999994e-57 | NR | XP_004344643.1 | 1257118 | g1329 | i0 | 74.1 | 2.98285714285714 | 116 | 30 | 99.4 | 0 | 1 | 348 | 31 | 146 | XP_004344643.1 MC family transporter: phosphate, putative [Acanthamoeba castellanii str. Neff] | diamond | 1044 | 189 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 18893843 | 18893843 | PRJNA1192965_P_NODE_2235_length_288_cov_1.432558_g2216_i0 | PRJNA1192965 | 2235 | 288 | 1.432558 | 4.12576704 | Evosea | 2605435 | Evosea | other_Eukaryota | 117 | 5.209999999999999e-32 | NR | KAF2076753.1 | 133409 | g2216 | i0 | 67.1 | 15.1458333333333 | 79 | 26 | 82.3 | 0 | 283 | 47 | 1 | 79 | KAF2076753.1 hypothetical protein CYY_001942 [Polysphondylium violaceum] | diamond | 4362 | 117 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Polysphondylium | Polysphondylium violaceum | ||
| 19446530 | 19446530 | PRJNA1192965_P_NODE_2136_length_293_cov_1.750000_g2117_i0 | PRJNA1192965 | 2136 | 293 | 1.75 | 5.1275 | Platyamoeba placida | 3454475 | Discosea | other_Eukaryota | 392 | 1.41e-104 | NTclustered | gi|33946348|gb|AY294153.1| | 197527 | g2117 | i0 | 90.785 | 92.2491467576792 | 293 | 27 | 100 | 0 | 1 | 293 | 1050 | 758 | Platyamoeba placida actin mRNA, partial cds | blastn | 27029 | 392 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Platyamoeba | Platyamoeba placida | |||
| 26819373 | 26819373 | PRJNA1192965_P_NODE_4041_length_247_cov_0.885057_g4022_i0 | PRJNA1192965 | 4041 | 247 | 0.885057 | 2.18609079 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 94 | 3.61e-20 | NR | PRP82197.1 | 1890364 | g4022 | i0 | 56.3 | 0.97165991902834 | 80 | 35 | 97.2 | 0 | 242 | 3 | 663 | 742 | PRP82197.1 hypothetical protein PROFUN_10406 [Planoprotostelium fungivorum] | diamond | 240 | 94 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 27122691 | 27122691 | PRJNA1192965_P_NODE_2382_length_283_cov_1.100000_g2363_i0 | PRJNA1192965 | 2382 | 283 | 1.1 | 3.113 | Eumycetozoa | 142796 | Evosea | other_Eukaryota | 108 | 4.660000000000001e-27 | NR | KAF2074121.1 | 133409 | g2363 | i0 | 52.2 | 3.6678445229682 | 90 | 43 | 95.4 | 0 | 1 | 270 | 94 | 183 | KAF2074121.1 hypothetical protein CYY_004563 [Polysphondylium violaceum] | diamond | 1038 | 108 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Polysphondylium | Polysphondylium violaceum | ||
| 28620019 | 28620019 | PRJNA1192965_P_NODE_3427_length_251_cov_0.865169_g3408_i0 | PRJNA1192965 | 3427 | 251 | 0.865169 | 2.17157419 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 57.4 | 2.33e-7 | NR | XP_004338074.1 | 1257118 | g3408 | i0 | 83.3 | 0.430278884462151 | 36 | 6 | 43 | 0 | 109 | 2 | 172 | 207 | XP_004338074.1 TolAlike protein [Acanthamoeba castellanii str. Neff] | diamond | 108 | 57.4 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 29819434 | 29819434 | PRJNA1192965_P_NODE_3271_length_251_cov_0.865169_g3252_i0 | PRJNA1192965 | 3271 | 251 | 0.865169 | 2.17157419 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 92.8 | 6.11e-20 | NR | XP_004338165.1 | 1257118 | g3252 | i0 | 49.4 | 0.99203187250996006 | 83 | 42 | 99.2 | 0 | 250 | 2 | 123 | 205 | XP_004338165.1 CDPalcohol phosphatidyltransferase superfamily protein [Acanthamoeba castellanii str. Neff] | diamond | 249 | 92.8 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 30925673 | 30925673 | PRJNA1192965_P_NODE_3214_length_252_cov_1.720670_g3195_i0 | PRJNA1192965 | 3214 | 252 | 1.72067 | 4.3360884 | Entamoeba dispar SAW76 | 46681 | Evosea | other_Eukaryota | 79.7 | 2.01e-16 | NR | XP_001735418.1 | 370354 | g3195 | i0 | 46.4 | 1 | 84 | 45 | 100 | 0 | 252 | 1 | 20 | 103 | XP_001735418.1 60S ribosomal protein L18A, putative [Entamoeba dispar SAW760] | diamond | 252 | 79.7 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba dispar | |||
| 31020309 | 31020309 | PRJNA1192965_P_NODE_1355_length_349_cov_1.090580_g1336_i0 | PRJNA1192965 | 1355 | 349 | 1.09058 | 3.8061242 | Entamoeba dispar SAW76 | 46681 | Evosea | other_Eukaryota | 49.7 | 4.45e-4 | NR | XP_001737935.1 | 370354 | g1336 | i0 | 32.3 | 0.799426934097421 | 93 | 57 | 79.1 | 4 | 347 | 72 | 551 | 638 | XP_001737935.1 uncharacterized protein EDI_307930, partial [Entamoeba dispar SAW760] | diamond | 279 | 49.7 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba dispar | |||
| 31450360 | 31450360 | PRJNA1192965_P_NODE_4616_length_244_cov_0.900585_g4597_i0 | PRJNA1192965 | 4616 | 244 | 0.900585 | 2.1974274 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 74.3 | 2.91e-13 | NR | XP_004349737.1 | 1257118 | g4597 | i0 | 62.9 | 1.61065573770492 | 62 | 20 | 76.2 | 1 | 19 | 204 | 908 | 966 | XP_004349737.1 helicase conserved Cterminal domain containing protein [Acanthamoeba castellanii str. Neff] | diamond | 393 | 74.3 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 32082845 | 32082845 | PRJNA1192965_P_NODE_3358_length_251_cov_0.865169_g3339_i0 | PRJNA1192965 | 3358 | 251 | 0.865169 | 2.17157419 | Dictyostelium | 5782 | Evosea | other_Eukaryota | 74.7 | 2.28e-13 | NR | CAA68685.1 | 44689 | g3339 | i0 | 47.4 | 1.86454183266932 | 78 | 40 | 93.2 | 1 | 236 | 3 | 727 | 803 | CAA68685.1 unnamed protein product [Dictyostelium discoideum] | diamond | 468 | 74.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 32254045 | 32254045 | PRJNA1192965_P_NODE_2238_length_288_cov_1.390698_g2219_i0 | PRJNA1192965 | 2238 | 288 | 1.390698 | 4.00521024 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 45.4 | 0.00111 | NR | PRP89373.1 | 1890364 | g2219 | i0 | 53.3 | 0.46875 | 45 | 21 | 46.9 | 0 | 255 | 121 | 4 | 48 | PRP89373.1 hypothetical protein PROFUN_01236 [Planoprotostelium fungivorum] | diamond | 135 | 45.4 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 32412036 | 32412036 | PRJNA1192965_P_NODE_3439_length_250_cov_1.779661_g3420_i0 | PRJNA1192965 | 3439 | 250 | 1.779661 | 4.4491525 | Polysphondylium violaceum | 133409 | Evosea | other_Eukaryota | 72 | 1.81e-13 | NR | KAF2071651.1 | 133409 | g3420 | i0 | 45.8 | 0.996 | 83 | 43 | 99.6 | 1 | 250 | 2 | 91 | 171 | KAF2071651.1 hypothetical protein CYY_007026 [Polysphondylium violaceum] | diamond | 249 | 72 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Polysphondylium | Polysphondylium violaceum |
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);;