contig_metadata
13 rows where bioproject = "PRJNA1068830" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7835269 | 7835269 | PRJNA1068830_P_NODE_42107_length_342_cov_0.843866_g41404_i0 | PRJNA1068830 | 42107 | 342 | 0.843866 | 2.88602172 | Paramoeba perurans | 437603 | Discosea | other_Eukaryota | 449 | 9.8100000000000015e-122 | NTclustered | gi|156617355|gb|EU089662.1| | 437603 | g41404 | i0 | 90.351 | 98.3099415204678 | 342 | 33 | 100 | 0 | 1 | 342 | 555 | 214 | Neoparamoeba perurans actin mRNA, partial cds | blastn | 33622 | 449 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Dactylopodida | Paramoebidae | Paramoeba | Paramoeba perurans | ||
| 18034643 | 18034643 | PRJNA1068830_P_NODE_49575_length_311_cov_1.966387_g48872_i0 | PRJNA1068830 | 49575 | 311 | 1.966387 | 6.11546357 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 239 | 2.08e-58 | NTclustered | gi|470442906|ref|XM_004339540.1| | 1257118 | g48872 | i0 | 85.043 | 24.8842443729904 | 234 | 35 | 75 | 0 | 12 | 245 | 274 | 41 | Acanthamoeba castellanii str. Neff 60S ribosomal protein, putative (ACA1_063390), partial mRNA | blastn | 7739 | 239 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 22691274 | 22691274 | PRJNA1068830_P_NODE_83558_length_245_cov_0.906977_g82855_i0 | PRJNA1068830 | 83558 | 245 | 0.906977 | 2.22209365 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 171 | 5.85e-38 | NTclustered | gi|470510585|ref|XM_004351497.1| | 1257118 | g82855 | i0 | 79.518 | 91.5020408163265 | 249 | 43 | 100 | 8 | 1 | 245 | 831 | 587 | Acanthamoeba castellanii str. Neff transport protein Sec61 alpha subunit, putative (ACA1_149400), partial mRNA | blastn | 22418 | 171 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 26909194 | 26909194 | PRJNA1068830_P_NODE_79602_length_248_cov_0.891429_g78899_i0 | PRJNA1068830 | 79602 | 248 | 0.891429 | 2.21074392 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 95.9 | 1.27e-22 | NR | XP_004358614.1 | 261658 | g78899 | i0 | 87.3 | 1.99596774193548 | 55 | 7 | 66.5 | 0 | 167 | 3 | 16 | 70 | XP_004358614.1 vacuolar ATPase proteolipid subunit [Cavenderia fasciculata] | diamond | 495 | 95.9 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 28172683 | 28172683 | PRJNA1068830_P_NODE_82106_length_246_cov_0.901734_g81403_i0 | PRJNA1068830 | 82106 | 246 | 0.901734 | 2.21826564 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 80.1 | 2.65e-15 | NR | XP_003292221.1 | 5786 | g81403 | i0 | 58.5 | 0.792682926829268 | 65 | 27 | 79.3 | 0 | 6 | 200 | 606 | 670 | XP_003292221.1 uncharacterized protein DICPUDRAFT_57799 [Dictyostelium purpureum] | diamond | 195 | 80.1 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 28362113 | 28362113 | PRJNA1068830_P_NODE_63486_length_272_cov_2.090452_g62783_i0 | PRJNA1068830 | 63486 | 272 | 2.090452 | 5.68602944 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 172 | 1.26e-49 | NR | BAN33737.1 | 931554 | g62783 | i0 | 88.9 | 0.992647058823529 | 90 | 10 | 99.3 | 0 | 2 | 271 | 363 | 452 | BAN33737.1 elongation factor-like protein [Copromyxa protea] | diamond | 270 | 172 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 28551829 | 28551829 | PRJNA1068830_P_NODE_88107_length_242_cov_0.923077_g87404_i0 | PRJNA1068830 | 88107 | 242 | 0.923077 | 2.23384634 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 72.4 | 1.29e-12 | NR | XP_004341397.1 | 1257118 | g87404 | i0 | 59.7 | 0.768595041322314 | 62 | 19 | 76.9 | 1 | 241 | 56 | 456 | 511 | XP_004341397.1 premRNA processing factor 3 (PRP3) protein [Acanthamoeba castellanii str. Neff] | diamond | 186 | 72.4 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 29593184 | 29593184 | PRJNA1068830_P_NODE_24410_length_474_cov_2.084788_g23709_i0 | PRJNA1068830 | 24410 | 474 | 2.084788 | 9.88189512 | Dictyostelium discoideum AX4 | 352472 | Evosea | other_Eukaryota | 46.6 | 0.0175 | NR | XP_641817.1 | 352472 | g23709 | i0 | 25.6 | 1.28481012658228 | 125 | 89 | 77.2 | 2 | 51 | 416 | 1038 | 1161 | XP_641817.1 hypothetical protein DDB_G0279365 [Dictyostelium discoideum AX4] | diamond | 609 | 46.6 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 30501248 | 30501248 | PRJNA1068830_P_NODE_60793_length_279_cov_1.378641_g60090_i0 | PRJNA1068830 | 60793 | 279 | 1.378641 | 3.84640839 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 87.8 | 7.13e-18 | NR | XP_020435829.1 | 670386 | g60090 | i0 | 49.5 | 1.98924731182796 | 95 | 36 | 98.9 | 4 | 4 | 279 | 206 | 291 | XP_020435829.1 cysteine proteinase 1 [Heterostelium album PN500] | diamond | 555 | 87.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 30667626 | 30667626 | PRJNA1068830_P_NODE_22553_length_497_cov_2.221698_g21852_i0 | PRJNA1068830 | 22553 | 497 | 2.221698 | 11.04183906 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 71.2 | 5.31e-11 | NR | PRP85627.1 | 1890364 | g21852 | i0 | 36.9 | 0.670020120724346 | 111 | 38 | 67 | 1 | 354 | 22 | 71 | 149 | PRP85627.1 hypothetical protein PROFUN_06416 [Planoprotostelium fungivorum] | diamond | 333 | 71.2 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 31742331 | 31742331 | PRJNA1068830_P_NODE_36977_length_368_cov_2.379661_g36274_i0 | PRJNA1068830 | 36977 | 368 | 2.379661 | 8.75715248 | Pelomyxa schiedti | 1580589 | Evosea | other_Eukaryota | 132 | 1.3e-33 | NR | KAH3766637.1 | 1580589 | g36274 | i0 | 52.6 | 0.945652173913043 | 116 | 54 | 94.6 | 1 | 368 | 21 | 306 | 420 | KAH3766637.1 acidstable alpha-amylase [Pelomyxa schiedti] | diamond | 348 | 132 | 1 | Eukaryota | Amoebozoa | Evosea | Pelobiontida | Pelomyxidae | Pelomyxa | Pelomyxa schiedti | |||
| 32240491 | 32240491 | PRJNA1068830_P_NODE_72538_length_253_cov_0.866667_g71835_i0 | PRJNA1068830 | 72538 | 253 | 0.866667 | 2.19266751 | root | 1 | Root_unresolved | Root_unresolved | 74.3 | 1.31e-14 | NR | XP_652635.1 | 294381 | g71835 | i0 | 42.9 | 4.13833992094862 | 70 | 40 | 83 | 0 | 216 | 7 | 1 | 70 | XP_652635.1 thioredoxin, putative [Entamoeba histolytica HM-1:IMSS] | diamond | 1047 | 74.3 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba histolytica | |||
| 32690874 | 32690874 | PRJNA1068830_P_NODE_61620_length_277_cov_1.308824_g60917_i0 | PRJNA1068830 | 61620 | 277 | 1.308824 | 3.62544248 | Acytostelium subglobosum LB1 | 1410327 | Evosea | other_Eukaryota | 43.1 | 0.0384 | NR | XP_012748989.1 | 1410327 | g60917 | i0 | 34.8 | 0.498194945848375 | 46 | 30 | 49.8 | 0 | 32 | 169 | 262 | 307 | XP_012748989.1 hypothetical protein SAMD00019534_112060, partial [Acytostelium subglobosum LB1] | diamond | 138 | 43.1 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum |
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);;