RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJNA734313" and tax_phylum = "Bacteroidota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacteroidota · 8 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA734313 · 8 ✖

analysis 1

  • blastn · 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
3268045 3268045 PRJNA734313_S_NODE_7903_length_330_cov_1.738516_g7790_i0 PRJNA734313 7903 330 1.738516 5.7371028 Porphyromonas sp. oral taxon 275 712435 Bacteria Bacteria 558 1.4999999999999995e-154   NTclustered gi|2028834772|gb|CP072333.1| 712435 g7790 i0 97.273 441.172727272727 330 8 100 1 1 330 443215 442887 Porphyromonas sp. oral taxon 275 strain W7780 chromosome, complete genome blastn 145587 558 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Porphyromonadaceae Porphyromonas Porphyromonas sp. oral taxon 275
8370016 8370016 PRJNA734313_S_NODE_4847_length_398_cov_20.108262_g4736_i0 PRJNA734313 4847 398 20.108262 80.03088276 Flavobacterium dauae 1563479 Bacteria Bacteria 56.5 0.003   NTclustered gi|2557430891|gb|CP130821.1| 1563479 g4736 i0 100 0.0753768844221105 30 0 8 0 279 308 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
10920659 10920659 PRJNA734313_S_NODE_25429_length_184_cov_1.277372_g25316_i0 PRJNA734313 25429 184 1.277372 2.35036448 Prevotella sp. oral taxon 299 652716 Bacteria Bacteria 340 2.99e-89   NTclustered gi|532126075|gb|CP003667.1| 575614 g25316 i0 100 216.217391304348 184 0 100 0 1 184 1523408 1523225 Prevotella sp. oral taxon 299 str. F0039 plasmid, complete sequence blastn 39784 340 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Prevotellaceae Prevotella Prevotella sp. oral taxon 299
10920678 10920678 PRJNA734313_S_NODE_9009_length_312_cov_4.479245_g8896_i0 PRJNA734313 9009 312 4.479245 13.9752444 Riemerella anatipestifer 34085 Bacteria Bacteria 363 1.1899999999999999e-95   NTclustered gi|392495286|gb|JQ664649.1| 34085 g8896 i0 89.041 0.935897435897436 292 32 94 0 3 294 293 2 Riemerella anatipestifer strain 8 aminoglycoside-3'-O-phosphotransferase (aph) gene, partial cds blastn 292 363 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Weeksellaceae Riemerella Riemerella anatipestifer
13470463 13470463 PRJNA734313_S_NODE_35111_length_160_cov_0.858407_g34998_i0 PRJNA734313 35111 160 0.858407 1.3734512 Prevotella corporis 28128 Bacteria Bacteria 257 2.62e-64   NTclustered gi|2446185766|gb|CP118020.1| 28128 g34998 i0 95.625 228.46875 160 7 100 0 1 160 1695511 1695352 Prevotella corporis strain OB21 FMU 4 chromosome 1, complete sequence blastn 36555 257 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Prevotellaceae Prevotella Prevotella corporis
13470464 13470464 PRJNA734313_S_NODE_3591_length_439_cov_48.729592_g3483_i0 PRJNA734313 3591 439 48.729592 213.92290888 Riemerella anatipestifer 34085 Bacteria Bacteria 481 4.57e-131   NTclustered gi|392495342|gb|JQ664677.1| 34085 g3483 i0 88.442 1.81321184510251 398 46 91 0 1 398 319 716 Riemerella anatipestifer strain T2 aminoglycoside-3'-O-phosphotransferase (aph) gene, partial cds blastn 796 481 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Weeksellaceae Riemerella Riemerella anatipestifer
20323276 20323276 PRJNA734313_S_NODE_35556_length_159_cov_0.910714_g35443_i0 PRJNA734313 35556 159 0.910714 1.44803526 root 1 Root_unresolved Root_unresolved 289 9.22e-74   NTclustered gi|1519262|gb|U65965.1|FSU65965 239 g35443 i0 99.371 101 159 1 100 0 1 159 245 403 Flavobacterium sp. 16S ribosomal RNA gene, partial sequence spanning the V3-V4 region blastn 16059 289 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium sp.
22394232 22394232 PRJNA734313_S_NODE_18778_length_216_cov_0.834320_g18665_i0 PRJNA734313 18778 216 0.83432 1.8021312 Porphyromonas sp. oral taxon 275 712435 Bacteria Bacteria 342 1.0099999999999999e-89   NTclustered gi|2028834772|gb|CP072333.1| 712435 g18665 i0 96.602 515.986111111111 206 7 95 0 1 206 444392 444597 Porphyromonas sp. oral taxon 275 strain W7780 chromosome, complete genome blastn 111453 342 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Porphyromonadaceae Porphyromonas Porphyromonas sp. oral taxon 275

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