RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA763718" and tax_phylum = "Myxococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Myxococcota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA763718 · 4 ✖

tax_clade 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
5847744 5847744 PRJNA763718_S_NODE_6625_length_170_cov_1.736842_g6417_i0 PRJNA763718 6625 170 1.736842 2.9526314 Anaeromyxobacter dehalogenans 161493 Bacteria Bacteria 93.5 8.38e-15   NTclustered gi|85772941|gb|CP000251.1| 290397 g6417 i0 90.411 2.08823529411765 73 4 43 3 38 110 617591 617660 Anaeromyxobacter dehalogenans 2CP-C, complete genome blastn 355 93.5 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Anaeromyxobacteraceae Anaeromyxobacter Anaeromyxobacter dehalogenans
31064490 31064490 PRJNA763718_S_NODE_5975_length_179_cov_1.070423_g5767_i0 PRJNA763718 5975 179 1.070423 1.91605717 Sorangiineae bacterium NIC37A_2 1970199 Bacteria Bacteria 97.1 9.58e-22   NR OQX66423.1 1970199 g5767 i0 75.9 0.972067039106145 58 14 97.2 0 2 175 315 372 OQX66423.1 MAG: hypothetical protein B6A08_20570 [Sorangiineae bacterium NIC37A_2] diamond 174 97.1 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Sorangiineae bacterium NIC37A_2
31222014 31222014 PRJNA763718_S_NODE_6475_length_172_cov_1.051852_g6267_i0 PRJNA763718 6475 172 1.051852 1.80918544 Polyangiaceae bacterium 2268199 Bacteria Bacteria 45.8 3.77e-4   NR HXS16005.1 2268199 g6267 i0 50 0.906976744186046 52 26 90.7 0 16 171 11 62 HXS16005.1 ATP synthase subunit I [Polyangiaceae bacterium] diamond 156 45.8 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae   Polyangiaceae bacterium
32686389 32686389 PRJNA763718_S_NODE_7680_length_159_cov_0.942623_g7472_i0 PRJNA763718 7680 159 0.942623 1.49877057 Bacteria 2 Bacteria Bacteria 45.1 0.00187   NR MEI6226463.1 2026735 g7472 i0 48 3.81132075471698 50 26 94.3 0 156 7 92 141 MEI6226463.1 DDE-type integrase/transposase/recombinase [Deltaproteobacteria bacterium] diamond 606 45.1 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria 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);;