RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJEB11523" 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

  • PRJEB11523 · 3 ✖

analysis 1

  • diamond · 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
29716640 29716640 PRJEB11523_P_NODE_3470_length_264_cov_2.046512_g3392_i0 PRJEB11523 3470 264 2.046512 5.40279168 uncultured Arcobacter sp. 165434 Bacteria Bacteria 76.6 1.78e-15   NR WP_298752127.1 165434 g3392 i0 50.7 2.23863636363636 73 34 83 1 46 264 17 87 WP_298752127.1 hypothetical protein [uncultured Arcobacter sp.] diamond 591 76.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Arcobacter uncultured Arcobacter sp.
30980835 30980835 PRJEB11523_P_NODE_1374_length_491_cov_4.056561_g1296_i0 PRJEB11523 1374 491 4.056561 19.91771451 Desulfurellales bacterium 2482794 Bacteria Bacteria 48.9 0.00244   NR TXH43637.1 2482794 g1296 i0 60 0.213849287169043 35 14 21.4 0 207 103 191 225 TXH43637.1 MAG: hypothetical protein E6Q97_33795, partial [Desulfurellales bacterium] diamond 105 48.9 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
31897638 31897638 PRJEB11523_P_NODE_3577_length_257_cov_25.192308_g3499_i0 PRJEB11523 3577 257 25.192308 64.74423156 Desulfurellales bacterium 2482794 Bacteria Bacteria 149 3.5899999999999998e-40   NR TXH58632.1 2482794 g3499 i0 92 0.875486381322957 75 6 87.5 0 28 252 169 243 TXH58632.1 MAG: hypothetical protein E6Q97_01875 [Desulfurellales bacterium] diamond 225 149 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium

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