RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA1011833" and tax_clade = "FCB group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • FCB group · 6 ✖

bioproject 1

  • PRJNA1011833 · 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
2276774 2276774 PRJNA1011833_S_NODE_54762_length_156_cov_0.964602_g54342_i0 PRJNA1011833 54762 156 0.964602 1.50477912 Sphingobacterium 28453 Bacteria Bacteria 283 4.1899999999999994e-72   NTclustered gi|2719408992|gb|CP151087.1| 259 g54342 i0 99.359 228.711538461538 156 1 100 0 1 156 2537389 2537544 Sphingobacterium thalpophilum strain ATCC BAA-1094 chromosome, complete genome blastn 35679 283 1 Bacteria FCB group Pseudomonadati Bacteroidota Sphingobacteriia Sphingobacteriales Sphingobacteriaceae Sphingobacterium Sphingobacterium thalpophilum
9082828 9082828 PRJNA1011833_S_NODE_15848_length_303_cov_6.984615_g15428_i0 PRJNA1011833 15848 303 6.984615 21.16338345 Flavobacterium dauae 1563479 Bacteria Bacteria 56.5 0.002   NTclustered gi|2557430891|gb|CP130821.1| 1563479 g15428 i0 100 0.099009900990099 30 0 10 0 271 300 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
11633947 11633947 PRJNA1011833_S_NODE_21910_length_256_cov_22.586854_g21490_i0 PRJNA1011833 21910 256 22.586854 57.82234624 Candidatus Karelsulcia muelleri 336810 Bacteria Bacteria 62.1 3.87e-5   NTclustered gi|2717309477|emb|OZ032149.1| 336810 g21490 i0 97.222 0.140625 36 1 14 0 72 107 226088 226053 Candidatus Karelsulcia muelleri isolate 1d4c07cd-1054-4c54-98f9-64159b4f6ee4 genome assembly, chromosome: 1 blastn 36 62.1 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales   Candidatus Karelsulcia Candidatus Karelsulcia muelleri
12480408 12480408 PRJNA1011833_S_NODE_28590_length_221_cov_1.859551_g28170_i0 PRJNA1011833 28590 221 1.859551 4.10960771 Weeksellaceae 2762318 Bacteria Bacteria 409 1.0100000000000001e-109   NTclustered gi|1750497007|gb|CP043634.1| 247 g28170 i0 100 455.787330316742 221 0 100 0 1 221 229159 228939 Empedobacter brevis strain SE1-3 chromosome, complete genome blastn 100729 409 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Weeksellaceae Empedobacter Empedobacter brevis
17579457 17579457 PRJNA1011833_S_NODE_37294_length_191_cov_1.297297_g36874_i0 PRJNA1011833 37294 191 1.297297 2.47783727 Sphingobacterium 28453 Bacteria Bacteria 348 1.87e-91   NTclustered gi|2719408992|gb|CP151087.1| 259 g36874 i0 99.476 457.738219895288 191 1 100 0 1 191 1767388 1767578 Sphingobacterium thalpophilum strain ATCC BAA-1094 chromosome, complete genome blastn 87428 348 1 Bacteria FCB group Pseudomonadati Bacteroidota Sphingobacteriia Sphingobacteriales Sphingobacteriaceae Sphingobacterium Sphingobacterium thalpophilum
20556561 20556561 PRJNA1011833_S_NODE_30477_length_213_cov_1.976471_g30057_i0 PRJNA1011833 30477 213 1.976471 4.20988323 Thermoflavifilum sp. 1968839 Bacteria Bacteria 56.5 0.001   NTclustered gi|1919310413|gb|CP063141.1| 1968839 g30057 i0 97.059 0.15962441314554 34 0 15 1 123 155 302638 302605 Thermoflavifilum sp. isolate Bu77 chromosome blastn 34 56.5 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae Thermoflavifilum Thermoflavifilum 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);;