RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where bioproject = "PRJEB10140", 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 · 16 ✖

tax_kingdom 1

tax_clade 1

  • PVC group · 16 ✖

bioproject 1

  • PRJEB10140 · 16 ✖

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
26779496 26779496 PRJEB10140_P_NODE_259541_length_167_cov_0.872881_g242232_i0 PRJEB10140 259541 167 0.872881 1.45771127 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 100 4.26e-23   NR MDD2455831.1 2212473 g242232 i0 96.4 0.988023952095808 55 2 98.8 0 3 167 344 398 MDD2455831.1 toprim domain-containing protein [Kiritimatiellia bacterium] diamond 165 100 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
26811130 26811130 PRJEB10140_P_NODE_247181_length_169_cov_0.866667_g229872_i0 PRJEB10140 247181 169 0.866667 1.46466723 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 93.2 1.57e-20   NR MBR4259574.1 2212473 g229872 i0 97.7 0.781065088757396 44 1 78.1 0 167 36 397 440 MBR4259574.1 B12-binding domain-containing radical SAM protein [Kiritimatiellia bacterium] diamond 132 93.2 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
27158761 27158761 PRJEB10140_P_NODE_278302_length_164_cov_0.895652_g260993_i0 PRJEB10140 278302 164 0.895652 1.46886928 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 72 2.97e-13   NR MBQ6340953.1 2212473 g260993 i0 61.2 0.896341463414634 49 19 89.6 0 149 3 181 229 MBQ6340953.1 hypothetical protein [Kiritimatiellia bacterium] diamond 147 72 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
27317299 27317299 PRJEB10140_P_NODE_258683_length_167_cov_0.881356_g241374_i0 PRJEB10140 258683 167 0.881356 1.47186452 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 113 1.53e-27   NR MBR6588029.1 2212473 g241374 i0 98.2 0.988023952095808 55 1 98.8 0 3 167 88 142 MBR6588029.1 DUF1565 domain-containing protein [Kiritimatiellia bacterium] diamond 165 113 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
27380514 27380514 PRJEB10140_P_NODE_282943_length_163_cov_0.912281_g265634_i0 PRJEB10140 282943 163 0.912281 1.48701803 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 75.9 2.54e-14   NR MBR4937564.1 2212473 g265634 i0 70.6 1.87730061349693 51 15 93.9 0 155 3 458 508 MBR4937564.1 beta-galactosidase [Kiritimatiellia bacterium] diamond 306 75.9 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
27980275 27980275 PRJEB10140_P_NODE_264365_length_166_cov_0.888889_g247056_i0 PRJEB10140 264365 166 0.888889 1.47555574 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 85.1 1.55e-17   NR MBR6587476.1 2212473 g247056 i0 74.5 0.993975903614458 55 14 99.4 0 1 165 683 737 MBR6587476.1 hypothetical protein [Kiritimatiellia bacterium] diamond 165 85.1 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
29369424 29369424 PRJEB10140_P_NODE_105289_length_347_cov_1.916107_g87990_i0 PRJEB10140 105289 347 1.916107 6.64889129 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 45.1 0.0199   NR MBO4448834.1 2212473 g87990 i0 36.2 0.501440922190202 58 37 50.1 0 159 332 732 789 MBO4448834.1 hypothetical protein [Kiritimatiellia bacterium] diamond 174 45.1 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
29874790 29874790 PRJEB10140_P_NODE_259351_length_167_cov_0.872881_g242042_i0 PRJEB10140 259351 167 0.872881 1.45771127 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 48.1 1.64e-4   NR MCR5413236.1 2212473 g242042 i0 95.2 0.754491017964072 21 1 37.7 0 164 102 334 354 MCR5413236.1 phosphoribosylformylglycinamidine cyclo-ligase [Kiritimatiellia bacterium] diamond 126 48.1 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
30001221 30001221 PRJEB10140_P_NODE_278711_length_164_cov_0.886957_g261402_i0 PRJEB10140 278711 164 0.886957 1.45460948 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 72 6e-13   NR MBQ9741945.1 2212473 g261402 i0 56.6 4.82926829268293 53 23 97 0 1 159 724 776 MBQ9741945.1 hypothetical protein [Kiritimatiellia bacterium] diamond 792 72 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
30222175 30222175 PRJEB10140_P_NODE_290232_length_162_cov_0.920354_g272923_i0 PRJEB10140 290232 162 0.920354 1.49097348 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 108 5.660000000000001e-27   NR MBQ3315518.1 2212473 g272923 i0 96.3 2 54 2 100 0 1 162 103 156 MBQ3315518.1 HipA domain-containing protein [Kiritimatiellia bacterium] diamond 324 108 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
30790924 30790924 PRJEB10140_P_NODE_264594_length_166_cov_0.888889_g247285_i0 PRJEB10140 264594 166 0.888889 1.47555574 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 107 1.84e-25   NR MBQ5794707.1 2212473 g247285 i0 100 0.939759036144578 52 0 94 0 158 3 434 485 MBQ5794707.1 hypothetical protein [Kiritimatiellia bacterium] diamond 156 107 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
30949048 30949048 PRJEB10140_P_NODE_182254_length_210_cov_1.869565_g164945_i0 PRJEB10140 182254 210 1.869565 3.9260865 Kiritimatiellota bacterium 2599938 Bacteria Bacteria 104 7.18e-26   NR MCL2103695.1 2599938 g164945 i0 71 5.95714285714286 69 17 98.6 2 209 3 100 165 MCL2103695.1 site-specific DNA-methyltransferase [Kiritimatiellota bacterium] diamond 1251 104 1 Bacteria PVC group Pseudomonadati Kiritimatiellota         Kiritimatiellota bacterium
31043953 31043953 PRJEB10140_P_NODE_123675_length_296_cov_1.578947_g106368_i0 PRJEB10140 123675 296 1.578947 4.67368312 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 45.8 0.00483   NR MBQ3747554.1 2212473 g106368 i0 30.7 1.02364864864865 101 58 95.3 4 8 289 37 132 MBQ3747554.1 hypothetical protein [Kiritimatiellia bacterium] diamond 303 45.8 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
31075404 31075404 PRJEB10140_P_NODE_270435_length_165_cov_0.896552_g253126_i0 PRJEB10140 270435 165 0.896552 1.4793108 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 105 7.37e-25   NR MBQ4385055.1 2212473 g253126 i0 81.8 1 55 10 100 0 1 165 165 219 MBQ4385055.1 Gfo/Idh/MocA family oxidoreductase [Kiritimatiellia bacterium] diamond 165 105 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
31075414 31075414 PRJEB10140_P_NODE_281475_length_163_cov_0.912281_g264166_i0 PRJEB10140 281475 163 0.912281 1.48701803 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 104 1.19e-24   NR MBR4259143.1 2212473 g264166 i0 96.3 0.993865030674847 54 2 99.4 0 2 163 33 86 MBR4259143.1 hypothetical protein [Kiritimatiellia bacterium] diamond 162 104 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
31549856 31549856 PRJEB10140_P_NODE_278296_length_164_cov_0.895652_g260987_i0 PRJEB10140 278296 164 0.895652 1.46886928 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 62 1.8e-9   NR MCQ2395463.1 2212473 g260987 i0 54.7 0.969512195121951 53 24 97 0 1 159 120 172 MCQ2395463.1 PD-(D/E)XK motif protein [Kiritimatiellia bacterium] diamond 159 62 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);;