RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA1129273" and tax_clade = "PVC group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

tax_clade 1

  • PVC group · 7 ✖

bioproject 1

  • PRJNA1129273 · 7 ✖

analysis 1

  • diamond · 7 ✖
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
27133174 27133174 PRJNA1129273_P_NODE_9882_length_245_cov_0.901163_g9602_i0 PRJNA1129273 9882 245 0.901163 2.20784935 Gemmataceae bacterium 2052164 Bacteria Bacteria 61.2 6.72e-9   NR MCI0681538.1 2052164 g9602 i0 44.4 0.991836734693878 81 44 98 1 6 245 122 202 MCI0681538.1 hypothetical protein [Gemmataceae bacterium] diamond 243 61.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
27280776 27280776 PRJNA1129273_P_NODE_4403_length_342_cov_3.345725_g4123_i0 PRJNA1129273 4403 342 3.345725 11.4423795 root 1 Root_unresolved Root_unresolved 89 6.4e-18   NR NUM34221.1 2517210 g4123 i0 46.5 1.73684210526316 99 49 83.3 1 41 325 388 486 NUM34221.1 hypothetical protein [Candidatus Brocadiia bacterium] diamond 594 89.4 0.995525727069351 Bacteria PVC group Pseudomonadati Planctomycetota Candidatus Brocadiia       Candidatus Brocadiia bacterium
27734045 27734045 PRJNA1129273_P_NODE_7784_length_261_cov_2.218085_g7504_i0 PRJNA1129273 7784 261 2.218085 5.78920185 Verrucomicrobiia bacterium 2499141 Bacteria Bacteria 77 4.04e-14   NR HYG84357.1 2499141 g7504 i0 55.1 0.896551724137931 78 33 89.7 1 258 25 204 279 HYG84357.1 hypothetical protein [Verrucomicrobiia bacterium] diamond 234 77 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       Verrucomicrobiia bacterium
27954769 27954769 PRJNA1129273_P_NODE_6185_length_286_cov_1.267606_g5905_i0 PRJNA1129273 6185 286 1.267606 3.62535316 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 91.3 5.95e-22   NR MBV8318647.1 2026779 g5905 i0 67.2 2.50699300699301 61 19 62.9 1 281 102 3 63 MBV8318647.1 hypothetical protein [Planctomycetaceae bacterium] diamond 717 91.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
30575597 30575597 PRJNA1129273_P_NODE_2393_length_503_cov_4.809302_g2117_i0 PRJNA1129273 2393 503 4.809302 24.19078906 Chlamydiales bacterium 2047757 Bacteria Bacteria 148 2.7499999999999993e-42   NR MCP5470421.1 2047757 g2117 i0 51.9 3.57256461232604 156 69 91.8 2 484 23 6 157 MCP5470421.1 hypothetical protein [Chlamydiales bacterium] diamond 1797 148 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales     Chlamydiales bacterium
31429114 31429114 PRJNA1129273_P_NODE_8056_length_258_cov_1.243243_g7776_i0 PRJNA1129273 8056 258 1.243243 3.20756694 Symmachiella macrocystis 2527985 Bacteria Bacteria 48.1 5.38e-4   NR WP_146374485.1 2527985 g7776 i0 43.3 0.697674418604651 60 33 69.8 1 236 57 381 439 WP_146374485.1 caspase family protein [Symmachiella macrocystis] diamond 180 48.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Symmachiella Symmachiella macrocystis
31860900 31860900 PRJNA1129273_P_NODE_2417_length_500_cov_1.250585_g2141_i0 PRJNA1129273 2417 500 1.250585 6.252925 root 1 Root_unresolved Root_unresolved 66.6 2.43e-9   NR MBA4031902.1 37635 g2141 i0 32.7 2.58 165 98 95.4 6 496 20 377 534 MBA4031902.1 hypothetical protein [Planctomyces sp.] diamond 1290 67 0.994029850746269 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Planctomyces Planctomyces sp.

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);;