RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA1148190" and tax_clade = "SAR86 cluster"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • SAR86 cluster · 4 ✖

bioproject 1

  • PRJNA1148190 · 4 ✖
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
20699570 20699570 PRJNA1148190_P_NODE_617057_length_249_cov_1.750000_g605884_i0 PRJNA1148190 617057 249 1.75 4.3575 SAR86 cluster bacterium 2030880 Bacteria Bacteria 54.7 0.006   NTclustered gi|2252314943|gb|CP097971.1| 2030880 g605884 i0 96.875 0.1285140562249 32 1 13 0 4 35 866439 866470 SAR86 cluster bacterium isolate D2474-J1 chromosome, complete genome blastn 32 54.7 1 Bacteria SAR86 cluster Pseudomonadati Pseudomonadota Gammaproteobacteria       SAR86 cluster bacterium
26691316 26691316 PRJNA1148190_P_NODE_435301_length_279_cov_1.495146_g424128_i0 PRJNA1148190 435301 279 1.495146 4.17145734 SAR86 cluster bacterium 2030880 Bacteria Bacteria 54.7 3.6e-6   NR PCJ18273.1 2030880 g424128 i0 34.5 0.935483870967742 87 56 93.5 1 268 8 188 273 PCJ18273.1 MAG: hypothetical protein COA96_16770 [SAR86 cluster bacterium] diamond 261 54.7 1 Bacteria SAR86 cluster Pseudomonadati Pseudomonadota Gammaproteobacteria       SAR86 cluster bacterium
28303162 28303162 PRJNA1148190_P_NODE_587426_length_251_cov_0.865169_g576253_i0 PRJNA1148190 587426 251 0.865169 2.17157419 SAR86 cluster bacterium 2030880 Bacteria Bacteria 90.9 4.74e-19   NR MBL6902899.1 2030880 g576253 i0 61.9 4.00398406374502 84 30 99.2 2 3 251 564 646 MBL6902899.1 excinuclease ABC subunit UvrA [SAR86 cluster bacterium] diamond 1005 90.9 1 Bacteria SAR86 cluster Pseudomonadati Pseudomonadota Gammaproteobacteria       SAR86 cluster bacterium
28998389 28998389 PRJNA1148190_P_NODE_715428_length_244_cov_1.526316_g704255_i0 PRJNA1148190 715428 244 1.526316 3.72421104 SAR86 cluster bacterium 2030880 Bacteria Bacteria 68.6 9.14e-12   NR MBC8221147.1 2030880 g704255 i0 40.5 2.84016393442623 79 44 94.7 2 242 12 136 213 MBC8221147.1 DUF723 domain-containing protein [SAR86 cluster bacterium] diamond 693 68.6 1 Bacteria SAR86 cluster Pseudomonadati Pseudomonadota Gammaproteobacteria       SAR86 cluster 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);;