contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJEB12982" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6399121 | 6399121 | PRJEB12982_P_NODE_19986_length_163_cov_0.894737_g19823_i0 | PRJEB12982 | 19986 | 163 | 0.894737 | 1.45842131 | Pelomyxa schiedti | 1580589 | Evosea | other_Eukaryota | 66.2 | 4.48e-12 | NR | KAH3763125.1 | 1580589 | g19823 | i0 | 72.5 | 0.736196319018405 | 40 | 11 | 73.6 | 0 | 44 | 163 | 6 | 45 | KAH3763125.1 60S acidic ribosomal protein P1 [Pelomyxa schiedti] | diamond | 120 | 66.2 | 1 | Eukaryota | Amoebozoa | Evosea | Pelobiontida | Pelomyxidae | Pelomyxa | Pelomyxa schiedti | |||
| 26589552 | 26589552 | PRJEB12982_P_NODE_12441_length_199_cov_1.000000_g12278_i0 | PRJEB12982 | 12441 | 199 | 1 | 1.99 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 60.5 | 1.18e-8 | NR | PRP89338.1 | 1890364 | g12278 | i0 | 60.4 | 0.723618090452261 | 48 | 19 | 72.4 | 0 | 25 | 168 | 47 | 94 | PRP89338.1 cobalamin synthesis protein P47K [Planoprotostelium fungivorum] | diamond | 144 | 60.5 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 27665091 | 27665091 | PRJEB12982_P_NODE_18864_length_164_cov_0.886957_g18701_i0 | PRJEB12982 | 18864 | 164 | 0.886957 | 1.45460948 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 77.4 | 7.58e-15 | NR | XP_004353652.1 | 1257118 | g18701 | i0 | 74.5 | 0.932926829268293 | 51 | 13 | 93.3 | 0 | 6 | 158 | 327 | 377 | XP_004353652.1 transcriptional regulator, Sir2 family protein [Acanthamoeba castellanii str. Neff] | diamond | 153 | 77.4 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 27791303 | 27791303 | PRJEB12982_P_NODE_10264_length_220_cov_1.192982_g10101_i0 | PRJEB12982 | 10264 | 220 | 1.192982 | 2.6245604 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 69.7 | 4.67e-12 | NR | PRP89404.1 | 1890364 | g10101 | i0 | 54.7 | 1.8 | 64 | 23 | 87.3 | 1 | 218 | 27 | 226 | 283 | PRP89404.1 spermidine synthase [Planoprotostelium fungivorum] | diamond | 396 | 69.7 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 28170085 | 28170085 | PRJEB12982_P_NODE_19646_length_163_cov_0.894737_g19483_i0 | PRJEB12982 | 19646 | 163 | 0.894737 | 1.45842131 | Polysphondylium violaceum | 133409 | Evosea | other_Eukaryota | 70.1 | 1.53e-12 | NR | KAF2070078.1 | 133409 | g19483 | i0 | 61.1 | 1.96932515337423 | 54 | 21 | 99.4 | 0 | 2 | 163 | 75 | 128 | KAF2070078.1 hypothetical protein CYY_008604 [Polysphondylium violaceum] | diamond | 321 | 70.1 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Polysphondylium | Polysphondylium violaceum | ||
| 29938376 | 29938376 | PRJEB12982_P_NODE_21071_length_161_cov_0.910714_g20908_i0 | PRJEB12982 | 21071 | 161 | 0.910714 | 1.46624954 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 47.4 | 2.85e-4 | NR | XP_004341550.1 | 1257118 | g20908 | i0 | 62.5 | 1.2111801242236 | 32 | 12 | 59.6 | 0 | 1 | 96 | 547 | 578 | XP_004341550.1 methylenetetrahydrofolate reductase [Acanthamoeba castellanii str. Neff] | diamond | 195 | 47.4 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 30349558 | 30349558 | PRJEB12982_P_NODE_15432_length_176_cov_1.204724_g15269_i0 | PRJEB12982 | 15432 | 176 | 1.204724 | 2.12031424 | Physarum polycephalum | 5791 | Evosea | other_Eukaryota | 59.7 | 1.61e-9 | NR | P18322.3 | 5791 | g15269 | i0 | 74.3 | 0.596590909090909 | 35 | 9 | 59.7 | 0 | 176 | 72 | 91 | 125 | P18322.3 RecName: Full=Profilin-P [Physarum polycephalum] | diamond | 105 | 59.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum polycephalum | ||
| 31986367 | 31986367 | PRJEB12982_P_NODE_20438_length_162_cov_0.902655_g20275_i0 | PRJEB12982 | 20438 | 162 | 0.902655 | 1.4623011 | Dictyostelium | 5782 | Evosea | other_Eukaryota | 50.4 | 2.24e-5 | NR | XP_003290573.1 | 5786 | g20275 | i0 | 49.1 | 2.09259259259259 | 57 | 22 | 98.1 | 3 | 161 | 3 | 170 | 223 | XP_003290573.1 uncharacterized protein DICPUDRAFT_155103 [Dictyostelium purpureum] | diamond | 339 | 50.4 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 32119564 | 32119564 | PRJEB12982_P_NODE_18158_length_165_cov_0.879310_g17995_i0 | PRJEB12982 | 18158 | 165 | 0.87931 | 1.4508615 | Pelomyxa schiedti | 1580589 | Evosea | other_Eukaryota | 60.8 | 5.15e-9 | NR | KAH3758651.1 | 1580589 | g17995 | i0 | 50 | 0.981818181818182 | 54 | 26 | 98.2 | 1 | 163 | 2 | 184 | 236 | KAH3758651.1 IBR domain protein [Pelomyxa schiedti] | diamond | 162 | 60.8 | 1 | Eukaryota | Amoebozoa | Evosea | Pelobiontida | Pelomyxidae | Pelomyxa | Pelomyxa schiedti | |||
| 32562667 | 32562667 | PRJEB12982_P_NODE_17179_length_167_cov_0.864407_g17016_i0 | PRJEB12982 | 17179 | 167 | 0.864407 | 1.44355969 | Dictyostelium discoideum AX4 | 352472 | Evosea | other_Eukaryota | 61.2 | 3.91e-9 | NR | XP_643747.1 | 352472 | g17016 | i0 | 60.7 | 1.9940119760479 | 56 | 16 | 98.8 | 2 | 1 | 165 | 256 | 306 | XP_643747.1 hypothetical protein DDB_G0275107 [Dictyostelium discoideum AX4] | diamond | 333 | 61.2 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 32782633 | 32782633 | PRJEB12982_P_NODE_13360_length_191_cov_1.436620_g13197_i0 | PRJEB12982 | 13360 | 191 | 1.43662 | 2.7439442 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 48.1 | 2.31e-4 | NR | XP_004353486.1 | 1257118 | g13197 | i0 | 47.2 | 0.832460732984293 | 53 | 27 | 83.2 | 1 | 159 | 1 | 99 | 150 | XP_004353486.1 amine oxidase, flavincontaining superfamily protein [Acanthamoeba castellanii str. Neff] | diamond | 159 | 48.1 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 32845769 | 32845769 | PRJEB12982_P_NODE_17100_length_167_cov_0.864407_g16937_i0 | PRJEB12982 | 17100 | 167 | 0.864407 | 1.44355969 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 85.9 | 6.68e-19 | NR | XP_004348701.1 | 1257118 | g16937 | i0 | 67.3 | 2.96407185628743 | 55 | 18 | 98.8 | 0 | 3 | 167 | 131 | 185 | XP_004348701.1 Ras family protein [Acanthamoeba castellanii str. Neff] | diamond | 495 | 85.9 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii |
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);;