RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA602115" and tax_phylum = "Bacteroidota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacteroidota · 8 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA602115 · 8 ✖

analysis 1

  • diamond · 8 ✖
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
28058999 28058999 PRJNA602115_P_NODE_6745_length_245_cov_0.815217_g6720_i0 PRJNA602115 6745 245 0.815217 1.99728165 Tannerella sp. 2382127 Bacteria Bacteria 73.2 1.87e-14   NR MDR2233916.1 2382127 g6720 i0 60.3 2.13061224489796 58 23 71 0 176 3 6 63 MDR2233916.1 hypothetical protein [Tannerella sp.] diamond 522 73.2 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Tannerellaceae Tannerella Tannerella sp.
30661916 30661916 PRJNA602115_P_NODE_11033_length_203_cov_0.901408_g11008_i0 PRJNA602115 11033 203 0.901408 1.82985824 Flavobacterium 237 Bacteria Bacteria 107 3.96e-25   NR WP_286925668.1 1946546 g11008 i0 80.6 1.98029556650246 67 13 99 0 2 202 2 68 WP_286925668.1 DUF4139 domain-containing protein [Flavobacterium sp. UBA4197] diamond 402 108 0.990740740740741 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium sp. UBA4197
30996271 30996271 PRJNA602115_P_NODE_7874_length_224_cov_1.177914_g7849_i0 PRJNA602115 7874 224 1.177914 2.63852736 Flammeovirgaceae bacterium 2026740 Bacteria Bacteria 121 4.51e-34   NR MFM7852277.1 2026740 g7849 i0 68.1 0.924107142857143 69 22 92.4 0 207 1 6 74 MFM7852277.1 transglycosylase SLT domain-containing protein [Flammeovirgaceae bacterium] diamond 207 121 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Flammeovirgaceae   Flammeovirgaceae bacterium
31262326 31262326 PRJNA602115_P_NODE_3215_length_339_cov_0.920863_g3190_i0 PRJNA602115 3215 339 0.920863 3.12172557 FCB group 1783270 Bacteria Bacteria 144 9.87e-41   NR WP_278410490.1 328814 g3190 i0 64.2 1.92920353982301 109 39 96.5 0 334 8 92 200 WP_278410490.1 replication protein [Alistipes shahii] diamond 654 144 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Rikenellaceae Alistipes Alistipes shahii
31438695 31438695 PRJNA602115_P_NODE_3836_length_314_cov_1.328063_g3811_i0 PRJNA602115 3836 314 1.328063 4.17011782 Bacteroidota bacterium 1898104 Bacteria Bacteria 199 3.18e-59   NR MEY3590881.1 1898104 g3811 i0 97.1 0.993630573248408 104 3 99.4 0 1 312 325 428 MEY3590881.1 Gokushovirinae [Bacteroidota bacterium] diamond 312 199 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
31470591 31470591 PRJNA602115_P_NODE_6656_length_246_cov_1.383784_g6631_i0 PRJNA602115 6656 246 1.383784 3.40410864 Flavobacterium cerinum 2502784 Bacteria Bacteria 58.5 3.79e-9   NR WP_256550751.1 2502784 g6631 i0 90.6 0.390243902439024 32 3 39 0 1 96 1 32 WP_256550751.1 hypothetical protein [Flavobacterium cerinum] diamond 96 58.5 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium cerinum
31565540 31565540 PRJNA602115_P_NODE_2936_length_353_cov_1.339041_g2911_i0 PRJNA602115 2936 353 1.339041 4.72681473 Bacteroidota bacterium 1898104 Bacteria Bacteria 158 6.02e-46   NR MEY3590880.1 1898104 g2911 i0 85.5 0.994334277620397 117 17 99.4 0 3 353 31 147 MEY3590880.1 hypothetical protein [Bacteroidota bacterium] diamond 351 158 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
32103053 32103053 PRJNA602115_P_NODE_5838_length_263_cov_1.584158_g5813_i0 PRJNA602115 5838 263 1.584158 4.16633554 Chryseobacterium gambrini 373672 Bacteria Bacteria 164 3.24e-50   NR MBL7880273.1 373672 g5813 i0 100 0.992395437262357 87 0 99.2 0 2 262 41 127 MBL7880273.1 PepSY-like domain-containing protein [Chryseobacterium gambrini] diamond 261 164 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Weeksellaceae Chryseobacterium Chryseobacterium gambrini

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