contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA951810" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 936710 | 936710 | PRJNA951810_P_NODE_185561_length_225_cov_4.861842_g185216_i0 | PRJNA951810 | 185561 | 225 | 4.861842 | 10.9391445 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 361 | 2.9299999999999993e-95 | NTclustered | gi|290978665|ref|XM_002672010.1| | 5762 | g185216 | i0 | 96.347 | 3.97333333333333 | 219 | 8 | 97 | 0 | 7 | 225 | 82 | 300 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_82759), mRNA | blastn | 894 | 361 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 2211384 | 2211384 | PRJNA951810_P_NODE_144842_length_262_cov_2.677249_g144497_i0 | PRJNA951810 | 144842 | 262 | 2.677249 | 7.01439238 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 440 | 4.369999999999998e-119 | NTclustered | gi|290987322|ref|XM_002676326.1| | 5762 | g144497 | i0 | 96.947 | 1 | 262 | 8 | 100 | 0 | 1 | 262 | 102 | 363 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_36914), mRNA | blastn | 262 | 440 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 9864232 | 9864232 | PRJNA951810_P_NODE_153108_length_255_cov_5.692308_g152763_i0 | PRJNA951810 | 153108 | 255 | 5.692308 | 14.5153854 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 407 | 4.29e-109 | NTclustered | gi|290993020|ref|XM_002679086.1| | 5762 | g152763 | i0 | 95.669 | 3.38823529411765 | 254 | 10 | 99 | 1 | 1 | 253 | 473 | 726 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_79189), mRNA | blastn | 864 | 407 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 20062705 | 20062705 | PRJNA951810_P_NODE_141716_length_264_cov_5.193717_g141371_i0 | PRJNA951810 | 141716 | 264 | 5.193717 | 13.71141288 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 364 | 2.729999999999999e-96 | NTclustered | gi|290976150|ref|XM_002670758.1| | 5762 | g141371 | i0 | 92.52 | 4.96969696969697 | 254 | 19 | 96 | 0 | 1 | 254 | 1192 | 1445 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_81712), partial mRNA | blastn | 1312 | 364 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 20064971 | 20064971 | PRJNA951810_P_NODE_96216_length_295_cov_2.198198_g95872_i0 | PRJNA951810 | 96216 | 295 | 2.198198 | 6.4846841 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 396 | 1.0999999999999994e-105 | NTclustered | gi|2031940963|emb|OD957789.1| | 5763 | g95872 | i0 | 90.847 | 2.09491525423729 | 295 | 27 | 100 | 0 | 1 | 295 | 182 | 476 | Naegleria fowleri Karachi_NF001 strain | blastn | 618 | 396 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 23888448 | 23888448 | PRJNA951810_P_NODE_143319_length_263_cov_3.452632_g142974_i0 | PRJNA951810 | 143319 | 263 | 3.452632 | 9.08042216 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 169 | 2.28e-37 | NTclustered | gi|290991132|ref|XM_002678144.1| | 5762 | g142974 | i0 | 78.327 | 1.47908745247148 | 263 | 55 | 99 | 2 | 1 | 262 | 278 | 17 | Naegleria gruberi ribosomal protein L3 (NAEGRDRAFT_79448), mRNA | blastn | 389 | 169 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 25164307 | 25164307 | PRJNA951810_P_NODE_88180_length_298_cov_3.537778_g87836_i0 | PRJNA951810 | 88180 | 298 | 3.537778 | 10.54257844 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 444 | 3.91e-120 | NTclustered | gi|290979181|ref|XM_002672267.1| | 5762 | g87836 | i0 | 93.709 | 4.02013422818792 | 302 | 10 | 98 | 1 | 6 | 298 | 548 | 247 | Naegleria gruberi 40S ribosomal protein (NAEGRDRAFT_56310), mRNA | blastn | 1198 | 444 | 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);;