contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJNA1002816" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11631485 | 11631485 | PRJNA1002816_P_NODE_19890_length_244_cov_0.900585_g19730_i0 | PRJNA1002816 | 19890 | 244 | 0.900585 | 2.1974274 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 130 | 6.089999999999999e-37 | NR | XP_044550136.1 | 51637 | g19730 | i0 | 73.8 | 1.9672131147541 | 80 | 21 | 98.4 | 0 | 242 | 3 | 10 | 89 | XP_044550136.1 uncharacterized protein C9374_002589 [Naegleria lovaniensis] | diamond | 480 | 130 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis | ||||
| 26971022 | 26971022 | PRJNA1002816_P_NODE_20862_length_241_cov_0.916667_g20702_i0 | PRJNA1002816 | 20862 | 241 | 0.916667 | 2.20916747 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 93.2 | 6.45e-20 | NR | XP_002676675.1 | 5762 | g20702 | i0 | 68.8 | 0.995850622406639 | 80 | 25 | 99.6 | 0 | 241 | 2 | 375 | 454 | XP_002676675.1 uncharacterized protein NAEGRDRAFT_79978 [Naegleria gruberi] | diamond | 240 | 93.2 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 28582107 | 28582107 | PRJNA1002816_P_NODE_18627_length_248_cov_0.880000_g18467_i0 | PRJNA1002816 | 18627 | 248 | 0.88 | 2.1824 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 154 | 8.569999999999999e-46 | NR | XP_002673923.1 | 5762 | g18467 | i0 | 92.6 | 0.979838709677419 | 81 | 6 | 98 | 0 | 5 | 247 | 2 | 82 | XP_002673923.1 uncharacterized protein NAEGRDRAFT_70971 [Naegleria gruberi] | diamond | 243 | 154 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 29465621 | 29465621 | PRJNA1002816_P_NODE_16150_length_267_cov_1.237113_g15990_i0 | PRJNA1002816 | 16150 | 267 | 1.237113 | 3.30309171 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 132 | 5.56e-35 | NR | KAL0484046.1 | 1008807 | g15990 | i0 | 70.1 | 8.91011235955056 | 87 | 26 | 97.8 | 0 | 1 | 261 | 28 | 114 | KAL0484046.1 peptidyl-prolyl cis-trans isomerase [Acrasis kona] | diamond | 2379 | 132 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 31045830 | 31045830 | PRJNA1002816_P_NODE_18915_length_247_cov_0.885057_g18755_i0 | PRJNA1002816 | 18915 | 247 | 0.885057 | 2.18609079 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 74.7 | 4.7e-15 | NR | XP_044562392.1 | 5763 | g18755 | i0 | 46.7 | 0.910931174089069 | 75 | 40 | 91.1 | 0 | 246 | 22 | 11 | 85 | XP_044562392.1 uncharacterized protein FDP41_003001 [Naegleria fowleri] | diamond | 225 | 74.7 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 31393430 | 31393430 | PRJNA1002816_P_NODE_20196_length_243_cov_0.905882_g20036_i0 | PRJNA1002816 | 20196 | 243 | 0.905882 | 2.20129326 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 84.7 | 4.53e-17 | NR | XP_044556144.1 | 51637 | g20036 | i0 | 46.4 | 1.03703703703704 | 84 | 35 | 91.4 | 1 | 224 | 3 | 69 | 152 | XP_044556144.1 uncharacterized protein C9374_004014 [Naegleria lovaniensis] | diamond | 252 | 84.7 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis | ||||
| 31867567 | 31867567 | PRJNA1002816_P_NODE_16137_length_267_cov_1.489691_g15977_i0 | PRJNA1002816 | 16137 | 267 | 1.489691 | 3.97747497 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 119 | 1.31e-29 | NR | KAL0478923.1 | 1008807 | g15977 | i0 | 81.5 | 0.730337078651685 | 65 | 12 | 73 | 0 | 197 | 3 | 8 | 72 | KAL0478923.1 hypothetical protein AKO1_007806 [Acrasis kona] | diamond | 195 | 119 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 32595414 | 32595414 | PRJNA1002816_P_NODE_15200_length_278_cov_1.502439_g15040_i0 | PRJNA1002816 | 15200 | 278 | 1.502439 | 4.17678042 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 97.4 | 6.89e-23 | NR | XP_002677475.1 | 5762 | g15040 | i0 | 65.2 | 0.712230215827338 | 66 | 23 | 71.2 | 0 | 3 | 200 | 138 | 203 | XP_002677475.1 uncharacterized protein NAEGRDRAFT_48805 [Naegleria gruberi] | diamond | 198 | 97.4 | 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);;