RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA1196438" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 10 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1196438 · 10 ✖

analysis 1

  • blastn · 10 ✖

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
3593857 3593857 PRJNA1196438_P_NODE_63583_length_253_cov_1.733333_g63156_i0 PRJNA1196438 63583 253 1.733333 4.38533249 Bacteria 2 Bacteria Bacteria 468 1.92e-127   NTclustered gi|1829627864|gb|CP048769.1| 197 g63156 i0 100 100 253 0 100 0 1 253 1416474 1416222 Campylobacter jejuni strain ZJB020 chromosome, complete genome blastn 25300 468 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
7976252 7976252 PRJNA1196438_P_NODE_17867_length_312_cov_3.389121_g17441_i0 PRJNA1196438 17867 312 3.389121 10.57405752 Campylobacter ureolyticus 827 Bacteria Bacteria 60.2 1.74e-4   NTclustered gi|1966876394|gb|CP068487.1| 827 g17441 i0 91.111 0.288461538461538 45 3 14 1 88 131 327652 327608 Campylobacter ureolyticus strain FDAARGOS_1102 chromosome blastn 90 60.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter ureolyticus
8696179 8696179 PRJNA1196438_P_NODE_11387_length_317_cov_1.918033_g10961_i0 PRJNA1196438 11387 317 1.918033 6.08016461 Bacteria 2 Bacteria Bacteria 329 1.23e-85   NTclustered gi|2323232558|gb|CP109813.1| 195 g10961 i0 100 57.8296529968454 178 0 56 0 140 317 568540 568363 Campylobacter coli strain CC20JX12 chromosome, complete genome blastn 18332 329 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli
10527338 10527338 PRJNA1196438_P_NODE_76129_length_242_cov_0.923077_g75702_i0 PRJNA1196438 76129 242 0.923077 2.23384634 Campylobacter hepaticus 1813019 Bacteria Bacteria 106 1.65e-18   NTclustered gi|1940031893|gb|CP065357.1| 1813019 g75702 i0 85.859 2.45454545454545 99 14 41 0 3 101 772595 772693 Campylobacter hepaticus strain UF2019SK1 chromosome, complete genome blastn 594 106 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter hepaticus
14351940 14351940 PRJNA1196438_P_NODE_20192_length_312_cov_3.004184_g19766_i0 PRJNA1196438 20192 312 3.004184 9.37305408 Campylobacter concisus 199 Bacteria Bacteria 257 5.76e-64   NTclustered gi|1938730527|gb|CP049274.1| 199 g19766 i0 97.351 4.73717948717949 151 4 96 0 162 312 1714174 1714324 Campylobacter concisus strain P10CDO-S2 chromosome, complete genome blastn 1478 257 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter concisus
16900287 16900287 PRJNA1196438_P_NODE_46614_length_278_cov_2.741463_g46187_i0 PRJNA1196438 46614 278 2.741463 7.62126714 Campylobacter showae 204 Bacteria Bacteria 435 2.1700000000000003e-117   NTclustered gi|1483583565|emb|LT631545.1| 204 g46187 i0 94.946 16.2805755395683 277 14 99 0 2 278 1621941 1621665 Campylobacter showae strain B32_SW genome assembly, chromosome: I blastn 4526 435 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter showae
18174482 18174482 PRJNA1196438_P_NODE_11835_length_313_cov_5.020833_g11409_i0 PRJNA1196438 11835 313 5.020833 15.71520729 Aliarcobacter lanthieri 1355374 Bacteria Bacteria 150 1.01e-31   NTclustered gi|2922095445|gb|CP182877.1| 1355374 g11409 i0 89.167 0.383386581469649 120 13 38 0 194 313 1741845 1741726 Aliarcobacter lanthieri strain BNI-4365 chromosome, complete genome blastn 120 150 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter lanthieri
20724898 20724898 PRJNA1196438_P_NODE_74917_length_243_cov_0.917647_g74490_i0 PRJNA1196438 74917 243 0.917647 2.22988221 Halarcobacter bivalviorum 663364 Bacteria Bacteria 52.8 0.022   NTclustered gi|1435902972|gb|CP031217.1| 663364 g74490 i0 100 0.230452674897119 28 0 12 0 171 198 2497282 2497255 Halarcobacter bivalviorum strain LMG 26154 chromosome, complete genome blastn 56 52.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Halarcobacter Halarcobacter bivalviorum
22000162 22000162 PRJNA1196438_P_NODE_63258_length_253_cov_2.822222_g62831_i0 PRJNA1196438 63258 253 2.822222 7.14022166 Campylobacter ureolyticus 827 Bacteria Bacteria 399 7.119999999999998e-107   NTclustered gi|909715533|gb|CP012195.1| 1032069 g62831 i0 95.238 39.9644268774704 252 12 99 0 1 252 1221291 1221040 Campylobacter ureolyticus RIGS 9880 chromosome, complete genome blastn 10111 399 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter ureolyticus
25269486 25269486 PRJNA1196438_P_NODE_31660_length_300_cov_4.039648_g31234_i0 PRJNA1196438 31660 300 4.039648 12.118944 PVC group 1783257 Bacteria Bacteria 279 1.18e-70   NTclustered gi|2523954314|dbj|AP028341.1| 195 g31234 i0 100 96.5533333333333 151 0 100 0 1 151 158510 158660 Campylobacter coli BCH-10328 DNA, complete genome blastn 28966 279 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli

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