RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA1112809" and tax_phylum = "Nitrospirota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrospirota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1112809 · 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
7874610 7874610 PRJNA1112809_P_NODE_93787_length_345_cov_1.132353_g90512_i0 PRJNA1112809 93787 345 1.132353 3.90661785 Nitrospira sp. 70125 Bacteria Bacteria 401 2.81e-107   NTclustered gi|2194428397|gb|CP092079.1| 70125 g90512 i0 87.977 75.6260869565217 341 40 99 1 1 341 1764943 1765282 MAG: Nitrospira sp. isolate UBC3 chromosome blastn 26091 401 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
9147962 9147962 PRJNA1112809_P_NODE_197748_length_232_cov_2.081761_g194473_i0 PRJNA1112809 197748 232 2.081761 4.82968552 Nitrospira sp. 70125 Bacteria Bacteria 156 1.54e-33   NTclustered gi|2194428397|gb|CP092079.1| 70125 g194473 i0 79.149 19.4612068965517 235 41 99 7 2 232 2533520 2533290 MAG: Nitrospira sp. isolate UBC3 chromosome blastn 4515 156 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
20149556 20149556 PRJNA1112809_P_NODE_123696_length_292_cov_1.223744_g120421_i0 PRJNA1112809 123696 292 1.223744 3.57333248 Pseudomonadati 3379134 Bacteria Bacteria 230 1.1599999999999998e-55   NTclustered gi|2449738114|gb|CP114561.1| 2927580 g120421 i0 83.673 51.1506849315069 245 39 84 1 4 247 3682177 3682421 MAG: Candidatus Manganitrophus sp. isolate GAC4 chromosome, complete genome blastn 14936 230 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Candidatus Troglogloeales Candidatus Manganitrophaceae Candidatus Manganitrophus Candidatus Manganitrophus sp.

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