contig_metadata
10 rows where analysis = "diamond", bioproject = "PRJNA493244" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1732662 | 1732662 | PRJNA493244_P_NODE_975802_length_417_cov_14.901685_g952735_i0 | PRJNA493244 | 975802 | 417 | 14.901685 | 62.14002645 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 114 | 3.9999999999999994e-28 | NR | KAL0488965.1 | 1008807 | g952735 | i0 | 52.6 | 0.683453237410072 | 95 | 45 | 68.3 | 0 | 126 | 410 | 153 | 247 | KAL0488965.1 Ras-related protein Rac [Acrasis kona] | diamond | 285 | 114 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 10659156 | 10659156 | PRJNA493244_P_NODE_1335449_length_286_cov_2.693333_g1312325_i0 | PRJNA493244 | 1335449 | 286 | 2.693333 | 7.70293238 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 115 | 5.88e-28 | NR | KAL0486315.1 | 1008807 | g1312325 | i0 | 66.7 | 4.65734265734266 | 78 | 26 | 81.8 | 0 | 274 | 41 | 345 | 422 | KAL0486315.1 2-amino-3-ketobutyrate coenzyme A ligase [Acrasis kona] | diamond | 1332 | 115 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 10660963 | 10660963 | PRJNA493244_P_NODE_572349_length_663_cov_17.272425_g551123_i0 | PRJNA493244 | 572349 | 663 | 17.272425 | 114.51617775 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 86.7 | 8.13e-17 | NR | XP_044547733.1 | 51637 | g551123 | i0 | 57.1 | 1 | 77 | 33 | 34.8 | 0 | 482 | 252 | 120 | 196 | XP_044547733.1 uncharacterized protein C9374_005846 [Naegleria lovaniensis] | diamond | 663 | 87.4 | 0.991990846681922 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis | ||||
| 17032983 | 17032983 | PRJNA493244_P_NODE_1439374_length_258_cov_1.299492_g1416249_i0 | PRJNA493244 | 1439374 | 258 | 1.299492 | 3.35268936 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 131 | 3.76e-35 | NR | KAL0491511.1 | 1008807 | g1416249 | i0 | 74.4 | 0.953488372093023 | 82 | 20 | 94.2 | 1 | 257 | 15 | 223 | 304 | KAL0491511.1 hypothetical protein AKO1_004011 [Acrasis kona] | diamond | 246 | 131 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 26759807 | 26759807 | PRJNA493244_P_NODE_1176101_length_337_cov_2.402174_g1152977_i0 | PRJNA493244 | 1176101 | 337 | 2.402174 | 8.09532638 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 108 | 1.4e-26 | NR | NP_066534.1 | 5762 | g1152977 | i0 | 57.5 | 0.943620178041543 | 106 | 45 | 94.4 | 0 | 2 | 319 | 92 | 197 | NP_066534.1 ATP synthase F0 subunit 6 [Naegleria gruberi] | diamond | 318 | 108 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 28529383 | 28529383 | PRJNA493244_P_NODE_1224947_length_320_cov_3.915058_g1201823_i0 | PRJNA493244 | 1224947 | 320 | 3.915058 | 12.5281856 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 102 | 4.13e-23 | NR | KAL0490020.1 | 1008807 | g1201823 | i0 | 51 | 0.95625 | 102 | 48 | 93.8 | 1 | 6 | 305 | 350 | 451 | KAL0490020.1 INO80 complex subunit D [Acrasis kona] | diamond | 306 | 102 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 29318444 | 29318444 | PRJNA493244_P_NODE_1109589_length_361_cov_11.010000_g1086467_i0 | PRJNA493244 | 1109589 | 361 | 11.01 | 39.7461 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 57.8 | 7.77e-7 | NR | KAL0478130.1 | 1008807 | g1086467 | i0 | 39.5 | 1.33795013850416 | 86 | 48 | 69 | 2 | 335 | 87 | 1038 | 1122 | KAL0478130.1 myosin [Acrasis kona] | diamond | 483 | 57.8 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 29350174 | 29350174 | PRJNA493244_P_NODE_1147049_length_347_cov_14.398601_g1123926_i0 | PRJNA493244 | 1147049 | 347 | 14.398601 | 49.96314547 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 54.3 | 8.54e-6 | NR | XP_002678540.1 | 5762 | g1123926 | i0 | 42.6 | 0.406340057636888 | 47 | 27 | 40.6 | 0 | 103 | 243 | 228 | 274 | XP_002678540.1 uncharacterized protein NAEGRDRAFT_48200 [Naegleria gruberi] | diamond | 141 | 54.3 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 29902992 | 29902992 | PRJNA493244_P_NODE_1562771_length_228_cov_5.485030_g1539646_i0 | PRJNA493244 | 1562771 | 228 | 5.48503 | 12.5058684 | Naegleria | 5761 | Heterolobosea | other_Eukaryota | 73.2 | 7.41e-14 | NR | XP_002679583.1 | 5762 | g1539646 | i0 | 77.3 | 1.73684210526316 | 44 | 10 | 57.9 | 0 | 95 | 226 | 97 | 140 | XP_002679583.1 uncharacterized protein NAEGRDRAFT_38480 [Naegleria gruberi] | diamond | 396 | 73.6 | 0.994565217391304 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 30518808 | 30518808 | PRJNA493244_P_NODE_663693_length_593_cov_4.951128_g641650_i0 | PRJNA493244 | 663693 | 593 | 4.951128 | 29.36018904 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 107 | 6.469999999999999e-23 | NR | XP_002672121.1 | 5762 | g641650 | i0 | 53 | 1.00674536256324 | 100 | 44 | 49.1 | 2 | 302 | 592 | 467 | 566 | XP_002672121.1 uncharacterized protein NAEGRDRAFT_44754 [Naegleria gruberi] | diamond | 597 | 107 | 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);;