RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA706190" and tax_phylum = "Bacteroidota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacteroidota · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA706190 · 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
2466420 2466420 PRJNA706190_P_NODE_46702_length_169_cov_1.633333_g46566_i0 PRJNA706190 46702 169 1.633333 2.76033277 Flavobacteriales 200644 Bacteria Bacteria 263 5.989999999999999e-66   NTclustered gi|2021938309|gb|CP051243.1| 2021391 g46566 i0 94.675 326.769230769231 169 9 100 0 1 169 1915631 1915799 Flavobacteriales bacterium isolate ih4 chromosome blastn 55224 263 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales     Flavobacteriales bacterium
10906798 10906798 PRJNA706190_P_NODE_6609_length_259_cov_1.400000_g6473_i0 PRJNA706190 6609 259 1.4 3.626 Flavobacterium magnum 2162713 Bacteria Bacteria 462 9.2e-126   NTclustered gi|1378740185|gb|CP028811.1| 2162713 g6473 i0 98.842 608.266409266409 259 3 100 0 1 259 1462234 1461976 Flavobacterium magnum strain HYN0048 chromosome, complete genome blastn 157541 462 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium magnum
12670697 12670697 PRJNA706190_P_NODE_27630_length_193_cov_3.875000_g27494_i0 PRJNA706190 27630 193 3.875 7.47875 Weeksellaceae 2762318 Bacteria Bacteria 329 6.86e-86   NTclustered gi|1527207946|gb|CP034157.1| 237258 g27494 i0 100 451.60103626943 178 0 92 0 1 178 129768 129945 Cloacibacterium normanense strain NRS-1 chromosome, complete genome blastn 87159 329 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Weeksellaceae Cloacibacterium Cloacibacterium normanense
18554433 18554433 PRJNA706190_P_NODE_36675_length_182_cov_0.781955_g36539_i0 PRJNA706190 36675 182 0.781955 1.4231581 Lacibacter sp. MH-610 3020883 Bacteria Bacteria 337 3.82e-88   NTclustered gi|2865359271|gb|CP116002.1| 3020883 g36539 i0 100 5.44505494505495 182 0 100 0 1 182 8573 8754 Lacibacter sp. MH-610 chromosome blastn 991 337 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae Lacibacter Lacibacter sp. MH-610
23655841 23655841 PRJNA706190_P_NODE_93699_length_160_cov_2.549550_g93563_i0 PRJNA706190 93699 160 2.54955 4.07928 Porphyromonas sp. oral taxon 275 712435 Bacteria Bacteria 257 2.62e-64   NTclustered gi|2028834772|gb|CP072333.1| 712435 g93563 i0 97.351 210.31875 151 4 94 0 10 160 442289 442439 Porphyromonas sp. oral taxon 275 strain W7780 chromosome, complete genome blastn 33651 257 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);;