RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA1009807" and tax_phylum = "Nitrospirota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrospirota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1009807 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
7807356 7807356 PRJNA1009807_S_NODE_2847_length_189_cov_2.326667_g2819_i0 PRJNA1009807 2847 189 2.326667 4.39740063 Nitrospira sp. 70125 Bacteria Bacteria 309 8.72e-80   NTclustered gi|2290907019|gb|CP060499.1| 70125 g2819 i0 96.277 107.089947089947 188 7 99 0 2 189 2683390 2683577 MAG: Nitrospira sp. isolate DH1 chromosome, complete genome blastn 20240 309 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
11633399 11633399 PRJNA1009807_S_NODE_1890_length_225_cov_2.553763_g1862_i0 PRJNA1009807 1890 225 2.553763 5.74596675 Nitrospira sp. 70125 Bacteria Bacteria 383 6.25e-102   NTclustered gi|2511640680|gb|CP126121.1| 70125 g1862 i0 97.333 139.36 225 6 100 0 1 225 201591 201367 MAG: Nitrospira sp. isolate bin_001 chromosome, complete genome blastn 31356 383 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
21403479 21403479 PRJNA1009807_S_NODE_2357_length_204_cov_123.375758_g2329_i0 PRJNA1009807 2357 204 123.375758 251.68654632 Nitrospira 1234 Bacteria Bacteria 355 1.21e-93   NTclustered gi|922305621|gb|CP011801.1| 42253 g2329 i0 98.039 156.647058823529 204 4 100 0 1 204 1278425 1278222 Nitrospira moscoviensis strain NSP M-1, complete genome blastn 31956 355 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira moscoviensis
24380864 24380864 PRJNA1009807_S_NODE_960_length_306_cov_2.479401_g932_i0 PRJNA1009807 960 306 2.479401 7.58696706 Candidatus Nitrospira kreftii 2652173 Bacteria Bacteria 424 5.25e-114   NTclustered gi|1884724763|gb|CP047423.1| 2652173 g932 i0 93.972 552.967320261438 282 13 91 4 1 278 2706532 2706251 Candidatus Nitrospira kreftii isolate comreactor17 chromosome, complete genome blastn 169208 424 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Candidatus Nitrospira kreftii

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