RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJEB65099" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJEB65099 · 7 ✖

analysis 1

  • diamond · 7 ✖

tax_clade 0

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
17571755 17571755 PRJEB65099_P_NODE_6374_length_245_cov_0.906977_g6269_i0 PRJEB65099 6374 245 0.906977 2.22209365 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 68.6 3.01e-11   NR HEX7778979.1 2910147 g6269 i0 76.1 0.563265306122449 46 11 56.3 0 2 139 451 496 HEX7778979.1 ankyrin repeat domain-containing protein [Vicinamibacterales bacterium] diamond 138 68.6 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
17981513 17981513 PRJEB65099_P_NODE_7075_length_228_cov_2.012903_g6970_i0 PRJEB65099 7075 228 2.012903 4.5894188400000004 Pseudomonadati 3379134 Bacteria Bacteria 130 3.5e-33   NR MBZ5556581.1 2081523 g6970 i0 89.3 15.7894736842105 75 8 98.7 0 3 227 443 517 MBZ5556581.1 ABC transporter ATP-binding protein/permease [Terriglobia bacterium] diamond 3600 130 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia       Terriglobia bacterium
26685600 26685600 PRJEB65099_P_NODE_5381_length_250_cov_1.322034_g5276_i0 PRJEB65099 5381 250 1.322034 3.305085 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 142 3.5099999999999995e-37   NR HEX8197159.1 2283092 g5276 i0 75.6 2.952 82 20 98.4 0 3 248 303 384 HEX8197159.1 triple tyrosine motif-containing protein [Pyrinomonadaceae bacterium] diamond 738 142 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
27792156 27792156 PRJEB65099_P_NODE_6464_length_244_cov_0.912281_g6359_i0 PRJEB65099 6464 244 0.912281 2.22596564 Acidobacteriota bacterium 1978231 Bacteria Bacteria 150 3.32e-42   NR PYT01409.1 1978231 g6359 i0 85 1.9672131147541 80 12 98.4 0 3 242 8 87 PYT01409.1 MAG: IS110 family transposase [Acidobacteriota bacterium] diamond 480 150 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
28613005 28613005 PRJEB65099_P_NODE_6727_length_243_cov_0.917647_g6622_i0 PRJEB65099 6727 243 0.917647 2.22988221 Candidatus Sulfotelmatobacter sp. 2771375 Bacteria Bacteria 144 2.32e-39   NR HTB93058.1 2771375 g6622 i0 95 0.987654320987654 80 4 98.8 0 242 3 125 204 HTB93058.1 MFS transporter [Candidatus Sulfotelmatobacter sp.] diamond 240 144 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Candidatus Korobacteraceae Candidatus Sulfotelmatobacter Candidatus Sulfotelmatobacter sp.
28770803 28770803 PRJEB65099_P_NODE_4947_length_253_cov_0.866667_g4842_i0 PRJEB65099 4947 253 0.866667 2.19266751 Terriglobia bacterium 2081523 Bacteria Bacteria 82 1.31e-17   NR MBZ5633929.1 2081523 g4842 i0 58.4 1.05533596837945 89 30 99.6 3 253 2 32 118 MBZ5633929.1 hypothetical protein [Terriglobia bacterium] diamond 267 82 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia       Terriglobia bacterium
31677304 31677304 PRJEB65099_P_NODE_6497_length_244_cov_0.912281_g6392_i0 PRJEB65099 6497 244 0.912281 2.22596564 Acidobacteriota bacterium 1978231 Bacteria Bacteria 157 4.2999999999999996e-46   NR MSO21345.1 1978231 g6392 i0 87.7 0.995901639344262 81 10 99.6 0 243 1 171 251 MSO21345.1 hypothetical protein [Acidobacteriota bacterium] diamond 243 157 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium

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