RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA1195374" and tax_phylum = "Cyanobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cyanobacteriota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1195374 · 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
10525294 10525294 PRJNA1195374_P_NODE_39929_length_353_cov_1.985714_g39585_i0 PRJNA1195374 39929 353 1.985714 7.00957042 Calothrix sp. NIES-3974 2005462 Bacteria Bacteria 84.2 1.18e-11   NTclustered gi|1210184319|dbj|AP018254.1| 2005462 g39585 i0 89.394 0.186968838526912 66 7 19 0 3 68 2202081 2202146 Calothrix sp. NIES-3974 DNA, complete genome blastn 66 84.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Calotrichaceae Calothrix Calothrix sp. NIES-3974
19447598 19447598 PRJNA1195374_P_NODE_40476_length_351_cov_1.086331_g40132_i0 PRJNA1195374 40476 351 1.086331 3.81302181 Synechococcus sp. NB0720_010 2907159 Bacteria Bacteria 52.8 0.033   NTclustered gi|2227925466|gb|CP090898.1| 2907159 g40132 i0 94.286 0.0997150997150997 35 1 10 1 276 310 409051 409018 Synechococcus sp. NB0720_010 chromosome, complete genome blastn 35 52.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae Synechococcus Synechococcus sp. NB0720_010
21998260 21998260 PRJNA1195374_P_NODE_37418_length_367_cov_1.047619_g37074_i0 PRJNA1195374 37418 367 1.047619 3.84476173 uncultured cyanobacterium 1211 Bacteria Bacteria 424 6.409999999999999e-114   NTclustered gi|171263038|gb|EU432339.1| 1211 g37074 i0 96.139 102.972752043597 259 10 71 0 109 367 373 115 Uncultured cyanobacterium clone Fuku4-SW-Pi15 16S ribosomal RNA gene, partial sequence blastn 37791 424 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         uncultured cyanobacterium

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