contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA340009" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27074677 | 27074677 | PRJNA340009_P_NODE_50282_length_183_cov_1.522388_g49975_i0 | PRJNA340009 | 50282 | 183 | 1.522388 | 2.78597004 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 49.3 | 8.43e-5 | NR | XP_044552309.1 | 51637 | g49975 | i0 | 51.6 | 2.08196721311475 | 62 | 18 | 85.2 | 3 | 174 | 19 | 443 | 502 | XP_044552309.1 uncharacterized protein C9374_000481 [Naegleria lovaniensis] | diamond | 381 | 49.3 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis | ||||
| 27408235 | 27408235 | PRJNA340009_P_NODE_33383_length_217_cov_2.119048_g33076_i0 | PRJNA340009 | 33383 | 217 | 2.119048 | 4.59833416 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 57 | 1.42e-7 | NR | XP_044541499.1 | 51637 | g33076 | i0 | 44.6 | 3.09677419354839 | 56 | 23 | 77.4 | 1 | 197 | 30 | 101 | 148 | XP_044541499.1 uncharacterized protein C9374_014719 [Naegleria lovaniensis] | diamond | 672 | 57.4 | 0.993031358885017 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis | ||||
| 28039563 | 28039563 | PRJNA340009_P_NODE_7805_length_399_cov_115.297143_g7498_i0 | PRJNA340009 | 7805 | 399 | 115.297143 | 460.03560057 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 49.7 | 5.04e-4 | NR | KAL0489646.1 | 1008807 | g7498 | i0 | 26.9 | 1.69172932330827 | 108 | 66 | 81.2 | 1 | 7 | 330 | 98 | 192 | KAL0489646.1 5 TM domain-containing transmembrane protein [Acrasis kona] | diamond | 675 | 49.7 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 28053745 | 28053745 | PRJNA340009_P_NODE_69365_length_164_cov_0.886957_g69058_i0 | PRJNA340009 | 69365 | 164 | 0.886957 | 1.45460948 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 76.3 | 1.94e-14 | NR | XP_002677578.1 | 5762 | g69058 | i0 | 66.7 | 0.98780487804878 | 54 | 17 | 98.8 | 1 | 2 | 163 | 649 | 701 | XP_002677578.1 uncharacterized protein NAEGRDRAFT_67181 [Naegleria gruberi] | diamond | 162 | 76.3 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 28481543 | 28481543 | PRJNA340009_P_NODE_62066_length_167_cov_0.864407_g61759_i0 | PRJNA340009 | 62066 | 167 | 0.864407 | 1.44355969 | Naegleria | 5761 | Heterolobosea | other_Eukaryota | 100 | 5.2499999999999996e-23 | NR | XP_002671295.1 | 5762 | g61759 | i0 | 87.3 | 1.97604790419162 | 55 | 7 | 98.8 | 0 | 167 | 3 | 382 | 436 | XP_002671295.1 uncharacterized protein NAEGRDRAFT_81548 [Naegleria gruberi] | diamond | 330 | 100 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 29663740 | 29663740 | PRJNA340009_P_NODE_41570_length_198_cov_1.369128_g41263_i0 | PRJNA340009 | 41570 | 198 | 1.369128 | 2.71087344 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 131 | 1.04e-34 | NR | XP_002676173.1 | 5762 | g41263 | i0 | 84.6 | 0.984848484848485 | 65 | 10 | 98.5 | 0 | 2 | 196 | 33 | 97 | XP_002676173.1 uncharacterized protein NAEGRDRAFT_34255, partial [Naegleria gruberi] | diamond | 195 | 131 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 30391144 | 30391144 | PRJNA340009_P_NODE_64233_length_166_cov_0.871795_g63926_i0 | PRJNA340009 | 64233 | 166 | 0.871795 | 1.4471797 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 57.4 | 9.01e-8 | NR | KAL0491759.1 | 1008807 | g63926 | i0 | 58.5 | 0.740963855421687 | 41 | 17 | 74.1 | 0 | 8 | 130 | 286 | 326 | KAL0491759.1 acylamino-acid-releasing enzyme [Acrasis kona] | diamond | 123 | 57.4 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 30517016 | 30517016 | PRJNA340009_P_NODE_10773_length_351_cov_1.582781_g10466_i0 | PRJNA340009 | 10773 | 351 | 1.582781 | 5.55556131 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 92 | 3.87e-19 | NR | KAL0476852.1 | 1008807 | g10466 | i0 | 64.5 | 2.76068376068376 | 62 | 22 | 53 | 0 | 197 | 12 | 47 | 108 | KAL0476852.1 branched-chain amino acid aminotransferase [Acrasis kona] | diamond | 969 | 92 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 31022671 | 31022671 | PRJNA340009_P_NODE_73975_length_162_cov_0.902655_g73668_i0 | PRJNA340009 | 73975 | 162 | 0.902655 | 1.4623011 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 101 | 3.1e-23 | NR | XP_002668942.1 | 5762 | g73668 | i0 | 92.5 | 1.94444444444444 | 53 | 4 | 98.1 | 0 | 159 | 1 | 1808 | 1860 | XP_002668942.1 uncharacterized protein NAEGRDRAFT_82279 [Naegleria gruberi] | diamond | 315 | 101 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 31338605 | 31338605 | PRJNA340009_P_NODE_58056_length_172_cov_1.268293_g57749_i0 | PRJNA340009 | 58056 | 172 | 1.268293 | 2.18146396 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 73.9 | 1.36e-13 | NR | XP_044547121.1 | 51637 | g57749 | i0 | 61.1 | 0.941860465116279 | 54 | 21 | 94.2 | 0 | 164 | 3 | 178 | 231 | XP_044547121.1 uncharacterized protein C9374_006430 [Naegleria lovaniensis] | diamond | 162 | 73.9 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis | ||||
| 31370529 | 31370529 | PRJNA340009_P_NODE_39976_length_201_cov_2.348684_g39669_i0 | PRJNA340009 | 39976 | 201 | 2.348684 | 4.72085484 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 92.8 | 4.93e-20 | NR | XP_044544910.1 | 51637 | g39669 | i0 | 68.2 | 1.97014925373134 | 66 | 21 | 98.5 | 0 | 3 | 200 | 612 | 677 | XP_044544910.1 uncharacterized protein C9374_009164 [Naegleria lovaniensis] | diamond | 396 | 92.8 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis | ||||
| 31370554 | 31370554 | PRJNA340009_P_NODE_64876_length_166_cov_0.871795_g64569_i0 | PRJNA340009 | 64876 | 166 | 0.871795 | 1.4471797 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 82 | 1.88e-16 | NR | XP_002670028.1 | 5762 | g64569 | i0 | 80 | 0.993975903614458 | 55 | 10 | 99.4 | 1 | 1 | 165 | 258 | 311 | XP_002670028.1 uncharacterized protein NAEGRDRAFT_75062 [Naegleria gruberi] | diamond | 165 | 82 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 31591887 | 31591887 | PRJNA340009_P_NODE_39076_length_203_cov_2.123377_g38769_i0 | PRJNA340009 | 39076 | 203 | 2.123377 | 4.31045531 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 128 | 1.4e-32 | NR | XP_002675454.1 | 5762 | g38769 | i0 | 89.6 | 0.990147783251232 | 67 | 7 | 99 | 0 | 203 | 3 | 1698 | 1764 | XP_002675454.1 uncharacterized protein NAEGRDRAFT_80324 [Naegleria gruberi] | diamond | 201 | 128 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 31907997 | 31907997 | PRJNA340009_P_NODE_40357_length_200_cov_4.026490_g40050_i0 | PRJNA340009 | 40357 | 200 | 4.02649 | 8.05298 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 75.1 | 2.52e-14 | NR | XP_002675091.1 | 5762 | g40050 | i0 | 72.7 | 0.99 | 66 | 16 | 97.5 | 2 | 2 | 196 | 143 | 207 | XP_002675091.1 uncharacterized protein NAEGRDRAFT_50483 [Naegleria gruberi] | diamond | 198 | 75.1 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 32034621 | 32034621 | PRJNA340009_P_NODE_66538_length_165_cov_0.879310_g66231_i0 | PRJNA340009 | 66538 | 165 | 0.87931 | 1.4508615 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 67.4 | 2.67e-11 | NR | XP_044568923.1 | 5763 | g66231 | i0 | 57.4 | 1.98181818181818 | 54 | 23 | 98.2 | 0 | 1 | 162 | 116 | 169 | XP_044568923.1 uncharacterized protein FDP41_007387 [Naegleria fowleri] | diamond | 327 | 67.4 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri |
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);;