contig_metadata
13 rows where bioproject = "PRJNA839281" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16132434 | 16132434 | PRJNA839281_S_NODE_30893_length_165_cov_0.879310_g30624_i0 | PRJNA839281 | 30893 | 165 | 0.87931 | 1.4508615 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 52.8 | 0.014 | NTclustered | gi|66808516|ref|XM_632889.1| | 352472 | g30624 | i0 | 100 | 0.16969696969697 | 28 | 0 | 17 | 0 | 13 | 40 | 3291 | 3264 | Dictyostelium discoideum AX4 hypothetical protein (DDB_G0285955) mRNA, complete cds | blastn | 28 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 18681183 | 18681183 | PRJNA839281_S_NODE_6555_length_321_cov_1.481618_g6286_i0 | PRJNA839281 | 6555 | 321 | 1.481618 | 4.75599378 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 195 | 4.73e-45 | NTclustered | gi|470531494|ref|XM_004358017.1| | 1257118 | g6286 | i0 | 86.111 | 17.208722741433 | 180 | 25 | 56 | 0 | 142 | 321 | 1370 | 1191 | Acanthamoeba castellanii str. Neff ribonucleosidediphosphate reductase, alpha subunit (ACA1_119180), partial mRNA | blastn | 5524 | 195 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 23782045 | 23782045 | PRJNA839281_S_NODE_27679_length_166_cov_2.777778_g27410_i0 | PRJNA839281 | 27679 | 166 | 2.777778 | 4.61111148 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 71.3 | 3.84e-8 | NTclustered | gi|470511767|ref|XM_004352013.1| | 1257118 | g27410 | i0 | 89.286 | 0.746987951807229 | 56 | 6 | 34 | 0 | 20 | 75 | 227 | 282 | Acanthamoeba castellanii str. Neff ribosomal protein S7e, putative (ACA1_036040), partial mRNA | blastn | 124 | 71.3 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 26959586 | 26959586 | PRJNA839281_S_NODE_16762_length_200_cov_0.940397_g16493_i0 | PRJNA839281 | 16762 | 200 | 0.940397 | 1.880794 | Dictyostelium discoideum AX4 | 352472 | Evosea | other_Eukaryota | 98.2 | 7.52e-23 | NR | XP_641424.1 | 352472 | g16493 | i0 | 67.2 | 4.8 | 64 | 21 | 96 | 0 | 6 | 197 | 34 | 97 | XP_641424.1 myosin light chain kinase [Dictyostelium discoideum AX4] | diamond | 960 | 98.2 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 27212549 | 27212549 | PRJNA839281_S_NODE_3182_length_658_cov_4.170772_g2930_i0 | PRJNA839281 | 3182 | 658 | 4.170772 | 27.44367976 | Heterostelium album PN5 | 2086695 | Evosea | other_Eukaryota | 177 | 1.24e-51 | NR | XP_020433716.1 | 670386 | g2930 | i0 | 42.9 | 0.90273556231003 | 198 | 109 | 90.3 | 2 | 594 | 1 | 39 | 232 | XP_020433716.1 component of the counting factor complex [Heterostelium album PN500] | diamond | 594 | 177 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 28412787 | 28412787 | PRJNA839281_S_NODE_16386_length_201_cov_4.190789_g16117_i0 | PRJNA839281 | 16386 | 201 | 4.190789 | 8.42348589 | Pelomyxa schiedti | 1580589 | Evosea | other_Eukaryota | 95.5 | 3.58e-22 | NR | KAH3743745.1 | 1580589 | g16117 | i0 | 66.1 | 0.925373134328358 | 62 | 21 | 92.5 | 0 | 187 | 2 | 4 | 65 | KAH3743745.1 60S ribosomal protein L14 [Pelomyxa schiedti] | diamond | 186 | 95.5 | 1 | Eukaryota | Amoebozoa | Evosea | Pelobiontida | Pelomyxidae | Pelomyxa | Pelomyxa schiedti | |||
| 28854577 | 28854577 | PRJNA839281_S_NODE_33788_length_163_cov_0.894737_g33519_i0 | PRJNA839281 | 33788 | 163 | 0.894737 | 1.45842131 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 61.6 | 2.75e-9 | NR | XP_004359611.1 | 261658 | g33519 | i0 | 48.1 | 1.98773006134969 | 54 | 27 | 99.4 | 1 | 162 | 1 | 201 | 253 | XP_004359611.1 Hypothetical protein yfeW precursor [Cavenderia fasciculata] | diamond | 324 | 61.6 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 29928499 | 29928499 | PRJNA839281_S_NODE_30371_length_165_cov_0.879310_g30102_i0 | PRJNA839281 | 30371 | 165 | 0.87931 | 1.4508615 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 47.4 | 3e-4 | NR | PRP79146.1 | 1890364 | g30102 | i0 | 38.8 | 0.890909090909091 | 49 | 30 | 89.1 | 0 | 12 | 158 | 207 | 255 | PRP79146.1 hypothetical protein PROFUN_13096 [Planoprotostelium fungivorum] | diamond | 147 | 47.4 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 30180985 | 30180985 | PRJNA839281_S_NODE_7492_length_295_cov_1.138211_g7223_i0 | PRJNA839281 | 7492 | 295 | 1.138211 | 3.35772245 | Dictyostelium discoideum AX4 | 352472 | Evosea | other_Eukaryota | 66.2 | 3.5e-10 | NR | XP_641725.1 | 352472 | g7223 | i0 | 40.7 | 1.67796610169492 | 91 | 53 | 91.5 | 1 | 6 | 275 | 1 | 91 | XP_641725.1 cysteine proteinase [Dictyostelium discoideum AX4] | diamond | 495 | 66.2 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 31160127 | 31160127 | PRJNA839281_S_NODE_14255_length_213_cov_1.865854_g13986_i0 | PRJNA839281 | 14255 | 213 | 1.865854 | 3.97426902 | Pelomyxa schiedti | 1580589 | Evosea | other_Eukaryota | 55.8 | 2.16e-7 | NR | KAH3756281.1 | 1580589 | g13986 | i0 | 41.3 | 0.887323943661972 | 63 | 34 | 88.7 | 1 | 8 | 196 | 1 | 60 | KAH3756281.1 ganglioside GM2 activator [Pelomyxa schiedti] | diamond | 189 | 55.8 | 1 | Eukaryota | Amoebozoa | Evosea | Pelobiontida | Pelomyxidae | Pelomyxa | Pelomyxa schiedti | |||
| 31792832 | 31792832 | PRJNA839281_S_NODE_8777_length_269_cov_1.145455_g8508_i0 | PRJNA839281 | 8777 | 269 | 1.145455 | 3.08127395 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 124 | 7.91e-31 | NR | PRP76070.1 | 1890364 | g8508 | i0 | 69.7 | 0.992565055762082 | 89 | 27 | 99.3 | 0 | 267 | 1 | 828 | 916 | PRP76070.1 inositol-3-phosphate synthase [Planoprotostelium fungivorum] | diamond | 267 | 124 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 31824540 | 31824540 | PRJNA839281_S_NODE_33097_length_163_cov_1.192982_g32828_i0 | PRJNA839281 | 33097 | 163 | 1.192982 | 1.94456066 | Pelomyxa schiedti | 1580589 | Evosea | other_Eukaryota | 81.3 | 9.34e-17 | NR | KAH3758173.1 | 1580589 | g32828 | i0 | 63.5 | 0.957055214723926 | 52 | 19 | 95.7 | 0 | 162 | 7 | 202 | 253 | KAH3758173.1 abc transporter [Pelomyxa schiedti] | diamond | 156 | 81.3 | 1 | Eukaryota | Amoebozoa | Evosea | Pelobiontida | Pelomyxidae | Pelomyxa | Pelomyxa schiedti | |||
| 32867276 | 32867276 | PRJNA839281_S_NODE_9400_length_259_cov_1.214286_g9131_i0 | PRJNA839281 | 9400 | 259 | 1.214286 | 3.14500074 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 58.5 | 1.29e-7 | NR | PRP88610.1 | 1890364 | g9131 | i0 | 39.4 | 0.764478764478765 | 66 | 40 | 76.4 | 0 | 5 | 202 | 897 | 962 | PRP88610.1 echinoderm microtubule-associated protein-like 6 [Planoprotostelium fungivorum] | diamond | 198 | 58.5 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum |
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);;