RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA770826" and tax_phylum = "Armatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Armatimonadota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA770826 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
27401065 27401065 PRJNA770826_P_NODE_20723_length_178_cov_1.209302_g20552_i0 PRJNA770826 20723 178 1.209302 2.15255756 Armatimonadota bacterium 2033014 Bacteria Bacteria 50.1 4.13e-5   NR HEY3414615.1 2033014 g20552 i0 52.8 0.893258426966292 53 25 89.3 0 159 1 402 454 HEY3414615.1 LamG-like jellyroll fold domain-containing protein [Armatimonadota bacterium] diamond 159 50.1 1 Bacteria   Bacillati Armatimonadota         Armatimonadota bacterium
27653698 27653698 PRJNA770826_P_NODE_18624_length_188_cov_1.043165_g18453_i0 PRJNA770826 18624 188 1.043165 1.9611502 Armatimonadota bacterium 2033014 Bacteria Bacteria 45.1 0.00276   NR MBI5834428.1 2033014 g18453 i0 51.5 1.56382978723404 33 16 52.7 0 99 1 601 633 MBI5834428.1 hypothetical protein [Armatimonadota bacterium] diamond 294 45.1 1 Bacteria   Bacillati Armatimonadota         Armatimonadota bacterium
30306520 30306520 PRJNA770826_P_NODE_37792_length_164_cov_0.904348_g37621_i0 PRJNA770826 37792 164 0.904348 1.48313072 Armatimonadota bacterium 2033014 Bacteria Bacteria 52.4 2.38e-7   NR MFN3420583.1 2033014 g37621 i0 78.8 0.603658536585366 33 7 60.4 0 100 2 1 33 MFN3420583.1 hypothetical protein [Armatimonadota bacterium] diamond 99 52.4 1 Bacteria   Bacillati Armatimonadota         Armatimonadota bacterium
31326741 31326741 PRJNA770826_P_NODE_7375_length_304_cov_1.011765_g7204_i0 PRJNA770826 7375 304 1.011765 3.0757656 Bacillati 1783272 Bacteria Bacteria 45.1 0.0108   NR GMV89461.1 2282153 g7204 i0 31.3 3.79934210526316 83 57 81.9 0 249 1 172 254 GMV89461.1 MAG: hypothetical protein AMXMBFR81_23920 [Chthonomonas sp.] diamond 1155 45.4 0.993392070484582 Bacteria   Bacillati Armatimonadota Chthonomonadia Chthonomonadales Chthonomonadaceae Chthonomonas Chthonomonas sp.
31886479 31886479 PRJNA770826_P_NODE_24377_length_169_cov_0.866667_g24206_i0 PRJNA770826 24377 169 0.866667 1.46466723 Armatimonadota bacterium 2033014 Bacteria Bacteria 83.6 2.72e-17   NR MCS7254252.1 2033014 g24206 i0 65.5 0.976331360946746 55 19 97.6 0 168 4 9 63 MCS7254252.1 D-glycerate dehydrogenase [Armatimonadota bacterium] diamond 165 83.6 1 Bacteria   Bacillati Armatimonadota         Armatimonadota bacterium
32054283 32054283 PRJNA770826_P_NODE_4158_length_423_cov_2.114973_g3987_i0 PRJNA770826 4158 423 2.114973 8.94633579 Bacillati 1783272 Bacteria Bacteria 160 7.29e-48   NR HXH61058.1 2682144 g3987 i0 62.1 3.30496453900709 116 44 82.3 0 349 2 3 118 HXH61058.1 glycine cleavage system protein GcvH [Fimbriimonadaceae bacterium] diamond 1398 160 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales Fimbriimonadaceae   Fimbriimonadaceae 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);;