contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA615351" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 595896 | 595896 | PRJNA615351_P_NODE_64861_length_547_cov_104.810547_g51258_i0 | PRJNA615351 | 64861 | 547 | 104.810547 | 573.31369209 | Cercomonas sp. HFCC53 | 458867 | SAR_Eukaryotes | SAR_Eukaryotes | 918 | 0 | NTclustered | gi|161015705|gb|EF681939.1| | 458867 | g51258 | i0 | 97.232 | 49.1042047531993 | 542 | 15 | 99 | 0 | 1 | 542 | 649 | 108 | Cercomonas sp. HFCC53 28S ribosomal RNA gene, partial sequence | blastn | 26860 | 918 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas sp. HFCC53 | |||
| 3146441 | 3146441 | PRJNA615351_P_NODE_162523_length_173_cov_2.797101_g148423_i0 | PRJNA615351 | 162523 | 173 | 2.797101 | 4.83898473 | Verrucomonas longifila | 629764 | SAR_Eukaryotes | SAR_Eukaryotes | 152 | 1.3899999999999998e-32 | NTclustered | gi|290760489|gb|GQ144692.1| | 629764 | g148423 | i0 | 85.616 | 48.5953757225434 | 146 | 19 | 84 | 2 | 1 | 146 | 1388 | 1245 | Cercozoa sp. CC-2009f large subunit ribosomal RNA gene, partial sequence | blastn | 8407 | 152 | 1 | Eukaryota | Sar | Cercozoa | Thecofilosea | Ventricleftida | Verrucomonas | Verrucomonas longifila | |||
| 4423232 | 4423232 | PRJNA615351_P_NODE_181964_length_154_cov_1.680672_g167864_i0 | PRJNA615351 | 181964 | 154 | 1.680672 | 2.58823488 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 235 | 1.17e-57 | NTclustered | gi|302026201|gb|GQ377711.1| | 323453 | g167864 | i0 | 94.156 | 99.025974025974 | 154 | 9 | 100 | 0 | 1 | 154 | 373 | 526 | Heteromita sp. PRA-74 alpha-tubulin-like mRNA, partial sequence | blastn | 15250 | 235 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 8248666 | 8248666 | PRJNA615351_P_NODE_128567_length_229_cov_1.695876_g114467_i0 | PRJNA615351 | 128567 | 229 | 1.695876 | 3.88355604 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 363 | 8.309999999999999e-96 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g114467 | i0 | 95.595 | 98.8733624454148 | 227 | 9 | 99 | 1 | 4 | 229 | 1581 | 1355 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 22642 | 363 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 12074825 | 12074825 | PRJNA615351_P_NODE_126330_length_234_cov_1.969849_g112230_i0 | PRJNA615351 | 126330 | 234 | 1.969849 | 4.60944666 | Bigelowiella natans | 227086 | SAR_Eukaryotes | SAR_Eukaryotes | 204 | 5.4699999999999994e-48 | NTclustered | gi|47028272|gb|AY542977.1| | 227086 | g112230 | i0 | 85.075 | 5.01282051282051 | 201 | 28 | 85 | 2 | 35 | 234 | 358 | 159 | Bigelowiella natans ADP ribosylation factor 1 (ARF1) mRNA, complete cds | blastn | 1173 | 204 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Bigelowiella | Bigelowiella natans | ||||
| 12074920 | 12074920 | PRJNA615351_P_NODE_159230_length_177_cov_4.598592_g145130_i0 | PRJNA615351 | 159230 | 177 | 4.598592 | 8.13950784 | Paracercomonas sp. | 1979800 | SAR_Eukaryotes | SAR_Eukaryotes | 283 | 4.87e-72 | NTclustered | gi|1326162414|gb|MG775634.1| | 1979800 | g145130 | i0 | 96.491 | 95.9830508474576 | 171 | 6 | 97 | 0 | 1 | 171 | 1778 | 1608 | Paracercomonas sp. strain SF61_P_Poa small subunit ribosomal RNA gene, partial sequence | blastn | 16989 | 283 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas sp. | |||
| 13350064 | 13350064 | PRJNA615351_P_NODE_66671_length_530_cov_108.202020_g52949_i0 | PRJNA615351 | 66671 | 530 | 108.20202 | 573.470706 | Cercomonas sp. HFCC549 | 458874 | SAR_Eukaryotes | SAR_Eukaryotes | 863 | 0 | NTclustered | gi|161015714|gb|EF681948.1| | 458874 | g52949 | i0 | 96.374 | 48.9264150943396 | 524 | 19 | 99 | 0 | 6 | 529 | 137 | 660 | Cercomonas sp. HFCC549 28S ribosomal RNA gene, partial sequence | blastn | 25931 | 863 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas sp. HFCC549 | |||
| 15898516 | 15898516 | PRJNA615351_P_NODE_160233_length_176_cov_1.985816_g146133_i0 | PRJNA615351 | 160233 | 176 | 1.985816 | 3.49503616 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 226 | 8.269999999999997e-55 | NTclustered | gi|302026201|gb|GQ377711.1| | 323453 | g146133 | i0 | 89.773 | 92.4034090909091 | 176 | 18 | 100 | 0 | 1 | 176 | 139 | 314 | Heteromita sp. PRA-74 alpha-tubulin-like mRNA, partial sequence | blastn | 16263 | 226 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 18447990 | 18447990 | PRJNA615351_P_NODE_79515_length_428_cov_19.027990_g65482_i0 | PRJNA615351 | 79515 | 428 | 19.02799 | 81.4397972 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 416 | 1.27e-111 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g65482 | i0 | 86.432 | 50.3060747663551 | 398 | 32 | 92 | 13 | 36 | 428 | 4039 | 3659 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 21531 | 416 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 18448002 | 18448002 | PRJNA615351_P_NODE_81195_length_417_cov_5.293194_g67150_i0 | PRJNA615351 | 81195 | 417 | 5.293194 | 22.07261898 | Amorphochlora amoebiformis | 1561963 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 8.44e-19 | NTclustered | gi|27734334|gb|AY099122.1| | 1561963 | g67150 | i0 | 85.577 | 11.8225419664269 | 104 | 13 | 25 | 2 | 12 | 114 | 55 | 157 | Lotharella amoeboformis isolate pub2 polyubiquitin gene, partial cds | blastn | 4930 | 108 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Amorphochlora | Amorphochlora amoebiformis | ||||
| 19001375 | 19001375 | PRJNA615351_P_NODE_150435_length_189_cov_1.883117_g136335_i0 | PRJNA615351 | 150435 | 189 | 1.883117 | 3.55909113 | Guttulinopsis | 1144921 | SAR_Eukaryotes | SAR_Eukaryotes | 350 | 5.14e-92 | NTclustered | gi|1402550487|gb|MH488773.1| | 2231167 | g136335 | i0 | 100 | 6.98941798941799 | 189 | 0 | 100 | 0 | 1 | 189 | 246 | 434 | Guttulinopsis sp. isolate STA small subunit ribosomal RNA gene, partial sequence | blastn | 1321 | 350 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Guttulinopsis | Guttulinopsis sp. | ||||
| 23548071 | 23548071 | PRJNA615351_P_NODE_135319_length_215_cov_1.383333_g121219_i0 | PRJNA615351 | 135319 | 215 | 1.383333 | 2.97416595 | Guttulinopsis rogosa | 2231170 | SAR_Eukaryotes | SAR_Eukaryotes | 392 | 9.83e-105 | NTclustered | gi|1402550485|gb|MH488771.1| | 2231170 | g121219 | i0 | 99.535 | 8.97209302325581 | 215 | 1 | 100 | 0 | 1 | 215 | 1853 | 1639 | Guttulinopsis rogosa isolate ATCC 50030 small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 1929 | 392 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Guttulinopsis | Guttulinopsis rogosa |
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);;