contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA393181" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26617274 | 26617274 | PRJNA393181_S_NODE_32681_length_194_cov_1.242038_g32575_i0 | PRJNA393181 | 32681 | 194 | 1.242038 | 2.40955372 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 54.7 | 1.01e-7 | NR | XP_004345808.1 | 1257118 | g32575 | i0 | 74.3 | 3.60309278350515 | 35 | 9 | 54.1 | 0 | 106 | 2 | 27 | 61 | XP_004345808.1 translocase of the inner mitochondrial membrane 14 isoform a, putative [Acanthamoeba castellanii str. Neff] | diamond | 699 | 54.7 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 26663504 | 26663504 | PRJNA393181_S_NODE_47561_length_150_cov_3.964602_g47455_i0 | PRJNA393181 | 47561 | 150 | 3.964602 | 5.946903 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 55.1 | 4.73e-7 | NR | XP_004367478.1 | 1257118 | g47455 | i0 | 100 | 0.52 | 26 | 0 | 52 | 0 | 150 | 73 | 195 | 220 | XP_004367478.1 heat shock protein 90 alpha, putative [Acanthamoeba castellanii str. Neff] | diamond | 78 | 55.1 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 27391540 | 27391540 | PRJNA393181_S_NODE_28943_length_210_cov_1.341040_g28837_i0 | PRJNA393181 | 28943 | 210 | 1.34104 | 2.816184 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 84 | 5.39e-17 | NR | XP_004334080.1 | 1257118 | g28837 | i0 | 60.3 | 0.9 | 63 | 22 | 90 | 2 | 21 | 209 | 55 | 114 | XP_004334080.1 Serine/threonine phosphatase [Acanthamoeba castellanii str. Neff] | diamond | 189 | 84 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 28433393 | 28433393 | PRJNA393181_S_NODE_46606_length_153_cov_0.974138_g46500_i0 | PRJNA393181 | 46606 | 153 | 0.974138 | 1.49043114 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 68.9 | 1.38e-12 | NR | XP_004339168.1 | 1257118 | g46500 | i0 | 80 | 0.882352941176471 | 45 | 7 | 88.2 | 1 | 136 | 2 | 1 | 43 | XP_004339168.1 Mimivirus encoded protein, putative [Acanthamoeba castellanii str. Neff] | diamond | 135 | 68.9 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 29649499 | 29649499 | PRJNA393181_S_NODE_47030_length_152_cov_1.017391_g46924_i0 | PRJNA393181 | 47030 | 152 | 1.017391 | 1.54643432 | root | 1 | Root_unresolved | Root_unresolved | 58.5 | 2.64e-8 | NR | XP_004356467.1 | 1257118 | g46924 | i0 | 60.4 | 1.97368421052632 | 48 | 19 | 94.7 | 0 | 149 | 6 | 40 | 87 | XP_004356467.1 FAD binding domain containing protein [Acanthamoeba castellanii str. Neff] | diamond | 300 | 58.5 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 29790816 | 29790816 | PRJNA393181_S_NODE_6911_length_451_cov_1.770531_g6805_i0 | PRJNA393181 | 6911 | 451 | 1.770531 | 7.98509481 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 204 | 3.8e-62 | NR | XP_004356467.1 | 1257118 | g6805 | i0 | 67.3 | 0.997782705099778 | 150 | 49 | 99.8 | 0 | 2 | 451 | 85 | 234 | XP_004356467.1 FAD binding domain containing protein [Acanthamoeba castellanii str. Neff] | diamond | 450 | 204 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 32161914 | 32161914 | PRJNA393181_S_NODE_22358_length_246_cov_3.153110_g22252_i0 | PRJNA393181 | 22358 | 246 | 3.15311 | 7.7566506 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 96.7 | 1.87e-21 | NR | XP_004354481.1 | 1257118 | g22252 | i0 | 62.1 | 0.804878048780488 | 66 | 24 | 80.5 | 1 | 3 | 200 | 328 | 392 | XP_004354481.1 Ser/Thr phosphatase, putative [Acanthamoeba castellanii str. Neff] | diamond | 198 | 96.7 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 32446767 | 32446767 | PRJNA393181_S_NODE_47979_length_150_cov_1.035398_g47873_i0 | PRJNA393181 | 47979 | 150 | 1.035398 | 1.553097 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 56.2 | 5.72e-8 | NR | XP_004339458.1 | 1257118 | g47873 | i0 | 89.7 | 0.58 | 29 | 3 | 58 | 0 | 3 | 89 | 144 | 172 | XP_004339458.1 shikimate kinase [Acanthamoeba castellanii str. Neff] | diamond | 87 | 56.2 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 32698883 | 32698883 | PRJNA393181_S_NODE_39020_length_172_cov_1.748148_g38914_i0 | PRJNA393181 | 39020 | 172 | 1.748148 | 3.00681456 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 78.6 | 2.77e-15 | NR | XP_004354481.1 | 1257118 | g38914 | i0 | 67.9 | 0.924418604651163 | 53 | 17 | 92.4 | 0 | 171 | 13 | 130 | 182 | XP_004354481.1 Ser/Thr phosphatase, putative [Acanthamoeba castellanii str. Neff] | diamond | 159 | 78.6 | 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);;