RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA939369", 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 · 6 ✖

tax_kingdom 1

tax_clade 1

  • PVC group · 6 ✖

bioproject 1

  • PRJNA939369 · 6 ✖

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
27024988 27024988 PRJNA939369_S_NODE_37042_length_283_cov_1.100000_g36625_i0 PRJNA939369 37042 283 1.1 3.113 Lentisphaeria bacterium 2053569 Bacteria Bacteria 73.6 2.43e-14   NR MBO5959449.1 2053569 g36625 i0 47.8 0.710247349823322 67 30 71 2 216 16 64 125 MBO5959449.1 hypothetical protein [Lentisphaeria bacterium] diamond 201 73.6 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria       Lentisphaeria bacterium
27189914 27189914 PRJNA939369_S_NODE_49942_length_258_cov_1.237838_g49525_i0 PRJNA939369 49942 258 1.237838 3.19362204 Pseudomonadati 3379134 Bacteria Bacteria 55.8 3.22e-7   NR MBE6396838.1 1932692 g49525 i0 53.2 1.63953488372093 47 21 53.5 1 143 6 1 47 MBE6396838.1 hypothetical protein [Lentisphaerota bacterium] diamond 423 55.8 1 Bacteria PVC group Pseudomonadati Lentisphaerota         Lentisphaerota bacterium
27246217 27246217 PRJNA939369_S_NODE_10103_length_423_cov_0.880000_g9686_i0 PRJNA939369 10103 423 0.88 3.7224 Lentisphaerota bacterium 1932692 Bacteria Bacteria 59.7 2.97e-7   NR MEI6421291.1 1932692 g9686 i0 35.2 0.865248226950355 122 62 83.7 6 396 43 368 476 MEI6421291.1 FkbM family methyltransferase [Lentisphaerota bacterium] diamond 366 59.7 1 Bacteria PVC group Pseudomonadati Lentisphaerota         Lentisphaerota bacterium
27467534 27467534 PRJNA939369_S_NODE_51783_length_255_cov_1.269231_g51366_i0 PRJNA939369 51783 255 1.269231 3.23653905 Victivallales bacterium 2212475 Bacteria Bacteria 51.6 3.2e-5   NR MBQ2337189.1 2212475 g51366 i0 40.2 1.02352941176471 87 47 100 2 255 1 305 388 MBQ2337189.1 hypothetical protein [Victivallales bacterium] diamond 261 51.6 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria Victivallales     Victivallales bacterium
29519676 29519676 PRJNA939369_S_NODE_68450_length_245_cov_0.860465_g68033_i0 PRJNA939369 68450 245 0.860465 2.10813925 Victivallales bacterium 2212475 Bacteria Bacteria 113 4.7400000000000006e-27   NR MBO4526572.1 2212475 g68033 i0 70.5 0.955102040816327 78 23 95.5 0 243 10 3065 3142 MBO4526572.1 strawberry notch C-terminal domain-containing protein [Victivallales bacterium] diamond 234 113 1 Bacteria PVC group Pseudomonadati Lentisphaerota Lentisphaeria Victivallales     Victivallales bacterium
32586088 32586088 PRJNA939369_S_NODE_70919_length_243_cov_1.358824_g70502_i0 PRJNA939369 70919 243 1.358824 3.30194232 Lentisphaeria bacterium 2053569 Bacteria Bacteria 79 4.19e-15   NR MBR1951952.1 2053569 g70502 i0 48.1 1.95061728395062 79 41 97.5 0 6 242 227 305 MBR1951952.1 tyrosine-type recombinase/integrase [Lentisphaeria bacterium] diamond 474 79 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);;