RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJEB39269" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB39269 · 6 ✖

analysis 1

  • diamond · 6 ✖
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
13742738 13742738 PRJEB39269_P_NODE_80271_length_158_cov_4.495798_g79866_i0 PRJEB39269 80271 158 4.495798 7.10336084 Planctomycetota bacterium 2026780 Bacteria Bacteria 55.1 1.71e-8   NR MFM2096802.1 2026780 g79866 i0 92.6 2.6962025316455702 27 2 51.3 0 82 2 6 32 MFM2096802.1 Dihydrofolate reductase type 3 [Planctomycetota bacterium] diamond 426 55.1 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
27697146 27697146 PRJEB39269_P_NODE_88684_length_152_cov_1.442478_g88279_i0 PRJEB39269 88684 152 1.442478 2.19256656 Tepidisphaeraceae bacterium 2876886 Bacteria Bacteria 66.2 5.43e-11   NR HSZ58344.1 2876886 g88279 i0 70.2 7.36184210526316 47 14 92.8 0 10 150 18 64 HSZ58344.1 long-chain fatty acid--CoA ligase [Tepidisphaeraceae bacterium] diamond 1119 66.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae   Tepidisphaeraceae bacterium
27823261 27823261 PRJEB39269_P_NODE_66784_length_170_cov_3.083969_g66379_i0 PRJEB39269 66784 170 3.083969 5.2427473000000004 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 50.4 1.44e-5   NR MBX3406412.1 2026777 g66379 i0 84.6 0.9 26 4 45.9 0 1 78 21 46 MBX3406412.1 sigma-70 family RNA polymerase sigma factor [Phycisphaeraceae bacterium] diamond 153 50.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
28959957 28959957 PRJEB39269_P_NODE_34248_length_236_cov_1.441624_g33843_i0 PRJEB39269 34248 236 1.441624 3.40223264 Pirellulaceae bacterium 2699754 Bacteria Bacteria 45.1 0.00522   NR MBX3417541.1 2699754 g33843 i0 40.4 0.597457627118644 47 28 59.7 0 23 163 22 68 MBX3417541.1 AMP-binding protein [Pirellulaceae bacterium] diamond 141 45.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae   Pirellulaceae bacterium
29117794 29117794 PRJEB39269_P_NODE_52589_length_189_cov_3.213333_g52184_i0 PRJEB39269 52589 189 3.213333 6.07319937 Planctomycetota bacterium 2026780 Bacteria Bacteria 41.6 0.0478   NR HET6202587.1 2026780 g52184 i0 37.9 0.920634920634921 58 32 85.7 1 10 171 48 105 HET6202587.1 glycosyltransferase [Planctomycetota bacterium] diamond 174 41.6 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31771683 31771683 PRJEB39269_P_NODE_87137_length_153_cov_1.596491_g86732_i0 PRJEB39269 87137 153 1.596491 2.44263123 Gemmataceae bacterium 2052164 Bacteria Bacteria 51.2 1.14e-5   NR MEO2089549.1 2052164 g86732 i0 56.1 0.803921568627451 41 18 80.4 0 1 123 230 270 MEO2089549.1 hypothetical protein [Gemmataceae bacterium] diamond 123 51.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae 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);;