contig_metadata
8 rows where bioproject = "PRJNA492363" and tax_clade = "Amoebozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25702956 | 25702956 | PRJNA492363_S_NODE_74602_length_220_cov_2.006289_g73781_i0 | PRJNA492363 | 74602 | 220 | 2.006289 | 4.4138358 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 151 | 2.63e-41 | NR | YP_003540812.1 | 5778 | g73781 | i0 | 98.6 | 0.995454545454545 | 73 | 1 | 99.5 | 0 | 220 | 2 | 238 | 310 | YP_003540812.1 ATP synthase F1 subunit alpha [Vermamoeba vermiformis] | diamond | 219 | 151 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 26383797 | 26383797 | PRJNA492363_S_NODE_94783_length_204_cov_16.223776_g93962_i0 | PRJNA492363 | 94783 | 204 | 16.223776 | 33.09650304 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 62.1 | 2.96e-5 | NTclustered | gi|292559443|ref|NC_013986.1| | 5778 | g93962 | i0 | 80.435 | 2.89705882352941 | 92 | 9 | 44 | 7 | 60 | 149 | 50711 | 50795 | Hartmannella vermiformis mitochondrion, complete genome | blastn | 591 | 62.1 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 26577224 | 26577224 | PRJNA492363_S_NODE_15736_length_256_cov_1.507692_g14915_i0 | PRJNA492363 | 15736 | 256 | 1.507692 | 3.85969152 | Corallomyxa tenera | 438413 | Root_unresolved | Root_unresolved | 119 | 1.31e-29 | NR | ADK26623.1 | 438413 | g14915 | i0 | 61.9 | 3.890625 | 84 | 31 | 98.4 | 1 | 254 | 3 | 154 | 236 | ADK26623.1 elongation factor 2, partial [Corallomyxa tenera] | diamond | 996 | 119 | 1 | Eukaryota | Amoebozoa | Corallomyxa | Corallomyxa tenera | ||||||
| 32918008 | 32918008 | PRJNA492363_S_NODE_111945_length_193_cov_2.272727_g111124_i0 | PRJNA492363 | 111945 | 193 | 2.272727 | 4.38636311 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 122 | 2.9799999999999997e-31 | NR | AKT93936.1 | 5778 | g111124 | i0 | 100 | 0.994818652849741 | 64 | 0 | 99.5 | 0 | 192 | 1 | 104 | 167 | AKT93936.1 translation elongation factor Tu [Vermamoeba vermiformis] | diamond | 192 | 122 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 32952533 | 32952533 | PRJNA492363_S_NODE_59194_length_229_cov_0.964286_g58373_i0 | PRJNA492363 | 59194 | 229 | 0.964286 | 2.20821494 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 87 | 2.9e-18 | NR | YP_003540855.1 | 5778 | g58373 | i0 | 75 | 0.786026200873362 | 60 | 15 | 78.6 | 0 | 227 | 48 | 224 | 283 | YP_003540855.1 NADH dehydrogenase subunit 1 [Vermamoeba vermiformis] | diamond | 180 | 87 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 33003508 | 33003508 | PRJNA492363_S_NODE_10675_length_296_cov_1.302128_g9854_i0 | PRJNA492363 | 10675 | 296 | 1.302128 | 3.85429888 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 152 | 2.16e-41 | NR | YP_003540851.1 | 5778 | g9854 | i0 | 77.6 | 1.98648648648649 | 98 | 22 | 99.3 | 0 | 2 | 295 | 118 | 215 | YP_003540851.1 NADH dehydrogenase subunit 2 [Vermamoeba vermiformis] | diamond | 588 | 152 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 33037619 | 33037619 | PRJNA492363_S_NODE_100684_length_201_cov_1.771429_g99863_i0 | PRJNA492363 | 100684 | 201 | 1.771429 | 3.56057229 | Acytostelium subglobosum LB1 | 1410327 | Evosea | other_Eukaryota | 52.4 | 8.03e-6 | NR | XP_012759850.1 | 1410327 | g99863 | i0 | 52.3 | 0.656716417910448 | 44 | 21 | 65.7 | 0 | 139 | 8 | 264 | 307 | XP_012759850.1 hypothetical protein SAMD00019534_035040, partial [Acytostelium subglobosum LB1] | diamond | 132 | 52.4 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 33122975 | 33122975 | PRJNA492363_S_NODE_15479_length_257_cov_1.290816_g14658_i0 | PRJNA492363 | 15479 | 257 | 1.290816 | 3.31739712 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 118 | 1.41e-30 | NR | AKT93937.1 | 5778 | g14658 | i0 | 64.2 | 0.945525291828794 | 81 | 29 | 94.6 | 0 | 15 | 257 | 11 | 91 | AKT93937.1 ribosomal protein L2 [Vermamoeba vermiformis] | diamond | 243 | 118 | 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);;