contig_metadata
8 rows where bioproject = "PRJNA520845", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 491262 | 491262 | PRJNA520845_P_NODE_254701_length_243_cov_0.905882_g253202_i0 | PRJNA520845 | 254701 | 243 | 0.905882 | 2.20129326 | Saccamoeba lacustris | 704142 | Tubulinea | other_Eukaryota | 157 | 1.3e-45 | NR | AFX84551.1 | 704142 | g253202 | i0 | 98.8 | 1 | 81 | 1 | 100 | 0 | 1 | 243 | 7 | 87 | AFX84551.1 alpha tubulin, partial [Saccamoeba lacustris] | diamond | 243 | 157 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Saccamoeba | Saccamoeba lacustris | ||
| 4939967 | 4939967 | PRJNA520845_P_NODE_243604_length_245_cov_1.447674_g242105_i0 | PRJNA520845 | 243604 | 245 | 1.447674 | 3.5468013 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 451 | 1.87e-122 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g242105 | i0 | 100 | 54.2 | 244 | 0 | 99 | 0 | 2 | 245 | 5496 | 5253 | Vermamoeba vermiformis isolate 1 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 13279 | 451 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 8143935 | 8143935 | PRJNA520845_P_NODE_237827_length_247_cov_0.879310_g236328_i0 | PRJNA520845 | 237827 | 247 | 0.87931 | 2.1718957 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 254 | 5.699999999999999e-63 | NTclustered | gi|508737347|dbj|AB766053.1| | 931554 | g236328 | i0 | 85.774 | 36.6072874493927 | 239 | 34 | 97 | 0 | 1 | 239 | 190 | 428 | Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324 | blastn | 9042 | 254 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 8144368 | 8144368 | PRJNA520845_P_NODE_254307_length_243_cov_0.905882_g252808_i0 | PRJNA520845 | 254307 | 243 | 0.905882 | 2.20129326 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 139 | 1.75e-37 | NR | AAP88974.1 | 5775 | g252808 | i0 | 78.8 | 1.97530864197531 | 80 | 17 | 98.8 | 0 | 2 | 241 | 65 | 144 | AAP88974.1 S-adenosylmethionine synthetase 2 [Amoeba proteus] | diamond | 480 | 139 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 10691227 | 10691227 | PRJNA520845_P_NODE_111429_length_353_cov_0.907143_g109930_i0 | PRJNA520845 | 111429 | 353 | 0.907143 | 3.20221479 | Paraflabellula hoguae | 136459 | Tubulinea | other_Eukaryota | 193 | 1.88e-44 | NTclustered | gi|145386791|gb|EF216916.1| | 136459 | g109930 | i0 | 90.476 | 38.2549575070822 | 147 | 13 | 41 | 1 | 149 | 294 | 1352 | 1498 | Paraflabellula hoguae 28S large subunit ribosomal RNA gene, partial sequence | blastn | 13504 | 193 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Flabellulidae | Paraflabellula | Paraflabellula hoguae | ||
| 20895546 | 20895546 | PRJNA520845_P_NODE_98857_length_374_cov_1.023256_g97358_i0 | PRJNA520845 | 98857 | 374 | 1.023256 | 3.82697744 | Rhizamoeba saxonica | 200886 | Tubulinea | other_Eukaryota | 424 | 6.55e-114 | NTclustered | gi|300078497|gb|GU001159.1| | 200886 | g97358 | i0 | 87.297 | 95.697860962566807 | 370 | 47 | 99 | 0 | 5 | 374 | 3035 | 2666 | Rhizamoeba saxonica 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 35791 | 424 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Leptomyxida | Flabellulidae | Rhizamoeba | Rhizamoeba saxonica | ||
| 23439605 | 23439605 | PRJNA520845_P_NODE_101799_length_369_cov_0.905405_g100300_i0 | PRJNA520845 | 101799 | 369 | 0.905405 | 3.34094445 | Pyxidicula operculata | 1078852 | Tubulinea | other_Eukaryota | 604 | 2.149999999999999e-168 | NTclustered | gi|345452598|gb|JF694317.1| | 1078852 | g100300 | i0 | 96.206 | 99.8644986449865 | 369 | 14 | 100 | 0 | 1 | 369 | 472 | 104 | Pyxidicula operculata clone 2 actin gene, partial cds | blastn | 36850 | 604 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Pyxidicula | Pyxidicula operculata | |||
| 28940730 | 28940730 | PRJNA520845_P_NODE_56968_length_494_cov_1.665083_g55474_i0 | PRJNA520845 | 56968 | 494 | 1.665083 | 8.22551002 | Saccamoeba lacustris | 704142 | Tubulinea | other_Eukaryota | 234 | 1.38e-74 | NR | AFX73097.1 | 704142 | g55474 | i0 | 72 | 0.977732793522267 | 161 | 41 | 97.8 | 1 | 12 | 494 | 102 | 258 | AFX73097.1 elongation factor 2 alpha, partial [Saccamoeba lacustris] | diamond | 483 | 234 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Saccamoeba | Saccamoeba lacustris |
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);;