RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "diamond", bioproject = "PRJNA721440" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 10 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA721440 · 10 ✖

analysis 1

  • diamond · 10 ✖
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
27652483 27652483 PRJNA721440_S_NODE_14424_length_179_cov_1.353846_g14298_i0 PRJNA721440 14424 179 1.353846 2.42338434 Planctomycetota bacterium 2026780 Bacteria Bacteria 94.7 6.040000000000001e-21   NR NOZ40414.1 2026780 g14298 i0 74.6 2.91620111731844 59 15 98.9 0 2 178 343 401 NOZ40414.1 3-isopropylmalate dehydratase large subunit [Planctomycetota bacterium] diamond 522 94.7 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
27715860 27715860 PRJNA721440_S_NODE_19104_length_164_cov_0.860870_g18978_i0 PRJNA721440 19104 164 0.86087 1.4118268 Planctomycetota bacterium 2026780 Bacteria Bacteria 43.1 0.00941   NR NRA36897.1 2026780 g18978 i0 44.7 0.859756097560976 47 25 86 1 14 154 29 74 NRA36897.1 GHKL domain-containing protein [Planctomycetota bacterium] diamond 141 43.1 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
28978562 28978562 PRJNA721440_S_NODE_1008_length_518_cov_29.699360_g885_i0 PRJNA721440 1008 518 29.69936 153.8426848 Candidatus Subterrananammoxibius californiae 3063417 Bacteria Bacteria 216 1.41e-61   NR MDO8094970.1 3063417 g885 i0 62 0.99034749034749 171 63 99 2 5 517 603 771 MDO8094970.1 RNase H-like domain-containing protein [Candidatus Subterrananammoxibius californiae] diamond 513 216 1 Bacteria PVC group Pseudomonadati Planctomycetota Candidatus Brocadiia Candidatus Brocadiales Candidatus Subterrananammoxibiaceae Candidatus Subterrananammoxibius Candidatus Subterrananammoxibius californiae
29546600 29546600 PRJNA721440_S_NODE_17250_length_168_cov_1.697479_g17124_i0 PRJNA721440 17250 168 1.697479 2.85176472 Isosphaeraceae bacterium 2691532 Bacteria Bacteria 76.3 2.01e-14   NR HEX8200246.1 2691532 g17124 i0 61.1 1.94642857142857 54 21 96.4 0 3 164 9 62 HEX8200246.1 glucose-6-phosphate isomerase [Isosphaeraceae bacterium] diamond 327 76.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae   Isosphaeraceae bacterium
30873538 30873538 PRJNA721440_S_NODE_13694_length_182_cov_3.015038_g13568_i0 PRJNA721440 13694 182 3.015038 5.48736916 Phycisphaerales bacterium 2052180 Bacteria Bacteria 41.6 0.0426   NR MFN7020982.1 2052180 g13568 i0 39.6 0.791208791208791 48 29 79.1 0 14 157 236 283 MFN7020982.1 GC-type dockerin domain-anchored protein [Phycisphaerales bacterium] diamond 144 41.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
31347733 31347733 PRJNA721440_S_NODE_11256_length_196_cov_3.476190_g11130_i0 PRJNA721440 11256 196 3.47619 6.8133324 Planctomycetota bacterium 2026780 Bacteria Bacteria 47.4 4.52e-4   NR MCA8973576.1 2026780 g11130 i0 44.8 0.887755102040816 58 32 88.8 0 194 21 30 87 MCA8973576.1 carbamoyl-phosphate synthase large subunit [Planctomycetota bacterium] diamond 174 47.4 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31548091 31548091 PRJNA721440_S_NODE_9816_length_206_cov_3.133758_g9690_i0 PRJNA721440 9816 206 3.133758 6.45554148 Bacteria 2 Bacteria Bacteria 90.5 3.66e-20   NR MCE2925133.1 2026777 g9690 i0 56.9 3.78640776699029 65 28 94.7 0 10 204 20 84 MCE2925133.1 queuosine precursor transporter [Phycisphaeraceae bacterium] diamond 780 90.5 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
31663784 31663784 PRJNA721440_S_NODE_12417_length_189_cov_1.442857_g12291_i0 PRJNA721440 12417 189 1.442857 2.72699973 Thermoguttaceae bacterium 2691551 Bacteria Bacteria 43.1 0.0129   NR HYW79930.1 2691551 g12291 i0 75 0.380952380952381 24 6 38.1 0 74 3 42 65 HYW79930.1 ammonium transporter [Thermoguttaceae bacterium] diamond 72 43.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Thermoguttaceae   Thermoguttaceae bacterium
32738962 32738962 PRJNA721440_S_NODE_17040_length_169_cov_0.866667_g16914_i0 PRJNA721440 17040 169 0.866667 1.46466723 Phycisphaerales bacterium 2052180 Bacteria Bacteria 42.7 0.0141   NR UCG46482.1 2052180 g16914 i0 45.1 0.905325443786982 51 23 90.5 2 157 5 99 144 UCG46482.1 MAG: hypothetical protein JSU94_13365, partial [Phycisphaerales bacterium] diamond 153 42.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
32906543 32906543 PRJNA721440_S_NODE_18180_length_166_cov_0.888889_g18054_i0 PRJNA721440 18180 166 0.888889 1.47555574 root 1 Root_unresolved Root_unresolved 53.5 1.98e-6   NR MFM2092802.1 2026780 g18054 i0 54.5 4.96987951807229 55 17 99.4 1 1 165 96 142 MFM2092802.1 NAD-dependent malic enzyme [Planctomycetota bacterium] diamond 825 53.9 0.992578849721707 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota 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);;