contig_metadata
10 rows where bioproject = "PRJEB14803", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 985824 | 985824 | PRJEB14803_P_NODE_4961_length_626_cov_2.368866_g4563_i0 | PRJEB14803 | 4961 | 626 | 2.368866 | 14.82910116 | Vermamoeba | 1260114 | Tubulinea | other_Eukaryota | 1118 | 0 | NTclustered | gi|909719645|gb|KT185625.1| | 5778 | g4563 | i0 | 98.882 | 70.8003194888179 | 626 | 7 | 100 | 0 | 1 | 626 | 5541 | 4916 | 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 | 44321 | 1118 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 2571248 | 2571248 | PRJEB14803_P_NODE_1663_length_1112_cov_2.429898_g1439_i0 | PRJEB14803 | 1663 | 1112 | 2.429898 | 27.02046576 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 1181 | 0 | NTclustered | gi|508737347|dbj|AB766053.1| | 931554 | g1439 | i0 | 86.467 | 16.0692446043165 | 1101 | 119 | 97 | 21 | 36 | 1112 | 1389 | 295 | Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324 | blastn | 17869 | 1181 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 12775153 | 12775153 | PRJEB14803_P_NODE_7071_length_504_cov_4.081023_g6618_i0 | PRJEB14803 | 7071 | 504 | 4.081023 | 20.56835592 | Copromyxa sp. PKD 2011 | 1215977 | Tubulinea | other_Eukaryota | 931 | 0 | NTclustered | gi|399764167|gb|JQ271678.1| | 1215977 | g6618 | i0 | 100 | 80.281746031746 | 504 | 0 | 100 | 0 | 1 | 504 | 1152 | 649 | Copromyxa sp. PKD 2011 strain ZEB1 18S ribosomal RNA gene, partial sequence | blastn | 40462 | 931 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa sp. PKD 2011 | ||
| 13739268 | 13739268 | PRJEB14803_P_NODE_34951_length_180_cov_1.379310_g34485_i0 | PRJEB14803 | 34951 | 180 | 1.37931 | 2.482758 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 322 | 1.05e-83 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g34485 | i0 | 98.889 | 24.0944444444444 | 180 | 2 | 100 | 0 | 1 | 180 | 1481 | 1660 | 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 | 4337 | 322 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 14049622 | 14049622 | PRJEB14803_P_NODE_37872_length_171_cov_1.470588_g37406_i0 | PRJEB14803 | 37872 | 171 | 1.470588 | 2.51470548 | Copromyxa sp. PKD 2011 | 1215977 | Tubulinea | other_Eukaryota | 316 | 4.6e-82 | NTclustered | gi|399764167|gb|JQ271678.1| | 1215977 | g37406 | i0 | 100 | 26.0233918128655 | 171 | 0 | 100 | 0 | 1 | 171 | 1500 | 1670 | Copromyxa sp. PKD 2011 strain ZEB1 18S ribosomal RNA gene, partial sequence | blastn | 4450 | 316 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa sp. PKD 2011 | ||
| 18837583 | 18837583 | PRJEB14803_P_NODE_15455_length_307_cov_1.764706_g14989_i0 | PRJEB14803 | 15455 | 307 | 1.764706 | 5.41764742 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 483 | 8.569999999999998e-132 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g14989 | i0 | 94.137 | 37.671009771987 | 307 | 15 | 99 | 1 | 1 | 304 | 1063 | 1369 | 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 | 11565 | 483 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 20422218 | 20422218 | PRJEB14803_P_NODE_42477_length_160_cov_0.960000_g42011_i0 | PRJEB14803 | 42477 | 160 | 0.96 | 1.536 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 94 | 7.200000000000001e-22 | NR | BAV21603.1 | 931554 | g42011 | i0 | 80.8 | 3.9 | 52 | 10 | 97.5 | 0 | 158 | 3 | 180 | 231 | BAV21603.1 elongation factor 2 alpha, partial [Copromyxa protea] | diamond | 624 | 94 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 21698129 | 21698129 | PRJEB14803_P_NODE_24878_length_223_cov_3.872340_g24412_i0 | PRJEB14803 | 24878 | 223 | 3.87234 | 8.6353182 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 396 | 7.939999999999995e-106 | NTclustered | gi|300078496|gb|GU001158.1| | 5778 | g24412 | i0 | 98.655 | 20.2825112107623 | 223 | 3 | 100 | 0 | 1 | 223 | 4381 | 4159 | 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 | 4523 | 396 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 21698206 | 21698206 | PRJEB14803_P_NODE_38138_length_170_cov_1.829630_g37672_i0 | PRJEB14803 | 38138 | 170 | 1.82963 | 3.110371 | Vermamoeba vermiformis | 5778 | Tubulinea | other_Eukaryota | 281 | 1.67e-71 | NTclustered | gi|423291980|gb|JQ519435.1| | 5778 | g37672 | i0 | 96.471 | 85.7764705882353 | 170 | 6 | 100 | 0 | 1 | 170 | 412 | 581 | Vermamoeba vermiformis clone JG10.93_f2 actin gene, partial cds | blastn | 14582 | 281 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 22973409 | 22973409 | PRJEB14803_P_NODE_25819_length_218_cov_1.393443_g25353_i0 | PRJEB14803 | 25819 | 218 | 1.393443 | 3.03770574 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 302 | 1.73e-77 | NTclustered | gi|508737347|dbj|AB766053.1| | 931554 | g25353 | i0 | 91.705 | 9.41743119266055 | 217 | 18 | 99 | 0 | 1 | 217 | 256 | 40 | Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324 | blastn | 2053 | 302 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea |
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);;