contig_metadata
8 rows where analysis = "blastn", 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 |
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);;