RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA560029" and tax_phylum = "Bacteroidota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacteroidota · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA560029 · 7 ✖

analysis 1

  • blastn · 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
1819313 1819313 PRJNA560029_S_NODE_10022_length_367_cov_2.027211_g9798_i0 PRJNA560029 10022 367 2.027211 7.43986437 Hymenobacter cellulosivorans 2932249 Bacteria Bacteria 259 1.91e-64   NTclustered gi|2221893832|gb|CP095049.1| 2932249 g9798 i0 84.758 5.13351498637602 269 29 71 8 108 367 238050 237785 Hymenobacter cellulosivorans strain 5116 S-27 chromosome, complete genome blastn 1884 259 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Hymenobacteraceae Hymenobacter Hymenobacter cellulosivorans
10058956 10058956 PRJNA560029_S_NODE_14348_length_335_cov_1.992366_g14124_i0 PRJNA560029 14348 335 1.992366 6.6744261 root 1 Root_unresolved Root_unresolved 619 6.91e-173   NTclustered gi|2252144666|gb|CP098482.1| 817 g14124 i0 100 50.5761194029851 335 0 100 0 1 335 4159331 4158997 Bacteroides fragilis strain 86-5443-2-2 chromosome, complete genome blastn 16943 619 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Bacteroidaceae Bacteroides Bacteroides fragilis
11333612 11333612 PRJNA560029_S_NODE_8749_length_379_cov_2.741830_g8525_i0 PRJNA560029 8749 379 2.74183 10.3915357 Chryseobacterium 59732 Bacteria Bacteria 54.7 0.01   NTclustered gi|1519571667|gb|CP033932.1| 1241978 g8525 i0 94.444 0.284960422163588 36 0 9 2 1 34 1356764 1356799 Chryseobacterium bernardetii strain G0229 chromosome, complete genome blastn 108 54.7 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Weeksellaceae Chryseobacterium Chryseobacterium bernardetii
12022793 12022793 PRJNA560029_S_NODE_12610_length_346_cov_3.326007_g12386_i0 PRJNA560029 12610 346 3.326007 11.50798422 Flavobacterium sp. CECT 9288 2845819 Bacteria Bacteria 632 9.199999999999996e-177   NTclustered gi|2152726014|emb|OU957226.1| 2845819 g12386 i0 99.71 489.387283236994 345 1 99 0 2 346 823507 823163 Flavobacterium sp. CECT 9288 genome assembly, chromosome: 1 blastn 169328 632 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium sp. CECT 9288
13298094 13298094 PRJNA560029_S_NODE_28251_length_265_cov_84.083333_g28027_i0 PRJNA560029 28251 265 84.083333 222.82083245 Candidatus Karelsulcia muelleri 336810 Bacteria Bacteria 62.1 4.02e-5   NTclustered gi|2717309477|emb|OZ032149.1| 336810 g28027 i0 97.222 0.135849056603774 36 1 14 0 110 145 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
18396042 18396042 PRJNA560029_S_NODE_34395_length_244_cov_1.216374_g34171_i0 PRJNA560029 34395 244 1.216374 2.96795256 Bacteroides zhangwenhongii 2650157 Bacteria Bacteria 451 1.86e-122   NTclustered gi|2922009181|gb|CP182860.1| 2650157 g34171 i0 100 1 244 0 100 0 1 244 1546643 1546400 Bacteroides zhangwenhongii strain 10-10 chromosome, complete genome blastn 244 451 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Bacteroidaceae Bacteroides Bacteroides zhangwenhongii
20945858 20945858 PRJNA560029_S_NODE_11817_length_352_cov_3.139785_g11593_i0 PRJNA560029 11817 352 3.139785 11.0520432 Flavobacterium dauae 1563479 Bacteria Bacteria 56.5 0.003   NTclustered gi|2557430891|gb|CP130821.1| 1563479 g11593 i0 100 0.0852272727272727 30 0 9 0 65 94 1161438 1161409 Flavobacterium dauae strain TCH3-2 chromosome, complete genome blastn 30 56.5 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium dauae

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