contig_metadata
10 rows where bioproject = "PRJNA290839", tax_phylum = "Discosea" and tax_superkingdom = "Eukaryota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8026201 | 8026201 | PRJNA290839_P_NODE_427_length_395_cov_1.093168_g406_i0 | PRJNA290839 | 427 | 395 | 1.093168 | 4.3180136 | root | 1 | Root_unresolved | Root_unresolved | 213 | 2.77e-64 | NR | XP_004344078.1 | 1257118 | g406 | i0 | 78.6 | 9.80506329113924 | 131 | 28 | 99.5 | 0 | 1 | 393 | 190 | 320 | XP_004344078.1 Sadenosyl-L-homocysteine hydrolase, putative [Acanthamoeba castellanii str. Neff] | diamond | 3873 | 214 | 0.995327102803738 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 16950295 | 16950295 | PRJNA290839_P_NODE_254_length_534_cov_1.648590_g233_i0 | PRJNA290839 | 254 | 534 | 1.64859 | 8.8034706 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 269 | 4.43e-82 | NR | XP_004337289.1 | 1257118 | g233 | i0 | 81 | 21.0337078651685 | 168 | 32 | 94.4 | 0 | 505 | 2 | 4 | 171 | XP_004337289.1 eukaryotic translation elongation factor 2, putative [Acanthamoeba castellanii str. Neff] | diamond | 11232 | 270 | 0.996296296296296 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 27028564 | 27028564 | PRJNA290839_P_NODE_242_length_548_cov_2.120000_g221_i0 | PRJNA290839 | 242 | 548 | 2.12 | 11.6176 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 282 | 2.37e-93 | NR | XP_004341437.1 | 1257118 | g221 | i0 | 73.6 | 11.956204379562 | 182 | 48 | 99.6 | 0 | 548 | 3 | 3 | 184 | XP_004341437.1 ribosomal proteins l2, RNA binding domain containing protein [Acanthamoeba castellanii str. Neff] | diamond | 6552 | 282 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 27327109 | 27327109 | PRJNA290839_P_NODE_1163_length_250_cov_0.881356_g1142_i0 | PRJNA290839 | 1163 | 250 | 0.881356 | 2.20339 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 54.3 | 1.75e-6 | NR | XP_004339568.1 | 1257118 | g1142 | i0 | 38.2 | 0.816 | 68 | 36 | 81.6 | 1 | 11 | 214 | 131 | 192 | XP_004339568.1 START domain containing protein [Acanthamoeba castellanii str. Neff] | diamond | 204 | 54.3 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 27358835 | 27358835 | PRJNA290839_P_NODE_1403_length_246_cov_0.895954_g1382_i0 | PRJNA290839 | 1403 | 246 | 0.895954 | 2.20404684 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 110 | 2.33e-26 | NR | XP_004333651.1 | 1257118 | g1382 | i0 | 63.8 | 0.975609756097561 | 80 | 29 | 97.6 | 0 | 6 | 245 | 44 | 123 | XP_004333651.1 coronin3, putative [Acanthamoeba castellanii str. Neff] | diamond | 240 | 110 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 28179365 | 28179365 | PRJNA290839_P_NODE_1226_length_249_cov_0.880682_g1205_i0 | PRJNA290839 | 1226 | 249 | 0.880682 | 2.19289818 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 45.1 | 0.00626 | NR | XP_004339445.1 | 1257118 | g1205 | i0 | 46.8 | 0.566265060240964 | 47 | 25 | 56.6 | 0 | 249 | 109 | 8 | 54 | XP_004339445.1 uncharacterized protein ACA1_061730 [Acanthamoeba castellanii str. Neff] | diamond | 141 | 45.1 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 29284508 | 29284508 | PRJNA290839_P_NODE_409_length_403_cov_2.333333_g388_i0 | PRJNA290839 | 409 | 403 | 2.333333 | 9.40333199 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 161 | 1.4299999999999999e-47 | NR | XP_004334896.1 | 1257118 | g388 | i0 | 61.8 | 0.975186104218362 | 131 | 48 | 96.8 | 2 | 13 | 402 | 1 | 130 | XP_004334896.1 ribosomal protein L6, putative [Acanthamoeba castellanii str. Neff] | diamond | 393 | 161 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 29631721 | 29631721 | PRJNA290839_P_NODE_490_length_368_cov_1.054237_g469_i0 | PRJNA290839 | 490 | 368 | 1.054237 | 3.87959216 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 94 | 6.21e-20 | NR | AFD36233.1 | 5755 | g469 | i0 | 60.3 | 0.635869565217391 | 78 | 31 | 63.6 | 0 | 234 | 1 | 61 | 138 | AFD36233.1 protein kinase C4, partial [Acanthamoeba castellanii] | diamond | 234 | 94 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 30295781 | 30295781 | PRJNA290839_P_NODE_812_length_285_cov_1.160377_g791_i0 | PRJNA290839 | 812 | 285 | 1.160377 | 3.30707445 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 124 | 6.149999999999999e-31 | NR | XP_004348339.1 | 1257118 | g791 | i0 | 69.6 | 1.78947368421053 | 92 | 27 | 95.8 | 1 | 12 | 284 | 1 | 92 | XP_004348339.1 H(+)-transporting atpase family protein [Acanthamoeba castellanii str. Neff] | diamond | 510 | 124 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 31749195 | 31749195 | PRJNA290839_P_NODE_697_length_307_cov_0.991453_g676_i0 | PRJNA290839 | 697 | 307 | 0.991453 | 3.04376071 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 134 | 3.94e-34 | NR | XP_004335836.1 | 1257118 | g676 | i0 | 55.7 | 1.03583061889251 | 106 | 41 | 99.7 | 2 | 307 | 2 | 46 | 149 | XP_004335836.1 uncharacterized protein ACA1_076760 [Acanthamoeba castellanii str. Neff] | diamond | 318 | 134 | 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);;