RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA1132896" and tax_phylum = "Rhodothermota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Rhodothermota · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1132896 · 7 ✖

analysis 1

  • diamond · 7 ✖
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
27228281 27228281 PRJNA1132896_P_NODE_9303_length_244_cov_0.900585_g9212_i0 PRJNA1132896 9303 244 0.900585 2.1974274 Salinibacter ruber 146919 Bacteria Bacteria 72 2.74e-14   NR WP_259122985.1 146919 g9212 i0 77.5 0.491803278688525 40 9 49.2 0 2 121 55 94 WP_259122985.1 hypothetical protein, partial [Salinibacter ruber] diamond 120 72 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Salinibacteraceae Salinibacter Salinibacter ruber
27544319 27544319 PRJNA1132896_P_NODE_8404_length_246_cov_1.416185_g8313_i0 PRJNA1132896 8404 246 1.416185 3.4838151 Salinibacter sp. 2065818 Bacteria Bacteria 63.5 1.78e-9   NR WP_375801212.1 2065818 g8313 i0 51.7 1.57317073170732 58 28 70.7 0 177 4 178 235 WP_375801212.1 IS1096 element passenger TnpR family protein [Salinibacter sp.] diamond 387 63.5 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Salinibacteraceae Salinibacter Salinibacter sp.
28744114 28744114 PRJNA1132896_P_NODE_2907_length_327_cov_0.893701_g2816_i0 PRJNA1132896 2907 327 0.893701 2.92240227 Salinivenus sp. 1885341 Bacteria Bacteria 62.4 2.25e-9   NR MEF8939632.1 1885341 g2816 i0 44.9 0.63302752293578 69 38 63.3 0 209 3 36 104 MEF8939632.1 hypothetical protein [Salinivenus sp.] diamond 207 62.4 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Salinibacteraceae Salinivenus Salinivenus sp.
32030303 32030303 PRJNA1132896_P_NODE_8798_length_245_cov_0.895349_g8707_i0 PRJNA1132896 8798 245 0.895349 2.19360505 Salinivenus sp. 1885341 Bacteria Bacteria 48.5 9.66e-5   NR MFP4117240.1 1885341 g8707 i0 32.5 0.979591836734694 80 45 98 2 240 1 8 78 MFP4117240.1 hypothetical protein [Salinivenus sp.] diamond 240 48.5 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Salinibacteraceae Salinivenus Salinivenus sp.
32093429 32093429 PRJNA1132896_P_NODE_10338_length_241_cov_0.916667_g10247_i0 PRJNA1132896 10338 241 0.916667 2.20916747 Salinibacter ruber 146919 Bacteria Bacteria 164 1.7799999999999998e-47   NR WP_259171181.1 146919 g10247 i0 100 1.99170124481328 80 0 99.6 0 240 1 135 214 WP_259171181.1 hypothetical protein, partial [Salinibacter ruber] diamond 480 164 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Salinibacteraceae Salinibacter Salinibacter ruber
32156925 32156925 PRJNA1132896_P_NODE_8898_length_245_cov_0.895349_g8807_i0 PRJNA1132896 8898 245 0.895349 2.19360505 Salinibacter ruber 146919 Bacteria Bacteria 96.3 7.06e-22   NR WP_259219626.1 146919 g8807 i0 54.3 0.991836734693878 81 36 99.2 1 1 243 179 258 WP_259219626.1 hypothetical protein [Salinibacter ruber] diamond 243 96.3 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Salinibacteraceae Salinibacter Salinibacter ruber
32725552 32725552 PRJNA1132896_P_NODE_9940_length_242_cov_0.911243_g9849_i0 PRJNA1132896 9940 242 0.911243 2.20520806 Salinibacter ruber 146919 Bacteria Bacteria 169 1e-46   NR WP_272502953.1 146919 g9849 i0 98.8 1.98347107438017 80 1 99.2 0 1 240 186 265 WP_272502953.1 hypothetical protein [Salinibacter ruber] diamond 480 169 1 Bacteria FCB group Pseudomonadati Rhodothermota Rhodothermia Rhodothermales Salinibacteraceae Salinibacter Salinibacter ruber

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