contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA685607" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3217242 | 3217242 | PRJNA685607_P_NODE_54623_length_269_cov_1.561224_g54264_i0 | PRJNA685607 | 54623 | 269 | 1.561224 | 4.19969256 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 438 | 1.6199999999999996e-118 | NTclustered | gi|290995331|ref|XM_002680203.1| | 5762 | g54264 | i0 | 96.255 | 3.88475836431227 | 267 | 10 | 99 | 0 | 1 | 267 | 202 | 468 | Naegleria gruberi 60S ribosomal protein L21 (NAEGRDRAFT_78822), mRNA | blastn | 1045 | 438 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 13420452 | 13420452 | PRJNA685607_P_NODE_92791_length_242_cov_0.911243_g92432_i0 | PRJNA685607 | 92791 | 242 | 0.911243 | 2.20520806 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 191 | 4.43e-44 | NTclustered | gi|290972987|ref|XM_002669186.1| | 5762 | g92432 | i0 | 81.739 | 3.92148760330579 | 230 | 40 | 95 | 2 | 1 | 229 | 263 | 35 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_56405), mRNA | blastn | 949 | 191 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 14695421 | 14695421 | PRJNA685607_P_NODE_8272_length_537_cov_1.788793_g7917_i0 | PRJNA685607 | 8272 | 537 | 1.788793 | 9.60581841 | Percolomonas cosmopolitus | 63605 | Heterolobosea | other_Eukaryota | 560 | 7.09e-155 | NTclustered | gi|33089879|gb|AY283748.1| | 63605 | g7917 | i0 | 86.127 | 97.4599627560521 | 519 | 72 | 97 | 0 | 19 | 537 | 781 | 263 | Percolomonas cosmopolitus isolate Gym67_1 actin gene, partial cds | blastn | 52336 | 560 | 1 | Eukaryota | Discoba | Heterolobosea | Percolomonadidae | Percolomonas | Percolomonas cosmopolitus | ||||
| 15969075 | 15969075 | PRJNA685607_P_NODE_62433_length_255_cov_1.269231_g62074_i0 | PRJNA685607 | 62433 | 255 | 1.269231 | 3.23653905 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 237 | 5.96e-58 | NTclustered | gi|290997451|ref|XM_002681249.1| | 5762 | g62074 | i0 | 85.043 | 0.917647058823529 | 234 | 33 | 91 | 2 | 2 | 234 | 419 | 187 | Naegleria gruberi S-phase kinase-associated protein (NAEGRDRAFT_82963), mRNA | blastn | 234 | 237 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 17244282 | 17244282 | PRJNA685607_P_NODE_45354_length_288_cov_0.902326_g44995_i0 | PRJNA685607 | 45354 | 288 | 0.902326 | 2.59869888 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 189 | 1.95e-43 | NTclustered | gi|290983699|ref|XM_002674520.1| | 5762 | g44995 | i0 | 83.838 | 0.6875 | 198 | 32 | 69 | 0 | 1 | 198 | 295 | 98 | Naegleria gruberi rab family small GTPase (NAEGRDRAFT_80594), mRNA | blastn | 198 | 189 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 19793405 | 19793405 | PRJNA685607_P_NODE_85956_length_244_cov_0.900585_g85597_i0 | PRJNA685607 | 85956 | 244 | 0.900585 | 2.1974274 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 327 | 3.27e-85 | NTclustered | gi|290985452|ref|XM_002675394.1| | 5762 | g85597 | i0 | 90.984 | 1 | 244 | 20 | 99 | 2 | 2 | 244 | 616 | 374 | Naegleria gruberi uncharacterized protein (NAEGRDRAFT_69403), partial mRNA | blastn | 244 | 327 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 22343512 | 22343512 | PRJNA685607_P_NODE_11918_length_459_cov_1.404145_g11561_i0 | PRJNA685607 | 11918 | 459 | 1.404145 | 6.44502555 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 383 | 1.3899999999999995e-101 | NTclustered | gi|2031924593|emb|OD955803.1| | 5763 | g11561 | i0 | 81.739 | 93.5555555555556 | 460 | 82 | 100 | 2 | 1 | 459 | 5271 | 5729 | Naegleria fowleri Karachi_NF001 strain | blastn | 42942 | 383 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 22343523 | 22343523 | PRJNA685607_P_NODE_1578_length_1297_cov_3.937092_g1392_i0 | PRJNA685607 | 1578 | 1297 | 3.937092 | 51.06408324 | Acrasis rosea | 43695 | Heterolobosea | other_Eukaryota | 1199 | 0 | NTclustered | gi|12083876|gb|AF190771.1|AF190771 | 43695 | g1392 | i0 | 84.866 | 59.9282960678489 | 1196 | 173 | 92 | 8 | 14 | 1205 | 1204 | 13 | Acrasis rosea elongation factor 1 alpha (tef1) gene, partial cds | blastn | 77727 | 1199 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis rosea | ||||
| 23619108 | 23619108 | PRJNA685607_P_NODE_15879_length_409_cov_1.446429_g15521_i0 | PRJNA685607 | 15879 | 409 | 1.446429 | 5.91589461 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 259 | 2.16e-64 | NTclustered | gi|290995758|ref|XM_002680404.1| | 5762 | g15521 | i0 | 81.098 | 14.6601466992665 | 328 | 58 | 95 | 4 | 77 | 402 | 844 | 519 | Naegleria gruberi mitochondrial F-1-ATPase subunit (NAEGRDRAFT_77267), mRNA | blastn | 5996 | 259 | 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);;