RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA615175" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA615175 · 3 ✖

analysis 1

  • blastn · 3 ✖

tax_clade 0

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
1871043 1871043 PRJNA615175_P_NODE_30282_length_248_cov_0.880000_g30114_i0 PRJNA615175 30282 248 0.88 2.1824 Sulfurimonas sp. SWIR-19 2878390 Bacteria Bacteria 52.8 0.022   NTclustered gi|2111132204|gb|CP084578.1| 2878390 g30114 i0 100 0.112903225806452 28 0 11 0 193 220 745700 745727 Sulfurimonas sp. SWIR-19 chromosome, complete genome blastn 28 52.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurimonadaceae Sulfurimonas Sulfurimonas sp. SWIR-19
7527577 7527577 PRJNA615175_P_NODE_2186_length_1037_cov_4.882780_g2069_i0 PRJNA615175 2186 1037 4.88278 50.6344286 root 1 Root_unresolved Root_unresolved 1236 0   NTclustered gi|2096309699|gb|CP083377.1| 195 g2069 i0 99.558 67.0578592092575 679 2 65 1 359 1037 1024961 1024284 Campylobacter coli strain C203110 chromosome, complete genome blastn 69539 1236 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli
12074297 12074297 PRJNA615175_P_NODE_27490_length_252_cov_2.972067_g27322_i0 PRJNA615175 27490 252 2.972067 7.48960884 Aliarcobacter cryaerophilus 28198 Bacteria Bacteria 442 1.1599999999999995e-119   NTclustered gi|1817415263|gb|CP026655.1| 28198 g27322 i0 98.413 1 252 3 100 1 1 252 1179005 1178755 Aliarcobacter cryaerophilus strain G13RTA chromosome, complete genome blastn 252 442 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter cryaerophilus

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