contig_metadata
6 rows where analysis = "diamond", bioproject = "PRJNA1237347" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11819149 | 11819149 | PRJNA1237347_P_NODE_295210_length_337_cov_2.003788_g288637_i0 | PRJNA1237347 | 295210 | 337 | 2.003788 | 6.75276556 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 201 | 1.68e-58 | NR | YP_003540848.1 | 5778 | g288637 | i0 | 91.9 | 0.98813056379822 | 111 | 9 | 98.8 | 0 | 3 | 335 | 131 | 241 | YP_003540848.1 NADH dehydrogenase subunit 5 [Vermamoeba vermiformis] | diamond | 333 | 201 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 23296601 | 23296601 | PRJNA1237347_P_NODE_492099_length_249_cov_0.875000_g485526_i0 | PRJNA1237347 | 492099 | 249 | 0.875 | 2.17875 | Arcellinida | 318493 | Tubulinea | other_Eukaryota | 137 | 1.41e-38 | NR | AFX73089.1 | 497998 | g485526 | i0 | 71.1 | 2.98795180722892 | 83 | 24 | 100 | 0 | 249 | 1 | 20 | 102 | AFX73089.1 elongation factor 2 alpha, partial [Arcella hemisphaerica] | diamond | 744 | 138 | 0.992753623188406 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Arcellidae | Arcella | Arcella hemisphaerica | ||
| 28733807 | 28733807 | PRJNA1237347_P_NODE_221487_length_405_cov_2.024096_g214915_i0 | PRJNA1237347 | 221487 | 405 | 2.024096 | 8.1975888 | root | 1 | Root_unresolved | Root_unresolved | 159 | 4.05e-46 | NR | ABD46563.1 | 5778 | g214915 | i0 | 58.1 | 20.0518518518519 | 136 | 53 | 100 | 3 | 1 | 405 | 24 | 156 | ABD46563.1 succinyl-diaminopimelate desuccinylase-like protein A, partial [Vermamoeba vermiformis] | diamond | 8121 | 160 | 0.99375 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 30389450 | 30389450 | PRJNA1237347_P_NODE_333453_length_312_cov_3.711297_g326880_i0 | PRJNA1237347 | 333453 | 312 | 3.711297 | 11.57924664 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 130 | 1.24e-33 | NR | AAD37351.1 | 5775 | g326880 | i0 | 64.9 | 0.932692307692308 | 97 | 32 | 91.3 | 1 | 287 | 3 | 91 | 187 | AAD37351.1 pepstatin-insensitive carboxyl proteinase 1, partial [Amoeba proteus] | diamond | 291 | 130 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 31400268 | 31400268 | PRJNA1237347_P_NODE_193896_length_442_cov_4.010840_g187324_i0 | PRJNA1237347 | 193896 | 442 | 4.01084 | 17.7279128 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 54.3 | 2.01e-5 | NR | AKN09692.1 | 5775 | g187324 | i0 | 32.2 | 0.970588235294118 | 143 | 84 | 95 | 5 | 21 | 440 | 1 | 133 | AKN09692.1 Tom40 [Amoeba proteus] | diamond | 429 | 54.3 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 32790890 | 32790890 | PRJNA1237347_P_NODE_238400_length_386_cov_1.805112_g231827_i0 | PRJNA1237347 | 238400 | 386 | 1.805112 | 6.96773232 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 238 | 1.3499999999999998e-73 | NR | YP_003540812.1 | 5778 | g231827 | i0 | 97.7 | 0.994818652849741 | 128 | 3 | 99.5 | 0 | 384 | 1 | 33 | 160 | YP_003540812.1 ATP synthase F1 subunit alpha [Vermamoeba vermiformis] | diamond | 384 | 238 | 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);;