contig_metadata
5 rows where bioproject = "PRJNA1123309" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 278603 | 278603 | PRJNA1123309_P_NODE_58341_length_246_cov_2.369942_g57961_i0 | PRJNA1123309 | 58341 | 246 | 2.369942 | 5.83005732 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 226 | 1.2399999999999997e-54 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g57961 | i0 | 83.658 | 40.239837398374 | 257 | 24 | 100 | 12 | 1 | 246 | 1615 | 1864 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 9899 | 226 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 9957029 | 9957029 | PRJNA1123309_P_NODE_30548_length_294_cov_9.800905_g30168_i0 | PRJNA1123309 | 30548 | 294 | 9.800905 | 28.8146607 | Sandona | 1239209 | SAR_Eukaryotes | SAR_Eukaryotes | 542 | 1.33e-149 | NTclustered | gi|219524789|gb|EU709152.1| | 175275 | g30168 | i0 | 100 | 99.6360544217687 | 293 | 0 | 99 | 0 | 1 | 293 | 616 | 908 | Uncultured cercozoan isolate HetPan20 18S ribosomal RNA gene, partial sequence | blastn | 29293 | 542 | 1 | Eukaryota | Sar | Cercozoa | uncultured Cercozoa | ||||||
| 9957060 | 9957060 | PRJNA1123309_P_NODE_36968_length_278_cov_1.351220_g36588_i0 | PRJNA1123309 | 36968 | 278 | 1.35122 | 3.7563916 | Bodomorpha | 188949 | SAR_Eukaryotes | SAR_Eukaryotes | 455 | 1.67e-123 | NTclustered | gi|219524805|gb|EU709168.1| | 175275 | g36588 | i0 | 97.048 | 97.5719424460432 | 271 | 6 | 97 | 2 | 10 | 278 | 525 | 795 | Uncultured cercozoan isolate H24p79p118t11 18S ribosomal RNA gene, partial sequence | blastn | 27125 | 455 | 1 | Eukaryota | Sar | Cercozoa | uncultured Cercozoa | ||||||
| 13031867 | 13031867 | PRJNA1123309_P_NODE_27151_length_310_cov_4.649789_g26771_i0 | PRJNA1123309 | 27151 | 310 | 4.649789 | 14.4143459 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 327 | 4.3e-85 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g26771 | i0 | 86.711 | 34.8677419354839 | 301 | 32 | 97 | 7 | 5 | 304 | 4008 | 3715 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 10809 | 327 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 30512484 | 30512484 | PRJNA1123309_P_NODE_53373_length_249_cov_1.767045_g52993_i0 | PRJNA1123309 | 53373 | 249 | 1.767045 | 4.39994205 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 49.3 | 1.26e-5 | NR | MES1916146.1 | 1215613 | g52993 | i0 | 44.6 | 0.674698795180723 | 56 | 29 | 67.5 | 2 | 235 | 68 | 12 | 65 | MES1916146.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 168 | 49.3 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM |
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);;