RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA484127" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA484127 · 4 ✖

analysis 1

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
27518694 27518694 PRJNA484127_P_NODE_9263_length_394_cov_2.037383_g9114_i0 PRJNA484127 9263 394 2.037383 8.02728902 Edaphobacter aggregans 570835 Bacteria Bacteria 45.8 0.0161   NR WP_125485313.1 570835 g9114 i0 41.6 0.677664974619289 89 39 64 4 372 121 713 793 WP_125485313.1 LPS-assembly protein LptD [Edaphobacter aggregans] diamond 267 45.8 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Edaphobacter Edaphobacter aggregans
29555309 29555309 PRJNA484127_P_NODE_18490_length_304_cov_1.186147_g18341_i0 PRJNA484127 18490 304 1.186147 3.60588688 Pseudomonadati 3379134 Bacteria Bacteria 104 1.4499999999999998e-23   NR HBL28423.1 1978231 g18341 i0 52.6 4.82565789473684 97 46 95.7 0 2 292 421 517 HBL28423.1 glutamate formimidoyltransferase [Acidobacteriota bacterium] diamond 1467 104 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
30708151 30708151 PRJNA484127_P_NODE_6974_length_442_cov_1.170732_g6826_i0 PRJNA484127 6974 442 1.170732 5.17463544 Acidobacteriota bacterium 1978231 Bacteria Bacteria 45.4 0.032   NR MCB1007425.1 1978231 g6826 i0 40.8 0.481900452488688 71 42 48.2 0 144 356 345 415 MCB1007425.1 PD40 domain-containing protein [Acidobacteriota bacterium] diamond 213 45.4 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
32731548 32731548 PRJNA484127_P_NODE_34500_length_247_cov_0.896552_g34351_i0 PRJNA484127 34500 247 0.896552 2.21448344 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 65.9 9.05e-12   NR MET0164672.1 2910147 g34351 i0 60.8 0.959514170040486 79 8 68 3 184 17 7 85 MET0164672.1 hypothetical protein [Vicinamibacterales bacterium] diamond 237 65.9 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales 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);;