RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA547066" and tax_phylum = "Bacteroidota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacteroidota · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA547066 · 6 ✖

analysis 1

  • blastn · 6 ✖
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
1787041 1787041 PRJNA547066_P_NODE_6202_length_150_cov_1.008696_g6108_i0 PRJNA547066 6202 150 1.008696 1.513044 Flavobacterium nakdongensis 3073563 Bacteria Bacteria 243 6.75e-60   NTclustered gi|2575681008|gb|CP133721.1| 3073563 g6108 i0 96 556 150 5 100 1 1 150 829654 829506 Flavobacterium nakdongensis strain 20NA77.7 chromosome, complete genome blastn 83400 243 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium nakdongensis
3670784 3670784 PRJNA547066_P_NODE_2603_length_289_cov_1.236220_g2509_i0 PRJNA547066 2603 289 1.23622 3.5726758 Aquirufa 2676247 Bacteria Bacteria 316 8.59e-82   NTclustered gi|1390254249|gb|CP029346.1| 2516557 g2509 i0 90.164 282.176470588235 244 22 84 2 14 256 359291 359049 Aquirufa nivalisilvae strain HME7025 chromosome, complete genome blastn 81549 316 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Flectobacillaceae Aquirufa Aquirufa nivalisilvae
4947631 4947631 PRJNA547066_P_NODE_5004_length_173_cov_1.065217_g4910_i0 PRJNA547066 5004 173 1.065217 1.84282541 Flavobacterium 237 Bacteria Bacteria 289 1.02e-73   NTclustered gi|2496343437|gb|CP092332.1| 1306518 g4910 i0 97.076 455.751445086705 171 5 99 0 3 173 1184576 1184746 Flavobacterium keumense strain K3R-10 chromosome, complete genome blastn 78845 289 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium keumense
5615387 5615387 PRJNA547066_P_NODE_3905_length_209_cov_1.609195_g3811_i0 PRJNA547066 3905 209 1.609195 3.36321755 Empedobacter falsenii 343874 Bacteria Bacteria 364 2.0699999999999992e-96   NTclustered gi|1878091573|gb|CP040908.1| 343874 g3811 i0 98.086 6.22488038277512 209 4 100 0 1 209 1132400 1132192 Empedobacter falsenii strain 1681-1 chromosome, complete genome blastn 1301 364 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Weeksellaceae Empedobacter Empedobacter falsenii
10715712 10715712 PRJNA547066_P_NODE_5009_length_173_cov_0.949275_g4915_i0 PRJNA547066 5009 173 0.949275 1.64224575 Coprobacter fastidiosus 1099853 Bacteria Bacteria 176 8.26e-40   NTclustered gi|2487365010|dbj|AP028032.1| 1099853 g4915 i0 85.393 283.526011560694 178 16 98 9 1 170 1036934 1036759 Coprobacter fastidiosus JCM 33896 DNA, complete genome blastn 49050 176 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Barnesiellaceae Coprobacter Coprobacter fastidiosus
22796703 22796703 PRJNA547066_P_NODE_5078_length_171_cov_1.470588_g4984_i0 PRJNA547066 5078 171 1.470588 2.51470548 Sphingobacterium 28453 Bacteria Bacteria 316 4.6e-82   NTclustered gi|1958275331|gb|CP068224.1| 28454 g4984 i0 100 17.8830409356725 171 0 100 0 1 171 4671291 4671121 Sphingobacterium multivorum strain FDAARGOS_1141 chromosome, complete genome blastn 3058 316 1 Bacteria FCB group Pseudomonadati Bacteroidota Sphingobacteriia Sphingobacteriales Sphingobacteriaceae Sphingobacterium Sphingobacterium multivorum

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