RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA594101", tax_phylum = "Nanobdellota" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 6 ✖

tax_phylum 1

  • Nanobdellota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA594101 · 6 ✖

analysis 1

tax_clade 0

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
19693440 19693440 PRJNA594101_S_NODE_28496_length_319_cov_2.158537_g28194_i0 PRJNA594101 28496 319 2.158537 6.88573303 Archaea 2157 Archaea Archaea 119 4.45e-29   NR MFC1691309.1 2026764 g28194 i0 49 5.858934169279 104 53 97.8 0 317 6 306 409 MFC1691309.1 leucyl aminopeptidase [Nanoarchaeota archaeon] diamond 1869 120 0.991666666666667 Archaea   Nanobdellati Nanobdellota         Nanobdellota archaeon
19693676 19693676 PRJNA594101_S_NODE_6396_length_645_cov_3.587413_g6103_i0 PRJNA594101 6396 645 3.587413 23.13881385 Nanobdellota archaeon 2026764 Archaea Archaea 294 1.9700000000000002e-91   NR MCA9485224.1 2026764 g6103 i0 62.6 1.9906976744186 214 80 99.5 0 644 3 200 413 MCA9485224.1 GTP-binding protein [Nanoarchaeota archaeon] diamond 1284 294 1 Archaea   Nanobdellati Nanobdellota         Nanobdellota archaeon
27061538 27061538 PRJNA594101_S_NODE_5902_length_670_cov_3.917923_g5613_i0 PRJNA594101 5902 670 3.917923 26.2500841 root 1 Root_unresolved Root_unresolved 74.7 1.76e-11   NR MAG45281.1 2026764 g5613 i0 61.4 2.48059701492537 57 22 25.5 0 173 3 191 247 MAG45281.1 hypothetical protein [Nanoarchaeota archaeon] diamond 1662 75.1 0.994673768308922 Archaea   Nanobdellati Nanobdellota         Nanobdellota archaeon
27774907 27774907 PRJNA594101_S_NODE_38804_length_279_cov_1.189320_g38502_i0 PRJNA594101 38804 279 1.18932 3.3182028 Nanobdellota archaeon 2026764 Archaea Archaea 120 2.67e-29   NR MCA9485224.1 2026764 g38502 i0 62.6 0.978494623655914 91 34 97.8 0 2 274 259 349 MCA9485224.1 GTP-binding protein [Nanoarchaeota archaeon] diamond 273 120 1 Archaea   Nanobdellati Nanobdellota         Nanobdellota archaeon
28911075 28911075 PRJNA594101_S_NODE_36808_length_286_cov_1.079812_g36506_i0 PRJNA594101 36808 286 1.079812 3.08826232 Nanobdellota archaeon 2026764 Archaea Archaea 44.3 0.00225   NR MBU1976183.1 2026764 g36506 i0 51.7 0.304195804195804 29 14 30.4 0 50 136 33 61 MBU1976183.1 hypothetical protein [Nanoarchaeota archaeon] diamond 87 44.3 1 Archaea   Nanobdellati Nanobdellota         Nanobdellota archaeon
30932879 30932879 PRJNA594101_S_NODE_21214_length_365_cov_0.832192_g20912_i0 PRJNA594101 21214 365 0.832192 3.0375008 Nanobdellota archaeon 2026764 Archaea Archaea 45.1 0.0225   NR MAG45500.1 2026764 g20912 i0 43.5 0.378082191780822 46 26 37.8 0 135 272 401 446 MAG45500.1 ATPase [Nanoarchaeota archaeon] diamond 138 45.1 1 Archaea   Nanobdellati Nanobdellota         Nanobdellota archaeon

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);;