contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA478247" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22124223 | 22124223 | PRJNA478247_P_NODE_1418_length_317_cov_2.885417_g1312_i0 | PRJNA478247 | 1418 | 317 | 2.885417 | 9.14677189 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 132 | 9.89e-38 | NR | XP_002674291.1 | 5762 | g1312 | i0 | 69.4 | 4.94006309148265 | 85 | 26 | 80.4 | 0 | 280 | 26 | 1 | 85 | XP_002674291.1 uncharacterized protein NAEGRDRAFT_56264 [Naegleria gruberi] | diamond | 1566 | 132 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 26759627 | 26759627 | PRJNA478247_P_NODE_1521_length_303_cov_1.627737_g1415_i0 | PRJNA478247 | 1521 | 303 | 1.627737 | 4.93204311 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 71.6 | 5.01e-12 | NR | XP_044546071.1 | 51637 | g1415 | i0 | 59.7 | 2.65346534653465 | 67 | 17 | 62.4 | 2 | 193 | 5 | 320 | 380 | XP_044546071.1 uncharacterized protein C9374_007957 [Naegleria lovaniensis] | diamond | 804 | 71.6 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis | ||||
| 27234312 | 27234312 | PRJNA478247_P_NODE_2963_length_180_cov_1.668874_g2857_i0 | PRJNA478247 | 2963 | 180 | 1.668874 | 3.0039732 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 97.8 | 1.8299999999999994e-23 | NR | XP_044546126.1 | 51637 | g2857 | i0 | 79.7 | 0.983333333333333 | 59 | 12 | 98.3 | 0 | 4 | 180 | 1 | 59 | XP_044546126.1 uncharacterized protein C9374_008012 [Naegleria lovaniensis] | diamond | 177 | 97.8 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis | ||||
| 28055265 | 28055265 | PRJNA478247_P_NODE_2905_length_184_cov_1.167742_g2799_i0 | PRJNA478247 | 2905 | 184 | 1.167742 | 2.14864528 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 75.1 | 5.11e-14 | NR | KAL0481438.1 | 1008807 | g2799 | i0 | 55.7 | 0.994565217391304 | 61 | 27 | 99.5 | 0 | 183 | 1 | 251 | 311 | KAL0481438.1 hypothetical protein AKO1_012577 [Acrasis kona] | diamond | 183 | 75.1 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 29223828 | 29223828 | PRJNA478247_P_NODE_789_length_471_cov_8.914027_g684_i0 | PRJNA478247 | 789 | 471 | 8.914027 | 41.98506717 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 89.7 | 1.96e-19 | NR | KAL0484069.1 | 1008807 | g684 | i0 | 39.1 | 2.40764331210191 | 110 | 66 | 70.1 | 1 | 370 | 41 | 43 | 151 | KAL0484069.1 coactosin [Acrasis kona] | diamond | 1134 | 89.7 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 30329545 | 30329545 | PRJNA478247_P_NODE_2872_length_185_cov_2.512821_g2766_i0 | PRJNA478247 | 2872 | 185 | 2.512821 | 4.64871885 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 107 | 7.71e-29 | NR | CAG4714691.1 | 5763 | g2766 | i0 | 78.7 | 0.989189189189189 | 61 | 13 | 98.9 | 0 | 183 | 1 | 12 | 72 | CAG4714691.1 unnamed protein product [Naegleria fowleri] | diamond | 183 | 107 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 30676436 | 30676436 | PRJNA478247_P_NODE_73_length_1683_cov_7.877267_g46_i0 | PRJNA478247 | 73 | 1683 | 7.877267 | 132.57440361 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 151 | 2.8099999999999997e-35 | NR | XP_002672528.1 | 5762 | g46 | i0 | 27.2 | 0.903743315508021 | 507 | 319 | 85 | 16 | 209 | 1639 | 74 | 560 | XP_002672528.1 uncharacterized protein NAEGRDRAFT_59200 [Naegleria gruberi] | diamond | 1521 | 151 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 32067672 | 32067672 | PRJNA478247_P_NODE_3018_length_177_cov_1.702703_g2912_i0 | PRJNA478247 | 3018 | 177 | 1.702703 | 3.01378431 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 45.8 | 0.00124 | NR | XP_002675861.1 | 5762 | g2912 | i0 | 55.8 | 0.728813559322034 | 43 | 19 | 72.9 | 0 | 176 | 48 | 271 | 313 | XP_002675861.1 uncharacterized protein NAEGRDRAFT_68862 [Naegleria gruberi] | diamond | 129 | 45.8 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 32415972 | 32415972 | PRJNA478247_P_NODE_399_length_752_cov_5.526971_g313_i0 | PRJNA478247 | 399 | 752 | 5.526971 | 41.56282192 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 136 | 1.7e-32 | NR | XP_002669434.1 | 5762 | g313 | i0 | 56.2 | 0.482712765957447 | 121 | 48 | 47.5 | 5 | 43 | 399 | 896 | 1013 | XP_002669434.1 uncharacterized protein NAEGRDRAFT_82167 [Naegleria gruberi] | diamond | 363 | 136 | 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);;