contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA849822" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7216669 | 7216669 | PRJNA849822_P_NODE_16306_length_359_cov_13.772727_g16132_i0 | PRJNA849822 | 16306 | 359 | 13.772727 | 49.44408993 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 499 | 1.01e-136 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g16132 | i0 | 91.758 | 101.451253481894 | 364 | 22 | 100 | 8 | 1 | 359 | 3033 | 2673 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 36421 | 499 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 9766835 | 9766835 | PRJNA849822_P_NODE_6828_length_590_cov_3.580271_g6659_i0 | PRJNA849822 | 6828 | 590 | 3.580271 | 21.1235989 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 669 | 0 | NTclustered | gi|238617666|gb|FJ973412.1| | 188950 | g6659 | i0 | 92.672 | 78.9169491525424 | 464 | 34 | 79 | 0 | 126 | 589 | 1 | 464 | Bodomorpha minima strain ATCC 50339 alpha-tubulin (atub) gene, partial cds | blastn | 46561 | 669 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 11042150 | 11042150 | PRJNA849822_P_NODE_12429_length_417_cov_14.186047_g12255_i0 | PRJNA849822 | 12429 | 417 | 14.186047 | 59.15581599 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 285 | 3.6299999999999995e-72 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g12255 | i0 | 81.283 | 35.726618705036 | 374 | 51 | 89 | 11 | 46 | 417 | 4021 | 3665 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 14898 | 285 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 13592445 | 13592445 | PRJNA849822_P_NODE_44111_length_207_cov_13.582090_g43937_i0 | PRJNA849822 | 44111 | 207 | 13.582090000000001 | 28.1149263 | Bodomorpha sp. HFCC 92 | 458884 | SAR_Eukaryotes | SAR_Eukaryotes | 383 | 5.65e-102 | NTclustered | gi|197723521|gb|EF681900.2| | 458884 | g43937 | i0 | 100 | 101.067632850242 | 207 | 0 | 100 | 0 | 1 | 207 | 938 | 732 | Bodomorpha sp. HFCC 92 28S ribosomal RNA gene, partial sequence | blastn | 20921 | 383 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha sp. HFCC 92 | |||
| 18689812 | 18689812 | PRJNA849822_P_NODE_12095_length_423_cov_7.757143_g11921_i0 | PRJNA849822 | 12095 | 423 | 7.757143 | 32.81271489 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 424 | 7.5e-114 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g11921 | i0 | 86.923 | 52.0992907801418 | 390 | 35 | 92 | 9 | 36 | 423 | 4039 | 3664 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 22038 | 424 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 22911139 | 22911139 | PRJNA849822_P_NODE_33698_length_253_cov_0.866667_g33524_i0 | PRJNA849822 | 33698 | 253 | 0.866667 | 2.19266751 | Bodomorpha | 188949 | SAR_Eukaryotes | SAR_Eukaryotes | 189 | 1.6799999999999996e-43 | NTclustered | gi|219524918|gb|EU709281.1| | 555790 | g33524 | i0 | 99.048 | 22.4624505928854 | 105 | 1 | 42 | 0 | 1 | 105 | 1726 | 1830 | Bodomorpha sp. Panama115 18S ribosomal RNA gene, partial sequence | blastn | 5683 | 189 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha sp. Panama115 | |||
| 24185076 | 24185076 | PRJNA849822_P_NODE_36499_length_249_cov_4.397727_g36325_i0 | PRJNA849822 | 36499 | 249 | 4.397727 | 10.95034023 | Bodomorpha | 188949 | SAR_Eukaryotes | SAR_Eukaryotes | 459 | 1.1399999999999998e-124 | NTclustered | gi|225216798|gb|FJ176713.1| | 458884 | g36325 | i0 | 100 | 101.285140562249 | 248 | 0 | 99 | 0 | 2 | 249 | 371 | 124 | Bodomorpha sp. HFCC92 18S ribosomal RNA gene, partial sequence | blastn | 25220 | 459 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha sp. HFCC 92 |
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);;