RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where bioproject = "PRJNA950981", tax_phylum = "Acidobacteriota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 11 ✖

tax_phylum 1

  • Acidobacteriota · 11 ✖

tax_kingdom 1

bioproject 1

  • PRJNA950981 · 11 ✖

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
27063727 27063727 PRJNA950981_P_NODE_19682_length_246_cov_0.901734_g19506_i0 PRJNA950981 19682 246 0.901734 2.21826564 Bacteria 2 Bacteria Bacteria 90.5 5.8200000000000005e-21   NR HEX5707520.1 2283092 g19506 i0 57.5 1.81707317073171 73 31 89 0 242 24 75 147 HEX5707520.1 membrane dipeptidase [Pyrinomonadaceae bacterium] diamond 447 90.5 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
27411672 27411672 PRJNA950981_P_NODE_11123_length_306_cov_2.266094_g10947_i0 PRJNA950981 11123 306 2.266094 6.93424764 Bacteria 2 Bacteria Bacteria 65.5 2.31e-10   NR MDQ3816950.1 1978231 g10947 i0 46.7 4.26470588235294 75 34 67.6 1 80 286 45 119 MDQ3816950.1 hypothetical protein [Acidobacteriota bacterium] diamond 1305 65.9 0.993930197268589 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
28263717 28263717 PRJNA950981_P_NODE_21946_length_236_cov_2.773006_g21770_i0 PRJNA950981 21946 236 2.773006 6.54429416 Pseudomonadati 3379134 Bacteria Bacteria 50.1 8.98e-5   NR MEN8162850.1 1978231 g21770 i0 33.7 3.15254237288136 83 49 97.9 1 234 4 12 94 MEN8162850.1 phosphoenolpyruvate carboxylase [Acidobacteriota bacterium] diamond 744 50.4 0.994047619047619 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
28358493 28358493 PRJNA950981_P_NODE_15226_length_264_cov_1.225131_g15050_i0 PRJNA950981 15226 264 1.225131 3.23434584 Pseudomonadati 3379134 Bacteria Bacteria 74.3 1.37e-14   NR MBI3450741.1 1978231 g15050 i0 42.5 5.88636363636364 87 50 98.9 0 262 2 19 105 MBI3450741.1 DUF4197 domain-containing protein [Acidobacteriota bacterium] diamond 1554 74.3 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
28383600 28383600 PRJNA950981_P_NODE_8986_length_336_cov_1.779468_g8810_i0 PRJNA950981 8986 336 1.779468 5.97901248 Acidobacteriota bacterium 1978231 Bacteria Bacteria 118 1.36e-28   NR MCU1229960.1 1978231 g8810 i0 53.8 2.875 106 49 94.6 0 7 324 362 467 MCU1229960.1 gabT [Acidobacteriota bacterium] diamond 966 118 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
28983802 28983802 PRJNA950981_P_NODE_248_length_1624_cov_2.180529_g199_i0 PRJNA950981 248 1624 2.180529 35.41179096 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 213 1.57e-58   NR HEX8178810.1 2283092 g199 i0 32.8 1.76046798029557 458 268 84.1 12 120 1484 65 485 HEX8178810.1 FAD-binding protein [Pyrinomonadaceae bacterium] diamond 2859 213 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
29646173 29646173 PRJNA950981_P_NODE_270_length_1595_cov_2.089356_g218_i0 PRJNA950981 270 1595 2.089356 33.3252282 Candidatus Acidiferrales bacterium 2952895 Bacteria Bacteria 52.4 0.00522   NR HKS67540.1 2952895 g218 i0 25.6 0.46269592476489 246 153 44.4 8 891 184 1 226 HKS67540.1 translational GTPase TypA [Candidatus Acidiferrales bacterium] diamond 738 52.4 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Candidatus Acidiferrales     Candidatus Acidiferrales bacterium
30151702 30151702 PRJNA950981_P_NODE_9232_length_332_cov_1.806950_g9056_i0 PRJNA950981 9232 332 1.80695 5.999074 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 73.6 1.19e-14   NR HTS02623.1 2651171 g9056 i0 47.4 1.56325301204819 57 29 51.5 1 281 111 11 66 HTS02623.1 hypothetical protein [Thermoanaerobaculia bacterium] diamond 519 73.6 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
31447643 31447643 PRJNA950981_P_NODE_2956_length_556_cov_4.175983_g2783_i0 PRJNA950981 2956 556 4.1759829999999996 23.21846548 Acidobacteriaceae bacterium 2052142 Bacteria Bacteria 140 1.07e-36   NR MDR3737318.1 2052142 g2783 i0 46 0.949640287769784 176 90 93.3 3 543 25 139 312 MDR3737318.1 hypothetical protein [Acidobacteriaceae bacterium] diamond 528 140 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae   Acidobacteriaceae bacterium
31580863 31580863 PRJNA950981_P_NODE_11316_length_304_cov_1.870130_g11140_i0 PRJNA950981 11316 304 1.87013 5.6851952 Pseudomonadati 3379134 Bacteria Bacteria 102 1.09e-22   NR WP_184252823.1 940614 g11140 i0 52.5 5.96052631578947 101 46 99.7 1 1 303 332 430 WP_184252823.1 allophanate hydrolase [Granulicella mallensis] diamond 1812 102 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Granulicella Granulicella mallensis
31953648 31953648 PRJNA950981_P_NODE_20357_length_245_cov_0.906977_g20181_i0 PRJNA950981 20357 245 0.906977 2.22209365 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 54.7 2.4e-6   NR HEX9421636.1 2283092 g20181 i0 42.3 0.636734693877551 52 30 63.7 0 88 243 1195 1246 HEX9421636.1 protein kinase [Pyrinomonadaceae bacterium] diamond 156 54.7 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae 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);;