RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "diamond", bioproject = "PRJEB6584" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 9 ✖

tax_kingdom 1

bioproject 1

  • PRJEB6584 · 9 ✖

analysis 1

  • diamond · 9 ✖

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
26477331 26477331 PRJEB6584o_S_NODE_23280_length_193_cov_1.886076_g23172_i0 PRJEB6584 23280 193 1.886076 3.64012668 Alloacidobacterium sp. 2951999 Bacteria Bacteria 66.2 9.51e-11   NR HMD21440.1 2951999 g23172 i0 51.8 3.48186528497409 56 27 87 0 193 26 290 345 HMD21440.1 sensor histidine kinase [Alloacidobacterium sp.] diamond 672 66.2 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Alloacidobacterium Alloacidobacterium sp.
32963675 32963675 PRJEB6584o_S_NODE_1666_length_504_cov_31.501066_g1582_i0 PRJEB6584 1666 504 31.501066 158.76537264 Acidobacteriota bacterium 1978231 Bacteria Bacteria 66.6 5.48e-10   NR MEM7351477.1 1978231 g1582 i0 42.6 0.55952380952381 94 43 49.4 2 461 213 104 197 MEM7351477.1 hypothetical protein [Acidobacteriota bacterium] diamond 282 66.6 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
33014736 33014736 PRJEB6584o_S_NODE_1756_length_495_cov_73.197826_g1671_i0 PRJEB6584 1756 495 73.197826 362.3292387 Acidobacteriota bacterium 1978231 Bacteria Bacteria 66.6 5.08e-10   NR MEM7351477.1 1978231 g1671 i0 42.6 0.56969696969697 94 43 50.3 2 44 292 104 197 MEM7351477.1 hypothetical protein [Acidobacteriota bacterium] diamond 282 66.6 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
33014859 33014859 PRJEB6584o_S_NODE_2860_length_428_cov_19.188295_g2754_i0 PRJEB6584 2860 428 19.188295 82.1259026 Acidobacteriota bacterium 1978231 Bacteria Bacteria 67.4 1.42e-10   NR MEM7351477.1 1978231 g2754 i0 42.6 0.658878504672897 94 43 58.2 2 44 292 104 197 MEM7351477.1 hypothetical protein [Acidobacteriota bacterium] diamond 282 67.4 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
33025766 33025766 PRJEB6584o_S_NODE_21052_length_199_cov_2.445122_g20944_i0 PRJEB6584 21052 199 2.445122 4.86579278 Pseudomonadati 3379134 Bacteria Bacteria 48.5 1.93e-4   NR HEV7429049.1 2651171 g20944 i0 47.7 1.20603015075377 44 23 66.3 0 2 133 25 68 HEV7429049.1 hypothetical protein [Thermoanaerobaculia bacterium] diamond 240 48.5 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
33059656 33059656 PRJEB6584d_S_NODE_4813_length_261_cov_3.880531_g4745_i0 PRJEB6584 4813 261 3.880531 10.12818591 Pseudomonadati 3379134 Bacteria Bacteria 42.4 0.0118   NR MEP7212091.1 1978231 g4745 i0 44.6 2.03448275862069 56 23 55.2 2 197 54 2 57 MEP7212091.1 hypothetical protein [Acidobacteriota bacterium] diamond 531 42.4 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
33093879 33093879 PRJEB6584a_S_NODE_4382_length_190_cov_2.393548_g4362_i0 PRJEB6584 4382 190 2.393548 4.5477412 Pseudomonadati 3379134 Bacteria Bacteria 58.5 4.4e-8   NR MCI0490797.1 2052146 g4362 i0 51.9 1.64210526315789 52 25 82.1 0 33 188 26 77 MCI0490797.1 hypothetical protein [Blastocatellia bacterium] diamond 312 58.9 0.99320882852292 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia       Blastocatellia bacterium
33116888 33116888 PRJEB6584l_S_NODE_24535_length_153_cov_2.059322_g24383_i0 PRJEB6584 24535 153 2.059322 3.15076266 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 48.1 1.39e-4   NR HVL66240.1 2910147 g24383 i0 51.1 0.92156862745098 47 23 92.2 0 150 10 451 497 HVL66240.1 tetratricopeptide repeat protein [Vicinamibacterales bacterium] diamond 141 48.1 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
33168200 33168200 PRJEB6584o_S_NODE_16592_length_218_cov_5.846995_g16484_i0 PRJEB6584 16592 218 5.846995 12.7464491 Acidobacteriota bacterium 1978231 Bacteria Bacteria 67 2.84e-12   NR MDQ7008654.1 1978231 g16484 i0 92.5 1.19724770642202 40 2 55 1 218 99 70 108 MDQ7008654.1 hypothetical protein [Acidobacteriota bacterium] diamond 261 67 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);;