contig_metadata
9 rows where bioproject = "PRJNA400391", tax_clade = "Amoebozoa" and tax_phylum = "Evosea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2356477 | 2356477 | PRJNA400391_S_NODE_4562_length_187_cov_1.921053_g4501_i0 | PRJNA400391 | 4562 | 187 | 1.921053 | 3.59236911 | Entamoeba | 5758 | Evosea | other_Eukaryota | 346 | 6.56e-91 | NTclustered | gi|2202715588|gb|OM900081.1| | 715123 | g4501 | i0 | 100 | 100.005347593583 | 187 | 0 | 100 | 0 | 1 | 187 | 1513 | 1327 | Entamoeba bovis voucher Z0817044-XIX small subunit ribosomal RNA gene, partial sequence | blastn | 18701 | 346 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba bovis | |||
| 4241202 | 4241202 | PRJNA400391_S_NODE_5524_length_168_cov_2.172932_g5463_i0 | PRJNA400391 | 5524 | 168 | 2.172932 | 3.65052576 | Didymium spongiosum | 289992 | Evosea | other_Eukaryota | 246 | 6.03e-61 | NTclustered | gi|2161226356|gb|MZ313554.1| | 289992 | g5463 | i0 | 93.902 | 8.22619047619048 | 164 | 9 | 98 | 1 | 5 | 168 | 7649 | 7811 | Mucilago crustacea 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 | 1382 | 246 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Didymium | Didymium spongiosum | ||
| 12559754 | 12559754 | PRJNA400391_S_NODE_6390_length_154_cov_1.873950_g6329_i0 | PRJNA400391 | 6390 | 154 | 1.87395 | 2.885883 | Didymiaceae | 1115745 | Evosea | other_Eukaryota | 215 | 1.52e-51 | NTclustered | gi|2161226356|gb|MZ313554.1| | 289992 | g6329 | i0 | 93.75 | 40.961038961039 | 144 | 8 | 93 | 1 | 12 | 154 | 5651 | 5508 | Mucilago crustacea 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 | 6308 | 215 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Didymium | Didymium spongiosum | ||
| 13167894 | 13167894 | PRJNA400391_S_NODE_5851_length_162_cov_2.322835_g5790_i0 | PRJNA400391 | 5851 | 162 | 2.322835 | 3.7629927 | Protosporangium articulatum | 668360 | Evosea | other_Eukaryota | 180 | 5.93e-41 | NTclustered | gi|256550197|gb|FJ792705.1| | 668360 | g5790 | i0 | 86.503 | 100.771604938272 | 163 | 20 | 100 | 2 | 1 | 162 | 1221 | 1060 | Protosporangium articulatum small subunit ribosomal RNA gene, partial sequence | blastn | 16325 | 180 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Protosporangiidae | Protosporangium | Protosporangium articulatum | |||
| 16991638 | 16991638 | PRJNA400391_S_NODE_5474_length_169_cov_1.865672_g5413_i0 | PRJNA400391 | 5474 | 169 | 1.865672 | 3.15298568 | Entamoeba histolytica | 5759 | Evosea | other_Eukaryota | 195 | 2.22e-45 | NTclustered | gi|467633|emb|Z29969.1| | 5759 | g5413 | i0 | 93.233 | 6.3905325443787 | 133 | 8 | 78 | 1 | 38 | 169 | 2153 | 2285 | E.histolytica plasmid genes for ribosomal RNA and hemolysins HLY1, HLY5mc1 HLY5mc2 HLY4 | blastn | 1080 | 195 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba histolytica | |||
| 18265673 | 18265673 | PRJNA400391_S_NODE_2695_length_244_cov_2.631579_g2634_i0 | PRJNA400391 | 2695 | 244 | 2.631579 | 6.42105276 | Entamoeba bovis | 715123 | Evosea | other_Eukaryota | 449 | 6.68e-122 | NTclustered | gi|1867180758|gb|MT734186.1| | 715123 | g2634 | i0 | 100 | 99.5901639344262 | 243 | 0 | 99 | 0 | 2 | 244 | 381 | 139 | Entamoeba bovis isolate Aa1.seq small subunit ribosomal RNA gene, partial sequence | blastn | 24300 | 449 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba bovis | |||
| 22758021 | 22758021 | PRJNA400391_S_NODE_6378_length_154_cov_3.327731_g6317_i0 | PRJNA400391 | 6378 | 154 | 3.327731 | 5.12470574 | Lamproderma | 142788 | Evosea | other_Eukaryota | 279 | 5.33e-71 | NTclustered | gi|1478167969|gb|MH930619.1| | 142791 | g6317 | i0 | 99.351 | 100.045454545455 | 154 | 1 | 100 | 0 | 1 | 154 | 261 | 108 | Lamproderma ovoideum isolate MSU8505 small subunit ribosomal RNA gene, partial sequence | blastn | 15407 | 279 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Stemonitida | Stemonitidae | Lamproderma | Lamproderma ovoideum | ||
| 23366121 | 23366121 | PRJNA400391_S_NODE_2239_length_267_cov_3.336207_g2178_i0 | PRJNA400391 | 2239 | 267 | 3.336207 | 8.90767269 | Entamoeba histolytica | 5759 | Evosea | other_Eukaryota | 222 | 1.76e-53 | NTclustered | gi|415339|emb|X65163.1| | 5759 | g2178 | i0 | 81.884 | 1.46441947565543 | 276 | 38 | 100 | 9 | 1 | 267 | 6047 | 6319 | E.histolytica rRNA | blastn | 391 | 222 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba histolytica | |||
| 23366144 | 23366144 | PRJNA400391_S_NODE_3159_length_226_cov_4.806283_g3098_i0 | PRJNA400391 | 3159 | 226 | 4.806283 | 10.86219958 | Entamoeba bovis | 715123 | Evosea | other_Eukaryota | 412 | 8.01e-111 | NTclustered | gi|2202715588|gb|OM900081.1| | 715123 | g3098 | i0 | 99.558 | 89.1194690265487 | 226 | 1 | 100 | 0 | 1 | 226 | 893 | 668 | Entamoeba bovis voucher Z0817044-XIX small subunit ribosomal RNA gene, partial sequence | blastn | 20141 | 412 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba bovis |
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);;