contig_metadata
7 rows where bioproject = "PRJEB12296", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1294947 | 1294947 | PRJEB12296_P_NODE_382_length_217_cov_2.861702_g369_i0 | PRJEB12296 | 382 | 217 | 2.861702 | 6.20989334 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 185 | 1.81e-42 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g369 | i0 | 93.548 | 110.470046082949 | 124 | 8 | 80 | 0 | 71 | 194 | 6376 | 6253 | 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 | 23972 | 185 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 25636723 | 25636723 | PRJEB12296_S_NODE_986_length_367_cov_3.228916_g954_i0 | PRJEB12296 | 986 | 367 | 3.228916 | 11.85012172 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 612 | 1.2699999999999999e-170 | NTclustered | gi|2651357777|gb|PP174294.1| | 1078836 | g954 | i0 | 96.73 | 67.6839237057221 | 367 | 12 | 100 | 0 | 1 | 367 | 2290 | 2656 | Cryptodifflugia operculata isolate 75 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 24840 | 612 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 25772863 | 25772863 | PRJEB12296_S_NODE_7403_length_187_cov_1.921053_g7371_i0 | PRJEB12296 | 7403 | 187 | 1.921053 | 3.59236911 | Cryptodifflugia operculata | 1078836 | Tubulinea | other_Eukaryota | 279 | 6.74e-71 | NTclustered | gi|2651357777|gb|PP174294.1| | 1078836 | g7371 | i0 | 96.45 | 54.620320855615 | 169 | 6 | 90 | 0 | 1 | 169 | 4231 | 4399 | Cryptodifflugia operculata isolate 75 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 10214 | 279 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Cryptodifflugiidae | Cryptodifflugia | Cryptodifflugia operculata | ||
| 25878811 | 25878811 | PRJEB12296_S_NODE_1963_length_297_cov_87.240458_g1931_i0 | PRJEB12296 | 1963 | 297 | 87.240458 | 259.10416026 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 486 | 6.379999999999998e-133 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g1931 | i0 | 98.545 | 34.4478114478114 | 275 | 4 | 93 | 0 | 22 | 296 | 1220 | 946 | Hartmannella vermiformis 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 | 10231 | 486 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 25908944 | 25908944 | PRJEB12296_S_NODE_3820_length_233_cov_8.156566_g3788_i0 | PRJEB12296 | 3820 | 233 | 8.156566 | 19.00479878 | Copromyxa sp. PKD 2 | 3118317 | Tubulinea | other_Eukaryota | 431 | 2.2899999999999996e-116 | NTclustered | gi|399764168|gb|JQ271679.1| | 1215977 | g3788 | i0 | 100 | 63.7081545064378 | 233 | 0 | 100 | 0 | 1 | 233 | 411 | 179 | Copromyxa sp. PKD 2011 strain ZEB4 18S ribosomal RNA gene, partial sequence | blastn | 14844 | 431 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa sp. PKD 2011 | ||
| 26151257 | 26151257 | PRJEB12296_S_NODE_10205_length_172_cov_2.357664_g10173_i0 | PRJEB12296 | 10205 | 172 | 2.357664 | 4.05518208 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 252 | 1.33e-62 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g10173 | i0 | 100 | 62.2383720930233 | 136 | 0 | 79 | 0 | 2 | 137 | 5265 | 5400 | 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 | 10705 | 252 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 26316988 | 26316988 | PRJEB12296_S_NODE_5311_length_207_cov_7.726744_g5279_i0 | PRJEB12296 | 5311 | 207 | 7.726744 | 15.99436008 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 377 | 2.63e-100 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g5279 | i0 | 99.517 | 3.27536231884058 | 207 | 1 | 100 | 0 | 1 | 207 | 6317 | 6111 | 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 | 678 | 377 | 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);;