RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA404067" and tax_phylum = "Nitrospirota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrospirota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA404067 · 5 ✖

analysis 1

  • blastn · 5 ✖

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
13168162 13168162 PRJNA404067_P_NODE_11971_length_305_cov_2.303279_g11585_i0 PRJNA404067 11971 305 2.303279 7.02500095 Nitrospira japonica 1325564 Bacteria Bacteria 329 1.17e-85   NTclustered gi|1167499077|emb|LT828648.1| 1325564 g11585 i0 86.23 10.8918032786885 305 40 100 2 1 305 982653 982351 Nitrospira japonica isolate Genome sequencing of Nitrospira japonica strain NJ11 genome assembly, chromosome: I blastn 3322 329 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira japonica
20816415 20816415 PRJNA404067_P_NODE_35857_length_204_cov_0.860140_g35470_i0 PRJNA404067 35857 204 0.86014 1.7546856 Nitrospira sp. 70125 Bacteria Bacteria 147 7.939999999999999e-31   NTclustered gi|1938802452|gb|CP054184.1| 70125 g35470 i0 85.034 2.13725490196078 147 18 71 4 60 203 1293156 1293301 MAG: Nitrospira sp. isolate H3_NOB1 chromosome, complete genome blastn 436 147 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
23366827 23366827 PRJNA404067_P_NODE_36279_length_203_cov_1.415493_g35892_i0 PRJNA404067 36279 203 1.415493 2.87345079 Nitrospira sp. 70125 Bacteria Bacteria 233 5.889999999999999e-57   NTclustered gi|2194428397|gb|CP092079.1| 70125 g35892 i0 87.879 0.975369458128079 198 24 98 0 1 198 175075 175272 MAG: Nitrospira sp. isolate UBC3 chromosome blastn 198 233 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
24641097 24641097 PRJNA404067_P_NODE_31340_length_209_cov_0.864865_g30953_i0 PRJNA404067 31340 209 0.864865 1.80756785 Nitrospira defluvii 330214 Bacteria Bacteria 219 1.71e-52   NTclustered gi|300603458|emb|FP929003.1| 330214 g30953 i0 86.432 0.952153110047847 199 27 95 0 2 200 1654106 1654304 Candidatus Nitrospira defluvii chromosome, complete genome blastn 199 219 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira defluvii
24641250 24641250 PRJNA404067_P_NODE_39100_length_201_cov_0.878571_g38713_i0 PRJNA404067 39100 201 0.878571 1.76592771 Nitrospira sp. 70125 Bacteria Bacteria 263 7.419999999999999e-66   NTclustered gi|2194428397|gb|CP092079.1| 70125 g38713 i0 90.816 1.92537313432836 196 18 98 0 6 201 200792 200987 MAG: Nitrospira sp. isolate UBC3 chromosome blastn 387 263 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira 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);;