contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJEB76780" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9066027 | 9066027 | PRJEB76780_P_NODE_1388_length_703_cov_1.269841_g1294_i0 | PRJEB76780 | 1388 | 703 | 1.269841 | 8.92698223 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 92.8 | 1.43e-17 | NR | XP_044554689.1 | 51637 | g1294 | i0 | 57.4 | 0.580369843527738 | 68 | 29 | 29 | 0 | 701 | 498 | 532 | 599 | XP_044554689.1 uncharacterized protein C9374_011520 [Naegleria lovaniensis] | diamond | 408 | 92.8 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis | ||||
| 26900479 | 26900479 | PRJEB76780_P_NODE_11041_length_250_cov_1.757062_g10941_i0 | PRJEB76780 | 11041 | 250 | 1.757062 | 4.392655 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 50.8 | 5.26e-5 | NR | XP_044548098.1 | 51637 | g10941 | i0 | 36.8 | 5.592 | 76 | 47 | 90 | 1 | 230 | 6 | 271 | 346 | XP_044548098.1 uncharacterized protein C9374_005621 [Naegleria lovaniensis] | diamond | 1398 | 51.2 | 0.9921875 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis | ||||
| 27753748 | 27753748 | PRJEB76780_P_NODE_1364_length_709_cov_1.715409_g1271_i0 | PRJEB76780 | 1364 | 709 | 1.715409 | 12.16224981 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 94.7 | 2.34e-18 | NR | XP_002669264.1 | 5762 | g1271 | i0 | 31.4 | 1.62482369534556 | 188 | 126 | 78.7 | 3 | 560 | 3 | 67 | 253 | XP_002669264.1 mitochondrial processing peptidase beta subunit [Naegleria gruberi] | diamond | 1152 | 94.7 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 27887026 | 27887026 | PRJEB76780_P_NODE_11205_length_250_cov_0.881356_g11105_i0 | PRJEB76780 | 11205 | 250 | 0.881356 | 2.20339 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 67.8 | 6e-11 | NR | XP_002678129.1 | 5762 | g11105 | i0 | 39 | 0.984 | 82 | 46 | 97.2 | 2 | 248 | 6 | 160 | 238 | XP_002678129.1 exportin-2 [Naegleria gruberi] | diamond | 246 | 67.8 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 28013588 | 28013588 | PRJEB76780_P_NODE_12085_length_246_cov_2.687861_g11985_i0 | PRJEB76780 | 12085 | 246 | 2.687861 | 6.61213806 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 65.1 | 6.88e-11 | NR | XP_044551193.1 | 51637 | g11985 | i0 | 50 | 0.878048780487805 | 72 | 28 | 87.8 | 4 | 220 | 5 | 33 | 96 | XP_044551193.1 uncharacterized protein C9374_001533 [Naegleria lovaniensis] | diamond | 216 | 65.1 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis | ||||
| 28013589 | 28013589 | PRJEB76780_P_NODE_1265_length_733_cov_2.539394_g1173_i0 | PRJEB76780 | 1265 | 733 | 2.539394 | 18.61375802 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 49.3 | 0.0022 | NR | XP_044550801.1 | 51637 | g1173 | i0 | 26.5 | 0.556616643929059 | 136 | 62 | 55.7 | 4 | 614 | 207 | 48 | 145 | XP_044550801.1 uncharacterized protein C9374_001844 [Naegleria lovaniensis] | diamond | 408 | 49.3 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis | ||||
| 28234158 | 28234158 | PRJEB76780_P_NODE_10606_length_252_cov_0.871508_g10506_i0 | PRJEB76780 | 10606 | 252 | 0.871508 | 2.19620016 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 89.4 | 1.63e-18 | NR | KAL0480312.1 | 1008807 | g10506 | i0 | 51.3 | 1.77380952380952 | 76 | 36 | 89.3 | 1 | 3 | 227 | 323 | 398 | KAL0480312.1 N-acetylglucosaminylaminotransferase [Acrasis kona] | diamond | 447 | 89.4 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 28550365 | 28550365 | PRJEB76780_P_NODE_9387_length_265_cov_1.390625_g9287_i0 | PRJEB76780 | 9387 | 265 | 1.390625 | 3.68515625 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 59.7 | 5.42e-8 | NR | XP_044557499.1 | 5763 | g9287 | i0 | 44.1 | 1.33584905660377 | 59 | 33 | 66.8 | 0 | 264 | 88 | 409 | 467 | XP_044557499.1 uncharacterized protein FDP41_009034 [Naegleria fowleri] | diamond | 354 | 59.7 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 29213451 | 29213451 | PRJEB76780_P_NODE_12109_length_246_cov_1.780347_g12009_i0 | PRJEB76780 | 12109 | 246 | 1.780347 | 4.37965362 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 47.4 | 0.00093000000000000005 | NR | CAG4710169.1 | 5763 | g12009 | i0 | 34.9 | 2.09756097560976 | 86 | 51 | 98.8 | 3 | 1 | 243 | 550 | 635 | CAG4710169.1 unnamed protein product, partial [Naegleria fowleri] | diamond | 516 | 47.4 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 29837319 | 29837319 | PRJEB76780_P_NODE_9471_length_264_cov_1.225131_g9371_i0 | PRJEB76780 | 9471 | 264 | 1.225131 | 3.23434584 | Naegleria | 5761 | Heterolobosea | other_Eukaryota | 121 | 1.09e-29 | NR | XP_002678727.1 | 5762 | g9371 | i0 | 62.1 | 2.96590909090909 | 87 | 33 | 98.9 | 0 | 2 | 262 | 335 | 421 | XP_002678727.1 uncharacterized protein NAEGRDRAFT_83074 [Naegleria gruberi] | diamond | 783 | 121 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 30280143 | 30280143 | PRJEB76780_P_NODE_3532_length_435_cov_1.389503_g3432_i0 | PRJEB76780 | 3532 | 435 | 1.389503 | 6.04433805 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 71.2 | 3.32e-11 | NR | XP_044566377.1 | 5763 | g3432 | i0 | 50.9 | 0.937931034482759 | 57 | 27 | 38.6 | 1 | 268 | 435 | 4 | 60 | XP_044566377.1 uncharacterized protein FDP41_012321 [Naegleria fowleri] | diamond | 408 | 71.2 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 30571137 | 30571137 | PRJEB76780_P_NODE_9113_length_269_cov_1.193878_g9013_i0 | PRJEB76780 | 9113 | 269 | 1.193878 | 3.21153182 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 96.7 | 5.6e-21 | NR | XP_044550623.1 | 51637 | g9013 | i0 | 54 | 7.98513011152416 | 87 | 40 | 97 | 0 | 263 | 3 | 341 | 427 | XP_044550623.1 uncharacterized protein C9374_002375 [Naegleria lovaniensis] | diamond | 2148 | 96.7 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis | ||||
| 30911794 | 30911794 | PRJEB76780_P_NODE_10514_length_252_cov_1.307263_g10414_i0 | PRJEB76780 | 10514 | 252 | 1.307263 | 3.29430276 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 62.8 | 3.65e-9 | NR | XP_002683106.1 | 5762 | g10414 | i0 | 38.6 | 3.41666666666667 | 70 | 40 | 83.3 | 1 | 217 | 8 | 757 | 823 | XP_002683106.1 rap/ran GTPase-activating protein [Naegleria gruberi] | diamond | 861 | 62.8 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 31709365 | 31709365 | PRJEB76780_P_NODE_1957_length_593_cov_1.342308_g1858_i0 | PRJEB76780 | 1957 | 593 | 1.342308 | 7.95988644 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 121 | 6.55e-28 | NR | XP_044550991.1 | 51637 | g1858 | i0 | 34.9 | 0.971332209106239 | 192 | 114 | 96.6 | 2 | 2 | 574 | 496 | 677 | XP_044550991.1 uncharacterized protein C9374_002034 [Naegleria lovaniensis] | diamond | 576 | 121 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis | ||||
| 31867365 | 31867365 | PRJEB76780_P_NODE_8897_length_272_cov_1.356784_g8797_i0 | PRJEB76780 | 8897 | 272 | 1.356784 | 3.69045248 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 53.9 | 6.42e-6 | NR | XP_044549134.1 | 51637 | g8797 | i0 | 39.7 | 2.41544117647059 | 73 | 43 | 79.4 | 1 | 12 | 227 | 2949 | 3021 | XP_044549134.1 uncharacterized protein C9374_004126 [Naegleria lovaniensis] | diamond | 657 | 53.9 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis | ||||
| 31930684 | 31930684 | PRJEB76780_P_NODE_5817_length_336_cov_0.889734_g5717_i0 | PRJEB76780 | 5817 | 336 | 0.889734 | 2.98950624 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 141 | 3.02e-36 | NR | XP_044548230.1 | 51637 | g5717 | i0 | 65.1 | 1.9375 | 109 | 38 | 97.3 | 0 | 3 | 329 | 774 | 882 | XP_044548230.1 uncharacterized protein C9374_005131 [Naegleria lovaniensis] | diamond | 651 | 141 | 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);;