RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA789095" 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

  • PRJNA789095 · 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
2489991 2489991 PRJNA789095_P_NODE_68782_length_248_cov_0.880000_g67448_i0 PRJNA789095 68782 248 0.88 2.1824 Campylobacter 194 Bacteria Bacteria 459 1.13e-124   NTclustered gi|1938724023|gb|CP060707.1| 199 g67448 i0 100 235.209677419355 248 0 100 0 1 248 724190 724437 Campylobacter concisus strain P1CDO2 chromosome, complete genome blastn 58332 459 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter concisus
8867667 8867667 PRJNA789095_P_NODE_73787_length_243_cov_0.905882_g72453_i0 PRJNA789095 73787 243 0.905882 2.20129326 Bacteria 2 Bacteria Bacteria 449 6.65e-122   NTclustered gi|2323232558|gb|CP109813.1| 195 g72453 i0 100 183.658436213992 243 0 100 0 1 243 562186 562428 Campylobacter coli strain CC20JX12 chromosome, complete genome blastn 44629 449 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli
18622757 18622757 PRJNA789095_P_NODE_61935_length_259_cov_1.720430_g60601_i0 PRJNA789095 61935 259 1.72043 4.4559137 Campylobacter ureolyticus 827 Bacteria Bacteria 424 4.34e-114   NTclustered gi|909715533|gb|CP012195.1| 1032069 g60601 i0 96.139 4 259 10 100 0 1 259 1266485 1266227 Campylobacter ureolyticus RIGS 9880 chromosome, complete genome blastn 1036 424 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter ureolyticus
18623248 18623248 PRJNA789095_P_NODE_77675_length_234_cov_2.403727_g76341_i0 PRJNA789095 77675 234 2.403727 5.62472118 Hydrogenimonas thermophila 223786 Bacteria Bacteria 52.8 0.021   NTclustered gi|2329051133|dbj|AP026673.1| 223786 g76341 i0 100 0.11965811965812 28 0 12 0 150 177 660116 660143 Hydrogenimonas thermophila JCM 11971 DNA, complete sequence blastn 28 52.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Hydrogenimonadaceae Hydrogenimonas Hydrogenimonas thermophila
21172817 21172817 PRJNA789095_P_NODE_30917_length_379_cov_3.444444_g29584_i0 PRJNA789095 30917 379 3.444444 13.05444276 Campylobacter lari 201 Bacteria Bacteria 54.7 0.01   NTclustered gi|2878590106|gb|CP176604.1| 488545 g29584 i0 100 0.306068601583113 29 0 8 0 121 149 701496 701524 Campylobacter lari subsp. concheus strain RM19222 chromosome, complete genome blastn 116 54.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter lari

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