RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJEB12237", tax_kingdom = "Pseudomonadati" and tax_phylum = "Nitrospirota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrospirota · 6 ✖

tax_kingdom 1

  • Pseudomonadati · 6 ✖

bioproject 1

  • PRJEB12237 · 6 ✖

analysis 1

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
20674 20674 PRJEB12237_P_NODE_2361_length_460_cov_3.336471_g2165_i0 PRJEB12237 2361 460 3.336471 15.3477666 Nitrospira sp. 70125 Bacteria Bacteria 828 0   NTclustered gi|2863125063|dbj|AP038805.1| 70125 g2165 i0 99.13 596.667391304348 460 4 100 0 1 460 2095011 2094552 MAG: Nitrospira sp. AFB01 DNA, complete genome blastn 274467 828 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
6088721 6088721 PRJEB12237_P_NODE_6425_length_227_cov_4.312500_g6229_i0 PRJEB12237 6425 227 4.3125 9.789375 Nitrospira 1234 Bacteria Bacteria 316 6.489999999999998e-82   NTclustered gi|2863125063|dbj|AP038805.1| 70125 g6229 i0 98.87 189.092511013216 177 2 78 0 11 187 2094297 2094121 MAG: Nitrospira sp. AFB01 DNA, complete genome blastn 42924 318 0.993710691823899 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
10223451 10223451 PRJEB12237_P_NODE_5069_length_272_cov_2.409283_g4873_i0 PRJEB12237 5069 272 2.409283 6.55324976 Nitrospira sp. 70125 Bacteria Bacteria 497 2.67e-136   NTclustered gi|2863125063|dbj|AP038805.1| 70125 g4873 i0 99.632 207.463235294118 272 1 100 0 1 272 2095351 2095080 MAG: Nitrospira sp. AFB01 DNA, complete genome blastn 56430 497 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
12464728 12464728 PRJEB12237_P_NODE_5170_length_268_cov_1.939914_g4974_i0 PRJEB12237 5170 268 1.939914 5.19896952 Nitrospira 1234 Bacteria Bacteria 457 4.45e-124   NTclustered gi|1808878785|dbj|AP022671.1| 1936990 g4974 i0 97.398 286.671641791045 269 6 100 1 1 268 4206609 4206341 Nitrospira sp. KM1 DNA, complete genome blastn 76828 457 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp. KM1
12774327 12774327 PRJEB12237_P_NODE_8951_length_181_cov_1.958904_g8755_i0 PRJEB12237 8951 181 1.958904 3.54561624 Nitrospira sp. 70125 Bacteria Bacteria 252 1.41e-62   NTclustered gi|2290907019|gb|CP060499.1| 70125 g8755 i0 91.758 140.303867403315 182 13 100 2 1 181 2684035 2683855 MAG: Nitrospira sp. isolate DH1 chromosome, complete genome blastn 25395 252 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
22972680 22972680 PRJEB12237_P_NODE_6679_length_221_cov_1.930108_g6483_i0 PRJEB12237 6679 221 1.930108 4.26553868 Nitrospira sp. 70125 Bacteria Bacteria 337 4.83e-88   NTclustered gi|2290907019|gb|CP060499.1| 70125 g6483 i0 94.118 31.972850678733 221 13 100 0 1 221 2684714 2684494 MAG: Nitrospira sp. isolate DH1 chromosome, complete genome blastn 7066 337 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);;