contig_metadata
6 rows where bioproject = "PRJNA909412", tax_clade = "Amoebozoa" and tax_phylum = "Discosea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26992554 | 26992554 | PRJNA909412_P_NODE_13602_length_160_cov_1.107438_g13461_i0 | PRJNA909412 | 13602 | 160 | 1.107438 | 1.7719008 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 69.3 | 2.51e-12 | NR | XP_004333661.1 | 1257118 | g13461 | i0 | 56.6 | 2.98125 | 53 | 23 | 99.4 | 0 | 2 | 160 | 41 | 93 | XP_004333661.1 actin bundling protein [Acanthamoeba castellanii str. Neff] | diamond | 477 | 69.3 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 27663879 | 27663879 | PRJNA909412_P_NODE_17544_length_150_cov_2.792793_g17403_i0 | PRJNA909412 | 17544 | 150 | 2.792793 | 4.1891895 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 76.6 | 1.14e-14 | NR | XP_004335113.1 | 1257118 | g17403 | i0 | 77.3 | 6.46 | 44 | 10 | 88 | 0 | 14 | 145 | 457 | 500 | XP_004335113.1 methionine-tRNA ligase [Acanthamoeba castellanii str. Neff] | diamond | 969 | 77 | 0.994805194805195 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 28698442 | 28698442 | PRJNA909412_P_NODE_7247_length_196_cov_2.394904_g7106_i0 | PRJNA909412 | 7247 | 196 | 2.394904 | 4.69401184 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 99.8 | 1.49e-22 | NR | XP_004338851.1 | 1257118 | g7106 | i0 | 68.8 | 1.91326530612245 | 64 | 20 | 98 | 0 | 195 | 4 | 464 | 527 | XP_004338851.1 glucose6-phosphate dehydrogenase, C-terminal domain containing protein [Acanthamoeba castellanii str. Neff] | diamond | 375 | 99.8 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 30782718 | 30782718 | PRJNA909412_P_NODE_4174_length_257_cov_2.752294_g4033_i0 | PRJNA909412 | 4174 | 257 | 2.752294 | 7.07339558 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 67 | 9.48e-11 | NR | XP_004356622.1 | 1257118 | g4033 | i0 | 62.5 | 0.560311284046693 | 48 | 18 | 56 | 0 | 144 | 1 | 57 | 104 | XP_004356622.1 mitochondrial phosphate transporter, putative [Acanthamoeba castellanii str. Neff] | diamond | 144 | 67 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 30972419 | 30972419 | PRJNA909412_P_NODE_17234_length_151_cov_1.482143_g17093_i0 | PRJNA909412 | 17234 | 151 | 1.482143 | 2.23803593 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 87 | 2.55e-18 | NR | XP_004338851.1 | 1257118 | g17093 | i0 | 77.6 | 0.973509933774834 | 49 | 11 | 97.4 | 0 | 1 | 147 | 324 | 372 | XP_004338851.1 glucose6-phosphate dehydrogenase, C-terminal domain containing protein [Acanthamoeba castellanii str. Neff] | diamond | 147 | 87 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 32174329 | 32174329 | PRJNA909412_P_NODE_1718_length_417_cov_3.433862_g1578_i0 | PRJNA909412 | 1718 | 417 | 3.433862 | 14.31920454 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 199 | 3.3899999999999995e-61 | NR | XP_004367664.1 | 1257118 | g1578 | i0 | 65 | 0.985611510791367 | 137 | 48 | 98.6 | 0 | 2 | 412 | 121 | 257 | XP_004367664.1 phytanoylCoA dioxygenase [Acanthamoeba castellanii str. Neff] | diamond | 411 | 199 | 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);;