contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA795663" and tax_phylum = "Heterolobosea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4607658 | 4607658 | PRJNA795663_S_NODE_1224_length_493_cov_4.298246_g1122_i0 | PRJNA795663 | 1224 | 493 | 4.298246 | 21.19035278 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 218 | 4.27e-65 | NR | KAL0483822.1 | 1008807 | g1122 | i0 | 76.6 | 1.66734279918864 | 137 | 32 | 83.4 | 0 | 2 | 412 | 427 | 563 | KAL0483822.1 isocitrate lyase AceA [Acrasis kona] | diamond | 822 | 218 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 5883009 | 5883009 | PRJNA795663_S_NODE_4705_length_269_cov_1.965517_g4600_i0 | PRJNA795663 | 4705 | 269 | 1.965517 | 5.28724073 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 130 | 7.83e-34 | NR | KAL0483328.1 | 1008807 | g4600 | i0 | 89.2 | 0.825278810408922 | 74 | 8 | 82.5 | 0 | 246 | 25 | 332 | 405 | KAL0483328.1 26S proteasome subunit Rpt6 [Acrasis kona] | diamond | 222 | 130 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 7157847 | 7157847 | PRJNA795663_S_NODE_5326_length_253_cov_1.898148_g5221_i0 | PRJNA795663 | 5326 | 253 | 1.898148 | 4.80231444 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 139 | 3.5e-36 | NR | KAL0481875.1 | 1008807 | g5221 | i0 | 74 | 0.91304347826087 | 77 | 20 | 91.3 | 0 | 22 | 252 | 352 | 428 | KAL0481875.1 DNA excision repair protein ERCC [Acrasis kona] | diamond | 231 | 139 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 27116791 | 27116791 | PRJNA795663_S_NODE_13282_length_172_cov_1.918519_g13177_i0 | PRJNA795663 | 13282 | 172 | 1.918519 | 3.29985268 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 48.9 | 8.7e-5 | NR | KAL0476461.1 | 1008807 | g13177 | i0 | 52 | 0.872093023255814 | 50 | 18 | 83.7 | 2 | 27 | 170 | 195 | 240 | KAL0476461.1 SLC22A7 [Acrasis kona] | diamond | 150 | 48.9 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 27685968 | 27685968 | PRJNA795663_S_NODE_8004_length_212_cov_1.925714_g7899_i0 | PRJNA795663 | 8004 | 212 | 1.925714 | 4.08251368 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 109 | 2.24e-26 | NR | KAL0487669.1 | 1008807 | g7899 | i0 | 81 | 0.891509433962264 | 63 | 12 | 89.2 | 0 | 192 | 4 | 331 | 393 | KAL0487669.1 solute carrier family 35 member [Acrasis kona] | diamond | 189 | 109 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 27780497 | 27780497 | PRJNA795663_S_NODE_5464_length_250_cov_2.488263_g5359_i0 | PRJNA795663 | 5464 | 250 | 2.488263 | 6.2206575 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 65.1 | 2.75e-10 | NR | KAL0484498.1 | 1008807 | g5359 | i0 | 44.7 | 0.912 | 76 | 41 | 90 | 1 | 226 | 2 | 130 | 205 | KAL0484498.1 gamma-glutamyl cyclotransferase domain-containing protein [Acrasis kona] | diamond | 228 | 65.1 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 27875016 | 27875016 | PRJNA795663_S_NODE_4445_length_276_cov_2.803347_g4340_i0 | PRJNA795663 | 4445 | 276 | 2.803347 | 7.73723772 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 58.5 | 1.52e-7 | NR | KAL0476585.1 | 1008807 | g4340 | i0 | 50 | 0.5 | 46 | 19 | 50 | 1 | 261 | 124 | 244 | 285 | KAL0476585.1 Tmprss12 [Acrasis kona] | diamond | 138 | 58.5 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 28317171 | 28317171 | PRJNA795663_S_NODE_15706_length_161_cov_1.556452_g15601_i0 | PRJNA795663 | 15706 | 161 | 1.556452 | 2.50588772 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 42.7 | 0.0124 | NR | KAL0484560.1 | 1008807 | g15601 | i0 | 50 | 0.708074534161491 | 38 | 19 | 70.8 | 0 | 154 | 41 | 877 | 914 | KAL0484560.1 hypothetical protein AKO1_011618 [Acrasis kona] | diamond | 114 | 42.7 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 28633075 | 28633075 | PRJNA795663_S_NODE_6107_length_238_cov_4.721393_g6002_i0 | PRJNA795663 | 6107 | 238 | 4.721393 | 11.23691534 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 68.6 | 2.23e-12 | NR | XP_044563306.1 | 5763 | g6002 | i0 | 47.2 | 1.80252100840336 | 72 | 37 | 90.8 | 1 | 236 | 21 | 82 | 152 | XP_044563306.1 uncharacterized protein FDP41_002413 [Naegleria fowleri] | diamond | 429 | 68.6 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 29012085 | 29012085 | PRJNA795663_S_NODE_4088_length_286_cov_3.437751_g3983_i0 | PRJNA795663 | 4088 | 286 | 3.437751 | 9.83196786 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 43.5 | 0.032 | NR | KAL0487856.1 | 1008807 | g3983 | i0 | 53.8 | 0.409090909090909 | 39 | 16 | 40.9 | 1 | 46 | 162 | 353 | 389 | KAL0487856.1 S-adenosylmethionine decarboxylase [Acrasis kona] | diamond | 117 | 43.5 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 30685576 | 30685576 | PRJNA795663_S_NODE_11993_length_179_cov_2.697183_g11888_i0 | PRJNA795663 | 11993 | 179 | 2.697183 | 4.82795757 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 49.3 | 7.17e-5 | NR | KAL0476461.1 | 1008807 | g11888 | i0 | 49 | 0.82122905027933 | 49 | 24 | 82.1 | 1 | 1 | 147 | 238 | 285 | KAL0476461.1 SLC22A7 [Acrasis kona] | diamond | 147 | 49.3 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 31381186 | 31381186 | PRJNA795663_S_NODE_1876_length_409_cov_3.069892_g1771_i0 | PRJNA795663 | 1876 | 409 | 3.069892 | 12.55585828 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 177 | 5.72e-54 | NR | KAL0483306.1 | 1008807 | g1771 | i0 | 68.3 | 0.902200488997555 | 123 | 36 | 90.2 | 1 | 389 | 21 | 55 | 174 | KAL0483306.1 cathepsin H [Acrasis kona] | diamond | 369 | 177 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 31381187 | 31381187 | PRJNA795663_S_NODE_2296_length_373_cov_3.166667_g2191_i0 | PRJNA795663 | 2296 | 373 | 3.166667 | 11.81166791 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 169 | 2.53e-47 | NR | KAL0476660.1 | 1008807 | g2191 | i0 | 76.4 | 1.72117962466488 | 106 | 25 | 85.3 | 0 | 22 | 339 | 411 | 516 | KAL0476660.1 HMG-CoA reductase [Acrasis kona] | diamond | 642 | 169 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 31728830 | 31728830 | PRJNA795663_S_NODE_6617_length_230_cov_1.818653_g6512_i0 | PRJNA795663 | 6617 | 230 | 1.818653 | 4.1829019 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 92.8 | 6.55e-20 | NR | XP_044546210.1 | 51637 | g6512 | i0 | 62.9 | 1.78695652173913 | 70 | 25 | 91.3 | 1 | 224 | 15 | 403 | 471 | XP_044546210.1 uncharacterized protein C9374_007586 [Naegleria lovaniensis] | diamond | 411 | 92.8 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis |
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);;