contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJDB3785" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11486815 | 11486815 | PRJDB3785_S_NODE_28050_length_154_cov_2.390476_g27897_i0 | PRJDB3785 | 28050 | 154 | 2.390476 | 3.68133304 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 80.1 | 5.22e-17 | NR | XP_004352065.1 | 1257118 | g27897 | i0 | 79.6 | 8.2987012987013 | 49 | 10 | 95.5 | 0 | 154 | 8 | 114 | 162 | XP_004352065.1 ribosomal protein S7e, putative [Acanthamoeba castellanii str. Neff] | diamond | 1278 | 80.1 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 16585738 | 16585738 | PRJDB3785_S_NODE_3494_length_411_cov_2.544199_g3341_i0 | PRJDB3785 | 3494 | 411 | 2.544199 | 10.45665789 | Acanthamoeba | 5754 | Discosea | other_Eukaryota | 115 | 3.54e-30 | NR | 7SOG_A | 5755 | g3341 | i0 | 50 | 2.81021897810219 | 128 | 61 | 92.7 | 3 | 31 | 411 | 3 | 128 | 7SOG_A Chain A, Actophorin [Acanthamoeba castellanii] | diamond | 1155 | 115 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 19134325 | 19134325 | PRJDB3785_S_NODE_19596_length_179_cov_1.569231_g19443_i0 | PRJDB3785 | 19596 | 179 | 1.569231 | 2.80892349 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 115 | 2.06e-29 | NR | XP_004344643.1 | 1257118 | g19443 | i0 | 89.8 | 0.988826815642458 | 59 | 6 | 98.9 | 0 | 1 | 177 | 85 | 143 | XP_004344643.1 MC family transporter: phosphate, putative [Acanthamoeba castellanii str. Neff] | diamond | 177 | 115 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 26779305 | 26779305 | PRJDB3785_S_NODE_20261_length_177_cov_0.867188_g20108_i0 | PRJDB3785 | 20261 | 177 | 0.867188 | 1.53492276 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 50.1 | 5.39e-6 | NR | XP_004351526.1 | 1257118 | g20108 | i0 | 64.1 | 0.661016949152542 | 39 | 13 | 66.1 | 1 | 53 | 169 | 26 | 63 | XP_004351526.1 selT/selW/selH selenoprotein domain containing protein [Acanthamoeba castellanii str. Neff] | diamond | 117 | 50.1 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 27221864 | 27221864 | PRJDB3785_S_NODE_1923_length_572_cov_10.321224_g1784_i0 | PRJDB3785 | 1923 | 572 | 10.321224 | 59.03740128 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 47.8 | 0.00135 | NR | XP_004351526.1 | 1257118 | g1784 | i0 | 46.9 | 0.256993006993007 | 49 | 26 | 25.7 | 0 | 512 | 366 | 26 | 74 | XP_004351526.1 selT/selW/selH selenoprotein domain containing protein [Acanthamoeba castellanii str. Neff] | diamond | 147 | 47.8 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 27285307 | 27285307 | PRJDB3785_S_NODE_22443_length_169_cov_1.266667_g22290_i0 | PRJDB3785 | 22443 | 169 | 1.266667 | 2.14066723 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 65.9 | 9.16e-11 | NR | XP_004333651.1 | 1257118 | g22290 | i0 | 54.7 | 1.89940828402367 | 53 | 24 | 94.1 | 0 | 167 | 9 | 199 | 251 | XP_004333651.1 coronin3, putative [Acanthamoeba castellanii str. Neff] | diamond | 321 | 65.9 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 27696217 | 27696217 | PRJDB3785_S_NODE_9444_length_246_cov_1.279188_g9291_i0 | PRJDB3785 | 9444 | 246 | 1.279188 | 3.14680248 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 99.8 | 7.72e-25 | NR | 1PRQ_A | 5755 | g9291 | i0 | 73.3 | 1.45121951219512 | 60 | 16 | 73.2 | 0 | 1 | 180 | 66 | 125 | 1PRQ_A Chain A, PROFILIN IA [Acanthamoeba castellanii] | diamond | 357 | 99.8 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 27790708 | 27790708 | PRJDB3785_S_NODE_17244_length_189_cov_1.464286_g17091_i0 | PRJDB3785 | 17244 | 189 | 1.464286 | 2.76750054 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 66.6 | 6.42e-11 | NR | XP_004341586.1 | 1257118 | g17091 | i0 | 50.8 | 0.968253968253968 | 61 | 29 | 96.8 | 1 | 185 | 3 | 298 | 357 | XP_004341586.1 elongation factor 1-gamma family protein [Acanthamoeba castellanii str. Neff] | diamond | 183 | 66.6 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 28074683 | 28074683 | PRJDB3785_S_NODE_21345_length_173_cov_1.153226_g21192_i0 | PRJDB3785 | 21345 | 173 | 1.153226 | 1.99508098 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 80.1 | 9.01e-16 | NR | XP_004333651.1 | 1257118 | g21192 | i0 | 64.8 | 1.92485549132948 | 54 | 19 | 93.6 | 0 | 10 | 171 | 181 | 234 | XP_004333651.1 coronin3, putative [Acanthamoeba castellanii str. Neff] | diamond | 333 | 80.1 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 28674757 | 28674757 | PRJDB3785_S_NODE_24487_length_165_cov_0.879310_g24334_i0 | PRJDB3785 | 24487 | 165 | 0.87931 | 1.4508615 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 50.8 | 1.83e-5 | NR | XP_004335438.1 | 1257118 | g24334 | i0 | 36.2 | 1.05454545454545 | 58 | 30 | 92.7 | 1 | 13 | 165 | 248 | 305 | XP_004335438.1 oxysterol binding protein [Acanthamoeba castellanii str. Neff] | diamond | 174 | 50.8 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 29369341 | 29369341 | PRJDB3785_S_NODE_27129_length_161_cov_0.910714_g26976_i0 | PRJDB3785 | 27129 | 161 | 0.910714 | 1.46624954 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 92 | 1.47e-21 | NR | XP_004344656.1 | 1257118 | g26976 | i0 | 83 | 4.93788819875776 | 53 | 9 | 98.8 | 0 | 160 | 2 | 69 | 121 | XP_004344656.1 Rasrelated protein Rap-1, putative [Acanthamoeba castellanii str. Neff] | diamond | 795 | 92 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 30974555 | 30974555 | PRJDB3785_S_NODE_11714_length_223_cov_1.172414_g11561_i0 | PRJDB3785 | 11714 | 223 | 1.172414 | 2.61448322 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 113 | 5.46e-30 | NR | XP_004341583.1 | 1257118 | g11561 | i0 | 71.6 | 11.9461883408072 | 74 | 21 | 99.6 | 0 | 2 | 223 | 21 | 94 | XP_004341583.1 ribosomal protein S9, putative [Acanthamoeba castellanii str. Neff] | diamond | 2664 | 114 | 0.991228070175439 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 31707505 | 31707505 | PRJDB3785_S_NODE_18317_length_184_cov_1.888889_g18164_i0 | PRJDB3785 | 18317 | 184 | 1.888889 | 3.47555576 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 53.5 | 2.59e-6 | NR | XP_004356453.1 | 1257118 | g18164 | i0 | 47.2 | 0.864130434782609 | 53 | 28 | 86.4 | 0 | 175 | 17 | 288 | 340 | XP_004356453.1 uncharacterized protein ACA1_171260 [Acanthamoeba castellanii str. Neff] | diamond | 159 | 53.5 | 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);;