RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA1022392" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1022392 · 5 ✖

analysis 1

  • blastn · 5 ✖

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
1003737 1003737 PRJNA1022392_P_NODE_19341_length_243_cov_4.352041_g18672_i0 PRJNA1022392 19341 243 4.352041 10.57545963 root 1 Root_unresolved Root_unresolved 390 4.089999999999999e-104   NTclustered gi|1226876681|gb|CP022559.1| 197 g18672 i0 95.885 100 243 2 100 1 1 243 698252 698018 Campylobacter jejuni strain 11168H/araE chromosome, complete genome blastn 24300 390 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
10365223 10365223 PRJNA1022392_P_NODE_32409_length_206_cov_2.955975_g31740_i0 PRJNA1022392 32409 206 2.955975 6.0893085 Campylobacter ureolyticus 827 Bacteria Bacteria 182 2.2e-41   NTclustered gi|1829985141|gb|CP050963.1| 827 g31740 i0 100 5.02912621359223 98 0 95 0 109 206 780307 780210 Campylobacter ureolyticus strain FDAARGOS_673 chromosome blastn 1036 182 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter ureolyticus
15464777 15464777 PRJNA1022392_P_NODE_33273_length_206_cov_2.767296_g32604_i0 PRJNA1022392 33273 206 2.767296 5.70062976 Campylobacter curvus 200 Bacteria Bacteria 143 1.04e-29   NTclustered gi|1861373391|gb|CP053826.1| 200 g32604 i0 92.857 0.951456310679612 98 7 48 0 1 98 1516493 1516396 Campylobacter curvus strain ATCC 35224 chromosome, complete genome blastn 196 143 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter curvus
17581826 17581826 PRJNA1022392_P_NODE_74914_length_161_cov_1.728070_g74245_i0 PRJNA1022392 74914 161 1.72807 2.7821927 Pseudomonadati 3379134 Bacteria Bacteria 292 7.24e-75   NTclustered gi|1226876681|gb|CP022559.1| 197 g74245 i0 99.379 100 161 1 100 0 1 161 701294 701134 Campylobacter jejuni strain 11168H/araE chromosome, complete genome blastn 16100 292 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
25230086 25230086 PRJNA1022392_P_NODE_46820_length_193_cov_4.698630_g46151_i0 PRJNA1022392 46820 193 4.69863 9.0683559 root 1 Root_unresolved Root_unresolved 259 9.13e-65   NTclustered gi|1226876681|gb|CP022559.1| 197 g46151 i0 90.187 111.989637305699 214 0 100 1 1 193 699056 698843 Campylobacter jejuni strain 11168H/araE chromosome, complete genome blastn 21614 259 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni

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