RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA767802" and tax_phylum = "Bacteroidota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacteroidota · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA767802 · 3 ✖

analysis 1

  • blastn · 3 ✖
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
745204 745204 PRJNA767802_P_NODE_241_length_1587_cov_2.401170_g227_i0 PRJNA767802 241 1587 2.40117 38.1065679 Lacibacter sp. MH-610 3020883 Bacteria Bacteria 2920 0   NTclustered gi|2865359271|gb|CP116002.1| 3020883 g227 i0 99.874 1.94517958412098 1587 2 100 0 1 1587 3238301 3239887 Lacibacter sp. MH-610 chromosome blastn 3087 2920 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae Lacibacter Lacibacter sp. MH-610
21147778 21147778 PRJNA767802_P_NODE_4557_length_394_cov_4.179710_g4484_i0 PRJNA767802 4557 394 4.17971 16.4680574 Sphingobacterium spiritivorum 258 Bacteria Bacteria 682 0   NTclustered gi|2636475595|gb|CP139978.1| 258 g4484 i0 99.467 5.28680203045685 375 2 95 0 20 394 4324637 4324263 Sphingobacterium spiritivorum strain HAMBI_1896 chromosome, complete genome blastn 2083 682 1 Bacteria FCB group Pseudomonadati Bacteroidota Sphingobacteriia Sphingobacteriales Sphingobacteriaceae Sphingobacterium Sphingobacterium spiritivorum
22422524 22422524 PRJNA767802_P_NODE_9338_length_238_cov_1.074074_g9265_i0 PRJNA767802 9338 238 1.074074 2.55629612 Aquirufa nivalisilvae 2516557 Bacteria Bacteria 303 5.35e-78   NTclustered gi|1390254249|gb|CP029346.1| 2516557 g9265 i0 91.441 342.894957983193 222 17 93 2 18 238 360769 360989 Aquirufa nivalisilvae strain HME7025 chromosome, complete genome blastn 81609 303 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Flectobacillaceae Aquirufa Aquirufa nivalisilvae

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