RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "diamond", bioproject = "PRJNA1247234" and tax_phylum = "Balneolota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Balneolota · 9 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1247234 · 9 ✖

analysis 1

  • diamond · 9 ✖
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
27231606 27231606 PRJNA1247234_P_NODE_22263_length_250_cov_0.881356_g22107_i0 PRJNA1247234 22263 250 0.881356 2.20339 Balneolaceae bacterium 2053516 Bacteria Bacteria 122 1.5399999999999998e-30   NR MFA5669142.1 2053516 g22107 i0 100 0.876 73 0 87.6 0 250 32 220 292 MFA5669142.1 hypothetical protein [Balneolaceae bacterium] diamond 219 122 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae   Balneolaceae bacterium
27737277 27737277 PRJNA1247234_P_NODE_22884_length_249_cov_0.886364_g22728_i0 PRJNA1247234 22884 249 0.886364 2.20704636 Balneolaceae bacterium 2053516 Bacteria Bacteria 159 1.61e-46   NR MFA5668427.1 2053516 g22728 i0 97.6 1 83 2 100 0 249 1 152 234 MFA5668427.1 indole-3-glycerol phosphate synthase TrpC [Balneolaceae bacterium] diamond 249 159 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae   Balneolaceae bacterium
28102223 28102223 PRJNA1247234_P_NODE_25565_length_245_cov_0.906977_g25409_i0 PRJNA1247234 25565 245 0.906977 2.22209365 Gracilimonas 649462 Bacteria Bacteria 90.1 8.27e-19   NR WP_083909891.1 454600 g25409 i0 56.6 2.86530612244898 76 33 93.1 0 16 243 589 664 WP_083909891.1 right-handed parallel beta-helix repeat-containing protein [Gracilimonas tropica] diamond 702 90.9 0.991199119911991 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae Gracilimonas Gracilimonas tropica
28558031 28558031 PRJNA1247234_P_NODE_24827_length_246_cov_0.901734_g24671_i0 PRJNA1247234 24827 246 0.901734 2.21826564 Balneolaceae bacterium 2053516 Bacteria Bacteria 126 1.47e-31   NR MFA5670608.1 2053516 g24671 i0 98.4 0.780487804878049 64 1 78 0 55 246 94 157 MFA5670608.1 two-component regulator propeller domain-containing protein [Balneolaceae bacterium] diamond 192 126 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae   Balneolaceae bacterium
29473267 29473267 PRJNA1247234_P_NODE_27750_length_242_cov_0.923077_g27594_i0 PRJNA1247234 27750 242 0.923077 2.23384634 Balneolaceae bacterium 2053516 Bacteria Bacteria 152 3.49e-41   NR MFA5668938.1 2053516 g27594 i0 100 0.991735537190083 80 0 99.2 0 242 3 127 206 MFA5668938.1 ABC transporter ATP-binding protein [Balneolaceae bacterium] diamond 240 152 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae   Balneolaceae bacterium
30073454 30073454 PRJNA1247234_P_NODE_23212_length_249_cov_0.886364_g23056_i0 PRJNA1247234 23212 249 0.886364 2.20704636 Balneolaceae bacterium 2053516 Bacteria Bacteria 177 8.58e-51   NR MFA5669762.1 2053516 g23056 i0 98.8 2 83 1 100 0 1 249 59 141 MFA5669762.1 sodium:solute symporter family protein [Balneolaceae bacterium] diamond 498 177 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae   Balneolaceae bacterium
30452996 30452996 PRJNA1247234_P_NODE_11153_length_328_cov_0.847059_g10997_i0 PRJNA1247234 11153 328 0.847059 2.77835352 Balneolaceae bacterium 2053516 Bacteria Bacteria 144 1.35e-39   NR MFA5668034.1 2053516 g10997 i0 95.7 0.63109756097561 69 3 63.1 0 326 120 247 315 MFA5668034.1 alpha/beta fold hydrolase [Balneolaceae bacterium] diamond 207 144 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae   Balneolaceae bacterium
31179119 31179119 PRJNA1247234_P_NODE_21835_length_251_cov_0.876404_g21679_i0 PRJNA1247234 21835 251 0.876404 2.19977404 Balneolaceae bacterium 2053516 Bacteria Bacteria 149 7.24e-42   NR MFA5670414.1 2053516 g21679 i0 85.5 0.99203187250996006 83 12 99.2 0 251 3 41 123 MFA5670414.1 hypothetical protein [Balneolaceae bacterium] diamond 249 149 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae   Balneolaceae bacterium
32571563 32571563 PRJNA1247234_P_NODE_26519_length_244_cov_0.912281_g26363_i0 PRJNA1247234 26519 244 0.912281 2.22596564 Balneola sp. 2024824 Bacteria Bacteria 104 7.8e-24   NR MEQ8578148.1 2024824 g26363 i0 53.1 1.99180327868852 81 38 99.6 0 243 1 26 106 MEQ8578148.1 hypothetical protein [Balneola sp.] diamond 486 104 1 Bacteria FCB group Pseudomonadati Balneolota Balneolia Balneolales Balneolaceae Balneola Balneola sp.

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