RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJNA399133", tax_phylum = "Acidobacteriota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 7 ✖

tax_phylum 1

  • Acidobacteriota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA399133 · 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
413254 413254 PRJNA399133_P_NODE_7761_length_188_cov_1.830065_g7673_i0 PRJNA399133 7761 188 1.830065 3.4405222 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 303 4.03e-78   NTclustered gi|2874254027|emb|OY970352.1| 171953 g7673 i0 95.767 100.563829787234 189 7 100 1 1 188 2370337 2370525 MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1 blastn 18906 303 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
5516895 5516895 PRJNA399133_P_NODE_10765_length_161_cov_1.269841_g10677_i0 PRJNA399133 10765 161 1.269841 2.04444401 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 171 3.54e-38   NTclustered gi|2893358436|emb|OZ220728.1| 2910147 g10677 i0 85.714 31.6459627329193 161 23 100 0 1 161 5374946 5374786 MAG: Vicinamibacterales bacterium isolate 73bbec36-abbb-48ff-8f96-0d8513c84f17 genome assembly, chromosome: 1 blastn 5095 171 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
27408448 27408448 PRJNA399133_P_NODE_6523_length_206_cov_1.116959_g6435_i0 PRJNA399133 6523 206 1.116959 2.30093554 root 1 Root_unresolved Root_unresolved 48.9 8.45e-5   NR HEX8894457.1 2282142 g6435 i0 46.8 2.56310679611651 62 30 90.3 1 5 190 71 129 HEX8894457.1 hypothetical protein [Terriglobales bacterium] diamond 528 48.9 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales     Terriglobales bacterium
27629406 27629406 PRJNA399133_P_NODE_2544_length_313_cov_1.420863_g2456_i0 PRJNA399133 2544 313 1.420863 4.44730119 Bacteria 2 Bacteria Bacteria 83.2 5.52e-16   NR MDQ7008659.1 1978231 g2456 i0 46.4 2.85623003194888 97 49 92 3 295 8 881 975 MDQ7008659.1 reverse transcriptase domain-containing protein [Acidobacteriota bacterium] diamond 894 83.2 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
28086002 28086002 PRJNA399133_P_NODE_10505_length_163_cov_0.937500_g10417_i0 PRJNA399133 10505 163 0.9375 1.528125 Terriglobus sp. TAA 43 278961 Bacteria Bacteria 50.1 3.14e-5   NR WP_047495492.1 278961 g10417 i0 81.5 0.496932515337423 27 5 49.7 0 3 83 358 384 WP_047495492.1 NAD-dependent formate dehydrogenase [Terriglobus sp. TAA 43] diamond 81 50.1 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Terriglobus Terriglobus sp. TAA 43
29254114 29254114 PRJNA399133_P_NODE_10469_length_163_cov_1.515625_g10381_i0 PRJNA399133 10469 163 1.515625 2.47046875 Bryobacteraceae bacterium 2212468 Bacteria Bacteria 87.4 8.72e-19   NR HNY40226.1 2212468 g10381 i0 79.6 1.98773006134969 54 11 99.4 0 2 163 207 260 HNY40226.1 hypothetical protein [Bryobacteraceae bacterium] diamond 324 87.4 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae bacterium
31655467 31655467 PRJNA399133_P_NODE_5057_length_229_cov_1.974227_g4969_i0 PRJNA399133 5057 229 1.974227 4.52097983 Edaphobacter flagellatus 1933044 Bacteria Bacteria 92.4 1.59e-20   NR WP_260703073.1 1933044 g4969 i0 60.5 1.99126637554585 76 8 99.6 1 1 228 39 92 WP_260703073.1 3-keto-disaccharide hydrolase [Edaphobacter flagellatus] diamond 456 92.4 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Edaphobacter Edaphobacter flagellatus

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