RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJNA741997", 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

  • PRJNA741997 · 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
18573297 18573297 PRJNA741997_P_NODE_61835_length_274_cov_1.124378_g60715_i0 PRJNA741997 61835 274 1.124378 3.08079572 Victivallales bacterium 2212475 Bacteria Bacteria 122 5.25e-30   NR MCF7791488.1 2212475 g60715 i0 63.3 0.985401459854015 90 33 98.5 0 272 3 492 581 MCF7791488.1 plasma-membrane proton-efflux P-type ATPase [Victivallales bacterium] diamond 270 122 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria Victivallales     Victivallales bacterium
26735635 26735635 PRJNA741997_P_NODE_82941_length_245_cov_0.895349_g81821_i0 PRJNA741997 82941 245 0.895349 2.19360505 Lentisphaeria bacterium 2053569 Bacteria Bacteria 43.5 0.0185   NR MBR2439833.1 2053569 g81821 i0 36.4 0.808163265306122 66 37 78.4 2 232 41 146 208 MBR2439833.1 hypothetical protein [Lentisphaeria bacterium] diamond 198 43.5 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria       Lentisphaeria bacterium
28884134 28884134 PRJNA741997_P_NODE_85568_length_243_cov_1.129412_g84448_i0 PRJNA741997 85568 243 1.129412 2.74447116 Lentisphaeria bacterium 2053569 Bacteria Bacteria 50.4 7.24e-5   NR MDT8389727.1 2053569 g84448 i0 38.3 2.81481481481481 81 41 91.4 3 241 20 1885 1963 MDT8389727.1 hypothetical protein [Lentisphaeria bacterium] diamond 684 50.4 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria       Lentisphaeria bacterium
28947609 28947609 PRJNA741997_P_NODE_55528_length_288_cov_1.134884_g54408_i0 PRJNA741997 55528 288 1.134884 3.26846592 Victivallis sp. Marseille-Q1 2049020 Bacteria Bacteria 121 5.35e-30   NR WP_176014944.1 2717288 g54408 i0 63.2 6.71875 95 35 99 0 287 3 377 471 WP_176014944.1 adenylosuccinate lyase [Victivallis sp. Marseille-Q1083] diamond 1935 121 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria Victivallales Victivallaceae Victivallis Victivallis sp. Marseille-Q1083
29168547 29168547 PRJNA741997_P_NODE_57129_length_284_cov_1.459716_g56009_i0 PRJNA741997 57129 284 1.459716 4.14559344 Lentisphaerota bacterium 1932692 Bacteria Bacteria 43.1 0.0445   NR NQU40803.1 1932692 g56009 i0 52.8 0.380281690140845 36 17 38 0 13 120 37 72 NQU40803.1 ankyrin repeat domain-containing protein [Lentisphaerota bacterium] diamond 108 43.1 1 Bacteria PVC group Pseudomonadati Lentisphaerota         Lentisphaerota bacterium
29483866 29483866 PRJNA741997_P_NODE_90330_length_237_cov_2.103659_g89210_i0 PRJNA741997 90330 237 2.103659 4.98567183 Lentisphaerota bacterium 1932692 Bacteria Bacteria 42.7 0.0326   NR NMA46629.1 1932692 g89210 i0 33.3 0.949367088607595 75 49 93.7 1 14 235 2 76 NMA46629.1 phosphate ABC transporter substrate-binding protein PstS [Lentisphaerota bacterium] diamond 225 42.7 1 Bacteria PVC group Pseudomonadati Lentisphaerota         Lentisphaerota bacterium
30368938 30368938 PRJNA741997_P_NODE_53512_length_293_cov_1.600000_g52392_i0 PRJNA741997 53512 293 1.6 4.688 Lentisphaeria bacterium 2053569 Bacteria Bacteria 114 5.6800000000000006e-27   NR MCK5802391.1 2053569 g52392 i0 66.3 1.79180887372014 89 30 91.1 0 27 293 381 469 MCK5802391.1 pyruvate, phosphate dikinase [Lentisphaeria bacterium] diamond 525 114 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);;