RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJEB673" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJEB673 · 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
9062184 9062184 PRJEB673_P_NODE_3068_length_569_cov_8.398876_g2755_i0 PRJEB673 3068 569 8.398876 47.78960444 Propionibacteriaceae bacterium 2021380 Bacteria Bacteria 213 2.47e-67   NR MCP3885490.1 2021380 g2755 i0 66.9 0.796133567662566 151 48 79.6 1 521 69 3 151 MCP3885490.1 translation initiation factor IF-5A [Propionibacteriaceae bacterium] diamond 453 213 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae   Propionibacteriaceae bacterium
21811678 21811678 PRJEB673_P_NODE_3278_length_551_cov_6.127907_g2962_i0 PRJEB673 3278 551 6.127907 33.76476757 Propionibacteriaceae bacterium 2021380 Bacteria Bacteria 215 2.4e-68   NR MCP3885490.1 2021380 g2962 i0 69.5 0.822141560798548 151 44 82.2 1 503 51 3 151 MCP3885490.1 translation initiation factor IF-5A [Propionibacteriaceae bacterium] diamond 453 215 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae   Propionibacteriaceae bacterium
26590620 26590620 PRJEB673_P_NODE_781_length_1032_cov_2.976931_g613_i0 PRJEB673 781 1032 2.976931 30.72192792 uncultured Solirubrobacteraceae bacterium 1162706 Bacteria Bacteria 45.8 0.00758   NR CAA9514049.1 1162706 g613 i0 54.8 0.122093023255814 42 16 12.2 1 670 795 16 54 CAA9514049.1 MAG: hypothetical protein AVDCRST_MAG53-2895, partial [uncultured Solirubrobacteraceae bacterium] diamond 126 45.8 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Solirubrobacterales Solirubrobacteraceae   uncultured Solirubrobacteraceae bacterium
28006333 28006333 PRJEB673_P_NODE_9845_length_186_cov_1.165563_g9496_i0 PRJEB673 9845 186 1.165563 2.16794718 Bacillati 1783272 Bacteria Bacteria 97.8 5.97e-22   NR WP_075735821.1 161895 g9496 i0 72.1 5.91935483870968 61 17 98.4 0 1 183 316 376 WP_075735821.1 aldehyde dehydrogenase family protein [Corynebacterium phocae] diamond 1101 98.2 0.995926680244399 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Corynebacteriaceae Corynebacterium Corynebacterium phocae
28423899 28423899 PRJEB673_P_NODE_6126_length_354_cov_1.357367_g5777_i0 PRJEB673 6126 354 1.357367 4.80507918 Propionibacteriaceae bacterium 2021380 Bacteria Bacteria 81.6 8.22e-17   NR MCP3885490.1 2021380 g5777 i0 78 0.423728813559322 50 11 42.4 0 156 7 66 115 MCP3885490.1 translation initiation factor IF-5A [Propionibacteriaceae bacterium] diamond 150 81.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae   Propionibacteriaceae bacterium
32310667 32310667 PRJEB673_P_NODE_5819_length_365_cov_1.721212_g5470_i0 PRJEB673 5819 365 1.721212 6.2824238 Frankiaceae bacterium 2654182 Bacteria Bacteria 86.3 7.62e-17   NR HEX4017710.1 2654182 g5470 i0 53 1.36438356164384 83 37 67.4 2 25 270 411 492 HEX4017710.1 flavin monoamine oxidase family protein [Frankiaceae bacterium] diamond 498 86.3 1 Bacteria   Bacillati Actinomycetota Actinomycetes Frankiales Frankiaceae   Frankiaceae 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);;