RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJEB10140" and tax_clade = "ant, tsetse, mealybug, aphid, etc. endosymbionts"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • ant, tsetse, mealybug, aphid, etc. endosymbionts · 7 ✖

bioproject 1

  • PRJEB10140 · 7 ✖

analysis 1

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
1287072 1287072 PRJEB10140_P_NODE_2762_length_3930_cov_27.418191_g1553_i0 PRJEB10140 2762 3930 27.418191 1077.5349063 Candidatus Stammera capleta 2608262 Bacteria Bacteria 58.4 0.009   NTclustered gi|1925240903|gb|CP043978.1| 2608262 g1553 i0 97.143 0.0089058524173028 35 0 1 1 1660 1694 22155 22188 MAG: Candidatus Stammera capleta isolate 1 chromosome, complete genome blastn 35 58.4 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Stammera Candidatus Stammera capleta
1287251 1287251 PRJEB10140_P_NODE_290922_length_162_cov_0.920354_g273613_i0 PRJEB10140 290922 162 0.920354 1.49097348 Candidatus Dasytiphilus stammeri 1895663 Bacteria Bacteria 60.2 8.06e-5   NTclustered gi|2689074019|gb|CP145877.1| 1895663 g273613 i0 94.737 0.234567901234568 38 2 23 0 26 63 258247 258210 MAG: Candidatus Dasytiphilus stammeri isolate Dnig chromosome, complete genome blastn 38 60.2 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Dasytiphilus Candidatus Dasytiphilus stammeri
5115686 5115686 PRJEB10140_P_NODE_7245_length_2639_cov_7.450965_g1553_i2 PRJEB10140 7245 2639 7.450965 196.63096635 Candidatus Stammera capleta 2608262 Bacteria Bacteria 58.4 0.006   NTclustered gi|1925240903|gb|CP043978.1| 2608262 g1553 i2 97.143 0.013262599469496 35 0 1 1 946 980 22188 22155 MAG: Candidatus Stammera capleta isolate 1 chromosome, complete genome blastn 35 58.4 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Stammera Candidatus Stammera capleta
12766772 12766772 PRJEB10140_P_NODE_51311_length_712_cov_2.209653_g35407_i0 PRJEB10140 51311 712 2.209653 15.73272936 Candidatus Dasytiphilus stammeri 1895663 Bacteria Bacteria 56.5 0.006   NTclustered gi|2689070146|gb|CP145873.1| 1895663 g35407 i0 100 0.0421348314606742 30 0 4 0 212 241 17709 17738 MAG: Candidatus Dasytiphilus stammeri isolate Lsp01 chromosome blastn 30 56.5 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Dasytiphilus Candidatus Dasytiphilus stammeri
12767023 12767023 PRJEB10140_P_NODE_94791_length_386_cov_3.596439_g77497_i0 PRJEB10140 94791 386 3.596439 13.88225454 Candidatus Stammera capleta 2608262 Bacteria Bacteria 54.7 0.01   NTclustered gi|1925240929|gb|CP062308.1| 2608262 g77497 i0 100 0.0751295336787565 29 0 8 0 234 262 52029 52001 MAG: Candidatus Stammera capleta isolate 1 chromosome, complete genome blastn 29 54.7 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Stammera Candidatus Stammera capleta
14040890 14040890 PRJEB10140_P_NODE_2772_length_3923_cov_24.754517_g1553_i1 PRJEB10140 2772 3923 24.754517 971.11970191 Candidatus Stammera capleta 2608262 Bacteria Bacteria 58.4 0.009   NTclustered gi|1925240903|gb|CP043978.1| 2608262 g1553 i1 97.143 0.00892174356359929 35 0 1 1 2230 2264 22188 22155 MAG: Candidatus Stammera capleta isolate 1 chromosome, complete genome blastn 35 58.4 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Stammera Candidatus Stammera capleta
22965044 22965044 PRJEB10140_P_NODE_47039_length_771_cov_2.260388_g31659_i0 PRJEB10140 47039 771 2.260388 17.42759148 Candidatus Stammera capleta 2608262 Bacteria Bacteria 54.7 0.022   NTclustered gi|1925240917|gb|CP043985.1| 2608262 g31659 i0 96.97 0.0428015564202335 33 0 4 1 342 373 235934 235966 MAG: Candidatus Stammera capleta isolate 1 chromosome, complete genome blastn 33 54.7 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Stammera Candidatus Stammera capleta

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;