RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

tax_clade 1

  • PVC group · 12 ✖

bioproject 1

  • PRJNA773247 · 12 ✖

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
26958186 26958186 PRJNA773247_P_NODE_14682_length_389_cov_3.522152_g14598_i0 PRJNA773247 14682 389 3.522152 13.70117128 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 130 1.23e-34   NR HRV31471.1 2212473 g14598 i0 59.8 0.902313624678663 117 47 90.2 0 389 39 131 247 HRV31471.1 hypothetical protein [Kiritimatiellia bacterium] diamond 351 130 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
27116335 27116335 PRJNA773247_P_NODE_27082_length_267_cov_11.082474_g26998_i0 PRJNA773247 27082 267 11.082474 29.59020558 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 118 8.049999999999998e-30   NR HRT29955.1 2212473 g26998 i0 71.3 0.898876404494382 80 23 89.9 0 265 26 34 113 HRT29955.1 N4-gp56 family major capsid protein [Kiritimatiellia bacterium] diamond 240 118 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
28600939 28600939 PRJNA773247_P_NODE_7747_length_590_cov_3.798839_g7664_i0 PRJNA773247 7747 590 3.798839 22.4131501 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 180 2.72e-53   NR HMO03937.1 2212473 g7664 i0 50 0.925423728813559 182 90 92.5 1 44 589 3 183 HMO03937.1 hypothetical protein [Kiritimatiellia bacterium] diamond 546 180 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
28664024 28664024 PRJNA773247_P_NODE_17987_length_342_cov_14.401487_g17903_i0 PRJNA773247 17987 342 14.401487 49.25308554 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 61.2 1.63e-9   NR HPC49771.1 2212473 g17903 i0 44.4 0.631578947368421 72 37 63.2 2 331 116 28 96 HPC49771.1 hypothetical protein [Kiritimatiellia bacterium] diamond 216 61.2 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
28758614 28758614 PRJNA773247_P_NODE_26527_length_271_cov_1.368687_g26443_i0 PRJNA773247 26527 271 1.368687 3.70914177 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 65.1 5.65e-10   NR HRT29955.1 2212473 g26443 i0 93.8 0.354243542435424 32 2 35.4 0 269 174 303 334 HRT29955.1 N4-gp56 family major capsid protein [Kiritimatiellia bacterium] diamond 96 65.1 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
28821538 28821538 PRJNA773247_P_NODE_35888_length_232_cov_8.132075_g35804_i0 PRJNA773247 35888 232 8.132075 18.866414 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 106 8.43e-25   NR MFA7334932.1 2212473 g35804 i0 71.1 0.982758620689655 76 22 98.3 0 2 229 186 261 MFA7334932.1 hypothetical protein [Kiritimatiellia bacterium] diamond 228 106 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
28916291 28916291 PRJNA773247_P_NODE_12348_length_434_cov_5.407202_g12265_i0 PRJNA773247 12348 434 5.407202 23.46725668 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 75.9 5e-13   NR HPT16267.1 2212473 g12265 i0 39.8 0.711981566820276 103 59 71.2 1 110 418 1 100 HPT16267.1 hypothetical protein [Kiritimatiellia bacterium] diamond 309 75.9 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
28948357 28948357 PRJNA773247_P_NODE_21528_length_306_cov_6.347639_g21444_i0 PRJNA773247 21528 306 6.347639 19.42377534 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 93.6 1.1e-19   NR MBP7638713.1 2212473 g21444 i0 54.4 0.882352941176471 90 41 88.2 0 33 302 625 714 MBP7638713.1 tape measure protein [Kiritimatiellia bacterium] diamond 270 93.6 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
29863756 29863756 PRJNA773247_P_NODE_19751_length_323_cov_4.800000_g19667_i0 PRJNA773247 19751 323 4.8 15.504 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 50.1 1.44e-4   NR HMO03935.1 2212473 g19667 i0 55.6 0.910216718266254 45 20 41.8 0 298 164 145 189 HMO03935.1 hypothetical protein [Kiritimatiellia bacterium] diamond 294 50.1 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
30116407 30116407 PRJNA773247_P_NODE_26852_length_269_cov_1.500000_g26768_i0 PRJNA773247 26852 269 1.5 4.035 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 71.2 4.16e-12   NR MBQ2632007.1 2212473 g26768 i0 58.2 0.613382899628253 55 23 61.3 0 167 3 148 202 MBQ2632007.1 AAA family ATPase [Kiritimatiellia bacterium] diamond 165 71.2 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
31064641 31064641 PRJNA773247_P_NODE_28395_length_260_cov_3.224599_g28311_i0 PRJNA773247 28395 260 3.224599 8.3839574 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 49.3 4.52e-5   NR HMP76842.1 2212473 g28311 i0 39.6 0.611538461538462 53 32 61.2 0 82 240 5 57 HMP76842.1 DUF1353 domain-containing protein [Kiritimatiellia bacterium] diamond 159 49.3 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
32076488 32076488 PRJNA773247_P_NODE_37318_length_201_cov_5.656250_g37234_i0 PRJNA773247 37318 201 5.65625 11.3690625 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 48.9 1.37e-4   NR MDD2462046.1 2212473 g37234 i0 39.4 0.985074626865672 66 40 98.5 0 200 3 100 165 MDD2462046.1 hypothetical protein [Kiritimatiellia bacterium] diamond 198 48.9 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);;