RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA753704" and tax_phylum = "Nitrospirota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrospirota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA753704 · 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
26682782 26682782 PRJNA753704_P_NODE_24721_length_250_cov_0.881356_g24360_i0 PRJNA753704 24721 250 0.881356 2.20339 Nitrospira 1234 Bacteria Bacteria 131 2.42e-35   NR WP_086426417.1 96242 g24360 i0 83.1 1.848 77 13 92.4 0 1 231 215 291 WP_086426417.1 Mrp/NBP35 family ATP-binding protein [Nitrospira cf. moscoviensis SBR1015] diamond 462 131 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira cf. moscoviensis SBR1015
26768073 26768073 PRJNA753704_P_NODE_25301_length_249_cov_0.886364_g24940_i0 PRJNA753704 25301 249 0.886364 2.20704636 Nitrospira sp. 70125 Bacteria Bacteria 151 2.88e-42   NR MEZ4244304.1 70125 g24940 i0 92.7 0.987951807228916 82 6 98.8 0 248 3 138 219 MEZ4244304.1 dihydroxy-acid dehydratase [Nitrospira sp.] diamond 246 151 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
30274343 30274343 PRJNA753704_P_NODE_25172_length_249_cov_0.886364_g24811_i0 PRJNA753704 25172 249 0.886364 2.20704636 Nitrospira sp. BO4 2944935 Bacteria Bacteria 45.8 0.00258   NR MDK2741970.1 2944935 g24811 i0 42.9 0.674698795180723 56 31 67.5 1 82 249 3 57 MDK2741970.1 hypothetical protein [Nitrospira sp. BO4] diamond 168 45.8 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp. BO4
30306150 30306150 PRJNA753704_P_NODE_26492_length_246_cov_0.901734_g26131_i0 PRJNA753704 26492 246 0.901734 2.21826564 Nitrospira sp. WS110 2039811 Bacteria Bacteria 136 2.7599999999999997e-37   NR NGZ96292.1 2039811 g26131 i0 82.9 1.98780487804878 82 14 100 0 1 246 187 268 NGZ96292.1 NAD-dependent dehydratase [Nitrospira sp. WS110] diamond 489 136 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp. WS110
31032639 31032639 PRJNA753704_P_NODE_4275_length_544_cov_2.450106_g3916_i0 PRJNA753704 4275 544 2.450106 13.32857664 Nitrospira sp. 70125 Bacteria Bacteria 190 1.35e-56   NR HNA85763.1 70125 g3916 i0 53 0.998161764705882 181 85 99.8 0 544 2 5 185 HNA85763.1 hypothetical protein [Nitrospira sp.] diamond 543 190 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
31095492 31095492 PRJNA753704_P_NODE_24635_length_250_cov_1.683616_g24274_i0 PRJNA753704 24635 250 1.683616 4.20904 Nitrospira sp. WS238 2039812 Bacteria Bacteria 123 4.41e-31   NR NGZ03672.1 2039812 g24274 i0 96.8 0.756 63 2 75.6 0 190 2 1 63 NGZ03672.1 adenylosuccinate lyase [Nitrospira sp. WS238] diamond 189 123 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp. WS238

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);;