contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA1086823" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23145813 | 23145813 | PRJNA1086823_P_NODE_10319_length_269_cov_2.362245_g10202_i0 | PRJNA1086823 | 10319 | 269 | 2.362245 | 6.35443905 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 182 | 2.29e-51 | NR | XP_002670292.1 | 5762 | g10202 | i0 | 93.3 | 2.97769516728625 | 89 | 6 | 99.3 | 0 | 3 | 269 | 662 | 750 | XP_002670292.1 uncharacterized protein NAEGRDRAFT_59731 [Naegleria gruberi] | diamond | 801 | 182 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 26592446 | 26592446 | PRJNA1086823_P_NODE_18561_length_243_cov_0.917647_g18444_i0 | PRJNA1086823 | 18561 | 243 | 0.917647 | 2.22988221 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 153 | 4.54e-41 | NR | XP_002671975.1 | 5762 | g18444 | i0 | 88.8 | 0.987654320987654 | 80 | 9 | 98.8 | 0 | 3 | 242 | 667 | 746 | XP_002671975.1 uncharacterized protein NAEGRDRAFT_52582 [Naegleria gruberi] | diamond | 240 | 153 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 27667908 | 27667908 | PRJNA1086823_P_NODE_14864_length_249_cov_0.886364_g14747_i0 | PRJNA1086823 | 14864 | 249 | 0.886364 | 2.20704636 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 72.4 | 1.4e-12 | NR | CAG4718155.1 | 5763 | g14747 | i0 | 44.4 | 1.89156626506024 | 81 | 32 | 97.6 | 1 | 248 | 6 | 504 | 571 | CAG4718155.1 unnamed protein product [Naegleria fowleri] | diamond | 471 | 72.4 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 27825733 | 27825733 | PRJNA1086823_P_NODE_18464_length_243_cov_0.917647_g18347_i0 | PRJNA1086823 | 18464 | 243 | 0.917647 | 2.22988221 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 45.4 | 0.00435 | NR | XP_044542611.1 | 51637 | g18347 | i0 | 55.8 | 0.530864197530864 | 43 | 19 | 53.1 | 0 | 129 | 1 | 989 | 1031 | XP_044542611.1 uncharacterized protein C9374_012176 [Naegleria lovaniensis] | diamond | 129 | 45.4 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis | ||||
| 29332638 | 29332638 | PRJNA1086823_P_NODE_17429_length_245_cov_0.906977_g17312_i0 | PRJNA1086823 | 17429 | 245 | 0.906977 | 2.22209365 | root | 1 | Root_unresolved | Root_unresolved | 91.7 | 2.3e-19 | NR | XP_044562231.1 | 5763 | g17312 | i0 | 48.2 | 7.23673469387755 | 85 | 33 | 95.5 | 3 | 12 | 245 | 547 | 627 | XP_044562231.1 uncharacterized protein FDP41_003510 [Naegleria fowleri] | diamond | 1773 | 91.7 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 30193777 | 30193777 | PRJNA1086823_P_NODE_16652_length_246_cov_0.901734_g16535_i0 | PRJNA1086823 | 16652 | 246 | 0.901734 | 2.21826564 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 81.6 | 7.71e-16 | NR | KAL0482681.1 | 1008807 | g16535 | i0 | 51.2 | 1.02439024390244 | 84 | 35 | 95.1 | 1 | 11 | 244 | 56 | 139 | KAL0482681.1 integrator complex subunit 7 [Acrasis kona] | diamond | 252 | 81.6 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 30383882 | 30383882 | PRJNA1086823_P_NODE_18933_length_242_cov_0.923077_g18816_i0 | PRJNA1086823 | 18933 | 242 | 0.923077 | 2.23384634 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 79.7 | 3.51e-15 | NR | XP_002682270.1 | 5762 | g18816 | i0 | 54.7 | 1.17768595041322 | 95 | 26 | 99.2 | 5 | 240 | 1 | 749 | 841 | XP_002682270.1 uncharacterized protein NAEGRDRAFT_45703 [Naegleria gruberi] | diamond | 285 | 79.7 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 31299799 | 31299799 | PRJNA1086823_P_NODE_19675_length_227_cov_2.025974_g19558_i0 | PRJNA1086823 | 19675 | 227 | 2.025974 | 4.59896098 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 60.5 | 1.73e-8 | NR | XP_002672549.1 | 5762 | g19558 | i0 | 43.1 | 0.859030837004405 | 65 | 37 | 85.9 | 0 | 195 | 1 | 44 | 108 | XP_002672549.1 uncharacterized protein NAEGRDRAFT_81217 [Naegleria gruberi] | diamond | 195 | 60.5 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 32185677 | 32185677 | PRJNA1086823_P_NODE_18398_length_243_cov_0.917647_g18281_i0 | PRJNA1086823 | 18398 | 243 | 0.917647 | 2.22988221 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 135 | 1.17e-36 | NR | XP_002672831.1 | 5762 | g18281 | i0 | 77.5 | 0.987654320987654 | 80 | 18 | 98.8 | 0 | 3 | 242 | 266 | 345 | XP_002672831.1 uncharacterized protein NAEGRDRAFT_72176 [Naegleria gruberi] | diamond | 240 | 135 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 32217289 | 32217289 | PRJNA1086823_P_NODE_11658_length_256_cov_1.409836_g11541_i0 | PRJNA1086823 | 11658 | 256 | 1.409836 | 3.60918016 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 121 | 4.35e-33 | NR | KAL0481681.1 | 1008807 | g11541 | i0 | 71.1 | 0.97265625 | 83 | 24 | 97.3 | 0 | 254 | 6 | 23 | 105 | KAL0481681.1 ribosomal protein S12 [Acrasis kona] | diamond | 249 | 121 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 32565561 | 32565561 | PRJNA1086823_P_NODE_15139_length_248_cov_0.891429_g15022_i0 | PRJNA1086823 | 15139 | 248 | 0.891429 | 2.21074392 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 132 | 8.67e-38 | NR | KAL0485755.1 | 1008807 | g15022 | i0 | 84 | 0.907258064516129 | 75 | 12 | 90.7 | 0 | 233 | 9 | 3 | 77 | KAL0485755.1 SWEET14 [Acrasis kona] | diamond | 225 | 132 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 32848609 | 32848609 | PRJNA1086823_P_NODE_4080_length_386_cov_2.562300_g3963_i0 | PRJNA1086823 | 4080 | 386 | 2.5623 | 9.890478 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 48.5 | 0.00181 | NR | XP_002673492.1 | 5762 | g3963 | i0 | 31.1 | 0.924870466321243 | 119 | 68 | 82.4 | 3 | 46 | 363 | 182 | 299 | XP_002673492.1 uncharacterized protein NAEGRDRAFT_71475 [Naegleria gruberi] | diamond | 357 | 48.5 | 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);;