RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "blastn", bioproject = "PRJNA222400" 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 · 12 ✖

bioproject 1

  • PRJNA222400 · 12 ✖

analysis 1

  • blastn · 12 ✖
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
1642007 1642007 PRJNA222400_P_NODE_5822_length_186_cov_1.394161_g5789_i0 PRJNA222400 5822 186 1.394161 2.59313946 Runella sp. SP2 2268026 Bacteria Bacteria 322 1.1e-83   NTclustered gi|1509191025|gb|CP031030.1| 2268026 g5789 i0 97.861 287.263440860215 187 3 100 1 1 186 5733124 5733310 Runella sp. SP2 chromosome, complete genome blastn 53431 322 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Spirosomataceae Runella Runella sp. SP2
1642032 1642032 PRJNA222400_P_NODE_8482_length_165_cov_0.896552_g8449_i0 PRJNA222400 8482 165 0.896552 1.4793108 Cloacibacterium normanense 237258 Bacteria Bacteria 215 1.66e-51   NTclustered gi|1527207946|gb|CP034157.1| 237258 g8449 i0 93.151 1.76363636363636 146 10 88 0 1 146 209328 209473 Cloacibacterium normanense strain NRS-1 chromosome, complete genome blastn 291 215 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Weeksellaceae Cloacibacterium Cloacibacterium normanense
4884499 4884499 PRJNA222400_P_NODE_5084_length_198_cov_1.067114_g5051_i0 PRJNA222400 5084 198 1.067114 2.11288572 Sphingobacterium 28453 Bacteria Bacteria 331 1.97e-86   NTclustered gi|2306435172|gb|CP094931.1| 34087 g5051 i0 96.954 419.787878787879 197 6 99 0 2 198 228242 228046 Sphingobacterium faecium strain WB1 chromosome, complete genome blastn 83118 333 0.993993993993994 Bacteria FCB group Pseudomonadati Bacteroidota Sphingobacteriia Sphingobacteriales Sphingobacteriaceae Sphingobacterium Sphingobacterium faecium
4884508 4884508 PRJNA222400_P_NODE_9584_length_152_cov_2.019417_g9551_i0 PRJNA222400 9584 152 2.019417 3.06951384 Weeksellaceae 2762318 Bacteria Bacteria 281 1.46e-71   NTclustered gi|2429070341|gb|CP115857.1| 373672 g9551 i0 100 470.631578947368 152 0 100 0 1 152 1757828 1757979 Chryseobacterium gambrini strain PL22-1A chromosome, complete genome blastn 71536 281 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Weeksellaceae Chryseobacterium Chryseobacterium gambrini
5470588 5470588 PRJNA222400_P_NODE_8005_length_166_cov_1.324786_g7972_i0 PRJNA222400 8005 166 1.324786 2.19914476 Runella sp. SP2 2268026 Bacteria Bacteria 307 2.69e-79   NTclustered gi|1509191025|gb|CP031030.1| 2268026 g7972 i0 100 48.9457831325301 166 0 100 0 1 166 5734833 5734998 Runella sp. SP2 chromosome, complete genome blastn 8125 307 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Spirosomataceae Runella Runella sp. SP2
9295270 9295270 PRJNA222400_P_NODE_3228_length_258_cov_1.244019_g3195_i0 PRJNA222400 3228 258 1.244019 3.20956902 Runella sp. SP2 2268026 Bacteria Bacteria 460 3.29e-125   NTclustered gi|1509191025|gb|CP031030.1| 2268026 g3195 i0 98.842 312.813953488372 259 1 100 2 1 258 5735082 5735339 Runella sp. SP2 chromosome, complete genome blastn 80706 460 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Spirosomataceae Runella Runella sp. SP2
9295286 9295286 PRJNA222400_P_NODE_5348_length_194_cov_0.986207_g5315_i0 PRJNA222400 5348 194 0.986207 1.91324158 Sphingobacterium multivorum 28454 Bacteria Bacteria 267 5.489999999999999e-67   NTclustered gi|1958258319|gb|CP068086.1| 28454 g5315 i0 96.875 529.536082474227 160 4 82 1 35 194 4172382 4172540 Sphingobacterium multivorum strain FDAARGOS_1143 chromosome, complete genome blastn 102730 267 1 Bacteria FCB group Pseudomonadati Bacteroidota Sphingobacteriia Sphingobacteriales Sphingobacteriaceae Sphingobacterium Sphingobacterium multivorum
13121004 13121004 PRJNA222400_P_NODE_3711_length_234_cov_1.194595_g3678_i0 PRJNA222400 3711 234 1.194595 2.7953523 Flavobacterium alkalisoli 2602769 Bacteria Bacteria 243 1.16e-59   NTclustered gi|1724793953|gb|CP042831.1| 2602769 g3678 i0 88.038 536.324786324786 209 19 88 5 29 234 1553306 1553101 Flavobacterium alkalisoli strain XS-5 chromosome, complete genome blastn 125500 243 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium alkalisoli
18907992 18907992 PRJNA222400_P_NODE_6615_length_174_cov_2.568000_g6582_i0 PRJNA222400 6615 174 2.568 4.46832 Flavobacterium 237 Bacteria Bacteria 316 4.7e-82   NTclustered gi|1387106870|gb|CP029186.1| 2175091 g6582 i0 99.425 601.816091954023 174 1 100 0 1 174 383322 383495 Flavobacterium album strain HYN0059 chromosome, complete genome blastn 104716 316 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium album
24008479 24008479 PRJNA222400_P_NODE_9219_length_162_cov_1.380531_g9186_i0 PRJNA222400 9219 162 1.380531 2.23646022 Chitinophaga 79328 Bacteria Bacteria 110 7.89e-20   NTclustered gi|1241244614|gb|CP023254.1| 2033437 g9186 i0 92.308 134.925925925926 78 5 48 1 85 162 2093445 2093521 Chitinophaga sp. MD30 chromosome blastn 21858 110 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae Chitinophaga Chitinophaga sp. MD30
24593433 24593433 PRJNA222400_P_NODE_3320_length_253_cov_1.465686_g3287_i0 PRJNA222400 3320 253 1.465686 3.70818558 Runella sp. SP2 2268026 Bacteria Bacteria 462 8.95e-126   NTclustered gi|1509191025|gb|CP031030.1| 2268026 g3287 i0 99.605 296.296442687747 253 1 100 0 1 253 5734788 5734536 Runella sp. SP2 chromosome, complete genome blastn 74963 462 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Spirosomataceae Runella Runella sp. SP2
25282611 25282611 PRJNA222400_P_NODE_8000_length_166_cov_1.333333_g7967_i0 PRJNA222400 8000 166 1.333333 2.21333278 Sphingobacterium 28453 Bacteria Bacteria 302 1.2500000000000001e-77   NTclustered gi|359803893|dbj|AB680842.1| 34087 g7967 i0 99.398 125.855421686747 166 1 100 0 1 166 1109 1274 Sphingobacterium faecium gene for 16S rRNA, partial sequence, strain: NBRC 15337 blastn 20892 302 1 Bacteria FCB group Pseudomonadati Bacteroidota Sphingobacteriia Sphingobacteriales Sphingobacteriaceae Sphingobacterium Sphingobacterium faecium

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