contig_metadata
10 rows where bioproject = "PRJNA699078" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5786433 | 5786433 | PRJNA699078_S_NODE_89625_length_177_cov_0.984375_g88676_i0 | PRJNA699078 | 89625 | 177 | 0.984375 | 1.74234375 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 52.8 | 0.015 | NTclustered | gi|2124392370|ref|XM_044711932.1| | 5763 | g88676 | i0 | 100 | 0.31638418079096 | 28 | 0 | 16 | 0 | 22 | 49 | 687 | 660 | Naegleria fowleri uncharacterized protein (FDP41_008113), partial mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 7061209 | 7061209 | PRJNA699078_S_NODE_7046_length_543_cov_37.550607_g6191_i0 | PRJNA699078 | 7046 | 543 | 37.550607 | 203.89979601 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 149 | 1.5499999999999998e-42 | NR | XP_044555121.1 | 51637 | g6191 | i0 | 48.4 | 0.867403314917127 | 157 | 80 | 86.2 | 1 | 501 | 34 | 1 | 157 | XP_044555121.1 uncharacterized protein C9374_009804 [Naegleria lovaniensis] | diamond | 471 | 149 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis | ||||
| 18533662 | 18533662 | PRJNA699078_S_NODE_14795_length_417_cov_6.888587_g13857_i0 | PRJNA699078 | 14795 | 417 | 6.888587 | 28.72540779 | root | 1 | Root_unresolved | Root_unresolved | 177 | 1.31e-51 | NR | XP_044564599.1 | 5763 | g13857 | i0 | 62.9 | 86.6330935251799 | 124 | 46 | 89.2 | 0 | 26 | 397 | 252 | 375 | XP_044564599.1 uncharacterized protein FDP41_001039 [Naegleria fowleri] | diamond | 36126 | 177 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 26998880 | 26998880 | PRJNA699078_S_NODE_79702_length_188_cov_1.496403_g78753_i0 | PRJNA699078 | 79702 | 188 | 1.496403 | 2.81323764 | root | 1 | Root_unresolved | Root_unresolved | 83.6 | 6.89e-17 | NR | XP_002671353.1 | 5762 | g78753 | i0 | 56.5 | 7.73936170212766 | 62 | 27 | 98.9 | 0 | 1 | 186 | 314 | 375 | XP_002671353.1 uncharacterized protein NAEGRDRAFT_59458 [Naegleria gruberi] | diamond | 1455 | 84 | 0.995238095238095 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 28061773 | 28061773 | PRJNA699078_S_NODE_64205_length_211_cov_1.283951_g63256_i0 | PRJNA699078 | 64205 | 211 | 1.283951 | 2.70913661 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 58.5 | 5.26e-8 | NR | KAL0487918.1 | 1008807 | g63256 | i0 | 54.8 | 1.74881516587678 | 62 | 27 | 86.7 | 1 | 27 | 209 | 229 | 290 | KAL0487918.1 NAD+ synthase NadE [Acrasis kona] | diamond | 369 | 58.5 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 28156795 | 28156795 | PRJNA699078_S_NODE_44565_length_258_cov_1.244019_g43616_i0 | PRJNA699078 | 44565 | 258 | 1.244019 | 3.20956902 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 114 | 7.57e-28 | NR | KAL0479427.1 | 1008807 | g43616 | i0 | 62.3 | 1.7906976744186 | 77 | 29 | 89.5 | 0 | 258 | 28 | 298 | 374 | KAL0479427.1 serine/threonine kinase 4 [Acrasis kona] | diamond | 462 | 114 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 29356461 | 29356461 | PRJNA699078_S_NODE_77989_length_190_cov_1.843972_g77040_i0 | PRJNA699078 | 77989 | 190 | 1.843972 | 3.5035468 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 48.9 | 1.23e-4 | NR | XP_044541602.1 | 51637 | g77040 | i0 | 38.7 | 0.978947368421053 | 62 | 38 | 97.9 | 0 | 189 | 4 | 393 | 454 | XP_044541602.1 uncharacterized protein C9374_014280 [Naegleria lovaniensis] | diamond | 186 | 48.9 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis | ||||
| 30114244 | 30114244 | PRJNA699078_S_NODE_11932_length_450_cov_40.229426_g11010_i0 | PRJNA699078 | 11932 | 450 | 40.229426 | 181.032417 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 93.6 | 1.54e-19 | NR | KAL0483913.1 | 1008807 | g11010 | i0 | 40.7 | 0.9 | 135 | 74 | 88 | 2 | 450 | 55 | 196 | 327 | KAL0483913.1 ribosomal protein P0 [Acrasis kona] | diamond | 405 | 93.6 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 31611047 | 31611047 | PRJNA699078_S_NODE_73196_length_197_cov_1.054054_g72247_i0 | PRJNA699078 | 73196 | 197 | 1.054054 | 2.07648638 | Naegleria | 5761 | Heterolobosea | other_Eukaryota | 74.3 | 9.26e-14 | NR | XP_044556297.1 | 5763 | g72247 | i0 | 56.3 | 1.9492385786802 | 64 | 28 | 97.5 | 0 | 1 | 192 | 182 | 245 | XP_044556297.1 uncharacterized protein FDP41_010110 [Naegleria fowleri] | diamond | 384 | 74.3 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 32654257 | 32654257 | PRJNA699078_S_NODE_105540_length_163_cov_2.280702_g104591_i0 | PRJNA699078 | 105540 | 163 | 2.280702 | 3.71754426 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 52.8 | 3.68e-6 | NR | XP_002676377.1 | 5762 | g104591 | i0 | 59.6 | 7.50920245398773 | 47 | 17 | 84.7 | 2 | 156 | 19 | 432 | 477 | XP_002676377.1 uncharacterized protein NAEGRDRAFT_34178 [Naegleria gruberi] | diamond | 1224 | 52.8 | 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);;