RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA448207" and tax_clade = "FCB group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

tax_clade 1

  • FCB group · 8 ✖

bioproject 1

  • PRJNA448207 · 8 ✖

analysis 1

  • diamond · 8 ✖
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
27455470 27455470 PRJNA448207_P_NODE_27063_length_249_cov_0.875000_g26900_i0 PRJNA448207 27063 249 0.875 2.17875 Candidatus Pullibacteroides excrementavium 2840905 Bacteria Bacteria 42.7 0.0402   NR MBO8433670.1 2840905 g26900 i0 33.9 0.746987951807229 62 37 69.9 1 188 15 543 604 MBO8433670.1 fibronectin type III domain-containing protein [Candidatus Pullibacteroides excrementavium] diamond 186 42.7 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales   Candidatus Pullibacteroides Candidatus Pullibacteroides excrementavium
28939389 28939389 PRJNA448207_S_NODE_3488_length_250_cov_0.864407_g3477_i0 PRJNA448207 3488 250 0.864407 2.1610175 Porphyromonas gingivalis F 837 Bacteria Bacteria 59.7 8.01e-10   NR ERJ68952.1 1227271 g3477 i0 96.2 0.312 26 1 31.2 0 80 3 10 35 ERJ68952.1 hypothetical protein HMPREF1555_00132 [Porphyromonas gingivalis F0570] diamond 78 59.7 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Porphyromonadaceae Porphyromonas Porphyromonas gingivalis
29065669 29065669 PRJNA448207_P_NODE_28448_length_247_cov_0.885057_g28285_i0 PRJNA448207 28448 247 0.885057 2.18609079 Tannerella sp. 2382127 Bacteria Bacteria 53.1 2.31e-6   NR MDR1224070.1 2382127 g28285 i0 35.2 0.862348178137652 71 44 83.8 1 243 37 71 141 MDR1224070.1 hypothetical protein [Tannerella sp.] diamond 213 53.1 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Tannerellaceae Tannerella Tannerella sp.
30013003 30013003 PRJNA448207_P_NODE_28591_length_247_cov_0.885057_g28428_i0 PRJNA448207 28591 247 0.885057 2.18609079 Porphyromonas sp. 1924944 Bacteria Bacteria 114 2.61e-31   NR WP_414477854.1 1924944 g28428 i0 98.3 3.582995951417 59 1 71.7 0 247 71 24 82 WP_414477854.1 transposase, partial [Porphyromonas sp.] diamond 885 114 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Porphyromonadaceae Porphyromonas Porphyromonas sp.
30329340 30329340 PRJNA448207_P_NODE_13292_length_346_cov_0.849817_g13129_i0 PRJNA448207 13292 346 0.849817 2.94036682 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 47.4 0.00283   NR HKU63407.1 2448054 g13129 i0 36.1 0.936416184971098 108 55 85 6 25 318 66 169 HKU63407.1 hypothetical protein [Gemmatimonadales bacterium] diamond 324 47.4 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
30455553 30455553 PRJNA448207_P_NODE_26193_length_250_cov_0.870056_g26030_i0 PRJNA448207 26193 250 0.870056 2.17514 Bacteroidota bacterium 1898104 Bacteria Bacteria 41.6 0.0346   NR MCH8276136.1 1898104 g26030 i0 42.4 0.396 33 19 39.6 0 3 101 9 41 MCH8276136.1 hypothetical protein [Bacteroidota bacterium] diamond 99 41.6 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
31466700 31466700 PRJNA448207_P_NODE_17796_length_304_cov_1.961039_g17633_i0 PRJNA448207 17796 304 1.961039 5.96155856 Hymenobacter sp. 1898978 Bacteria Bacteria 42 0.0174   NR MDB5234348.1 1898978 g17633 i0 40 0.592105263157895 60 35 58.2 1 235 59 7 66 MDB5234348.1 transcription-repair coupling factor [Hymenobacter sp.] diamond 180 42 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Hymenobacteraceae Hymenobacter Hymenobacter sp.
31845972 31845972 PRJNA448207_P_NODE_27137_length_249_cov_0.875000_g26974_i0 PRJNA448207 27137 249 0.875 2.17875 Flavobacterium soli 344881 Bacteria Bacteria 166 1.43e-50   NR WP_026704786.1 344881 g26974 i0 92.8 1 83 6 100 0 249 1 20 102 WP_026704786.1 class I SAM-dependent methyltransferase [Flavobacterium soli] diamond 249 166 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium soli

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