contig_metadata
10 rows where bioproject = "PRJNA758398", tax_clade = "Amoebozoa" and tax_phylum = "Tubulinea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2015673 | 2015673 | PRJNA758398_S_NODE_22182_length_218_cov_1.319527_g22041_i0 | PRJNA758398 | 22182 | 218 | 1.319527 | 2.87656886 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 130 | 1.5399999999999999e-34 | NR | AAP88974.1 | 5775 | g22041 | i0 | 86.1 | 0.990825688073395 | 72 | 10 | 99.1 | 0 | 218 | 3 | 196 | 267 | AAP88974.1 S-adenosylmethionine synthetase 2 [Amoeba proteus] | diamond | 216 | 130 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 3291042 | 3291042 | PRJNA758398_S_NODE_33263_length_185_cov_2.132353_g33122_i0 | PRJNA758398 | 33263 | 185 | 2.132353 | 3.94485305 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 219 | 1.4699999999999996e-52 | NTclustered | gi|508737347|dbj|AB766053.1| | 931554 | g33122 | i0 | 92.715 | 0.816216216216216 | 151 | 11 | 82 | 0 | 35 | 185 | 523 | 373 | Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324 | blastn | 151 | 219 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 3291079 | 3291079 | PRJNA758398_S_NODE_36603_length_178_cov_1.186047_g36462_i0 | PRJNA758398 | 36603 | 178 | 1.186047 | 2.11116366 | Spumochlamys perforata | 675831 | Tubulinea | other_Eukaryota | 243 | 8.33e-60 | NTclustered | gi|259595680|gb|FJ705344.1| | 675831 | g36462 | i0 | 92.353 | 99.438202247191 | 170 | 13 | 96 | 0 | 9 | 178 | 653 | 484 | Spumochlamys perforata actin gene, partial cds | blastn | 17700 | 243 | 1 | Eukaryota | Amoebozoa | Tubulinea | Corycida | Microchlamyiidae | Spumochlamys | Spumochlamys perforata | |||
| 9668276 | 9668276 | PRJNA758398_S_NODE_31888_length_189_cov_1.092857_g31747_i0 | PRJNA758398 | 31888 | 189 | 1.092857 | 2.06549973 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 178 | 2.5599999999999993e-40 | NTclustered | gi|345452566|gb|JF694301.1| | 1078836 | g31747 | i0 | 83.957 | 50.6507936507937 | 187 | 28 | 98 | 2 | 3 | 188 | 505 | 320 | Cryptodifflugia operculata clone 5 actin gene, partial cds | blastn | 9573 | 178 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 17317855 | 17317855 | PRJNA758398_S_NODE_21614_length_220_cov_1.783626_g21473_i0 | PRJNA758398 | 21614 | 220 | 1.783626 | 3.9239772 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 303 | 4.87e-78 | NTclustered | gi|508737347|dbj|AB766053.1| | 931554 | g21473 | i0 | 91.818 | 5.73636363636364 | 220 | 14 | 99 | 3 | 3 | 220 | 1011 | 794 | Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324 | blastn | 1262 | 303 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 17318130 | 17318130 | PRJNA758398_S_NODE_42794_length_167_cov_0.864407_g42653_i0 | PRJNA758398 | 42794 | 167 | 0.864407 | 1.44355969 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 259 | 7.69e-65 | NTclustered | gi|508737347|dbj|AB766053.1| | 931554 | g42653 | i0 | 94.611 | 28.1916167664671 | 167 | 9 | 100 | 0 | 1 | 167 | 310 | 144 | Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324 | blastn | 4708 | 259 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 26989524 | 26989524 | PRJNA758398_S_NODE_21762_length_220_cov_0.894737_g21621_i0 | PRJNA758398 | 21762 | 220 | 0.894737 | 1.9684214 | Lesquereusia modesta | 1260108 | Tubulinea | other_Eukaryota | 114 | 3.4400000000000003e-29 | NR | AFX73094.1 | 1260108 | g21621 | i0 | 71.2 | 0.995454545454545 | 73 | 21 | 99.5 | 0 | 220 | 2 | 90 | 162 | AFX73094.1 elongation factor 2 alpha, partial [Lesquereusia modesta] | diamond | 219 | 114 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Lesquereusiidae | Lesquereusia | Lesquereusia modesta | ||
| 28852903 | 28852903 | PRJNA758398_S_NODE_34448_length_183_cov_1.082090_g34307_i0 | PRJNA758398 | 34448 | 183 | 1.08209 | 1.9802247 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 119 | 4.3699999999999995e-30 | NR | BAN33737.1 | 931554 | g34307 | i0 | 95 | 0.983606557377049 | 60 | 3 | 98.4 | 0 | 182 | 3 | 363 | 422 | BAN33737.1 elongation factor-like protein [Copromyxa protea] | diamond | 180 | 119 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 29011374 | 29011374 | PRJNA758398_S_NODE_50748_length_163_cov_0.894737_g50607_i0 | PRJNA758398 | 50748 | 163 | 0.894737 | 1.45842131 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 76.6 | 1.23e-14 | NR | AAD37351.1 | 5775 | g50607 | i0 | 72.5 | 0.938650306748466 | 51 | 14 | 93.9 | 0 | 9 | 161 | 123 | 173 | AAD37351.1 pepstatin-insensitive carboxyl proteinase 1, partial [Amoeba proteus] | diamond | 153 | 76.6 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 31759786 | 31759786 | PRJNA758398_S_NODE_42337_length_167_cov_0.864407_g42196_i0 | PRJNA758398 | 42337 | 167 | 0.864407 | 1.44355969 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 98.2 | 2.0600000000000001e-22 | NR | AAD37351.1 | 5775 | g42196 | i0 | 80 | 0.988023952095808 | 55 | 11 | 98.8 | 0 | 165 | 1 | 91 | 145 | AAD37351.1 pepstatin-insensitive carboxyl proteinase 1, partial [Amoeba proteus] | diamond | 165 | 98.2 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus |
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);;