contig_metadata
10 rows where bioproject = "PRJNA315399", tax_clade = "Discoba" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2931892 | 2931892 | PRJNA315399_P_NODE_118683_length_194_cov_55.611465_g118235_i0 | PRJNA315399 | 118683 | 194 | 55.611465 | 107.8862421 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 191 | 3.3999999999999997e-44 | NTclustered | gi|2031941228|emb|OD957855.1| | 5763 | g118235 | i0 | 93.75 | 1.31958762886598 | 128 | 7 | 66 | 1 | 9 | 136 | 273 | 399 | Naegleria fowleri Karachi_NF001 strain | blastn | 256 | 191 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 4212689 | 4212689 | PRJNA315399_S_NODE_52824_length_211_cov_37.982759_g52623_i0 | PRJNA315399 | 52824 | 211 | 37.982759 | 80.14362149 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 93.5 | 1.09e-14 | NTclustered | gi|2031938551|emb|OD957402.1| | 5763 | g52623 | i0 | 100 | 7.30331753554502 | 50 | 0 | 24 | 0 | 162 | 211 | 2020 | 2069 | Naegleria fowleri Karachi_NF001 strain | blastn | 1541 | 93.5 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 9310278 | 9310278 | PRJNA315399_P_NODE_27468_length_276_cov_36.184100_g27023_i0 | PRJNA315399 | 27468 | 276 | 36.1841 | 99.868116 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 202 | 2.38e-47 | NTclustered | gi|2031941228|emb|OD957855.1| | 5763 | g27023 | i0 | 92.308 | 1.03985507246377 | 143 | 10 | 52 | 1 | 9 | 151 | 273 | 414 | Naegleria fowleri Karachi_NF001 strain | blastn | 287 | 202 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 10587880 | 10587880 | PRJNA315399_P_NODE_96949_length_202_cov_17.472727_g96501_i0 | PRJNA315399 | 96949 | 202 | 17.472727 | 35.29490854 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 132 | 2.2e-26 | NTclustered | gi|2031940710|emb|OD957740.1| | 5763 | g96501 | i0 | 82.993 | 0.727722772277228 | 147 | 23 | 72 | 2 | 4 | 149 | 286 | 431 | Naegleria fowleri Karachi_NF001 strain | blastn | 147 | 132 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 13819837 | 13819837 | PRJNA315399_P_NODE_86371_length_207_cov_14.676471_g85923_i0 | PRJNA315399 | 86371 | 207 | 14.676471 | 30.38029497 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 67.6 | 6.47e-7 | NTclustered | gi|2031937503|emb|OD957242.1| | 5763 | g85923 | i0 | 100 | 51.7246376811594 | 36 | 0 | 17 | 0 | 172 | 207 | 1844 | 1879 | Naegleria fowleri Karachi_NF001 strain | blastn | 10707 | 67.6 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 14411169 | 14411169 | PRJNA315399_P_NODE_268432_length_180_cov_7.034965_g267984_i0 | PRJNA315399 | 268432 | 180 | 7.034965 | 12.662937 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 95.3 | 2.5e-15 | NTclustered | gi|2031939451|emb|OD957552.1| | 5763 | g267984 | i0 | 89.333 | 198.838888888889 | 75 | 8 | 83 | 0 | 4 | 78 | 415 | 489 | Naegleria fowleri Karachi_NF001 strain | blastn | 35791 | 95.3 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 14411342 | 14411342 | PRJNA315399_P_NODE_297972_length_179_cov_2.704225_g297524_i0 | PRJNA315399 | 297972 | 179 | 2.704225 | 4.84056275 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 86.1 | 1.5e-12 | NTclustered | gi|2031942078|emb|OD958043.1| | 5763 | g297524 | i0 | 88.571 | 1.68715083798883 | 70 | 8 | 39 | 0 | 104 | 173 | 87 | 18 | Naegleria fowleri Karachi_NF001 strain | blastn | 302 | 86.1 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 20785576 | 20785576 | PRJNA315399_S_NODE_100277_length_178_cov_5.092199_g100076_i0 | PRJNA315399 | 100277 | 178 | 5.092199 | 9.06411422 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 265 | 1.78e-66 | NTclustered | gi|2031940963|emb|OD957789.1| | 5763 | g100076 | i0 | 95.238 | 0.943820224719101 | 168 | 6 | 93 | 2 | 13 | 178 | 316 | 149 | Naegleria fowleri Karachi_NF001 strain | blastn | 168 | 265 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 24607899 | 24607899 | PRJNA315399_P_NODE_190400_length_185_cov_7.277027_g189952_i0 | PRJNA315399 | 190400 | 185 | 7.277027 | 13.46249995 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 110 | 9.24e-20 | NTclustered | gi|2031939004|emb|OD957472.1| | 5763 | g189952 | i0 | 94.366 | 36.5567567567568 | 71 | 4 | 38 | 0 | 94 | 164 | 653 | 723 | Naegleria fowleri Karachi_NF001 strain | blastn | 6763 | 110 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 24608420 | 24608420 | PRJNA315399_P_NODE_27460_length_276_cov_922.903766_g27015_i0 | PRJNA315399 | 27460 | 276 | 922.903766 | 2547.21439416 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 110 | 1.48e-19 | NTclustered | gi|290983097|ref|XM_002674220.1| | 5762 | g27015 | i0 | 100 | 0.590579710144927 | 59 | 0 | 57 | 0 | 108 | 166 | 86 | 144 | Naegleria gruberi iron hydrogenase (NAEGRDRAFT_80699), mRNA | blastn | 163 | 110 | 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);;