RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA506002 · 5 ✖

analysis 1

  • blastn · 5 ✖
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
13237724 13237724 PRJNA506002_S_NODE_22751_length_333_cov_1.911538_g22505_i0 PRJNA506002 22751 333 1.911538 6.36542154 uncultured Bacteroides sp. 162156 Bacteria Bacteria 272 2.2099999999999998e-68   NTclustered gi|2729058744|emb|OZ007034.1| 162156 g22505 i0 81.846 10.5435435435435 325 57 97 2 10 333 2766033 2766356 MAG: uncultured Bacteroides sp. isolate 6737_HOM_CTRL_s7.ctg000008l_hifiasm_large MAG genome assembly, chromosome: 1 blastn 3511 272 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Bacteroidaceae Bacteroides uncultured Bacteroides sp.
17061167 17061167 PRJNA506002_S_NODE_24134_length_328_cov_0.894118_g23888_i0 PRJNA506002 24134 328 0.894118 2.93270704 Marinoscillum sp. 2024838 Bacteria Bacteria 54.7 0.009   NTclustered gi|2836248207|gb|CP121337.1| 2024838 g23888 i0 100 0.173780487804878 29 0 9 0 226 254 2770392 2770364 MAG: Marinoscillum sp. isolate NCC532_bact_3502 chromosome, complete genome blastn 57 54.7 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Reichenbachiellaceae Marinoscillum Marinoscillum sp.
17061381 17061381 PRJNA506002_S_NODE_51154_length_259_cov_1.655914_g50908_i0 PRJNA506002 51154 259 1.655914 4.28881726 Sphingobacterium sp. G1-14 2003121 Bacteria Bacteria 479 9.13e-131   NTclustered gi|1207396639|gb|CP021381.1| 2003121 g50908 i0 100 16.003861003861 259 0 100 0 1 259 4821639 4821897 Sphingobacterium sp. G1-14, complete genome blastn 4145 479 1 Bacteria FCB group Pseudomonadati Bacteroidota Sphingobacteriia Sphingobacteriales Sphingobacteriaceae Sphingobacterium Sphingobacterium sp. G1-14
22160917 22160917 PRJNA506002_S_NODE_65398_length_242_cov_1.189349_g65152_i0 PRJNA506002 65398 242 1.189349 2.87822458 Candidatus Ornithobacterium hominis 2497989 Bacteria Bacteria 52.8 0.022   NTclustered gi|2502739559|emb|OX579588.1| 2497989 g65152 i0 100 0.462809917355372 28 0 12 0 177 204 1401684 1401657 Candidatus Ornithobacterium hominis strain MSHR-COH1 genome assembly, chromosome: 1 blastn 112 52.8 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Weeksellaceae Ornithobacterium Candidatus Ornithobacterium hominis
24062475 24062475 PRJNA506002_S_NODE_39279_length_284_cov_0.981043_g39033_i0 PRJNA506002 39279 284 0.981043 2.78616212 Sphingobacterium 28453 Bacteria Bacteria 514 2.78e-141   NTclustered gi|2647208394|gb|CP141191.1| 259 g39033 i0 99.298 438.904929577465 285 1 100 1 1 284 411538 411254 Sphingobacterium thalpophilum strain YX-3 chromosome, complete genome blastn 124649 514 1 Bacteria FCB group Pseudomonadati Bacteroidota Sphingobacteriia Sphingobacteriales Sphingobacteriaceae Sphingobacterium Sphingobacterium thalpophilum

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