RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJNA690592", tax_clade = "PVC group" and tax_phylum = "Lentisphaerota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Lentisphaerota · 7 ✖

tax_kingdom 1

tax_clade 1

  • PVC group · 7 ✖

bioproject 1

  • PRJNA690592 · 7 ✖

analysis 1

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
19030665 19030665 PRJNA690592_S_NODE_176755_length_257_cov_1.255435_g175741_i0 PRJNA690592 176755 257 1.255435 3.22646795 Lentisphaerae bacterium GWF2_44_16 1798571 Bacteria Bacteria 89.7 1.32e-18   NR OGV47526.1 1798571 g175741 i0 75.9 11.1828793774319 58 14 67.7 0 175 2 740 797 OGV47526.1 MAG: methionine synthase, partial [Lentisphaerae bacterium GWF2_44_16] diamond 2874 89.7 1 Bacteria PVC group Pseudomonadati Lentisphaerota         Lentisphaerae bacterium GWF2_44_16
27524839 27524839 PRJNA690592_S_NODE_194723_length_248_cov_1.045714_g193709_i0 PRJNA690592 194723 248 1.045714 2.59337072 Lentisphaeria bacterium 2053569 Bacteria Bacteria 44.7 0.00806   NR MCH2176571.1 2053569 g193709 i0 54.5 0.870967741935484 33 15 39.9 0 148 246 253 285 MCH2176571.1 protein kinase [Lentisphaeria bacterium] diamond 216 44.7 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria       Lentisphaeria bacterium
27883479 27883479 PRJNA690592_S_NODE_28385_length_566_cov_2.081136_g27387_i0 PRJNA690592 28385 566 2.081136 11.77922976 Bacteria 2 Bacteria Bacteria 187 3.1899999999999992e-52   NR MBR7145767.1 2053569 g27387 i0 56.6 10.113074204947 159 68 84.3 1 85 561 221 378 MBR7145767.1 alpha amylase C-terminal domain-containing protein [Lentisphaeria bacterium] diamond 5724 188 0.99468085106383 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria       Lentisphaeria bacterium
28345679 28345679 PRJNA690592_S_NODE_129306_length_295_cov_1.387387_g128292_i0 PRJNA690592 129306 295 1.387387 4.09279165 Victivallis vadensis 172901 Bacteria Bacteria 43.1 0.0474   NR WP_168964365.1 172901 g128292 i0 41.7 0.610169491525424 60 28 61 2 205 26 30 82 WP_168964365.1 hypothetical protein, partial [Victivallis vadensis] diamond 180 43.1 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria Victivallales Victivallaceae Victivallis Victivallis vadensis
30145301 30145301 PRJNA690592_S_NODE_118592_length_306_cov_0.991416_g117578_i0 PRJNA690592 118592 306 0.991416 3.03373296 Lentisphaeria bacterium 2053569 Bacteria Bacteria 63.9 2.87e-9   NR MBQ9754129.1 2053569 g117578 i0 30.3 0.970588235294118 99 69 97.1 0 9 305 376 474 MBQ9754129.1 DUF4838 domain-containing protein [Lentisphaeria bacterium] diamond 297 63.9 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria       Lentisphaeria bacterium
31409815 31409815 PRJNA690592_S_NODE_63536_length_396_cov_1.665635_g62522_i0 PRJNA690592 63536 396 1.665635 6.5959146 Lentisphaeria bacterium 2053569 Bacteria Bacteria 68.2 2.72e-10   NR NQZ67090.1 2053569 g62522 i0 50.7 2.40909090909091 67 33 50.8 0 2 202 1448 1514 NQZ67090.1 hypothetical protein [Lentisphaeria bacterium] diamond 954 68.2 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria       Lentisphaeria bacterium
32674395 32674395 PRJNA690592_S_NODE_109880_length_315_cov_2.190083_g108866_i0 PRJNA690592 109880 315 2.190083 6.89876145 Lentisphaeria bacterium 2053569 Bacteria Bacteria 53.5 1.44e-5   NR NQZ67090.1 2053569 g108866 i0 59.1 2.35238095238095 44 18 41.9 0 307 176 1471 1514 NQZ67090.1 hypothetical protein [Lentisphaeria bacterium] diamond 741 53.5 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria       Lentisphaeria 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);;