contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJEB7366" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 135263 | 135263 | PRJEB7366_P_NODE_21001_length_165_cov_1.953846_g20567_i0 | PRJEB7366 | 21001 | 165 | 1.953846 | 3.2238459 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 124 | 2.88e-24 | NTclustered | gi|470245387|ref|XM_004356373.1| | 261658 | g20567 | i0 | 83.333 | 2.66666666666667 | 138 | 19 | 82 | 4 | 30 | 165 | 1775 | 1640 | Cavenderia fasciculata isoleucyl-tRNA synthetase (ileS), partial mRNA | blastn | 440 | 124 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 2685315 | 2685315 | PRJEB7366_P_NODE_16823_length_188_cov_3.039216_g16389_i0 | PRJEB7366 | 16823 | 188 | 3.039216 | 5.71372608 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 54.7 | 0.004 | NTclustered | gi|66816706|ref|XM_637271.1| | 352472 | g16389 | i0 | 94.444 | 0.356382978723404 | 36 | 1 | 19 | 1 | 15 | 50 | 329 | 295 | Dictyostelium discoideum AX4 hypothetical protein (DDB_G0278433) mRNA, complete cds | blastn | 67 | 54.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 3961395 | 3961395 | PRJEB7366_P_NODE_8404_length_293_cov_2.472868_g7970_i0 | PRJEB7366 | 8404 | 293 | 2.472868 | 7.24550324 | Mayorella sp. JJP-2003 | 242541 | Discosea | other_Eukaryota | 351 | 2.39e-92 | NTclustered | gi|33946346|gb|AY294152.1| | 242541 | g7970 | i0 | 93.966 | 89.778156996587 | 232 | 14 | 79 | 0 | 62 | 293 | 1134 | 903 | Mayorella sp. JJP-2003 actin mRNA, partial cds | blastn | 26305 | 351 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Mayorella | Mayorella sp. JJP-2003 | ||||
| 5237786 | 5237786 | PRJEB7366_P_NODE_14165_length_210_cov_1.257143_g13731_i0 | PRJEB7366 | 14165 | 210 | 1.257143 | 2.6400003 | Dianema sp. (in: plasmodial slime molds) | 2046418 | Evosea | other_Eukaryota | 145 | 2.96e-30 | NTclustered | gi|1883421900|gb|MT162160.1| | 2046418 | g13731 | i0 | 81.461 | 74.4047619047619 | 178 | 32 | 84 | 1 | 30 | 206 | 1028 | 851 | Dianema sp. (in: Myxogastria) voucher KRAM:M1506 elongation factor 1-alpha (EF1A) gene, partial cds | blastn | 15625 | 145 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Trichiida | Dianemataceae | Dianema | Dianema sp. (in: plasmodial slime molds) | ||
| 7787638 | 7787638 | PRJEB7366_P_NODE_2507_length_612_cov_1.573657_g2121_i0 | PRJEB7366 | 2507 | 612 | 1.573657 | 9.63078084 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 732 | 0 | NTclustered | gi|66821326|ref|XM_639065.1| | 352472 | g2121 | i0 | 88.254 | 100.014705882353 | 613 | 70 | 100 | 2 | 1 | 612 | 232 | 843 | Dictyostelium discoideum AX4 hypothetical protein (act13) mRNA, complete cds | blastn | 61209 | 732 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 10338336 | 10338336 | PRJEB7366_P_NODE_749_length_1111_cov_11.751859_g549_i0 | PRJEB7366 | 749 | 1111 | 11.751859 | 130.56315349 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 1086 | 0 | NTclustered | gi|33946362|gb|AY294160.1| | 5775 | g549 | i0 | 84.338 | 96.1458145814581 | 1111 | 172 | 99 | 2 | 1 | 1110 | 3 | 1112 | Amoeba proteus actin mRNA, complete cds | blastn | 106818 | 1086 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 14163647 | 14163647 | PRJEB7366_P_NODE_1592_length_783_cov_4.573529_g1273_i0 | PRJEB7366 | 1592 | 783 | 4.573529 | 35.81073207 | Chaos carolinense | 160823 | Tubulinea | other_Eukaryota | 640 | 1.32e-178 | NTclustered | gi|33946356|gb|AY294157.1| | 160823 | g1273 | i0 | 81.481 | 94.8569604086845 | 783 | 142 | 99 | 3 | 1 | 781 | 55 | 836 | Chaos carolinense actin mRNA, partial cds | blastn | 74273 | 640 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Chaos | Chaos carolinense | ||
| 14163688 | 14163688 | PRJEB7366_P_NODE_7452_length_317_cov_1.294326_g7018_i0 | PRJEB7366 | 7452 | 317 | 1.294326 | 4.10301342 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 315 | 3.4299999999999993e-81 | NTclustered | gi|508737347|dbj|AB766053.1| | 931554 | g7018 | i0 | 85.859 | 0.936908517350158 | 297 | 40 | 93 | 2 | 12 | 307 | 1090 | 1385 | Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324 | blastn | 297 | 315 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 15437777 | 15437777 | PRJEB7366_P_NODE_7853_length_307_cov_1.617647_g7419_i0 | PRJEB7366 | 7853 | 307 | 1.617647 | 4.96617629 | Lamproderma pulveratum | 1115717 | Evosea | other_Eukaryota | 255 | 2.03e-63 | NTclustered | gi|2301599501|gb|MZ044070.1| | 1115717 | g7419 | i0 | 82.06 | 81.5374592833876 | 301 | 52 | 98 | 2 | 1 | 300 | 325 | 26 | Lamproderma pulveratum voucher MYX8389 translation elongation factor 1-alpha (EF1a) gene, partial cds | blastn | 25032 | 255 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Stemonitida | Stemonitidae | Lamproderma | Lamproderma pulveratum | ||
| 16711920 | 16711920 | PRJEB7366_P_NODE_17094_length_187_cov_1.046053_g16660_i0 | PRJEB7366 | 17094 | 187 | 1.046053 | 1.95611911 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 52.8 | 0.016 | NTclustered | gi|1160568546|ref|XM_020581517.1| | 670386 | g16660 | i0 | 100 | 0.149732620320856 | 28 | 0 | 15 | 0 | 21 | 48 | 159 | 132 | Polysphondylium pallidum PN500 hypothetical protein partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 19260820 | 19260820 | PRJEB7366_P_NODE_11816_length_236_cov_1.194030_g11382_i0 | PRJEB7366 | 11816 | 236 | 1.19403 | 2.8179108 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 54.7 | 0.006 | NTclustered | gi|66809100|ref|XM_633181.1| | 352472 | g11382 | i0 | 100 | 0.610169491525424 | 29 | 0 | 12 | 0 | 205 | 233 | 2036 | 2064 | Dictyostelium discoideum AX4 guanine nucleotide binding protein 1 (gnl1) mRNA, complete cds | blastn | 144 | 54.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 19260868 | 19260868 | PRJEB7366_P_NODE_7276_length_322_cov_1.393728_g6842_i0 | PRJEB7366 | 7276 | 322 | 1.393728 | 4.48780416 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|470523679|ref|XM_004355001.1| | 1257118 | g6842 | i0 | 94.444 | 0.211180124223602 | 36 | 2 | 11 | 0 | 206 | 241 | 4626 | 4591 | Acanthamoeba castellanii str. Neff Tyrosine kinase, putative (ACA1_006130), partial mRNA | blastn | 68 | 56.5 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 19260875 | 19260875 | PRJEB7366_P_NODE_8696_length_287_cov_1.587302_g8262_i0 | PRJEB7366 | 8696 | 287 | 1.587302 | 4.55555674 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 58.4 | 5.7e-4 | NTclustered | gi|1160571886|ref|XM_020575437.1| | 670386 | g8262 | i0 | 94.595 | 0.128919860627178 | 37 | 2 | 13 | 0 | 101 | 137 | 362 | 326 | Polysphondylium pallidum PN500 DNA topoisomerase II (top2), partial mRNA | blastn | 37 | 58.4 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 24361083 | 24361083 | PRJEB7366_P_NODE_24060_length_153_cov_1.016949_g23626_i0 | PRJEB7366 | 24060 | 153 | 1.016949 | 1.55593197 | Filamoeba sinensis | 308476 | Evosea | other_Eukaryota | 95.3 | 2.05e-15 | NTclustered | gi|146448851|gb|EF513193.1| | 308476 | g23626 | i0 | 78.231 | 9.68627450980392 | 147 | 32 | 96 | 0 | 2 | 148 | 1196 | 1342 | Filamoeba sinensis elongation factor 1A (EF1A) gene, partial cds | blastn | 1482 | 95.3 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Filamoeba | Filamoeba sinensis | ||||
| 25221672 | 25221672 | PRJEB7366_P_NODE_14060_length_211_cov_1.102273_g13626_i0 | PRJEB7366 | 14060 | 211 | 1.102273 | 2.32579603 | Entamoeba | 5758 | Evosea | other_Eukaryota | 132 | 2.31e-26 | NTclustered | gi|57157180|dbj|AB092411.1| | 5759 | g13626 | i0 | 79.888 | 3.39336492890995 | 179 | 36 | 85 | 0 | 33 | 211 | 1370 | 1548 | Entamoeba histolytica gene for cytosolic-type hsp90, partial cds | blastn | 716 | 132 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba histolytica |
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);;