contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA939369" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 914581 | 914581 | PRJNA939369_S_NODE_75921_length_241_cov_0.916667_g75504_i0 | PRJNA939369 | 75921 | 241 | 0.916667 | 2.20916747 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 131 | 1.2e-34 | NR | XP_002680515.1 | 5762 | g75504 | i0 | 83.1 | 0.883817427385892 | 71 | 12 | 88.4 | 0 | 215 | 3 | 257 | 327 | XP_002680515.1 uncharacterized protein NAEGRDRAFT_31331 [Naegleria gruberi] | diamond | 213 | 131 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 21316415 | 21316415 | PRJNA939369_S_NODE_40757_length_275_cov_1.143564_g40340_i0 | PRJNA939369 | 40757 | 275 | 1.143564 | 3.144801 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 102 | 3.0099999999999997e-25 | NR | XP_044565811.1 | 5763 | g40340 | i0 | 59.3 | 0.938181818181818 | 86 | 30 | 88.4 | 2 | 273 | 31 | 55 | 140 | XP_044565811.1 uncharacterized protein FDP41_012886 [Naegleria fowleri] | diamond | 258 | 102 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 27056705 | 27056705 | PRJNA939369_S_NODE_65882_length_246_cov_0.890173_g65465_i0 | PRJNA939369 | 65882 | 246 | 0.890173 | 2.18982558 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 59.3 | 5.35e-8 | NR | XP_002675929.1 | 5762 | g65465 | i0 | 48.4 | 0.75609756097561 | 62 | 26 | 68.3 | 2 | 54 | 221 | 377 | 438 | XP_002675929.1 uncharacterized protein NAEGRDRAFT_49921 [Naegleria gruberi] | diamond | 186 | 59.3 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 27530545 | 27530545 | PRJNA939369_S_NODE_43863_length_269_cov_1.102041_g43446_i0 | PRJNA939369 | 43863 | 269 | 1.102041 | 2.96449029 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 149 | 2.19e-42 | NR | NP_066520.1 | 5762 | g43446 | i0 | 78.9 | 1.00371747211896 | 90 | 18 | 99.3 | 1 | 267 | 1 | 134 | 223 | NP_066520.1 ribosomal protein L2 [Naegleria gruberi] | diamond | 270 | 149 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 27941114 | 27941114 | PRJNA939369_S_NODE_72545_length_243_cov_0.894118_g72128_i0 | PRJNA939369 | 72545 | 243 | 0.894118 | 2.17270674 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 130 | 5.2000000000000004e-37 | NR | XP_002672751.1 | 5762 | g72128 | i0 | 82.7 | 1 | 81 | 14 | 100 | 0 | 243 | 1 | 10 | 90 | XP_002672751.1 uncharacterized protein NAEGRDRAFT_81126 [Naegleria gruberi] | diamond | 243 | 130 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 28193419 | 28193419 | PRJNA939369_S_NODE_18326_length_347_cov_1.255474_g17909_i0 | PRJNA939369 | 18326 | 347 | 1.255474 | 4.35649478 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 78.2 | 4.73e-14 | NR | XP_002673152.1 | 5762 | g17909 | i0 | 45.5 | 0.968299711815562 | 112 | 50 | 88.2 | 5 | 347 | 42 | 857 | 967 | XP_002673152.1 uncharacterized protein NAEGRDRAFT_51700 [Naegleria gruberi] | diamond | 336 | 78.2 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 28635900 | 28635900 | PRJNA939369_S_NODE_31007_length_298_cov_1.026667_g30590_i0 | PRJNA939369 | 31007 | 298 | 1.026667 | 3.05946766 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 135 | 1.8899999999999998e-34 | NR | XP_002673737.1 | 5762 | g30590 | i0 | 62 | 1.00671140939597 | 100 | 36 | 98.7 | 2 | 3 | 296 | 324 | 423 | XP_002673737.1 uncharacterized protein NAEGRDRAFT_80805 [Naegleria gruberi] | diamond | 300 | 135 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 29046224 | 29046224 | PRJNA939369_S_NODE_63108_length_247_cov_0.885057_g62691_i0 | PRJNA939369 | 63108 | 247 | 0.885057 | 2.18609079 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 47 | 0.00119 | NR | XP_044545604.1 | 51637 | g62691 | i0 | 39.7 | 0.825910931174089 | 68 | 27 | 65.6 | 2 | 21 | 182 | 187 | 254 | XP_044545604.1 uncharacterized protein C9374_008485 [Naegleria lovaniensis] | diamond | 204 | 47 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis | ||||
| 29046226 | 29046226 | PRJNA939369_S_NODE_75928_length_241_cov_0.916667_g75511_i0 | PRJNA939369 | 75928 | 241 | 0.916667 | 2.20916747 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 127 | 3.03e-33 | NR | XP_002683552.1 | 5762 | g75511 | i0 | 79.5 | 0.970954356846473 | 78 | 16 | 97.1 | 0 | 6 | 239 | 310 | 387 | XP_002683552.1 uncharacterized protein NAEGRDRAFT_1848, partial [Naegleria gruberi] | diamond | 234 | 127 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 29211162 | 29211162 | PRJNA939369_S_NODE_19549_length_340_cov_1.299625_g19132_i0 | PRJNA939369 | 19549 | 340 | 1.299625 | 4.418725 | Naegleria | 5761 | Heterolobosea | other_Eukaryota | 160 | 1.9799999999999998e-47 | NR | XP_044565737.1 | 5763 | g19132 | i0 | 68.6 | 1.87058823529412 | 105 | 33 | 92.6 | 0 | 321 | 7 | 77 | 181 | XP_044565737.1 uncharacterized protein FDP41_012812 [Naegleria fowleri] | diamond | 636 | 160 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 30278137 | 30278137 | PRJNA939369_S_NODE_59192_length_249_cov_0.875000_g58775_i0 | PRJNA939369 | 59192 | 249 | 0.875 | 2.17875 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 149 | 1.04e-39 | NR | XP_002681319.1 | 5762 | g58775 | i0 | 85.5 | 1 | 83 | 12 | 100 | 0 | 1 | 249 | 962 | 1044 | XP_002681319.1 uncharacterized protein NAEGRDRAFT_63237 [Naegleria gruberi] | diamond | 249 | 149 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 30561879 | 30561879 | PRJNA939369_S_NODE_54353_length_251_cov_1.297753_g53936_i0 | PRJNA939369 | 54353 | 251 | 1.297753 | 3.25736003 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 126 | 1.2e-33 | NR | XP_044544079.1 | 51637 | g53936 | i0 | 68.7 | 0.99203187250996006 | 83 | 25 | 99.2 | 1 | 249 | 1 | 161 | 242 | XP_044544079.1 uncharacterized protein C9374_010279 [Naegleria lovaniensis] | diamond | 249 | 126 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis | ||||
| 30783311 | 30783311 | PRJNA939369_S_NODE_72754_length_243_cov_0.858824_g72337_i0 | PRJNA939369 | 72754 | 243 | 0.858824 | 2.08694232 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 105 | 3.0699999999999998e-24 | NR | XP_002679956.1 | 5762 | g72337 | i0 | 71.8 | 0.876543209876543 | 71 | 20 | 87.7 | 0 | 241 | 29 | 982 | 1052 | XP_002679956.1 isoleucyl-tRNA synthetase [Naegleria gruberi] | diamond | 213 | 105 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 31004500 | 31004500 | PRJNA939369_S_NODE_26594_length_311_cov_1.390756_g26177_i0 | PRJNA939369 | 26594 | 311 | 1.390756 | 4.32525116 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 177 | 2.2199999999999998e-54 | NR | XP_002676188.1 | 5762 | g26177 | i0 | 86.3 | 1.83279742765273 | 95 | 13 | 91.6 | 0 | 25 | 309 | 94 | 188 | XP_002676188.1 uncharacterized protein NAEGRDRAFT_68539 [Naegleria gruberi] | diamond | 570 | 177 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 31542069 | 31542069 | PRJNA939369_S_NODE_59916_length_249_cov_0.875000_g59499_i0 | PRJNA939369 | 59916 | 249 | 0.875 | 2.17875 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 122 | 5.41e-30 | NR | XP_044542409.1 | 51637 | g59499 | i0 | 75.9 | 2 | 83 | 20 | 100 | 0 | 249 | 1 | 937 | 1019 | XP_044542409.1 uncharacterized protein C9374_012338 [Naegleria lovaniensis] | diamond | 498 | 122 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis | ||||
| 31794771 | 31794771 | PRJNA939369_S_NODE_78377_length_231_cov_2.436709_g77960_i0 | PRJNA939369 | 78377 | 231 | 2.436709 | 5.62879779 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 126 | 1.08e-34 | NR | XP_002677233.1 | 5762 | g77960 | i0 | 95.6 | 0.883116883116883 | 68 | 3 | 88.3 | 0 | 3 | 206 | 99 | 166 | XP_002677233.1 uncharacterized protein NAEGRDRAFT_56165 [Naegleria gruberi] | diamond | 204 | 126 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 32016413 | 32016413 | PRJNA939369_S_NODE_40558_length_275_cov_2.287129_g40141_i0 | PRJNA939369 | 40558 | 275 | 2.287129 | 6.28960475 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 194 | 2.77e-58 | NR | XP_002679351.1 | 5762 | g40141 | i0 | 94.5 | 2.97818181818182 | 91 | 5 | 99.3 | 0 | 3 | 275 | 309 | 399 | XP_002679351.1 uncharacterized protein NAEGRDRAFT_36021 [Naegleria gruberi] | diamond | 819 | 194 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 32466731 | 32466731 | PRJNA939369_S_NODE_37759_length_281_cov_1.644231_g37342_i0 | PRJNA939369 | 37759 | 281 | 1.644231 | 4.62028911 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 53.1 | 4.87e-6 | NR | XP_044558117.1 | 5763 | g37342 | i0 | 56.8 | 2.83985765124555 | 37 | 16 | 39.5 | 0 | 280 | 170 | 140 | 176 | XP_044558117.1 uncharacterized protein FDP41_008108 [Naegleria fowleri] | diamond | 798 | 53.5 | 0.992523364485981 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 32523006 | 32523006 | PRJNA939369_S_NODE_54359_length_251_cov_1.297753_g53942_i0 | PRJNA939369 | 54359 | 251 | 1.297753 | 3.25736003 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 103 | 8.36e-24 | NR | XP_002670016.1 | 5762 | g53942 | i0 | 69.7 | 0.788844621513944 | 66 | 19 | 77.7 | 1 | 251 | 57 | 433 | 498 | XP_002670016.1 uncharacterized protein NAEGRDRAFT_59806 [Naegleria gruberi] | diamond | 198 | 103 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi |
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);;