RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA796639" and tax_phylum = "Bacteroidota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacteroidota · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA796639 · 4 ✖

analysis 1

  • blastn · 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
3768316 3768316 PRJNA796639_P_NODE_2963_length_326_cov_0.881423_g2838_i0 PRJNA796639 2963 326 0.881423 2.87343898 Hoylesella 2974257 Bacteria Bacteria 479 1.1899999999999996e-130   NTclustered gi|2127571982|gb|CP085926.1| 28127 g2838 i0 93.03 253.613496932515 330 19 100 3 1 326 210154 210483 Hoylesella buccalis strain FDAARGOS_1588 chromosome, complete genome blastn 82678 479 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Prevotellaceae Hoylesella Hoylesella buccalis
12696253 12696253 PRJNA796639_P_NODE_4370_length_278_cov_1.502439_g4245_i0 PRJNA796639 4370 278 1.502439 4.17678042 Elizabethkingia 308865 Bacteria Bacteria 52.8 0.026   NTclustered gi|2638023975|gb|CP140570.1| 172045 g4245 i0 100 0.201438848920863 28 0 10 0 109 136 1006673 1006646 Elizabethkingia miricola strain 2023CK-01286 chromosome, complete genome blastn 56 52.8 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Weeksellaceae Elizabethkingia Elizabethkingia miricola
22457701 22457701 PRJNA796639_P_NODE_6658_length_246_cov_1.138728_g6533_i0 PRJNA796639 6658 246 1.138728 2.80127088 Chryseobacterium gleum 250 Bacteria Bacteria 440 4.0599999999999984e-119   NTclustered gi|1966888383|gb|CP068486.1| 250 g6533 i0 99.18 304.036585365854 244 2 99 0 3 246 169515 169758 Chryseobacterium gleum strain FDAARGOS_1103 chromosome blastn 74793 440 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Weeksellaceae Chryseobacterium Chryseobacterium gleum
23733325 23733325 PRJNA796639_P_NODE_5999_length_249_cov_0.875000_g5874_i0 PRJNA796639 5999 249 0.875 2.17875 Pedobacter sp. HDW13 2714940 Bacteria Bacteria 52.8 0.023   NTclustered gi|1821195603|gb|CP049868.1| 2714940 g5874 i0 100 0.112449799196787 28 0 11 0 80 107 3216799 3216826 Pedobacter sp. HDW13 chromosome, complete genome blastn 28 52.8 1 Bacteria FCB group Pseudomonadati Bacteroidota Sphingobacteriia Sphingobacteriales Sphingobacteriaceae Pedobacter Pedobacter sp. HDW13

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