RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA1020854", tax_kingdom = "Nanobdellati" and tax_phylum = "Nanobdellota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nanobdellota · 3 ✖

tax_kingdom 1

  • Nanobdellati · 3 ✖

bioproject 1

  • PRJNA1020854 · 3 ✖

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
3987451 3987451 PRJNA1020854_S_NODE_23464_length_221_cov_3029.932292_g20700_i0 PRJNA1020854 23464 221 3029.932292 6696.15036532 Nanobdellota archaeon 2026764 Archaea Archaea 84.7 9.87e-18   NR MDO8509183.1 2026764 g20700 i0 80 0.746606334841629 55 11 74.7 0 57 221 88 142 MDO8509183.1 tyrosine-type recombinase/integrase [Nanoarchaeota archaeon] diamond 165 84.7 1 Archaea   Nanobdellati Nanobdellota         Nanobdellota archaeon
19286714 19286714 PRJNA1020854_S_NODE_30996_length_184_cov_3751.845161_g28232_i0 PRJNA1020854 30996 184 3751.845161 6903.39509624 Nanobdellota archaeon 2026764 Archaea Archaea 87.8 4.95e-20   NR MEK6894099.1 2026764 g28232 i0 89.4 0.766304347826087 47 5 76.6 0 142 2 122 168 MEK6894099.1 hypothetical protein [Nanoarchaeota archaeon] diamond 141 87.8 1 Archaea   Nanobdellati Nanobdellota         Nanobdellota archaeon
28519368 28519368 PRJNA1020854_S_NODE_34047_length_174_cov_2.627586_g31283_i0 PRJNA1020854 34047 174 2.627586 4.57199964 Nanobdellota archaeon 2026764 Archaea Archaea 77 2.5e-15   NR MFC1685439.1 2026764 g31283 i0 61.4 0.982758620689655 57 22 98.3 0 172 2 74 130 MFC1685439.1 (Fe-S)-binding protein [Nanoarchaeota archaeon] diamond 171 77 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);;