RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where bioproject = "PRJNA814235", tax_clade = "PVC group" and tax_phylum = "Kiritimatiellota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Kiritimatiellota · 11 ✖

tax_kingdom 1

tax_clade 1

  • PVC group · 11 ✖

bioproject 1

  • PRJNA814235 · 11 ✖

analysis 1

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
27465320 27465320 PRJNA814235_P_NODE_106943_length_203_cov_2.156627_g105548_i0 PRJNA814235 106943 203 2.156627 4.37795281 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 89 5.44e-19   NR MDA3873845.1 2212473 g105548 i0 69.7 0.975369458128079 66 18 97.5 1 6 203 228 291 MDA3873845.1 hypothetical protein [Kiritimatiellia bacterium] diamond 198 89 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
27654846 27654846 PRJNA814235_P_NODE_192464_length_151_cov_2.798246_g191069_i0 PRJNA814235 192464 151 2.798246 4.22535146 Kiritimatiellota bacterium B12222 3040511 Bacteria Bacteria 57.8 4.93e-8   NR WFB36836.1 3040511 g191069 i0 84 0.496688741721854 25 4 49.7 0 3 77 234 258 WFB36836.1 hypothetical protein P3T73_03545 [Kiritimatiellota bacterium B12222] diamond 75 57.8 1 Bacteria PVC group Pseudomonadati Kiritimatiellota         Kiritimatiellota bacterium B12222
28160041 28160041 PRJNA814235_P_NODE_184665_length_151_cov_4.043860_g183270_i0 PRJNA814235 184665 151 4.04386 6.1062286 Kiritimatiellaeota bacterium B1221 3033806 Bacteria Bacteria 46.6 4.41e-4   NR MDF3128013.1 3033806 g183270 i0 80 0.496688741721854 25 5 49.7 0 149 75 109 133 MDF3128013.1 RluA family pseudouridine synthase [Kiritimatiellaeota bacterium B1221] diamond 75 46.6 1 Bacteria PVC group Pseudomonadati Kiritimatiellota         Kiritimatiellaeota bacterium B1221
28317723 28317723 PRJNA814235_P_NODE_188166_length_151_cov_3.289474_g186771_i0 PRJNA814235 188166 151 3.289474 4.96710574 Kiritimatiellaeota bacterium B1221 3033806 Bacteria Bacteria 50.4 2.03e-5   NR MDF3128074.1 3033806 g186771 i0 87.5 0.95364238410596 24 3 47.7 0 150 79 46 69 MDF3128074.1 hypothetical protein [Kiritimatiellaeota bacterium B1221] diamond 144 50.4 1 Bacteria PVC group Pseudomonadati Kiritimatiellota         Kiritimatiellaeota bacterium B1221
29328004 29328004 PRJNA814235_P_NODE_183289_length_151_cov_4.754386_g181894_i0 PRJNA814235 183289 151 4.754386 7.17912286 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 55.8 2.53e-7   NR MDA3875278.1 2212473 g181894 i0 72.7 0.655629139072848 33 9 65.6 0 2 100 492 524 MDA3875278.1 cbb3-type cytochrome c oxidase subunit I [Kiritimatiellia bacterium] diamond 99 55.8 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
30148984 30148984 PRJNA814235_P_NODE_180172_length_152_cov_4.373913_g178777_i0 PRJNA814235 180172 152 4.373913 6.64834776 Kiritimatiellaeota bacterium B1221 3033806 Bacteria Bacteria 62.4 1.23e-9   NR MDF3127977.1 3033806 g178777 i0 43 1.83552631578947 93 10 98.7 1 151 2 221 313 MDF3127977.1 TolC family protein [Kiritimatiellaeota bacterium B1221] diamond 279 62.4 1 Bacteria PVC group Pseudomonadati Kiritimatiellota         Kiritimatiellaeota bacterium B1221
30370819 30370819 PRJNA814235_P_NODE_196872_length_150_cov_4.371681_g195477_i0 PRJNA814235 196872 150 4.371681 6.5575215 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 46.2 6.11e-4   NR MEX2607574.1 2212473 g195477 i0 87.5 0.48 24 3 48 0 78 149 52 75 MEX2607574.1 folylpolyglutamate synthase/dihydrofolate synthase family protein [Kiritimatiellia bacterium] diamond 72 46.2 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
30402388 30402388 PRJNA814235_P_NODE_182233_length_151_cov_7.535088_g180838_i0 PRJNA814235 182233 151 7.535088 11.37798288 Kiritimatiellota bacterium B12222 3040511 Bacteria Bacteria 69.7 3.27e-12   NR WFB35415.1 3040511 g180838 i0 47.5 1.96688741721854 99 3 99.3 1 1 150 291 389 WFB35415.1 ABC transporter permease subunit [Kiritimatiellota bacterium B12222] diamond 297 69.7 1 Bacteria PVC group Pseudomonadati Kiritimatiellota         Kiritimatiellota bacterium B12222
30717819 30717819 PRJNA814235_P_NODE_196754_length_150_cov_4.486726_g195359_i0 PRJNA814235 196754 150 4.486726 6.730089 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 43.1 0.00796   NR MBQ3290311.1 2212473 g195359 i0 75 1.44 24 6 48 0 76 147 664 687 MBQ3290311.1 family 43 glycosylhydrolase [Kiritimatiellia bacterium] diamond 216 43.1 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
30812677 30812677 PRJNA814235_P_NODE_90514_length_203_cov_3.307229_g89119_i0 PRJNA814235 90514 203 3.307229 6.71367487 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 82.8 1.53e-16   NR MEX2605997.1 2212473 g89119 i0 64.2 0.990147783251232 67 20 99 1 3 203 83 145 MEX2605997.1 PQQ-dependent sugar dehydrogenase [Kiritimatiellia bacterium] diamond 201 82.8 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
30844394 30844394 PRJNA814235_P_NODE_199854_length_150_cov_3.035398_g198459_i0 PRJNA814235 199854 150 3.035398 4.553097 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 113 1.6100000000000002e-27   NR MBR2941445.1 2212473 g198459 i0 100 1.96 49 0 98 0 3 149 128 176 MBR2941445.1 valine--tRNA ligase [Kiritimatiellia bacterium] diamond 294 113 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia 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);;