RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where tax_clade = "Candidatus Ecksteinia", tax_phylum = "Pseudomonadota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 11 ✖

tax_phylum 1

  • Pseudomonadota · 11 ✖

tax_kingdom 1

tax_clade 1

  • Candidatus Ecksteinia · 11 ✖

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
235650 235650 PRJNA1120060_P_NODE_1280141_length_308_cov_2.574468_g1262196_i0 PRJNA1120060 1280141 308 2.574468 7.92936144 Candidatus Ecksteinia adelgidicola 1076629 Bacteria Bacteria 56.5 0.002   NTclustered gi|2119945591|gb|CP045239.1| 1076629 g1262196 i0 100 0.0974025974025974 30 0 10 0 218 247 21911 21882 Candidatus Ecksteinia adelgidicola isolate Ad18-003 chromosome, complete genome blastn 30 56.5 1 Bacteria Candidatus Ecksteinia Pseudomonadati Pseudomonadota Gammaproteobacteria       Candidatus Ecksteinia adelgidicola
780263 780263 PRJNA795983_S_NODE_6841_length_447_cov_1.101604_g6716_i0 PRJNA795983 6841 447 1.101604 4.92416988 Candidatus Ecksteinia adelgidicola 1076629 Bacteria Bacteria 56.5 0.003   NTclustered gi|2119945591|gb|CP045239.1| 1076629 g6716 i0 100 0.0671140939597315 30 0 7 0 95 124 560842 560813 Candidatus Ecksteinia adelgidicola isolate Ad18-003 chromosome, complete genome blastn 30 56.5 1 Bacteria Candidatus Ecksteinia Pseudomonadati Pseudomonadota Gammaproteobacteria       Candidatus Ecksteinia adelgidicola
1074021 1074021 PRJNA379145_P_NODE_30641_length_407_cov_9.395722_g28514_i0 PRJNA379145 30641 407 9.395722 38.24058854 root 1 Root_unresolved Root_unresolved 52.8 0.039   NTclustered gi|2119945591|gb|CP045239.1| 1076629 g28514 i0 100 0.137592137592138 28 0 7 0 1 28 608406 608379 Candidatus Ecksteinia adelgidicola isolate Ad18-003 chromosome, complete genome blastn 56 52.8 1 Bacteria Candidatus Ecksteinia Pseudomonadati Pseudomonadota Gammaproteobacteria       Candidatus Ecksteinia adelgidicola
2563334 2563334 PRJEB10140_P_NODE_92683_length_395_cov_2.205202_g75390_i0 PRJEB10140 92683 395 2.205202 8.7105479 Candidatus Ecksteinia adelgidicola 1076629 Bacteria Bacteria 54.7 0.011   NTclustered gi|2119945591|gb|CP045239.1| 1076629 g75390 i0 96.97 0.0835443037974684 33 0 8 1 329 360 22343 22311 Candidatus Ecksteinia adelgidicola isolate Ad18-003 chromosome, complete genome blastn 33 54.7 1 Bacteria Candidatus Ecksteinia Pseudomonadati Pseudomonadota Gammaproteobacteria       Candidatus Ecksteinia adelgidicola
3109425 3109425 PRJNA565778_S_NODE_8203_length_375_cov_6.819527_g7910_i0 PRJNA565778 8203 375 6.819527 25.57322625 Candidatus Ecksteinia adelgidicola 1076629 Bacteria Bacteria 169 3.4e-37   NTclustered gi|2119945591|gb|CP045239.1| 1076629 g7910 i0 77.09 12.112 323 55 83 15 59 371 791151 790838 Candidatus Ecksteinia adelgidicola isolate Ad18-003 chromosome, complete genome blastn 4542 169 1 Bacteria Candidatus Ecksteinia Pseudomonadati Pseudomonadota Gammaproteobacteria       Candidatus Ecksteinia adelgidicola
19423629 19423629 PRJNA1148190_P_NODE_568896_length_253_cov_1.711111_g557723_i0 PRJNA1148190 568896 253 1.711111 4.32911083 Candidatus Ecksteinia adelgidicola 1076629 Bacteria Bacteria 167 7.86e-37   NTclustered gi|2119945591|gb|CP045239.1| 1076629 g557723 i0 89.922 58.197628458498 129 13 51 0 8 136 161412 161284 Candidatus Ecksteinia adelgidicola isolate Ad18-003 chromosome, complete genome blastn 14724 167 1 Bacteria Candidatus Ecksteinia Pseudomonadati Pseudomonadota Gammaproteobacteria       Candidatus Ecksteinia adelgidicola
19951841 19951841 PRJNA835051_S_NODE_108656_length_163_cov_2.533333_g108360_i0 PRJNA835051 108656 163 2.533333 4.12933279 Candidatus Ecksteinia adelgidicola 1076629 Bacteria Bacteria 52.8 0.014   NTclustered gi|2119945591|gb|CP045239.1| 1076629 g108360 i0 100 0.171779141104294 28 0 17 0 123 150 696415 696388 Candidatus Ecksteinia adelgidicola isolate Ad18-003 chromosome, complete genome blastn 28 52.8 1 Bacteria Candidatus Ecksteinia Pseudomonadati Pseudomonadota Gammaproteobacteria       Candidatus Ecksteinia adelgidicola
20075268 20075268 PRJNA976345_P_NODE_58476_length_232_cov_1.604061_g56868_i0 PRJNA976345 58476 232 1.604061 3.72142152 Candidatus Ecksteinia adelgidicola 1076629 Bacteria Bacteria 52.8 0.021   NTclustered gi|2119945591|gb|CP045239.1| 1076629 g56868 i0 91.892 0.15948275862069 37 3 16 0 125 161 850543 850579 Candidatus Ecksteinia adelgidicola isolate Ad18-003 chromosome, complete genome blastn 37 52.8 1 Bacteria Candidatus Ecksteinia Pseudomonadati Pseudomonadota Gammaproteobacteria       Candidatus Ecksteinia adelgidicola
20638005 20638005 PRJNA1120060_P_NODE_136697_length_521_cov_0.921875_g121122_i0 PRJNA1120060 136697 521 0.921875 4.80296875 Candidatus Ecksteinia adelgidicola 1076629 Bacteria Bacteria 54.7 0.014   NTclustered gi|2119945591|gb|CP045239.1| 1076629 g121122 i0 94.286 0.0671785028790787 35 2 7 0 478 512 739444 739478 Candidatus Ecksteinia adelgidicola isolate Ad18-003 chromosome, complete genome blastn 35 54.7 1 Bacteria Candidatus Ecksteinia Pseudomonadati Pseudomonadota Gammaproteobacteria       Candidatus Ecksteinia adelgidicola
20765129 20765129 PRJNA1262902_P_NODE_7817_length_250_cov_0.870056_g7775_i0 PRJNA1262902 7817 250 0.870056 2.17514 Candidatus Ecksteinia adelgidicola 1076629 Bacteria Bacteria 52.8 0.023   NTclustered gi|2119945591|gb|CP045239.1| 1076629 g7775 i0 100 0.112 28 0 11 0 5 32 267738 267765 Candidatus Ecksteinia adelgidicola isolate Ad18-003 chromosome, complete genome blastn 28 52.8 1 Bacteria Candidatus Ecksteinia Pseudomonadati Pseudomonadota Gammaproteobacteria       Candidatus Ecksteinia adelgidicola
22430075 22430075 PRJNA774958_P_NODE_34618_length_249_cov_0.875000_g34371_i0 PRJNA774958 34618 249 0.875 2.17875 Candidatus Ecksteinia adelgidicola 1076629 Bacteria Bacteria 54.7 0.006   NTclustered gi|2119945591|gb|CP045239.1| 1076629 g34371 i0 88.889 0.180722891566265 45 3 18 2 126 170 339377 339335 Candidatus Ecksteinia adelgidicola isolate Ad18-003 chromosome, complete genome blastn 45 54.7 1 Bacteria Candidatus Ecksteinia Pseudomonadati Pseudomonadota Gammaproteobacteria       Candidatus Ecksteinia adelgidicola

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