RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA849822" and tax_phylum = "Thermoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermoplasmatota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA849822 · 4 ✖

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
29076167 29076167 PRJNA849822_P_NODE_19528_length_327_cov_2.145669_g19354_i0 PRJNA849822 19528 327 2.145669 7.01633763 Thermoplasmata archaeon 1906666 Archaea Archaea 53.1 2.04e-5   NR MCI4324558.1 1906666 g19354 i0 33 2.44036697247706 103 61 94.5 3 326 18 97 191 MCI4324558.1 phosphate ABC transporter substrate-binding protein PstS [Thermoplasmata archaeon] diamond 798 53.1 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon
29423118 29423118 PRJNA849822_P_NODE_24669_length_292_cov_1.077626_g24495_i0 PRJNA849822 24669 292 1.077626 3.14666792 Thermoplasmata archaeon 1906666 Archaea Archaea 46.6 0.00149   NR MFQ6012969.1 1906666 g24495 i0 40.5 0.76027397260274 74 35 76 3 46 267 1 65 MFQ6012969.1 hypothetical protein [Thermoplasmata archaeon] diamond 222 46.6 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon
30308192 30308192 PRJNA849822_P_NODE_33032_length_254_cov_1.386740_g32858_i0 PRJNA849822 33032 254 1.38674 3.5223196 Candidatus Poseidoniaceae archaeon 2666346 Archaea Archaea 67 1.25e-10   NR MFL2985199.1 2666346 g32858 i0 45 0.94488188976378 80 39 94.5 1 13 252 708 782 MFL2985199.1 putative Ig domain-containing protein [Candidatus Poseidoniaceae archaeon] diamond 240 67 1 Archaea   Methanobacteriati Thermoplasmatota Candidatus Poseidoniia Candidatus Poseidoniales Candidatus Poseidoniaceae   Candidatus Poseidoniaceae archaeon
32014754 32014754 PRJNA849822_P_NODE_14478_length_383_cov_1.603226_g14304_i0 PRJNA849822 14478 383 1.603226 6.14035558 Thermoplasmata archaeon 1906666 Archaea Archaea 65.1 2.66e-9   NR RLF57331.1 1906666 g14304 i0 31.1 1.75456919060052 122 76 95.6 4 17 382 370 483 RLF57331.1 MAG: hypothetical protein DRN27_07995 [Thermoplasmata archaeon] diamond 672 65.1 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata 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);;