contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA751877" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4555009 | 4555009 | PRJNA751877_P_NODE_28884_length_243_cov_0.905882_g28762_i0 | PRJNA751877 | 28884 | 243 | 0.905882 | 2.20129326 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 111 | 2.56e-27 | NR | KAL0480924.1 | 1008807 | g28762 | i0 | 66.7 | 2.91358024691358 | 78 | 26 | 96.3 | 0 | 243 | 10 | 206 | 283 | KAL0480924.1 type I protein arginine methyltransferase PRMT1 [Acrasis kona] | diamond | 708 | 111 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 9655056 | 9655056 | PRJNA751877_P_NODE_5788_length_415_cov_0.900585_g5666_i0 | PRJNA751877 | 5788 | 415 | 0.900585 | 3.73742775 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 129 | 1.3e-31 | NR | XP_002678219.1 | 5762 | g5666 | i0 | 51.1 | 2.06746987951807 | 141 | 61 | 96.1 | 2 | 403 | 5 | 228 | 368 | XP_002678219.1 P-type II calcium ATPase [Naegleria gruberi] | diamond | 858 | 129 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 13480343 | 13480343 | PRJNA751877_P_NODE_29231_length_242_cov_0.911243_g29109_i0 | PRJNA751877 | 29231 | 242 | 0.911243 | 2.20520806 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 108 | 6.55e-29 | NR | CAG4718835.1 | 5763 | g29109 | i0 | 93 | 0.706611570247934 | 57 | 4 | 70.7 | 0 | 3 | 173 | 13 | 69 | CAG4718835.1 unnamed protein product [Naegleria fowleri] | diamond | 171 | 108 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 24952747 | 24952747 | PRJNA751877_P_NODE_17280_length_282_cov_1.473684_g17158_i0 | PRJNA751877 | 17280 | 282 | 1.473684 | 4.15578888 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 146 | 1.6699999999999999e-43 | NR | XP_044569047.1 | 5763 | g17158 | i0 | 87.8 | 0.957446808510638 | 90 | 11 | 95.7 | 0 | 280 | 11 | 1 | 90 | XP_044569047.1 uncharacterized protein FDP41_007511 [Naegleria fowleri] | diamond | 270 | 146 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 26704364 | 26704364 | PRJNA751877_P_NODE_24361_length_249_cov_0.875000_g24239_i0 | PRJNA751877 | 24361 | 249 | 0.875 | 2.17875 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 135 | 7.319999999999999e-35 | NR | XP_002678046.1 | 5762 | g24239 | i0 | 81.5 | 0.975903614457831 | 81 | 15 | 97.6 | 0 | 248 | 6 | 352 | 432 | XP_002678046.1 uncharacterized protein NAEGRDRAFT_48420 [Naegleria gruberi] | diamond | 243 | 135 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 27590065 | 27590065 | PRJNA751877_P_NODE_28544_length_243_cov_0.905882_g28422_i0 | PRJNA751877 | 28544 | 243 | 0.905882 | 2.20129326 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 130 | 3.64e-33 | NR | XP_002674170.1 | 5762 | g28422 | i0 | 92.1 | 0.777777777777778 | 63 | 5 | 77.8 | 0 | 189 | 1 | 27 | 89 | XP_002674170.1 uncharacterized protein NAEGRDRAFT_70850 [Naegleria gruberi] | diamond | 189 | 130 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 28862655 | 28862655 | PRJNA751877_P_NODE_20168_length_264_cov_1.612565_g20046_i0 | PRJNA751877 | 20168 | 264 | 1.612565 | 4.2571716 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 144 | 6.86e-38 | NR | XP_044564533.1 | 5763 | g20046 | i0 | 75.6 | 5.86363636363636 | 86 | 21 | 97.7 | 0 | 3 | 260 | 773 | 858 | XP_044564533.1 uncharacterized protein FDP41_000973 [Naegleria fowleri] | diamond | 1548 | 145 | 0.993103448275862 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 29358099 | 29358099 | PRJNA751877_P_NODE_18889_length_272_cov_1.547739_g18767_i0 | PRJNA751877 | 18889 | 272 | 1.547739 | 4.20985008 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 62.4 | 6.32e-9 | NR | XP_002679432.1 | 5762 | g18767 | i0 | 49 | 1.18014705882353 | 51 | 26 | 56.3 | 0 | 117 | 269 | 48 | 98 | XP_002679432.1 GPI anchored protein [Naegleria gruberi] | diamond | 321 | 62.4 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 30558097 | 30558097 | PRJNA751877_P_NODE_26513_length_246_cov_0.890173_g26391_i0 | PRJNA751877 | 26513 | 246 | 0.890173 | 2.18982558 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 121 | 9.72e-30 | NR | XP_002670245.1 | 5762 | g26391 | i0 | 78 | 2 | 82 | 18 | 100 | 0 | 246 | 1 | 862 | 943 | XP_002670245.1 uncharacterized protein NAEGRDRAFT_74709 [Naegleria gruberi] | diamond | 492 | 121 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 30906003 | 30906003 | PRJNA751877_P_NODE_23614_length_250_cov_0.870056_g23492_i0 | PRJNA751877 | 23614 | 250 | 0.870056 | 2.17514 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 135 | 1.7699999999999998e-37 | NR | XP_044569358.1 | 5763 | g23492 | i0 | 85.4 | 0.984 | 82 | 12 | 98.4 | 0 | 5 | 250 | 1 | 82 | XP_044569358.1 uncharacterized protein FDP41_000544 [Naegleria fowleri] | diamond | 246 | 135 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 32139226 | 32139226 | PRJNA751877_P_NODE_15858_length_291_cov_0.821101_g15736_i0 | PRJNA751877 | 15858 | 291 | 0.821101 | 2.38940391 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 102 | 1.32e-24 | NR | XP_044546422.1 | 51637 | g15736 | i0 | 58.8 | 1 | 97 | 35 | 99 | 2 | 4 | 291 | 72 | 164 | XP_044546422.1 uncharacterized protein C9374_007798 [Naegleria lovaniensis] | diamond | 291 | 102 | 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);;