RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJNA293022" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJNA293022 · 8 ✖

analysis 1

  • blastn · 8 ✖

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
1059709 1059709 PRJNA293022_P_NODE_35061_length_236_cov_1.449198_g34324_i0 PRJNA293022 35061 236 1.449198 3.42010728 Arcobacteraceae 2808963 Bacteria Bacteria 435 1.8e-117   NTclustered gi|822875157|emb|LM654284.1| 28198 g34324 i0 100 127.330508474576 235 0 99 0 2 236 27 261 Arcobacter cryaerophilus partial 16S rRNA gene, strain HSJR 8122333 blastn 30050 435 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter cryaerophilus
2334957 2334957 PRJNA293022_P_NODE_47982_length_201_cov_2.250000_g47245_i0 PRJNA293022 47982 201 2.25 4.5225 Campylobacter 194 Bacteria Bacteria 372 1.18e-98   NTclustered gi|1861373391|gb|CP053826.1| 200 g47245 i0 100 114 201 0 100 0 1 201 837112 837312 Campylobacter curvus strain ATCC 35224 chromosome, complete genome blastn 22914 372 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter curvus
6162462 6162462 PRJNA293022_P_NODE_24125_length_287_cov_13.163866_g23388_i0 PRJNA293022 24125 287 13.163866 37.78029542 Campylobacter 194 Bacteria Bacteria 521 1.6799999999999999e-143   NTclustered gi|1935888393|gb|CP049239.1| 199 g23388 i0 99.649 245 285 1 99 0 3 287 1034384 1034100 Campylobacter concisus strain P3UCO1 chromosome, complete genome blastn 70315 523 0.996175908221797 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter concisus
7437624 7437624 PRJNA293022_P_NODE_37506_length_228_cov_1.726257_g36769_i0 PRJNA293022 37506 228 1.726257 3.93586596 root 1 Root_unresolved Root_unresolved 418 1.7399999999999994e-112   NTclustered gi|1145145120|gb|KX686749.1| 195 g36769 i0 100 100.122807017544 226 0 99 0 1 226 46497 46272 Campylobacter coli strain Tx40 plasmid unnamed, complete sequence blastn 22828 422 0.990521327014218 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli
9301275 9301275 PRJNA293022_P_NODE_2088_length_918_cov_27.554661_g1659_i0 PRJNA293022 2088 918 27.554661 252.95178798 Campylobacter showae 204 Bacteria Bacteria 1517 0   NTclustered gi|1483583529|emb|LT631453.1| 204 g1659 i0 97.523 228.659041394336 888 20 97 2 1 887 389111 389997 Campylobacter showae strain B91_SCBr genome assembly, chromosome: I blastn 209909 1517 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter showae
9987883 9987883 PRJNA293022_P_NODE_64068_length_173_cov_1.750000_g63331_i0 PRJNA293022 64068 173 1.75 3.0275 Aliarcobacter 2321111 Bacteria Bacteria 305 1.01e-78   NTclustered gi|1231709647|emb|LT906455.1| 28197 g63331 i0 98.83 369.184971098266 171 2 99 0 3 173 849701 849871 Arcobacter butzleri strain NCTC12481 genome assembly, chromosome: 1 blastn 63869 305 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter butzleri
11852101 11852101 PRJNA293022_P_NODE_74770_length_164_cov_2.678261_g74033_i0 PRJNA293022 74770 164 2.678261 4.39234804 Campylobacter gracilis 824 Bacteria Bacteria 294 2.06e-75   NTclustered gi|909717139|gb|CP012196.1| 824 g74033 i0 99.383 140.841463414634 162 1 99 0 1 162 500092 499931 Campylobacter gracilis strain ATCC 33236, complete genome blastn 23098 294 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter gracilis
24599543 24599543 PRJNA293022_P_NODE_73940_length_165_cov_0.896552_g73203_i0 PRJNA293022 73940 165 0.896552 1.4793108 Campylobacter showae 204 Bacteria Bacteria 296 5.77e-76   NTclustered gi|1483583495|emb|LT631419.1| 204 g73203 i0 99.387 14.7757575757576 163 1 99 0 1 163 53363 53525 Campylobacter showae genome assembly, chromosome: I blastn 2438 296 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter showae

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