contig_metadata
8 rows where bioproject = "PRJNA379145", tax_clade = "Amoebozoa" and tax_phylum = "Tubulinea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1675317 | 1675317 | PRJNA379145_P_NODE_19802_length_600_cov_90.220459_g17941_i0 | PRJNA379145 | 19802 | 600 | 90.220459 | 541.322754 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 676 | 0 | NTclustered | gi|345452574|gb|JF694305.1| | 1078836 | g17941 | i0 | 87.124 | 102.608333333333 | 598 | 75 | 99 | 2 | 1 | 597 | 83 | 679 | Cryptodifflugia operculata clone 9 actin gene, partial cds | blastn | 61565 | 676 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 2349330 | 2349330 | PRJNA379145_P_NODE_33022_length_375_cov_106.698830_g30881_i0 | PRJNA379145 | 33022 | 375 | 106.69883 | 400.1206125 | Tubulinea | 555369 | Tubulinea | other_Eukaryota | 693 | 0 | NTclustered | gi|11527302|gb|AF293895.1|AF293895 | 136450 | g30881 | i0 | 100 | 72.2746666666667 | 375 | 0 | 100 | 0 | 1 | 375 | 623 | 997 | Echinamoeba exundans small subunit ribosomal RNA gene, complete sequence | blastn | 27103 | 693 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Echinamoebidae | Echinamoeba | Echinamoeba exundans | |||
| 8054373 | 8054373 | PRJNA379145_P_NODE_67207_length_166_cov_2.345865_g65053_i0 | PRJNA379145 | 67207 | 166 | 2.345865 | 3.8941359 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 235 | 1.2899999999999998e-57 | NTclustered | gi|423291976|gb|JQ519433.1| | 5778 | g65053 | i0 | 92.169 | 99.3674698795181 | 166 | 13 | 100 | 0 | 1 | 166 | 103 | 268 | Vermamoeba vermiformis clone JG10.93_b2 actin gene, partial cds | blastn | 16495 | 235 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 8726736 | 8726736 | PRJNA379145_P_NODE_55967_length_204_cov_3.918129_g53813_i0 | PRJNA379145 | 55967 | 204 | 3.918129 | 7.99298316 | Tubulinea | 555369 | Tubulinea | other_Eukaryota | 377 | 2.59e-100 | NTclustered | gi|11527302|gb|AF293895.1|AF293895 | 136450 | g53813 | i0 | 100 | 101.426470588235 | 204 | 0 | 100 | 0 | 1 | 204 | 1668 | 1465 | Echinamoeba exundans small subunit ribosomal RNA gene, complete sequence | blastn | 20691 | 377 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Echinamoebidae | Echinamoeba | Echinamoeba exundans | |||
| 13154749 | 13154749 | PRJNA379145_P_NODE_52791_length_219_cov_1.424731_g50637_i0 | PRJNA379145 | 52791 | 219 | 1.424731 | 3.12016089 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 366 | 6.09e-97 | NTclustered | gi|62910949|gb|AY925001.1| | 5778 | g50637 | i0 | 96.804 | 2.20547945205479 | 219 | 7 | 100 | 0 | 1 | 219 | 728 | 510 | Hartmannella vermiformis Rpl7A mRNA, partial cds | blastn | 483 | 366 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 24627458 | 24627458 | PRJNA379145_P_NODE_72560_length_153_cov_2.658333_g70405_i0 | PRJNA379145 | 72560 | 153 | 2.658333 | 4.06724949 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 215 | 1.51e-51 | NTclustered | gi|423291974|gb|JQ519432.1| | 5778 | g70405 | i0 | 93.706 | 98.6274509803922 | 143 | 9 | 93 | 0 | 1 | 143 | 124 | 266 | Vermamoeba vermiformis clone JG10.89_a2 actin gene, partial cds | blastn | 15090 | 215 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 25300172 | 25300172 | PRJNA379145_P_NODE_15080_length_733_cov_4.387143_g13465_i0 | PRJNA379145 | 15080 | 733 | 4.387143 | 32.15775819 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 249 | 2.1800000000000003e-79 | NR | AAY21191.1 | 5778 | g13465 | i0 | 67.7 | 0.78581173260573 | 192 | 61 | 78.6 | 1 | 2 | 577 | 41 | 231 | AAY21191.1 Rpl7A, partial [Vermamoeba vermiformis] | diamond | 576 | 249 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 27801598 | 27801598 | PRJNA379145_P_NODE_24764_length_500_cov_1.749465_g22742_i0 | PRJNA379145 | 24764 | 500 | 1.749465 | 8.747325 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 171 | 1.08e-51 | NR | ABD72565.1 | 5778 | g22742 | i0 | 59 | 0.834 | 139 | 55 | 83.4 | 1 | 490 | 74 | 1 | 137 | ABD72565.1 chitinase-like protein cluster B, partial [Vermamoeba vermiformis] | diamond | 417 | 171 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis |
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);;