contig_metadata
6 rows where analysis = "diamond", bioproject = "PRJNA1240805" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24575810 | 24575810 | PRJNA1240805_P_NODE_7980_length_164_cov_1.773913_g7931_i0 | PRJNA1240805 | 7980 | 164 | 1.773913 | 2.90921732 | Naegleria | 5761 | Heterolobosea | other_Eukaryota | 70.9 | 1.53e-12 | NR | XP_044557931.1 | 5763 | g7931 | i0 | 82.5 | 2.14024390243902 | 40 | 7 | 73.2 | 0 | 42 | 161 | 196 | 235 | XP_044557931.1 uncharacterized protein FDP41_008425 [Naegleria fowleri] | diamond | 351 | 70.9 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 28021281 | 28021281 | PRJNA1240805_P_NODE_4365_length_219_cov_10.452941_g4316_i0 | PRJNA1240805 | 4365 | 219 | 10.452941 | 22.89194079 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 75.9 | 3.21e-14 | NR | XP_044565141.1 | 5763 | g4316 | i0 | 48.5 | 2.79452054794521 | 68 | 35 | 93.2 | 0 | 16 | 219 | 219 | 286 | XP_044565141.1 uncharacterized protein FDP41_013642 [Naegleria fowleri] | diamond | 612 | 75.9 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 28052624 | 28052624 | PRJNA1240805_P_NODE_4045_length_229_cov_8.888889_g3996_i0 | PRJNA1240805 | 4045 | 229 | 8.888889 | 20.35555581 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 90.1 | 4.81e-19 | NR | XP_044548650.1 | 51637 | g3996 | i0 | 62.3 | 0.903930131004367 | 69 | 26 | 90.4 | 0 | 23 | 229 | 358 | 426 | XP_044548650.1 uncharacterized protein C9374_004938 [Naegleria lovaniensis] | diamond | 207 | 90.1 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis | ||||
| 28747329 | 28747329 | PRJNA1240805_P_NODE_447_length_724_cov_1.597037_g411_i0 | PRJNA1240805 | 447 | 724 | 1.597037 | 11.56254788 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 67.4 | 5.05e-9 | NR | KAL0477121.1 | 1008807 | g411 | i0 | 32 | 0.505524861878453 | 122 | 80 | 50.6 | 2 | 318 | 683 | 208 | 326 | KAL0477121.1 CBP20 [Acrasis kona] | diamond | 366 | 67.4 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 31875085 | 31875085 | PRJNA1240805_P_NODE_6897_length_175_cov_1.484127_g6848_i0 | PRJNA1240805 | 6897 | 175 | 1.484127 | 2.59722225 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 46.6 | 3.7e-4 | NR | XP_044568412.1 | 5763 | g6848 | i0 | 48.1 | 0.891428571428571 | 52 | 25 | 85.7 | 1 | 152 | 3 | 59 | 110 | XP_044568412.1 uncharacterized protein FDP41_007614 [Naegleria fowleri] | diamond | 156 | 46.6 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 32019930 | 32019930 | PRJNA1240805_P_NODE_3838_length_236_cov_3.133690_g3789_i0 | PRJNA1240805 | 3838 | 236 | 3.13369 | 7.3955084 | Naegleria | 5761 | Heterolobosea | other_Eukaryota | 100 | 6.55e-23 | NR | XP_044568048.1 | 5763 | g3789 | i0 | 83.9 | 1.42372881355932 | 56 | 8 | 71.2 | 1 | 231 | 64 | 388 | 442 | XP_044568048.1 uncharacterized protein FDP41_010400 [Naegleria fowleri] | diamond | 336 | 100 | 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);;