RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA1041773" and tax_phylum = "Thermoproteota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermoproteota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1041773 · 3 ✖

analysis 1

  • blastn · 3 ✖

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
1008402 1008402 PRJNA1041773_P_NODE_38981_length_338_cov_4.018868_g38648_i0 PRJNA1041773 38981 338 4.018868 13.58377384 Metallosphaera 41980 Archaea Archaea 73.1 2.45e-8   NTclustered gi|676314532|gb|CP008822.1| 43687 g38648 i0 85.915 4.22781065088757 71 6 29 3 40 107 1708064 1708133 Metallosphaera sedula strain CuR1 genome blastn 1429 73.1 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales Sulfolobaceae Metallosphaera Metallosphaera sedula
2720642 2720642 PRJNA1041773_P_NODE_36263_length_350_cov_0.967509_g35930_i0 PRJNA1041773 36263 350 0.967509 3.3862815 Candidatus Methanosuratincola petrocarbonis (ex Vanwonterghem et al. 2016) 1867261 Archaea Archaea 311 4.94e-80   NTclustered gi|2551788334|gb|CP130488.1| 1867261 g35930 i0 94.118 0.925714285714286 204 12 93 0 147 350 411003 411206 MAG: Candidatus Methanosuratincola petrocarbonis isolate LWZ-6 chromosome, complete genome blastn 324 311 1 Archaea   Thermoproteati Thermoproteota Methanosuratincolia Candidatus Methanomethylicales Candidatus Methanomethylicaceae Candidatus Methanosuratincola (ex Vanwonterghem et al. 2016) Candidatus Methanosuratincola petrocarbonis (ex Vanwonterghem et al. 2016)
5272687 5272687 PRJNA1041773_P_NODE_10445_length_637_cov_75.845745_g10121_i0 PRJNA1041773 10445 637 75.845745 483.13739565 Infirmifilum sp. NZ 2926850 Archaea Archaea 169 6.02e-37   NTclustered gi|2211485873|gb|CP094288.1| 2926850 g10121 i0 87.671 33.9058084772371 146 17 30 1 89 233 909863 909718 Infirmifilum sp. NZ chromosome blastn 21598 169 1 Archaea   Thermoproteati Thermoproteota Thermoprotei Thermofilales Thermofilaceae Infirmifilum Infirmifilum sp. NZ

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