contig_metadata
11 rows where bioproject = "PRJNA745553" and tax_phylum = "Cercozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 723979 | 723979 | PRJNA745553_S_NODE_10461_length_375_cov_8.715232_g10266_i0 | PRJNA745553 | 10461 | 375 | 8.715232 | 32.68212 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 387 | 8.609999999999998e-103 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g10266 | i0 | 85.526 | 60.6506666666667 | 380 | 44 | 100 | 11 | 1 | 375 | 4037 | 3664 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 22744 | 387 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 2000195 | 2000195 | PRJNA745553_S_NODE_19122_length_282_cov_10.789474_g18927_i0 | PRJNA745553 | 19122 | 282 | 10.789474 | 30.42631668 | Bodomorpha sp. HFCC56 | 352464 | SAR_Eukaryotes | SAR_Eukaryotes | 505 | 1.6599999999999995e-138 | NTclustered | gi|83034974|gb|DQ211603.1| | 352464 | g18927 | i0 | 98.936 | 98.0354609929078 | 282 | 3 | 100 | 0 | 1 | 282 | 301 | 582 | Bodomorpha sp. HFCC56 28S ribosomal RNA gene, partial sequence | blastn | 27646 | 505 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha sp. HFCC56 | |||
| 6302748 | 6302748 | PRJNA745553_S_NODE_5325_length_493_cov_5.278571_g5131_i0 | PRJNA745553 | 5325 | 493 | 5.278571 | 26.02335503 | Sandona | 1239209 | SAR_Eukaryotes | SAR_Eukaryotes | 905 | 0 | NTclustered | gi|219524777|gb|EU709140.1| | 563752 | g5131 | i0 | 99.797 | 100.062880324544 | 493 | 1 | 100 | 0 | 1 | 493 | 1087 | 595 | Cercozoa sp. G11 18S ribosomal RNA gene, partial sequence | blastn | 49331 | 905 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. G11 | ||||||
| 8851712 | 8851712 | PRJNA745553_S_NODE_27067_length_239_cov_3.487952_g26872_i0 | PRJNA745553 | 27067 | 239 | 3.487952 | 8.33620528 | Imbricatea | 1736114 | SAR_Eukaryotes | SAR_Eukaryotes | 209 | 1.2e-49 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g26872 | i0 | 96.124 | 49.4393305439331 | 129 | 4 | 54 | 1 | 89 | 217 | 1954 | 1827 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 11816 | 211 | 0.990521327014218 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 13478092 | 13478092 | PRJNA745553_S_NODE_27071_length_239_cov_3.301205_g26876_i0 | PRJNA745553 | 27071 | 239 | 3.301205 | 7.88987995 | Neocercomonas sp. strain 10-3.4 | 321426 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|62184260|gb|AY884314.1| | 321426 | g26876 | i0 | 90.476 | 0.297071129707113 | 42 | 4 | 18 | 0 | 70 | 111 | 154 | 113 | Neocercomonas sp. strain 10-3.4 small subunit ribosomal RNA gene, partial sequence | blastn | 71 | 56.5 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Neocercomonas | Neocercomonas sp. strain 10-3.4 | |||
| 16501574 | 16501574 | PRJNA745553_S_NODE_12893_length_342_cov_4.643123_g12698_i0 | PRJNA745553 | 12893 | 342 | 4.643123 | 15.87948066 | Bodomorpha | 188949 | SAR_Eukaryotes | SAR_Eukaryotes | 573 | 5.579999999999999e-159 | NTclustered | gi|219524778|gb|EU709141.1| | 175275 | g12698 | i0 | 98.457 | 94.6608187134503 | 324 | 5 | 95 | 0 | 19 | 342 | 1552 | 1229 | Uncultured cercozoan isolate HetChi37 18S ribosomal RNA gene, partial sequence | blastn | 32374 | 577 | 0.993067590987868 | Eukaryota | Sar | Cercozoa | uncultured Cercozoa | ||||||
| 19851262 | 19851262 | PRJNA745553_S_NODE_23916_length_253_cov_0.855556_g23721_i0 | PRJNA745553 | 23916 | 253 | 0.855556 | 2.16455668 | Protaspis grandis | 361427 | SAR_Eukaryotes | SAR_Eukaryotes | 248 | 2.73e-61 | NTclustered | gi|290760486|gb|GQ144689.1| | 361427 | g23721 | i0 | 88.725 | 43.8458498023715 | 204 | 22 | 80 | 1 | 1 | 203 | 2021 | 2224 | Protaspis grandis large subunit ribosomal RNA gene, partial sequence | blastn | 11093 | 248 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Protaspis | Protaspis grandis | ||
| 21600767 | 21600767 | PRJNA745553_S_NODE_10897_length_369_cov_4.111486_g10702_i0 | PRJNA745553 | 10897 | 369 | 4.111486 | 15.17138334 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 137 | 9.41e-28 | NTclustered | gi|290760487|gb|GQ144690.1| | 629762 | g10702 | i0 | 96.386 | 22.5230352303523 | 83 | 3 | 22 | 0 | 287 | 369 | 1495 | 1413 | Cercozoa sp. CC-2009d large subunit ribosomal RNA gene, partial sequence | blastn | 8311 | 137 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. CC-2009d | ||||||
| 27811094 | 27811094 | PRJNA745553_S_NODE_5264_length_495_cov_7.502370_g5070_i0 | PRJNA745553 | 5264 | 495 | 7.50237 | 37.1367315 | Bigelowiella natans | 227086 | SAR_Eukaryotes | SAR_Eukaryotes | 106 | 1.54e-26 | NR | AAP34642.1 | 227086 | g5070 | i0 | 74.6 | 0.406060606060606 | 67 | 17 | 40.6 | 0 | 22 | 222 | 10 | 76 | AAP34642.1 small ubiquitin-like modifier [Bigelowiella natans] | diamond | 201 | 106 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Bigelowiella | Bigelowiella natans | ||||
| 31126641 | 31126641 | PRJNA745553_S_NODE_2655_length_608_cov_5.472897_g2476_i0 | PRJNA745553 | 2655 | 608 | 5.472897 | 33.27521376 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 120 | 1.79e-30 | NR | MES1915609.1 | 1215613 | g2476 | i0 | 51.4 | 0.730263157894737 | 148 | 59 | 70.1 | 3 | 605 | 180 | 42 | 182 | MES1915609.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 444 | 120 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 31411636 | 31411636 | PRJNA745553_S_NODE_9436_length_394_cov_2.813084_g9241_i0 | PRJNA745553 | 9436 | 394 | 2.813084 | 11.08355096 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 124 | 7.98e-34 | NR | ADK26622.1 | 323453 | g9241 | i0 | 98.3 | 0.449238578680203 | 59 | 1 | 44.9 | 0 | 2 | 178 | 72 | 130 | ADK26622.1 rps22a [Heteromita sp. PRA-74] | diamond | 177 | 124 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 |
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);;