RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA801875" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 8 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA801875 · 8 ✖

analysis 1

  • diamond · 8 ✖
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
27591462 27591462 PRJNA801875_P_NODE_2664_length_208_cov_1.346821_g2561_i0 PRJNA801875 2664 208 1.346821 2.80138768 Planctomycetota bacterium 2026780 Bacteria Bacteria 84.3 7.68e-18   NR HKE02376.1 2026780 g2561 i0 64.7 1.96153846153846 68 23 96.6 1 206 6 144 211 HKE02376.1 glucose 1-dehydrogenase [Planctomycetota bacterium] diamond 408 84.3 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
28822341 28822341 PRJNA801875_P_NODE_2408_length_224_cov_1.407407_g2305_i0 PRJNA801875 2408 224 1.407407 3.15259168 Planctomycetota bacterium 2026780 Bacteria Bacteria 124 1.7199999999999995e-31   NR MCK6445862.1 2026780 g2305 i0 75.3 6.80357142857143 73 18 97.8 0 221 3 197 269 MCK6445862.1 cystathionine beta-synthase [Planctomycetota bacterium] diamond 1524 124 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30654344 30654344 PRJNA801875_P_NODE_1993_length_257_cov_1.815315_g1890_i0 PRJNA801875 1993 257 1.815315 4.66535955 Planctomycetota bacterium 2026780 Bacteria Bacteria 46.6 0.00203   NR GDY11708.1 2026780 g1890 i0 43.9 1.4124513618677 57 28 65.4 2 237 70 3022 3075 GDY11708.1 hypothetical protein LBMAG53_05860 [Planctomycetota bacterium] diamond 363 46.6 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31065455 31065455 PRJNA801875_P_NODE_1895_length_269_cov_1.606838_g1792_i0 PRJNA801875 1895 269 1.606838 4.32239422 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 105 5.59e-25   NR MAG94705.1 2026779 g1792 i0 57.5 1.95167286245353 87 35 95.9 2 2 259 96 181 MAG94705.1 hypothetical protein [Planctomycetaceae bacterium] diamond 525 105 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
31950627 31950627 PRJNA801875_P_NODE_277_length_867_cov_9.108173_g197_i0 PRJNA801875 277 867 9.108173 78.96785991 Phycisphaerales bacterium 2052180 Bacteria Bacteria 72.8 2.93e-10   NR NOT01860.1 2052180 g197 i0 29.1 0.688581314878893 199 133 67.5 6 864 280 27 221 NOT01860.1 DUF4215 domain-containing protein [Phycisphaerales bacterium] diamond 597 72.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
32330758 32330758 PRJNA801875_P_NODE_3639_length_172_cov_1.204380_g3536_i0 PRJNA801875 3639 172 1.20438 2.0715336 Phycisphaerales bacterium 2052180 Bacteria Bacteria 47 4.47e-4   NR HYE61306.1 2052180 g3536 i0 44.6 0.976744186046512 56 30 97.7 1 3 170 618 672 HYE61306.1 hypothetical protein [Phycisphaerales bacterium] diamond 168 47 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
32466068 32466068 PRJNA801875_P_NODE_1779_length_280_cov_3.640816_g1676_i0 PRJNA801875 1779 280 3.640816 10.1942848 Planctomycetia 203683 Bacteria Bacteria 47.8 9.87e-4   NR MFM7518713.1 117 g1676 i0 45.6 3.38571428571429 79 39 83.6 2 249 16 243 318 MFM7518713.1 hypothetical protein [Pirellula sp.] diamond 948 47.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Pirellula Pirellula sp.
32520526 32520526 PRJNA801875_P_NODE_1059_length_396_cov_2.662050_g956_i0 PRJNA801875 1059 396 2.66205 10.541718 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 75.5 7.64e-13   NR MEZ6056578.1 2026779 g956 i0 43.4 0.856060606060606 113 63 84.8 1 380 45 1334 1446 MEZ6056578.1 Ig-like domain-containing protein [Planctomycetaceae bacterium] diamond 339 75.5 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae 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);;