contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA700095" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12162419 | 12162419 | PRJNA700095_P_NODE_45950_length_262_cov_1.037037_g44686_i0 | PRJNA700095 | 45950 | 262 | 1.037037 | 2.71703694 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 164 | 2.85e-49 | NR | KAL0486938.1 | 1008807 | g44686 | i0 | 95.4 | 0.99618320610687 | 87 | 4 | 99.6 | 0 | 2 | 262 | 66 | 152 | KAL0486938.1 Ras-related protein Rap [Acrasis kona] | diamond | 261 | 164 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 14712136 | 14712136 | PRJNA700095_P_NODE_25072_length_343_cov_2.348148_g23808_i0 | PRJNA700095 | 25072 | 343 | 2.348148 | 8.05414764 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 125 | 1.03e-30 | NR | KAL0489416.1 | 1008807 | g23808 | i0 | 54.1 | 0.9533527696793 | 109 | 47 | 94.5 | 2 | 3 | 326 | 625 | 731 | KAL0489416.1 glucan 1,3-beta-glucosidase [Acrasis kona] | diamond | 327 | 125 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 26872765 | 26872765 | PRJNA700095_P_NODE_29481_length_313_cov_1.541667_g28217_i0 | PRJNA700095 | 29481 | 313 | 1.541667 | 4.82541771 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 129 | 6.29e-36 | NR | 5VJY_A | 5763 | g28217 | i0 | 74.7 | 7.88817891373802 | 83 | 21 | 79.6 | 0 | 64 | 312 | 13 | 95 | 5VJY_A Chain A, dUTP pyrophosphatase [Naegleria fowleri] | diamond | 2469 | 129 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 27619910 | 27619910 | PRJNA700095_P_NODE_14944_length_479_cov_1.689655_g13683_i0 | PRJNA700095 | 14944 | 479 | 1.689655 | 8.09344745 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 163 | 7.74e-45 | NR | KAL0480953.1 | 1008807 | g13683 | i0 | 53.4 | 0.926931106471816 | 148 | 64 | 92.7 | 1 | 30 | 473 | 12 | 154 | KAL0480953.1 hypothetical protein AKO1_013613 [Acrasis kona] | diamond | 444 | 163 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 28061787 | 28061787 | PRJNA700095_P_NODE_22285_length_369_cov_2.057432_g21021_i0 | PRJNA700095 | 22285 | 369 | 2.057432 | 7.59192408 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 87 | 5.82e-19 | NR | XP_002671786.1 | 5762 | g21021 | i0 | 56.8 | 0.601626016260163 | 74 | 31 | 59.3 | 1 | 150 | 368 | 5 | 78 | XP_002671786.1 uncharacterized protein NAEGRDRAFT_73036 [Naegleria gruberi] | diamond | 222 | 87 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 29525614 | 29525614 | PRJNA700095_P_NODE_36290_length_285_cov_2.985849_g35026_i0 | PRJNA700095 | 36290 | 285 | 2.985849 | 8.50966965 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 123 | 1.2699999999999998e-32 | NR | XP_002670908.1 | 5762 | g35026 | i0 | 58.5 | 3.93684210526316 | 94 | 39 | 98.9 | 0 | 3 | 284 | 90 | 183 | XP_002670908.1 uncharacterized protein NAEGRDRAFT_81691 [Naegleria gruberi] | diamond | 1122 | 124 | 0.991935483870968 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 30051015 | 30051015 | PRJNA700095_P_NODE_27131_length_328_cov_1.231373_g25867_i0 | PRJNA700095 | 27131 | 328 | 1.231373 | 4.03890344 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 101 | 1.4999999999999998e-24 | NR | KAL0491286.1 | 1008807 | g25867 | i0 | 56.6 | 0.905487804878049 | 99 | 40 | 89.6 | 2 | 326 | 33 | 80 | 176 | KAL0491286.1 hypothetical protein AKO1_002384 [Acrasis kona] | diamond | 297 | 101 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 30935917 | 30935917 | PRJNA700095_P_NODE_21254_length_380_cov_6.781759_g19990_i0 | PRJNA700095 | 21254 | 380 | 6.781759 | 25.7706842 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 109 | 3.2900000000000004e-27 | NR | KAL0488449.1 | 1008807 | g19990 | i0 | 51.9 | 0.836842105263158 | 106 | 47 | 83.7 | 2 | 56 | 373 | 2 | 103 | KAL0488449.1 hypothetical protein AKO1_015639 [Acrasis kona] | diamond | 318 | 109 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 31104848 | 31104848 | PRJNA700095_P_NODE_15395_length_469_cov_7.825758_g14134_i0 | PRJNA700095 | 15395 | 469 | 7.825758 | 36.70280502 | Naegleria | 5761 | Heterolobosea | other_Eukaryota | 52 | 1.89e-4 | NR | XP_044556235.1 | 5763 | g14134 | i0 | 33.9 | 3.58208955223881 | 62 | 41 | 39.7 | 0 | 283 | 468 | 256 | 317 | XP_044556235.1 uncharacterized protein FDP41_010195 [Naegleria fowleri] | diamond | 1680 | 52 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 31536705 | 31536705 | PRJNA700095_P_NODE_46736_length_260_cov_1.556150_g45472_i0 | PRJNA700095 | 46736 | 260 | 1.55615 | 4.04599 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 87.4 | 1.14e-18 | NR | XP_044542699.1 | 51637 | g45472 | i0 | 54.1 | 0.980769230769231 | 85 | 38 | 98.1 | 1 | 1 | 255 | 18 | 101 | XP_044542699.1 uncharacterized protein C9374_011988 [Naegleria lovaniensis] | diamond | 255 | 87.4 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis | ||||
| 31947560 | 31947560 | PRJNA700095_P_NODE_9737_length_624_cov_8.671506_g8515_i0 | PRJNA700095 | 9737 | 624 | 8.671506 | 54.11019744 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 197 | 4.64e-61 | NR | KAL0482313.1 | 1008807 | g8515 | i0 | 62.2 | 6.19230769230769 | 156 | 58 | 75 | 1 | 89 | 556 | 5 | 159 | KAL0482313.1 peroxiredoxin [Acrasis kona] | diamond | 3864 | 197 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 32738053 | 32738053 | PRJNA700095_P_NODE_12920_length_527_cov_1.966960_g11668_i0 | PRJNA700095 | 12920 | 527 | 1.96696 | 10.3658792 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 104 | 4.539999999999999e-23 | NR | KAL0480799.1 | 1008807 | g11668 | i0 | 49.6 | 0.64326375711575 | 113 | 54 | 63.8 | 2 | 171 | 506 | 1 | 111 | KAL0480799.1 Pus3 [Acrasis kona] | diamond | 339 | 104 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona |
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);;