RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA340009", tax_kingdom = "Methanobacteriati" and tax_phylum = "Thermoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermoplasmatota · 6 ✖

tax_kingdom 1

  • Methanobacteriati · 6 ✖

bioproject 1

  • PRJNA340009 · 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
28464449 28464449 PRJNA340009_P_NODE_72066_length_163_cov_0.894737_g71759_i0 PRJNA340009 72066 163 0.894737 1.45842131 Thermoplasmata archaeon 1906666 Archaea Archaea 75.9 2.64e-14   NR MFA5772861.1 1906666 g71759 i0 59.3 0.993865030674847 54 22 99.4 0 1 162 368 421 MFA5772861.1 hypothetical protein [Thermoplasmata archaeon] diamond 162 75.9 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon
28559197 28559197 PRJNA340009_P_NODE_57807_length_172_cov_1.658537_g57500_i0 PRJNA340009 57807 172 1.658537 2.85268364 Thermoplasmata archaeon M8B2D 1933278 Archaea Archaea 53.1 1.21e-6   NR PNX51334.1 1933278 g57500 i0 66.7 0.627906976744186 36 12 62.8 0 109 2 1 36 PNX51334.1 MAG: hypothetical protein BV456_03540 [Thermoplasmata archaeon M8B2D] diamond 108 53.1 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon M8B2D
29569295 29569295 PRJNA340009_P_NODE_17870_length_283_cov_6.418803_g17563_i0 PRJNA340009 17870 283 6.418803 18.16521249 Thermoplasmatales archaeon 2268204 Archaea Archaea 117 4.87e-30   NR MEM3318413.1 2268204 g17563 i0 57 0.985865724381625 93 39 97.5 1 4 279 3 95 MEM3318413.1 hypothetical protein [Thermoplasmatales archaeon] diamond 279 117 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Thermoplasmatales     Thermoplasmatales archaeon
29649374 29649374 PRJNA340009_P_NODE_74910_length_162_cov_0.902655_g74603_i0 PRJNA340009 74910 162 0.902655 1.4623011 root 1 Root_unresolved Root_unresolved 79.3 1.53e-15   NR MDR0334816.1 2052168 g74603 i0 66 3.75925925925926 53 17 96.3 1 157 2 201 253 MDR0334816.1 hypothetical protein [Methanomassiliicoccaceae archaeon] diamond 609 79.3 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales Methanomassiliicoccaceae   Methanomassiliicoccaceae archaeon
32034614 32034614 PRJNA340009_P_NODE_61618_length_167_cov_1.720339_g61311_i0 PRJNA340009 61618 167 1.720339 2.87296613 Thermoplasmata archaeon 1906666 Archaea Archaea 42 0.025   NR MEM3038631.1 1906666 g61311 i0 67.7 0.55688622754491 31 10 55.7 0 166 74 329 359 MEM3038631.1 hypothetical protein [Thermoplasmata archaeon] diamond 93 42 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       Thermoplasmata archaeon
32635166 32635166 PRJNA340009_P_NODE_49220_length_184_cov_30.296296_g48913_i0 PRJNA340009 49220 184 30.296296 55.74518464 Thermoplasmatales archaeon 2268204 Archaea Archaea 96.3 2e-23   NR HEC72088.1 2268204 g48913 i0 64.3 1.89130434782609 56 20 91.3 0 173 6 106 161 HEC72088.1 hypothetical protein [Thermoplasmatales archaeon] diamond 348 96.3 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Thermoplasmatales     Thermoplasmatales 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);;