RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA641707" and tax_phylum = "Chlorobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chlorobiota · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA641707 · 3 ✖

analysis 1

  • blastn · 3 ✖
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
4443133 4443133 PRJNA641707_P_NODE_302884_length_163_cov_7.614035_g300221_i0 PRJNA641707 302884 163 7.614035 12.41087705 Chlorobiota bacterium 2268192 Bacteria Bacteria 246 5.8099999999999995e-61   NTclustered gi|1958119998|gb|CP065014.1| 2268192 g300221 i0 94.375 337.147239263804 160 9 98 0 1 160 283464 283305 MAG: Chlorobiota bacterium isolate Ribe_18-Q3-R11-54_MAXAC.096_cln chromosome, complete genome blastn 54955 246 1 Bacteria FCB group Pseudomonadati Chlorobiota         Chlorobiota bacterium
4443364 4443364 PRJNA641707_P_NODE_312064_length_161_cov_2.892857_g309401_i0 PRJNA641707 312064 161 2.892857 4.65749977 Chlorobiota bacterium 2268192 Bacteria Bacteria 222 9.63e-54   NTclustered gi|1958119998|gb|CP065014.1| 2268192 g309401 i0 92.81 0.950310559006211 153 11 95 0 3 155 3137714 3137562 MAG: Chlorobiota bacterium isolate Ribe_18-Q3-R11-54_MAXAC.096_cln chromosome, complete genome blastn 153 222 1 Bacteria FCB group Pseudomonadati Chlorobiota         Chlorobiota bacterium
15185713 15185713 PRJNA641707_P_NODE_264012_length_176_cov_9.582677_g261349_i0 PRJNA641707 264012 176 9.582677 16.86551152 Bacteria 2 Bacteria Bacteria 291 2.89e-74   NTclustered gi|373279240|gb|JN713214.1| 1151614 g261349 i0 100 90.6875 157 0 89 0 17 173 1 157 Chlorobi bacterium canine oral taxon 046 clone 1F061 16S ribosomal RNA gene, partial sequence blastn 15961 291 1 Bacteria FCB group Pseudomonadati Chlorobiota         Chlorobi bacterium canine oral taxon 046

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