contig_metadata
10 rows where bioproject = "PRJNA270367", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11848563 | 11848563 | PRJNA270367_P_NODE_19590_length_274_cov_0.920000_g19385_i0 | PRJNA270367 | 19590 | 274 | 0.92 | 2.5208 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 116 | 3.03e-28 | NR | BAN33737.1 | 931554 | g19385 | i0 | 76 | 12.3175182481752 | 75 | 18 | 82.1 | 0 | 49 | 273 | 4 | 78 | BAN33737.1 elongation factor-like protein [Copromyxa protea] | diamond | 3375 | 116 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 14398969 | 14398969 | PRJNA270367_P_NODE_2132_length_954_cov_11.615470_g1969_i0 | PRJNA270367 | 2132 | 954 | 11.61547 | 110.8115838 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 283 | 6.929999999999999e-92 | NR | AAY21191.1 | 5778 | g1969 | i0 | 63.6 | 0.742138364779874 | 236 | 85 | 74.2 | 1 | 122 | 829 | 12 | 246 | AAY21191.1 Rpl7A, partial [Vermamoeba vermiformis] | diamond | 708 | 283 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 14399023 | 14399023 | PRJNA270367_P_NODE_26352_length_222_cov_1.306358_g26147_i0 | PRJNA270367 | 26352 | 222 | 1.306358 | 2.90011476 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 224 | 3.94e-54 | NTclustered | gi|844573744|gb|KP411223.1| | 5775 | g26147 | i0 | 85 | 0.990990990990991 | 220 | 33 | 99 | 0 | 2 | 221 | 743 | 524 | Amoeba proteus Tom40 mRNA, complete cds | blastn | 220 | 224 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 16947642 | 16947642 | PRJNA270367_P_NODE_9534_length_432_cov_2.595300_g9333_i0 | PRJNA270367 | 9534 | 432 | 2.5953 | 11.211696 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 398 | 4.649999999999998e-106 | NTclustered | gi|844573744|gb|KP411223.1| | 5775 | g9333 | i0 | 83.953 | 0.99537037037037 | 430 | 54 | 97 | 13 | 11 | 431 | 14 | 437 | Amoeba proteus Tom40 mRNA, complete cds | blastn | 430 | 398 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 27042458 | 27042458 | PRJNA270367_P_NODE_8062_length_474_cov_3.094118_g7864_i0 | PRJNA270367 | 8062 | 474 | 3.094118 | 14.66611932 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 169 | 8.89e-51 | NR | ABD72565.1 | 5778 | g7864 | i0 | 63 | 0.80379746835443 | 127 | 45 | 80.4 | 1 | 18 | 398 | 13 | 137 | ABD72565.1 chitinase-like protein cluster B, partial [Vermamoeba vermiformis] | diamond | 381 | 169 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 27105473 | 27105473 | PRJNA270367_P_NODE_8102_length_473_cov_1.865566_g7904_i0 | PRJNA270367 | 8102 | 473 | 1.865566 | 8.82412718 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 154 | 7.51e-45 | NR | ABD72565.1 | 5778 | g7904 | i0 | 65.7 | 0.684989429175476 | 108 | 37 | 68.5 | 0 | 149 | 472 | 1 | 108 | ABD72565.1 chitinase-like protein cluster B, partial [Vermamoeba vermiformis] | diamond | 324 | 154 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 27136814 | 27136814 | PRJNA270367_P_NODE_18662_length_283_cov_1.551282_g18457_i0 | PRJNA270367 | 18662 | 283 | 1.551282 | 4.39012806 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 58.2 | 1.44e-8 | NR | AKT93972.1 | 5778 | g18457 | i0 | 43.2 | 0.858657243816254 | 81 | 46 | 85.9 | 0 | 269 | 27 | 21 | 101 | AKT93972.1 ribosomal protein L19 [Vermamoeba vermiformis] | diamond | 243 | 58.2 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 27358679 | 27358679 | PRJNA270367_P_NODE_21983_length_252_cov_0.866995_g21778_i0 | PRJNA270367 | 21983 | 252 | 0.866995 | 2.1848274 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 90.5 | 3.17e-20 | NR | ABD46545.1 | 5778 | g21778 | i0 | 50.6 | 0.964285714285714 | 81 | 40 | 96.4 | 0 | 251 | 9 | 11 | 91 | ABD46545.1 aldehyde dehydrogenase, partial [Vermamoeba vermiformis] | diamond | 243 | 90.5 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 29379289 | 29379289 | PRJNA270367_P_NODE_2889_length_815_cov_2.156658_g2713_i0 | PRJNA270367 | 2889 | 815 | 2.156658 | 17.5767627 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 59.3 | 3.31e-6 | NR | AKN09692.1 | 5775 | g2713 | i0 | 27.2 | 0.63680981595092 | 173 | 119 | 61.8 | 3 | 798 | 295 | 3 | 173 | AKN09692.1 Tom40 [Amoeba proteus] | diamond | 519 | 59.3 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 31559615 | 31559615 | PRJNA270367_P_NODE_39996_length_169_cov_0.866667_g39791_i0 | PRJNA270367 | 39996 | 169 | 0.866667 | 1.46466723 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 51.2 | 1.34e-5 | NR | AAD37351.1 | 5775 | g39791 | i0 | 52.9 | 0.905325443786982 | 51 | 24 | 90.5 | 0 | 167 | 15 | 16 | 66 | AAD37351.1 pepstatin-insensitive carboxyl proteinase 1, partial [Amoeba proteus] | diamond | 153 | 51.2 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus |
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);;