contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJNA870096" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3400651 | 3400651 | PRJNA870096_S_NODE_20923_length_396_cov_3.912181_g19263_i0 | PRJNA870096 | 20923 | 396 | 3.912181 | 15.49223676 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 194 | 1.28e-60 | NR | KAL0485827.1 | 1008807 | g19263 | i0 | 75.2 | 2.61363636363636 | 113 | 28 | 85.6 | 0 | 33 | 371 | 68 | 180 | KAL0485827.1 60S ribosome subunit biogenesis protein NIP7 [Acrasis kona] | diamond | 1035 | 194 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 13603254 | 13603254 | PRJNA870096_S_NODE_126711_length_158_cov_1.669565_g125047_i0 | PRJNA870096 | 126711 | 158 | 1.669565 | 2.6379127000000002 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 80.9 | 4.48e-17 | NR | KAL0484822.1 | 1008807 | g125047 | i0 | 60.8 | 0.968354430379747 | 51 | 20 | 96.8 | 0 | 153 | 1 | 158 | 208 | KAL0484822.1 GH family lysozyme [Acrasis kona] | diamond | 153 | 80.9 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 13603870 | 13603870 | PRJNA870096_S_NODE_48891_length_252_cov_1.727273_g47227_i0 | PRJNA870096 | 48891 | 252 | 1.727273 | 4.35272796 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 152 | 2.75e-41 | NR | XP_002677495.1 | 5762 | g47227 | i0 | 86.9 | 19.9285714285714 | 84 | 11 | 100 | 0 | 1 | 252 | 534 | 617 | XP_002677495.1 dead box ATP-dependent RNA helicase [Naegleria gruberi] | diamond | 5022 | 152 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 26706720 | 26706720 | PRJNA870096_S_NODE_49621_length_250_cov_1.623188_g47957_i0 | PRJNA870096 | 49621 | 250 | 1.623188 | 4.05797 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 56.6 | 2.2e-7 | NR | XP_044545956.1 | 51637 | g47957 | i0 | 36.8 | 1.752 | 76 | 45 | 87.6 | 2 | 223 | 5 | 114 | 189 | XP_044545956.1 uncharacterized protein C9374_007842 [Naegleria lovaniensis] | diamond | 438 | 56.6 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis | ||||
| 26778567 | 26778567 | PRJNA870096_S_NODE_83261_length_192_cov_3.174497_g81597_i0 | PRJNA870096 | 83261 | 192 | 3.174497 | 6.09503424 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 70.9 | 2.35e-13 | NR | XP_044563226.1 | 5763 | g81597 | i0 | 59.2 | 6.828125 | 49 | 20 | 76.6 | 0 | 164 | 18 | 77 | 125 | XP_044563226.1 uncharacterized protein FDP41_002333 [Naegleria fowleri] | diamond | 1311 | 70.9 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 27402950 | 27402950 | PRJNA870096_S_NODE_42283_length_272_cov_3.563319_g40619_i0 | PRJNA870096 | 42283 | 272 | 3.563319 | 9.69222768 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 62.4 | 9.56e-10 | NR | XP_044569784.1 | 5763 | g40619 | i0 | 34.8 | 1.01470588235294 | 92 | 58 | 99.3 | 1 | 2 | 271 | 61 | 152 | XP_044569784.1 uncharacterized protein FDP41_000110 [Naegleria fowleri] | diamond | 276 | 62.4 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 27592455 | 27592455 | PRJNA870096_S_NODE_29264_length_331_cov_4.715278_g27600_i0 | PRJNA870096 | 29264 | 331 | 4.715278 | 15.60757018 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 47.8 | 0.00153 | NR | XP_044542340.1 | 51637 | g27600 | i0 | 39.6 | 2.63746223564955 | 101 | 60 | 90.6 | 1 | 306 | 7 | 166 | 266 | XP_044542340.1 uncharacterized protein C9374_012768 [Naegleria lovaniensis] | diamond | 873 | 47.8 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis | ||||
| 27789949 | 27789949 | PRJNA870096_S_NODE_40804_length_278_cov_1.429787_g39140_i0 | PRJNA870096 | 40804 | 278 | 1.429787 | 3.97480786 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 61.2 | 1.78e-8 | NR | XP_002669469.1 | 5762 | g39140 | i0 | 40.8 | 4.81294964028777 | 71 | 38 | 76.6 | 1 | 14 | 226 | 715 | 781 | XP_002669469.1 uncharacterized protein NAEGRDRAFT_75608 [Naegleria gruberi] | diamond | 1338 | 61.6 | 0.993506493506494 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 27852893 | 27852893 | PRJNA870096_S_NODE_28304_length_337_cov_4.265306_g26640_i0 | PRJNA870096 | 28304 | 337 | 4.265306 | 14.37408122 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 80.1 | 6.63e-16 | NR | XP_044557982.1 | 5763 | g26640 | i0 | 39.4 | 6.35608308605341 | 94 | 54 | 83.7 | 1 | 8 | 289 | 107 | 197 | XP_044557982.1 uncharacterized protein FDP41_008476 [Naegleria fowleri] | diamond | 2142 | 80.9 | 0.990111248454882 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 29242265 | 29242265 | PRJNA870096_S_NODE_98509_length_178_cov_1.192593_g96845_i0 | PRJNA870096 | 98509 | 178 | 1.192593 | 2.12281554 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 81.3 | 4.15e-16 | NR | XP_044544293.1 | 51637 | g96845 | i0 | 59.3 | 2.91573033707865 | 59 | 24 | 99.4 | 0 | 177 | 1 | 480 | 538 | XP_044544293.1 uncharacterized protein C9374_010123 [Naegleria lovaniensis] | diamond | 519 | 81.6 | 0.996323529411765 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis | ||||
| 30118236 | 30118236 | PRJNA870096_S_NODE_111412_length_168_cov_1.536000_g109748_i0 | PRJNA870096 | 111412 | 168 | 1.536 | 2.58048 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 48.5 | 1.12e-4 | NR | XP_002681806.1 | 5762 | g109748 | i0 | 41.8 | 0.982142857142857 | 55 | 32 | 98.2 | 0 | 165 | 1 | 93 | 147 | XP_002681806.1 translocon-associated protein, alpha subunit [Naegleria gruberi] | diamond | 165 | 48.5 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 30505671 | 30505671 | PRJNA870096_S_NODE_122093_length_161_cov_1.440678_g120429_i0 | PRJNA870096 | 122093 | 161 | 1.440678 | 2.31949158 | Viridiplantae | 33090 | Heterolobosea | other_Eukaryota | 58.5 | 1.21e-8 | NR | XP_044569724.1 | 5763 | g120429 | i0 | 47.1 | 2.83229813664596 | 51 | 27 | 95 | 0 | 5 | 157 | 109 | 159 | XP_044569724.1 uncharacterized protein FDP41_000050 [Naegleria fowleri] | diamond | 456 | 58.9 | 0.99320882852292 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 31445648 | 31445648 | PRJNA870096_S_NODE_102296_length_175_cov_1.090909_g100632_i0 | PRJNA870096 | 102296 | 175 | 1.090909 | 1.90909075 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 89 | 1.24e-20 | NR | XP_002675420.1 | 5762 | g100632 | i0 | 68.4 | 0.977142857142857 | 57 | 18 | 97.7 | 0 | 175 | 5 | 90 | 146 | XP_002675420.1 uncharacterized protein NAEGRDRAFT_69370 [Naegleria gruberi] | diamond | 171 | 89 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 31833135 | 31833135 | PRJNA870096_S_NODE_68897_length_211_cov_1.428571_g67233_i0 | PRJNA870096 | 68897 | 211 | 1.428571 | 3.01428481 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 44.3 | 0.00682 | NR | XP_044545796.1 | 51637 | g67233 | i0 | 50 | 1.81990521327014 | 26 | 13 | 37 | 0 | 200 | 123 | 523 | 548 | XP_044545796.1 uncharacterized protein C9374_008173 [Naegleria lovaniensis] | diamond | 384 | 44.3 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis | ||||
| 31991398 | 31991398 | PRJNA870096_S_NODE_13778_length_494_cov_3.053215_g12143_i0 | PRJNA870096 | 13778 | 494 | 3.053215 | 15.0828821 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 115 | 9.65e-29 | NR | CAG4712251.1 | 5763 | g12143 | i0 | 41.5 | 9.14574898785425 | 159 | 88 | 96.6 | 3 | 3 | 479 | 40 | 193 | CAG4712251.1 unnamed protein product [Naegleria fowleri] | diamond | 4518 | 116 | 0.991379310344828 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 32489824 | 32489824 | PRJNA870096_S_NODE_117899_length_164_cov_1.165289_g116235_i0 | PRJNA870096 | 117899 | 164 | 1.165289 | 1.91107396 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 47 | 4.03e-4 | NR | XP_002682390.1 | 5762 | g116235 | i0 | 58.8 | 0.621951219512195 | 34 | 14 | 62.2 | 0 | 2 | 103 | 262 | 295 | XP_002682390.1 DUF849 domain-containing protein [Naegleria gruberi] | diamond | 102 | 47 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 32647093 | 32647093 | PRJNA870096_S_NODE_36660_length_294_cov_2.250996_g34996_i0 | PRJNA870096 | 36660 | 294 | 2.250996 | 6.61792824 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 74.3 | 3.77e-15 | NR | KAL0487664.1 | 1008807 | g34996 | i0 | 47.9 | 0.724489795918367 | 71 | 37 | 72.4 | 0 | 294 | 82 | 2 | 72 | KAL0487664.1 hypothetical protein AKO1_008722 [Acrasis kona] | diamond | 213 | 74.3 | 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);;