contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA1240805" and tax_clade = "Discoba"
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 | ||||
| 26724953 | 26724953 | PRJNA1240805_P_NODE_2041_length_338_cov_7.204152_g1992_i0 | PRJNA1240805 | 2041 | 338 | 7.204152 | 24.35003376 | Euglena gracilis | 3039 | Euglenozoa | other_Eukaryota | 111 | 4.509999999999999e-28 | NR | QLA09622.1 | 3039 | g1992 | i0 | 62.8 | 0.763313609467456 | 86 | 29 | 73.7 | 1 | 28 | 276 | 97 | 182 | QLA09622.1 60S large subunit ribosomal protein eL18 [Euglena gracilis] | diamond | 258 | 111 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Euglenales | Euglenaceae | Euglena | Euglena gracilis | ||
| 26820590 | 26820590 | PRJNA1240805_P_NODE_5361_length_197_cov_4.506757_g5312_i0 | PRJNA1240805 | 5361 | 197 | 4.506757 | 8.87831129 | Diplonema papillatum | 91374 | Euglenozoa | other_Eukaryota | 52.8 | 9.31e-7 | NR | KAJ9462441.1 | 91374 | g5312 | i0 | 71.9 | 5.36040609137056 | 32 | 9 | 48.7 | 0 | 23 | 118 | 87 | 118 | KAJ9462441.1 60S ribosomal protein L35a [Diplonema papillatum] | diamond | 1056 | 52.8 | 1 | Eukaryota | Discoba | Euglenozoa | Diplonemea | Diplonemidae | Diplonema | Diplonema papillatum | |||
| 27579034 | 27579034 | PRJNA1240805_P_NODE_5144_length_201_cov_9.986842_g5095_i0 | PRJNA1240805 | 5144 | 201 | 9.986842 | 20.07355242 | Euglena gracilis | 3039 | Euglenozoa | other_Eukaryota | 82.4 | 7.35e-19 | NR | QLA09593.1 | 3039 | g5095 | i0 | 97.6 | 0.611940298507463 | 41 | 1 | 61.2 | 0 | 24 | 146 | 36 | 76 | QLA09593.1 40S small subunit ribosomal protein eS28 [Euglena gracilis] | diamond | 123 | 82.4 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Euglenales | Euglenaceae | Euglena | Euglena gracilis | ||
| 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 | ||||
| 29031721 | 29031721 | PRJNA1240805_P_NODE_4008_length_230_cov_8.502762_g3959_i0 | PRJNA1240805 | 4008 | 230 | 8.502762 | 19.5563526 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 62 | 3.27e-10 | NR | CUG91869.1 | 75058 | g3959 | i0 | 43.3 | 2.49130434782609 | 67 | 37 | 86.1 | 1 | 217 | 20 | 49 | 115 | CUG91869.1 coatamer zeta subunit, putative [Bodo saltans] | diamond | 573 | 62 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 29712264 | 29712264 | PRJNA1240805_P_NODE_6530_length_179_cov_3.138462_g6481_i0 | PRJNA1240805 | 6530 | 179 | 3.138462 | 5.61784698 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 55.1 | 7e-7 | NR | NP_044753.1 | 48483 | g6481 | i0 | 40.4 | 7.49162011173184 | 57 | 34 | 95.5 | 0 | 174 | 4 | 228 | 284 | NP_044753.1 NADH dehydrogenase subunit 11 [Reclinomonas americana] | diamond | 1341 | 55.5 | 0.992792792792793 | Eukaryota | Discoba | Jakobida | Histionidae | Reclinomonas | Reclinomonas americana | ||||
| 31559130 | 31559130 | PRJNA1240805_P_NODE_7096_length_173_cov_1.435484_g7047_i0 | PRJNA1240805 | 7096 | 173 | 1.435484 | 2.48338732 | Diplonema papillatum | 91374 | Euglenozoa | other_Eukaryota | 51.6 | 1.08e-5 | NR | KAJ9468081.1 | 91374 | g7047 | i0 | 63.2 | 7.5606936416185 | 38 | 14 | 65.9 | 0 | 60 | 173 | 116 | 153 | KAJ9468081.1 member 9 [Diplonema papillatum] | diamond | 1308 | 51.6 | 1 | Eukaryota | Discoba | Euglenozoa | Diplonemea | Diplonemidae | Diplonema | Diplonema papillatum | |||
| 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 | ||||
| 32886003 | 32886003 | PRJNA1240805_P_NODE_3740_length_239_cov_2.705263_g3691_i0 | PRJNA1240805 | 3740 | 239 | 2.705263 | 6.46557857 | Euglena gracilis | 3039 | Euglenozoa | other_Eukaryota | 69.3 | 1.78e-12 | NR | Q84TU6.1 | 3039 | g3691 | i0 | 88.6 | 0.439330543933054 | 35 | 4 | 43.9 | 0 | 230 | 126 | 139 | 173 | Q84TU6.1 RecName: Full=Cytochrome b6-f complex subunit 4, chloroplastic; AltName: Full=17 kDa polypeptide; Flags: Precursor [Euglena gracilis] | diamond | 105 | 69.3 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Euglenales | Euglenaceae | Euglena | Euglena gracilis |
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);;