RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA207719" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_kingdom 2

tax_superkingdom 1

  • Bacteria · 4 ✖

bioproject 1

  • PRJNA207719 · 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
27200191 27200191 PRJNA207719_P_NODE_942_length_197_cov_2.428571_g922_i0 PRJNA207719 942 197 2.428571 4.78428487 Nannocystis sp. 1962667 Bacteria Bacteria 46.6 8.67e-4   NR MBK8261645.1 1962667 g922 i0 42.6 0.822335025380711 54 29 79.2 2 37 192 293 346 MBK8261645.1 hypothetical protein [Nannocystis sp.] diamond 162 46.6 1 Bacteria   Pseudomonadati Myxococcota   Nannocystales Nannocystaceae Nannocystis Nannocystis sp.
29757965 29757965 PRJNA207719_P_NODE_771_length_225_cov_2.948980_g751_i0 PRJNA207719 771 225 2.94898 6.635205 Bacteroidales bacterium 2030927 Bacteria Bacteria 44.7 0.00608   NR MCI7177175.1 2030927 g751 i0 39.3 0.813333333333333 61 32 74.7 1 14 181 496 556 MCI7177175.1 chloride channel protein [Bacteroidales bacterium] diamond 183 44.7 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales     Bacteroidales bacterium
32540323 32540323 PRJNA207719_P_NODE_599_length_260_cov_5.385281_g579_i0 PRJNA207719 599 260 5.385281 14.0017306 Solirubrobacteraceae bacterium 2586742 Bacteria Bacteria 42.7 0.00429   NR HEV2785311.1 2586742 g579 i0 44.2 0.496153846153846 43 24 49.6 0 119 247 1 43 HEV2785311.1 hypothetical protein [Solirubrobacteraceae bacterium] diamond 129 42.7 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Solirubrobacterales Solirubrobacteraceae   Solirubrobacteraceae bacterium
32760598 32760598 PRJNA207719_P_NODE_480_length_301_cov_2.933824_g460_i0 PRJNA207719 480 301 2.933824 8.83081024 Candidatus Aminicenantes bacterium 2052149 Bacteria Bacteria 43.5 0.0334   NR MBN1224492.1 2052149 g460 i0 33.9 0.588039867109635 59 36 58.8 1 187 11 105 160 MBN1224492.1 hypothetical protein [Candidatus Aminicenantes bacterium] diamond 177 43.5 1 Bacteria Bacteria candidate phyla   Candidatus Aminicenantota         Candidatus Aminicenantes 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);;