RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "blastn", bioproject = "PRJNA382357" and tax_phylum = "Nitrospirota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrospirota · 12 ✖

tax_kingdom 1

bioproject 1

  • PRJNA382357 · 12 ✖

analysis 1

  • blastn · 12 ✖

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
5506646 5506646 PRJNA382357_P_NODE_142905_length_207_cov_2.150685_g142166_i0 PRJNA382357 142905 207 2.150685 4.45191795 Nitrospira sp. 70125 Bacteria Bacteria 147 8.08e-31   NTclustered gi|2194428397|gb|CP092079.1| 70125 g142166 i0 92.233 0.971014492753623 103 8 50 0 105 207 100612 100510 MAG: Nitrospira sp. isolate UBC3 chromosome blastn 201 147 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
8056537 8056537 PRJNA382357_P_NODE_169487_length_173_cov_4.732143_g168748_i0 PRJNA382357 169487 173 4.732143 8.18660739 Nitrospira sp. 70125 Bacteria Bacteria 104 3.96e-18   NTclustered gi|2511631678|gb|CP126123.1| 70125 g168748 i0 85.714 0.566473988439306 98 14 57 0 38 135 1562914 1563011 MAG: Nitrospira sp. isolate bin_003 chromosome, complete genome blastn 98 104 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
8056939 8056939 PRJNA382357_P_NODE_36807_length_376_cov_1.533333_g36068_i0 PRJNA382357 36807 376 1.533333 5.76533208 Nitrospira sp. 70125 Bacteria Bacteria 429 1.42e-115   NTclustered gi|2194428397|gb|CP092079.1| 70125 g36068 i0 87.234 4.80053191489362 376 48 100 0 1 376 2810822 2810447 MAG: Nitrospira sp. isolate UBC3 chromosome blastn 1805 429 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
9332618 9332618 PRJNA382357_P_NODE_86348_length_258_cov_1.649746_g85609_i0 PRJNA382357 86348 258 1.649746 4.25634468 Nitrospira sp. 70125 Bacteria Bacteria 296 9.83e-76   NTclustered gi|2194428397|gb|CP092079.1| 70125 g85609 i0 88 0.968992248062015 250 30 97 0 1 250 2429524 2429773 MAG: Nitrospira sp. isolate UBC3 chromosome blastn 250 296 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
11882196 11882196 PRJNA382357_P_NODE_25090_length_446_cov_3.176623_g24352_i0 PRJNA382357 25090 446 3.176623 14.16773858 Nitrospira sp. 70125 Bacteria Bacteria 265 5.089999999999999e-66   NTclustered gi|2194436381|gb|CP092080.1| 70125 g24352 i0 90.547 3.9372197309417 201 17 45 1 53 251 3590126 3590326 MAG: Nitrospira sp. isolate UBC1 chromosome blastn 1756 265 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
11883308 11883308 PRJNA382357_P_NODE_9250_length_680_cov_1.759289_g8557_i0 PRJNA382357 9250 680 1.759289 11.9631652 Nitrospira tepida 2973512 Bacteria Bacteria 920 0   NTclustered gi|2526808154|emb|OX365700.1| 2973512 g8557 i0 92.073 102.436764705882 656 49 96 3 26 680 1827287 1826634 Nitrospira sp. DNF genome assembly, chromosome: NsDNF blastn 69657 920 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira tepida
13157509 13157509 PRJNA382357_P_NODE_38891_length_367_cov_1.549020_g38152_i0 PRJNA382357 38891 367 1.54902 5.6849034 Nitrospira japonica 1325564 Bacteria Bacteria 226 1.9399999999999995e-54   NTclustered gi|1167499077|emb|LT828648.1| 1325564 g38152 i0 82.558 0.70299727520436 258 43 70 2 3 259 273641 273897 Nitrospira japonica isolate Genome sequencing of Nitrospira japonica strain NJ11 genome assembly, chromosome: I blastn 258 226 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira japonica
13158433 13158433 PRJNA382357_P_NODE_96291_length_246_cov_1.859459_g95552_i0 PRJNA382357 96291 246 1.859459 4.57426914 Nitrospira sp. 70125 Bacteria Bacteria 169 2.11e-37   NTclustered gi|2511631678|gb|CP126123.1| 70125 g95552 i0 81.221 0.865853658536585 213 37 86 3 29 240 2755922 2756132 MAG: Nitrospira sp. isolate bin_003 chromosome, complete genome blastn 213 169 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
15705057 15705057 PRJNA382357_P_NODE_104373_length_237_cov_6.704545_g103634_i0 PRJNA382357 104373 237 6.704545 15.88977165 Nitrospira moscoviensis 42253 Bacteria Bacteria 193 1.1999999999999998e-44   NTclustered gi|922305621|gb|CP011801.1| 42253 g103634 i0 92.029 21.1181434599156 138 10 96 1 7 143 36542 36405 Nitrospira moscoviensis strain NSP M-1, complete genome blastn 5005 193 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira moscoviensis
20804916 20804916 PRJNA382357_P_NODE_171997_length_166_cov_5.828571_g171258_i0 PRJNA382357 171997 166 5.828571 9.67542786 Nitrospira sp. 70125 Bacteria Bacteria 126 8.08e-25   NTclustered gi|2511640680|gb|CP126121.1| 70125 g171258 i0 95 0.734939759036145 80 4 71 0 85 164 727051 727130 MAG: Nitrospira sp. isolate bin_001 chromosome, complete genome blastn 122 126 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
22080903 22080903 PRJNA382357_P_NODE_78458_length_269_cov_1.793269_g77719_i0 PRJNA382357 78458 269 1.793269 4.82389361 Nitrospira sp. 70125 Bacteria Bacteria 110 1.44e-19   NTclustered gi|2194428397|gb|CP092079.1| 70125 g77719 i0 85.455 0.408921933085502 110 11 39 4 140 245 2800223 2800331 MAG: Nitrospira sp. isolate UBC3 chromosome blastn 110 110 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
24629324 24629324 PRJNA382357_P_NODE_147220_length_205_cov_6.333333_g146481_i0 PRJNA382357 147220 205 6.333333 12.98333265 Nitrospira sp. 70125 Bacteria Bacteria 128 2.89e-25   NTclustered gi|2863129529|dbj|AP038806.1| 70125 g146481 i0 83.099 0.692682926829268 142 23 69 1 54 194 4001111 4000970 MAG: Nitrospira sp. NFB02 DNA, complete genome blastn 142 128 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);;