RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA550047" and tax_clade = "Nitrospinota/Tectimicrobiota group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

tax_clade 1

  • Nitrospinota/Tectimicrobiota group · 4 ✖

bioproject 1

  • PRJNA550047 · 4 ✖

analysis 1

  • diamond · 4 ✖
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
28924259 28924259 PRJNA550047_P_NODE_552288_length_213_cov_4.942857_g550315_i0 PRJNA550047 552288 213 4.942857 10.52828541 Bacteria 2 Bacteria Bacteria 102 1.1099999999999999e-23   NR OGW12588.1 1801690 g550315 i0 67.6 22 71 23 100 0 1 213 276 346 OGW12588.1 MAG: diaminopimelate decarboxylase [Nitrospinae bacterium RIFCSPLOWO2_12_39_16] diamond 4686 102 1 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Nitrospinota         Nitrospinae bacterium RIFCSPLOWO2_12_39_16
29541041 29541041 PRJNA550047_P_NODE_324170_length_293_cov_18.709091_g322200_i0 PRJNA550047 324170 293 18.709091 54.81763663 Candidatus Tectimicrobiota bacterium 2528274 Bacteria Bacteria 50.4 1.09e-4   NR MDQ3830886.1 2528274 g322200 i0 61.8 0.348122866894198 34 13 34.8 0 192 293 37 70 MDQ3830886.1 IS5 family transposase [Candidatus Tectimicrobiota bacterium] diamond 102 50.4 1 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Candidatus Tectimicrobiota         Candidatus Tectimicrobiota bacterium
30204223 30204223 PRJNA550047_P_NODE_479932_length_237_cov_7.939024_g477959_i0 PRJNA550047 479932 237 7.939024 18.81548688 Nitrospinota bacterium 2026769 Bacteria Bacteria 74.7 1.23e-14   NR MDP7661740.1 2026769 g477959 i0 54.8 1.88607594936709 73 33 92.4 0 219 1 2 74 MDP7661740.1 IS5 family transposase [Nitrospinota bacterium] diamond 447 74.7 1 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Nitrospinota         Nitrospinota bacterium
30994451 30994451 PRJNA550047_P_NODE_539774_length_217_cov_7.284722_g537801_i0 PRJNA550047 539774 217 7.284722 15.80784674 Nitrospinota bacterium 2026769 Bacteria Bacteria 101 4.39e-24   NR MBI3584007.1 2026769 g537801 i0 70.4 1.963133640553 71 21 98.2 0 215 3 145 215 MBI3584007.1 AAA family ATPase [Nitrospinota bacterium] diamond 426 101 1 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Nitrospinota         Nitrospinota 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);;