RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "diamond" and tax_clade = "OMG group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • OMG group · 10 ✖

analysis 1

  • diamond · 10 ✖
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
10011314 10011314 PRJNA414225_P_NODE_74808_length_164_cov_0.886957_g74721_i0 PRJNA414225 74808 164 0.886957 1.45460948 Gammaproteobacteria 1236 Bacteria Bacteria 110 9.919999999999999e-28   NR KRP35056.1 1655628 g74721 i0 90.7 9.87804878048781 54 5 98.8 0 2 163 175 228 KRP35056.1 MAG: transposase [OM182 bacterium BACL3 MAG-120531-bin86] diamond 1620 110 1 Bacteria OMG group Pseudomonadati Pseudomonadota Gammaproteobacteria       OM182 bacterium BACL3 MAG-120531-bin86
20959278 20959278 PRJNA565584_P_NODE_51417_length_415_cov_1.190058_g50266_i0 PRJNA565584 51417 415 1.190058 4.9387407 Bowmanella 366580 Bacteria Bacteria 250 4.34e-81   NR KRO79565.1 1655580 g50266 i0 83.9 9.90361445783133 137 22 99 0 3 413 17 153 KRO79565.1 MAG: S-(hydroxymethyl)glutathione dehydrogenase, partial [OM182 bacterium BACL3 MAG-120920-bin41] diamond 4110 252 0.992063492063492 Bacteria OMG group Pseudomonadati Pseudomonadota Gammaproteobacteria       OM182 bacterium BACL3 MAG-120920-bin41
26775680 26775680 PRJNA379145_P_NODE_36481_length_336_cov_1.808581_g34333_i0 PRJNA379145 36481 336 1.808581 6.07683216 Bacteria 2 Bacteria Bacteria 96.7 3.51e-21   NR KRP32164.1 1655629 g34333 i0 81.4 2.10714285714286 59 11 52.7 0 335 159 272 330 KRP32164.1 MAG: acetyl-CoA acetyltransferase, partial [OM182 bacterium BACL3 MAG-121001-bin29] diamond 708 96.7 1 Bacteria OMG group Pseudomonadati Pseudomonadota Gammaproteobacteria       OM182 bacterium BACL3 MAG-121001-bin29
27327304 27327304 PRJNA315399_P_NODE_150963_length_189_cov_2.171053_g150515_i0 PRJNA315399 150963 189 2.171053 4.10329017 OM182 bacterium BACL3 MAG-12 2510334 Bacteria Bacteria 42 0.0323   NR KRO73214.1 1655577 g150515 i0 70.8 0.380952380952381 24 7 38.1 0 85 14 167 190 KRO73214.1 MAG: hypothetical protein ABR69_03850 [OM182 bacterium BACL3 MAG-120507-bin80] diamond 72 42 1 Bacteria OMG group Pseudomonadati Pseudomonadota Gammaproteobacteria       OM182 bacterium BACL3 MAG-120507-bin80
27478477 27478477 PRJNA1102048_P_NODE_9263_length_287_cov_1.266355_g9159_i0 PRJNA1102048 9263 287 1.266355 3.63443885 OM182 bacterium BACL3 MAG-12 2510334 Bacteria Bacteria 149 3.459999999999999e-43   NR KRO80840.1 1655593 g9159 i0 96.1 0.804878048780488 77 3 80.5 0 56 286 1 77 KRO80840.1 MAG: RNA polymerase subunit sigma [OM182 bacterium BACL3 MAG-120619-bin3] diamond 231 149 1 Bacteria OMG group Pseudomonadati Pseudomonadota Gammaproteobacteria       OM182 bacterium BACL3 MAG-120619-bin3
29593534 29593534 PRJNA1102048_P_NODE_17070_length_242_cov_0.911243_g16966_i0 PRJNA1102048 17070 242 0.911243 2.20520806 OM182 bacterium 2510334 Bacteria Bacteria 164 2.38e-48   NR MDO7640183.1 2510334 g16966 i0 95 4.95867768595041 80 4 99.2 0 1 240 10 89 MDO7640183.1 PQQ-binding-like beta-propeller repeat protein [OM182 bacterium] diamond 1200 164 1 Bacteria OMG group Pseudomonadati Pseudomonadota Gammaproteobacteria       OM182 bacterium
29615889 29615889 PRJEB30004_P_NODE_550590_length_178_cov_1.453237_g534963_i0 PRJEB30004 550590 178 1.453237 2.58676186 Bacteria 2 Bacteria Bacteria 45.8 0.00124   NR PDH32587.1 1986256 g534963 i0 41.7 2.00561797752809 60 32 96.1 1 1 171 98 157 PDH32587.1 MAG: hypothetical protein CNF02_11770 [OM182 bacterium MED-G28] diamond 357 45.8 1 Bacteria OMG group Pseudomonadati Pseudomonadota Gammaproteobacteria       OM182 bacterium MED-G28
29837631 29837631 PRJNA1067370_P_NODE_48691_length_299_cov_1.761062_g48143_i0 PRJNA1067370 48691 299 1.761062 5.26557538 Bacteria 2 Bacteria Bacteria 71.2 4.87e-12   NR KRO76580.1 1655580 g48143 i0 44.4 3.29096989966555 81 41 77.3 3 235 5 32 112 KRO76580.1 MAG: hypothetical protein ABR72_06385, partial [OM182 bacterium BACL3 MAG-120920-bin41] diamond 984 71.2 1 Bacteria OMG group Pseudomonadati Pseudomonadota Gammaproteobacteria       OM182 bacterium BACL3 MAG-120920-bin41
30409302 30409302 PRJNA560932_P_NODE_50213_length_256_cov_1.262295_g49857_i0 PRJNA560932 50213 256 1.262295 3.2314752 Bacteria 2 Bacteria Bacteria 89.7 3.81e-20   NR KRO70162.1 1655577 g49857 i0 48.8 13.39453125 82 42 96.1 0 254 9 106 187 KRO70162.1 MAG: hypothetical protein ABR69_03915, partial [OM182 bacterium BACL3 MAG-120507-bin80] diamond 3429 90.5 0.991160220994475 Bacteria OMG group Pseudomonadati Pseudomonadota Gammaproteobacteria       OM182 bacterium BACL3 MAG-120507-bin80
30754078 30754078 PRJNA1087264_P_NODE_8194_length_220_cov_1.309942_g8112_i0 PRJNA1087264 8194 220 1.309942 2.8818724 Bacteria 2 Bacteria Bacteria 92.8 6.4500000000000005e-21   NR KRO80699.1 1655593 g8112 i0 55.6 3.92727272727273 72 32 98.2 0 218 3 54 125 KRO80699.1 MAG: hypothetical protein ABR85_08005 [OM182 bacterium BACL3 MAG-120619-bin3] diamond 864 92.8 1 Bacteria OMG group Pseudomonadati Pseudomonadota Gammaproteobacteria       OM182 bacterium BACL3 MAG-120619-bin3

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