RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA804229" and tax_phylum = "Bacteroidota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacteroidota · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA804229 · 5 ✖

analysis 1

  • blastn · 5 ✖
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
14831943 14831943 PRJNA804229_S_NODE_19632_length_400_cov_1.378151_g18678_i0 PRJNA804229 19632 400 1.378151 5.512604 Porphyromonas sp. oral taxon 275 712435 Bacteria Bacteria 682 0   NTclustered gi|2028834772|gb|CP072333.1| 712435 g18678 i0 98.21 424.18 391 6 98 1 10 400 442967 443356 Porphyromonas sp. oral taxon 275 strain W7780 chromosome, complete genome blastn 169672 682 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Porphyromonadaceae Porphyromonas Porphyromonas sp. oral taxon 275
14832847 14832847 PRJNA804229_S_NODE_57712_length_265_cov_2.031532_g56754_i0 PRJNA804229 57712 265 2.031532 5.3835598 uncultured Prevotellamassilia sp. 1926676 Bacteria Bacteria 457 4.39e-124   NTclustered gi|1997760563|emb|LR994473.1| 1926676 g56754 i0 97.736 549.064150943396 265 6 100 0 1 265 1235020 1234756 uncultured Prevotellamassilia sp. isolate Prevotellamassilia canine HQ MAG genome assembly, chromosome: 1 blastn 145502 457 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Prevotellaceae Prevotellamassilia uncultured Prevotellamassilia sp.
16108090 16108090 PRJNA804229_S_NODE_96553_length_207_cov_1.567073_g95595_i0 PRJNA804229 96553 207 1.567073 3.24384111 Kaistella polysaccharea 2878534 Bacteria Bacteria 71.3 5e-8   NTclustered gi|2111125107|gb|CP084528.1| 2878534 g95595 i0 93.617 23.3091787439614 47 3 23 0 158 204 1327894 1327848 Kaistella polysaccharea strain GW4-15 chromosome, complete genome blastn 4825 71.3 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Weeksellaceae Kaistella Kaistella polysaccharea
17382209 17382209 PRJNA804229_S_NODE_30254_length_345_cov_2.092715_g29296_i0 PRJNA804229 30254 345 2.092715 7.2198667500000004 Flavobacterium dauae 1563479 Bacteria Bacteria 56.5 0.003   NTclustered gi|2557430891|gb|CP130821.1| 1563479 g29296 i0 100 0.0869565217391304 30 0 9 0 274 303 1161409 1161438 Flavobacterium dauae strain TCH3-2 chromosome, complete genome blastn 30 56.5 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium dauae
24173691 24173691 PRJNA804229_S_NODE_54799_length_271_cov_2.157895_g53841_i0 PRJNA804229 54799 271 2.157895 5.84789545 Weeksellaceae 2762318 Bacteria Bacteria 496 9.55e-136   NTclustered gi|1750497007|gb|CP043634.1| 247 g53841 i0 99.631 422.110701107011 271 1 100 0 1 271 228962 229232 Empedobacter brevis strain SE1-3 chromosome, complete genome blastn 114392 496 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Weeksellaceae Empedobacter Empedobacter brevis

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