RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA611476", tax_phylum = "Thermoplasmatota" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 5 ✖

tax_phylum 1

  • Thermoplasmatota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA611476 · 5 ✖

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
26605216 26605216 PRJNA611476_P_NODE_85881_length_249_cov_0.875000_g85090_i0 PRJNA611476 85881 249 0.875 2.17875 Thermoplasmatota archaeon 2806419 Archaea Archaea 90.5 5.91e-19   NR MFO8077312.1 2806419 g85090 i0 69.2 0.783132530120482 65 20 78.3 0 221 27 359 423 MFO8077312.1 CocE/NonD family hydrolase [Thermoplasmatota archaeon] diamond 195 90.5 1 Archaea   Methanobacteriati Thermoplasmatota         Thermoplasmatota archaeon
27206420 27206420 PRJNA611476_P_NODE_94122_length_247_cov_0.885057_g93331_i0 PRJNA611476 94122 247 0.885057 2.18609079 Thermoplasmatota archaeon 2806419 Archaea Archaea 54.3 3.28e-6   NR MED5376326.1 2806419 g93331 i0 33.8 0.97165991902834 80 45 94.7 2 13 246 409 482 MED5376326.1 hypothetical protein [Thermoplasmatota archaeon] diamond 240 54.3 1 Archaea   Methanobacteriati Thermoplasmatota         Thermoplasmatota archaeon
28059304 28059304 PRJNA611476_P_NODE_9905_length_619_cov_2.714286_g9121_i0 PRJNA611476 9905 619 2.714286 16.80143034 Thermoplasmatales archaeon 2268204 Archaea Archaea 80.1 4.56e-14   NR UCF13016.1 2268204 g9121 i0 35.6 0.722132471728595 149 85 70.3 5 2 436 116 257 UCF13016.1 MAG: FkbM family methyltransferase [Thermoplasmatales archaeon] diamond 447 80.1 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Thermoplasmatales     Thermoplasmatales archaeon
29511599 29511599 PRJNA611476_P_NODE_32310_length_365_cov_1.582192_g31519_i0 PRJNA611476 32310 365 1.582192 5.7750008 Thermoplasmata archaeon 1906666 Archaea Archaea 61.2 5.19e-8   NR MEM3395827.1 1906666 g31519 i0 33.7 0.83013698630137 101 52 78.1 4 334 50 1307 1398 MEM3395827.1 kelch repeat-containing protein [Thermoplasmata archaeon] diamond 303 61.2 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon
30301880 30301880 PRJNA611476_P_NODE_98332_length_246_cov_0.890173_g97541_i0 PRJNA611476 98332 246 0.890173 2.18982558 Thermoplasmatota archaeon 2806419 Archaea Archaea 69.7 7.74e-12   NR MCL4450642.1 2806419 g97541 i0 45.9 3.60975609756098 74 40 90.2 0 1 222 230 303 MCL4450642.1 deoxyhypusine synthase [Thermoplasmatota archaeon] diamond 888 69.7 1 Archaea   Methanobacteriati Thermoplasmatota         Thermoplasmatota 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);;