RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "diamond", bioproject = "PRJNA946307" and tax_clade = "delta/epsilon subdivisions"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • delta/epsilon subdivisions · 10 ✖

bioproject 1

  • PRJNA946307 · 10 ✖

analysis 1

  • diamond · 10 ✖

tax_phylum 0

tax_kingdom 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
11130038 11130038 PRJNA946307_P_NODE_149449_length_165_cov_0.896552_g148575_i0 PRJNA946307 149449 165 0.896552 1.4793108 Thermodesulfobacteriota 200940 Bacteria Bacteria 96.7 1.3e-21   NR PKN12315.1 2013754 g148575 i0 98.1 1.89090909090909 52 1 94.5 0 157 2 508 559 PKN12315.1 MAG: DNA gyrase subunit A [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-4] diamond 312 96.7 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium HGW-Deltaproteobacteria-4
27278428 27278428 PRJNA946307_P_NODE_88383_length_189_cov_2.685714_g87509_i0 PRJNA946307 88383 189 2.685714 5.07599946 Deltaproteobacteria bacterium RBG_16_71_12 1797848 Bacteria Bacteria 55.8 4.19e-7   NR OGQ24228.1 1797848 g87509 i0 33.3 1.95238095238095 123 14 87.3 1 166 2 21 143 OGQ24228.1 MAG: hypothetical protein A2138_08255 [Deltaproteobacteria bacterium RBG_16_71_12] diamond 369 55.8 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium RBG_16_71_12
28793766 28793766 PRJNA946307_P_NODE_131947_length_170_cov_1.595041_g131073_i0 PRJNA946307 131947 170 1.595041 2.7115697 Deltaproteobacteria bacterium RBG_16_71_12 1797848 Bacteria Bacteria 64.3 3.37e-10   NR OGQ11260.1 1797848 g131073 i0 60.9 0.811764705882353 46 18 81.2 0 14 151 135 180 OGQ11260.1 MAG: hypothetical protein A2138_03550 [Deltaproteobacteria bacterium RBG_16_71_12] diamond 138 64.3 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium RBG_16_71_12
29236112 29236112 PRJNA946307_P_NODE_62549_length_202_cov_4.071895_g61675_i0 PRJNA946307 62549 202 4.071895 8.2252279 Deltaproteobacteria bacterium RBG_16_71_12 1797848 Bacteria Bacteria 85.5 1.83e-17   NR OGQ11259.1 1797848 g61675 i0 74.2 0.920792079207921 62 16 92.1 0 6 191 752 813 OGQ11259.1 MAG: acriflavine resistance protein B [Deltaproteobacteria bacterium RBG_16_71_12] diamond 186 85.5 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium RBG_16_71_12
31011532 31011532 PRJNA946307_P_NODE_75394_length_197_cov_3.256757_g74520_i0 PRJNA946307 75394 197 3.256757 6.41581129 Myxococcota 2818505 Bacteria Bacteria 58.5 5.12e-8   NR OGQ25287.1 1797848 g74520 i0 80.6 2.08629441624365 36 7 54.8 0 194 87 321 356 OGQ25287.1 MAG: hypothetical protein A2138_16770 [Deltaproteobacteria bacterium RBG_16_71_12] diamond 411 58.9 0.99320882852292 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium RBG_16_71_12
31036837 31036837 PRJNA946307_P_NODE_67475_length_199_cov_4.186667_g66601_i0 PRJNA946307 67475 199 4.186667 8.33146733 Deltaproteobacteria bacterium RBG_16_71_12 1797848 Bacteria Bacteria 55.8 5.05e-7   NR OGQ25346.1 1797848 g66601 i0 89.3 0.422110552763819 28 3 42.2 0 16 99 438 465 OGQ25346.1 MAG: hypothetical protein A2138_02280, partial [Deltaproteobacteria bacterium RBG_16_71_12] diamond 84 55.8 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium RBG_16_71_12
31922011 31922011 PRJNA946307_P_NODE_87817_length_189_cov_4.478571_g86943_i0 PRJNA946307 87817 189 4.478571 8.46449919 Deltaproteobacteria bacterium RBG_13_43_22 1797825 Bacteria Bacteria 101 1.22e-24   NR OGP50641.1 1797825 g86943 i0 86.2 0.920634920634921 58 8 92.1 0 3 176 27 84 OGP50641.1 MAG: hypothetical protein A2Y79_07080 [Deltaproteobacteria bacterium RBG_13_43_22] diamond 174 101 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium RBG_13_43_22
31953562 31953562 PRJNA946307_P_NODE_69497_length_199_cov_3.173333_g68623_i0 PRJNA946307 69497 199 3.173333 6.31493267 Deltaproteobacteria bacterium RIFCSPLOWO2_12_FULL_57_22 1797892 Bacteria Bacteria 106 1.84e-25   NR OGQ83647.1 1797892 g68623 i0 58 1.50753768844221 100 3 92 1 16 198 36 135 OGQ83647.1 MAG: hypothetical protein A3G40_00580 [Deltaproteobacteria bacterium RIFCSPLOWO2_12_FULL_57_22] diamond 300 106 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium RIFCSPLOWO2_12_FULL_57_22
32743869 32743869 PRJNA946307_P_NODE_150500_length_165_cov_0.879310_g149626_i0 PRJNA946307 150500 165 0.87931 1.4508615 Deltaproteobacteria bacterium RBG_16_71_12 1797848 Bacteria Bacteria 97.4 4.1500000000000003e-22   NR OGQ15342.1 1797848 g149626 i0 86 0.909090909090909 50 7 90.9 0 164 15 294 343 OGQ15342.1 MAG: hypothetical protein A2138_05220 [Deltaproteobacteria bacterium RBG_16_71_12] diamond 150 97.4 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium RBG_16_71_12
32806628 32806628 PRJNA946307_P_NODE_111440_length_179_cov_1.492308_g110566_i0 PRJNA946307 111440 179 1.492308 2.67123132 Deltaproteobacteria bacterium RIFOXYD12_FULL_55_16 1797904 Bacteria Bacteria 97.8 4.33e-22   NR OGR01363.1 1797904 g110566 i0 89.1 2.76536312849162 55 6 92.2 0 3 167 35 89 OGR01363.1 MAG: transcriptional regulator [Deltaproteobacteria bacterium RIFOXYD12_FULL_55_16] diamond 495 97.8 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium RIFOXYD12_FULL_55_16

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