RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJDB12134" and tax_phylum = "Chloroflexota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chloroflexota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJDB12134 · 5 ✖

analysis 1

  • diamond · 5 ✖

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
74 74 PRJDB12134_P_NODE_1_length_13118_cov_3.495745_g0_i0 PRJDB12134 1 13118 3.495745 458.5718291 Anaerolineae bacterium 2052143 Bacteria Bacteria 375 1.07e-113   NR MCL6509847.1 2052143 g0 i0 70.4 0.112974538801647 247 72 5.6 1 4396 5136 48 293 MCL6509847.1 replication initiator protein A [Anaerolineae bacterium] diamond 1482 375 1 Bacteria   Bacillati Chloroflexota Anaerolineae       Anaerolineae bacterium
1274310 1274310 PRJDB12134_P_NODE_2_length_10017_cov_3.492257_g0_i1 PRJDB12134 2 10017 3.492257 349.81938369 Anaerolineae bacterium 2052143 Bacteria Bacteria 375 8.03e-114   NR MCL6509847.1 2052143 g0 i1 70.4 0.147948487571129 247 72 7.4 1 8723 7983 48 293 MCL6509847.1 replication initiator protein A [Anaerolineae bacterium] diamond 1482 375 1 Bacteria   Bacillati Chloroflexota Anaerolineae       Anaerolineae bacterium
6378382 6378382 PRJDB12134_P_NODE_1766_length_827_cov_2.797082_g1657_i0 PRJDB12134 1766 827 2.797082 23.13186814 Anaerolineae bacterium 2052143 Bacteria Bacteria 247 3.59e-78   NR MCL6509815.1 2052143 g1657 i0 63.2 0.896009673518742 247 84 89.6 1 744 4 7 246 MCL6509815.1 P-type conjugative transfer protein TrbJ [Anaerolineae bacterium] diamond 741 247 1 Bacteria   Bacillati Chloroflexota Anaerolineae       Anaerolineae bacterium
10203077 10203077 PRJDB12134_P_NODE_9_length_5412_cov_2.811950_g5_i0 PRJDB12134 9 5412 2.81195 152.182734 Anaerolineae bacterium 2052143 Bacteria Bacteria 419 5.05e-129   NR MCL6509811.1 2052143 g5 i0 72.6 0.155764966740576 281 75 15.5 2 1674 2513 77 356 MCL6509811.1 P-type conjugative transfer protein TrbG [Anaerolineae bacterium] diamond 843 419 1 Bacteria   Bacillati Chloroflexota Anaerolineae       Anaerolineae bacterium
30032482 30032482 PRJDB12134_P_NODE_13771_length_245_cov_0.906977_g13636_i0 PRJDB12134 13771 245 0.906977 2.22209365 Caldilineaceae bacterium 2614250 Bacteria Bacteria 78.6 5.48e-15   NR MFN8464591.1 2614250 g13636 i0 56.3 0.979591836734694 80 26 86.9 1 9 221 38 117 MFN8464591.1 hypothetical protein [Caldilineaceae bacterium] diamond 240 78.6 1 Bacteria   Bacillati Chloroflexota Caldilineae Caldilineales Caldilineaceae   Caldilineaceae 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);;