RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA643700" 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

  • PRJNA643700 · 7 ✖

analysis 1

  • blastn · 7 ✖
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
618105 618105 PRJNA643700_P_NODE_275401_length_223_cov_2.511494_g273845_i0 PRJNA643700 275401 223 2.511494 5.60063162 Candidatus Stammera capleta 2608262 Bacteria Bacteria 52.8 0.02   NTclustered gi|1269271234|gb|CP024013.1| 2608262 g273845 i0 100 0.125560538116592 28 0 13 0 177 204 216513 216540 MAG: Candidatus Stammera capleta isolate NZ1215 chromosome, complete genome blastn 28 52.8 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Stammera Candidatus Stammera capleta
5721572 5721572 PRJNA643700_P_NODE_122045_length_374_cov_3.516923_g120490_i0 PRJNA643700 122045 374 3.516923 13.15329202 Candidatus Purcelliella pentastirinorum 472834 Bacteria Bacteria 52.8 0.036   NTclustered gi|2446695914|gb|CP110499.1| 472834 g120490 i0 100 0.224598930481283 28 0 7 0 15 42 391980 391953 Candidatus Purcelliella pentastirinorum isolate OFIL1 chromosome, complete genome blastn 84 52.8 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Purcelliella Candidatus Purcelliella pentastirinorum
13372374 13372374 PRJNA643700_P_NODE_426211_length_162_cov_0.920354_g424655_i0 PRJNA643700 426211 162 0.920354 1.49097348 Candidatus Stammera capleta 2608262 Bacteria Bacteria 54.7 0.004   NTclustered gi|2676815340|gb|CP144813.1| 2608262 g424655 i0 100 0.351851851851852 29 0 18 0 128 156 68786 68758 MAG: Candidatus Stammera capleta isolate DOCHLPPF chromosome blastn 57 54.7 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Stammera Candidatus Stammera capleta
14647181 14647181 PRJNA643700_P_NODE_403392_length_166_cov_0.888889_g401836_i0 PRJNA643700 403392 166 0.888889 1.47555574 Candidatus Gullanella endobia 1070130 Bacteria Bacteria 52.8 0.014   NTclustered gi|1011040111|emb|LN999832.1| 1070130 g401836 i0 100 0.168674698795181 28 0 17 0 6 33 538461 538488 Enterobacteriaceae bacterium symbiont of Ferrisia virgata isolate GEFVIR genome assembly, chromosome: I blastn 28 52.8 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Gullanella Candidatus Gullanella endobia
14647220 14647220 PRJNA643700_P_NODE_423492_length_162_cov_1.380531_g421936_i0 PRJNA643700 423492 162 1.380531 2.23646022 Candidatus Hartigia pinicola 1345115 Bacteria Bacteria 54.7 0.004   NTclustered gi|2119947094|gb|CP048208.1| 1345115 g421936 i0 96.97 0.203703703703704 33 0 20 1 21 52 662428 662460 Candidatus Hartigia pinicola isolate Ad13-065 chromosome blastn 33 54.7 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Hartigia Candidatus Hartigia pinicola
18470360 18470360 PRJNA643700_P_NODE_236955_length_248_cov_4.040201_g235399_i0 PRJNA643700 236955 248 4.040201 10.01969848 Candidatus Stammera capleta 2608262 Bacteria Bacteria 56.5 0.002   NTclustered gi|1925240934|gb|CP043991.1| 2608262 g235399 i0 96.97 0.262096774193548 33 1 13 0 138 170 167507 167475 MAG: Candidatus Stammera capleta isolate 1 chromosome, complete genome blastn 65 56.5 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Stammera Candidatus Stammera capleta
25385066 25385066 PRJNA643700_P_NODE_337680_length_191_cov_1.464789_g336124_i0 PRJNA643700 337680 191 1.464789 2.79774699 root 1 Root_unresolved Root_unresolved 52.8 0.016   NTclustered gi|2246420380|gb|CP097750.1| 108080 g336124 i0 100 0.74869109947644 28 0 15 0 96 123 149384 149357 Candidatus Blochmanniella camponoti strain C-050 chromosome, complete genome blastn 143 52.8 1 Bacteria ant, tsetse, mealybug, aphid, etc. endosymbionts Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Candidatus Blochmanniella Candidatus Blochmanniella camponoti

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