RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA255848" and tax_clade = "Bacteria candidate phyla"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • Bacteria candidate phyla · 6 ✖

bioproject 1

  • PRJNA255848 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
4195770 4195770 PRJNA255848_P_NODE_21624_length_214_cov_1.539394_g21306_i0 PRJNA255848 21624 214 1.539394 3.29430316 Bacteria 2 Bacteria Bacteria 140 1.58e-38   NR MCL5011141.1 2052139 g21306 i0 84.1 9.67289719626168 69 11 96.7 0 6 212 182 250 MCL5011141.1 helix-turn-helix domain-containing protein [Patescibacteria group bacterium] diamond 2070 140 1 Bacteria Bacteria candidate phyla             Patescibacteria group bacterium
8022185 8022185 PRJNA255848_P_NODE_8007_length_376_cov_1.232416_g7689_i0 PRJNA255848 8007 376 1.232416 4.63388416 candidate division CPR1 bacterium ADurb.Bin16 1618338 Bacteria Bacteria 204 2.01e-62   NR OQB40762.1 1852826 g7689 i0 82.3 0.98936170212766 124 20 98.9 1 374 3 44 165 OQB40762.1 MAG: putative transposase [candidate division CPR1 bacterium ADurb.Bin160] diamond 372 204 1 Bacteria Bacteria candidate phyla   candidate division CPR1         candidate division CPR1 bacterium ADurb.Bin160
27073993 27073993 PRJNA255848_P_NODE_5682_length_463_cov_1.367150_g5365_i0 PRJNA255848 5682 463 1.36715 6.3299045 Candidatus Microgenomates bacterium 2093373 Bacteria Bacteria 47.4 0.00786   NR RJQ35878.1 2093373 g5365 i0 33.3 0.660907127429806 102 51 55.1 2 461 207 126 227 RJQ35878.1 MAG: hypothetical protein C4559_05970 [Candidatus Microgenomates bacterium] diamond 306 47.4 1 Bacteria Bacteria candidate phyla   Candidatus Microgenomatota         Candidatus Microgenomates bacterium
27737723 27737723 PRJNA255848_P_NODE_35904_length_167_cov_0.864407_g35586_i0 PRJNA255848 35904 167 0.864407 1.44355969 Candidatus Hydrothermia bacterium 3014280 Bacteria Bacteria 86.3 1.24e-18   NR HOP33351.1 3014280 g35586 i0 66.7 0.970059880239521 54 18 97 0 2 163 68 121 HOP33351.1 DNA adenine methylase [Candidatus Hydrothermia bacterium] diamond 162 86.3 1 Bacteria Bacteria candidate phyla   Candidatus Hydrothermota Candidatus Hydrothermia       Candidatus Hydrothermia bacterium
29032173 29032173 PRJNA255848_P_NODE_19088_length_228_cov_0.921788_g18770_i0 PRJNA255848 19088 228 0.921788 2.10167664 Candidatus Methylomirabilota bacterium 2072417 Bacteria Bacteria 44.3 0.00286   NR HEX9409770.1 2072417 g18770 i0 33.9 1.55263157894737 59 37 77.6 1 47 223 54 110 HEX9409770.1 RidA family protein [Candidatus Methylomirabilota bacterium] diamond 354 44.3 1 Bacteria Bacteria candidate phyla   Candidatus Methylomirabilota         Candidatus Methylomirabilota bacterium
31812417 31812417 PRJNA255848_P_NODE_26057_length_195_cov_1.280822_g25739_i0 PRJNA255848 26057 195 1.280822 2.4976029 Patescibacteria group bacterium 2052139 Bacteria Bacteria 44.3 0.00475   NR MEK7184073.1 2052139 g25739 i0 40.6 0.984615384615385 64 28 96.9 2 195 7 97 151 MEK7184073.1 dTMP kinase [Patescibacteria group bacterium] diamond 192 44.3 1 Bacteria Bacteria candidate phyla             Patescibacteria group 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);;