RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "diamond", bioproject = "PRJNA382558" and tax_phylum = "Nitrospirota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrospirota · 10 ✖

tax_kingdom 1

bioproject 1

  • PRJNA382558 · 10 ✖

analysis 1

  • diamond · 10 ✖

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
27629328 27629328 PRJNA382558_S_NODE_1724_length_280_cov_7.485597_g1720_i0 PRJNA382558 1724 280 7.485597 20.9596716 Nitrospira 1234 Bacteria Bacteria 84 1.92e-16   NR TKB77544.1 70125 g1720 i0 86 0.921428571428571 43 6 46.1 0 130 2 1 43 TKB77544.1 MAG: hypothetical protein E8D42_15705 [Nitrospira sp.] diamond 258 84 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
28780334 28780334 PRJNA382558_S_NODE_4627_length_216_cov_6.435754_g4623_i0 PRJNA382558 4627 216 6.435754 13.90122864 Nitrospira sp. 70125 Bacteria Bacteria 134 1.87e-34   NR BFU93129.1 70125 g4623 i0 90.1 4.93055555555556 71 7 98.6 0 216 4 489 559 BFU93129.1 MAG: site-specific DNA-methyltransferase [Nitrospira sp.] diamond 1065 134 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
28828817 28828817 PRJNA382558_S_NODE_128_length_513_cov_7.216387_g125_i0 PRJNA382558 128 513 7.216387 37.02006531 Pseudomonadati 3379134 Bacteria Bacteria 97.4 5.52e-20   NR MBF0565824.1 2026887 g125 i0 40.4 2.0233918128655 171 98 99.4 2 512 3 413 580 MBF0565824.1 hypothetical protein [Nitrospirota bacterium] diamond 1038 97.4 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
29096331 29096331 PRJNA382558_S_NODE_10848_length_168_cov_10.847328_g10844_i0 PRJNA382558 10848 168 10.847328 18.223511040000002 Nitrospira sp. SG-bin1 1827376 Bacteria Bacteria 61.6 2.89e-9   NR OQW36993.1 1827376 g10844 i0 63.6 0.982142857142857 55 19 96.4 1 2 163 756 810 OQW36993.1 MAG: hypothetical protein A4E19_14765 [Nitrospira sp. SG-bin1] diamond 165 61.6 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp. SG-bin1
29285518 29285518 PRJNA382558_S_NODE_12409_length_162_cov_5.064000_g12405_i0 PRJNA382558 12409 162 5.064 8.20368 Nitrospiraceae bacterium 2026770 Bacteria Bacteria 105 1.31e-24   NR MBX9660022.1 2026770 g12405 i0 86.8 3.92592592592593 53 7 98.1 0 160 2 601 653 MBX9660022.1 2Fe-2S iron-sulfur cluster binding domain-containing protein [Nitrospiraceae bacterium] diamond 636 105 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium
29411871 29411871 PRJNA382558_S_NODE_2309_length_259_cov_8.301802_g2305_i0 PRJNA382558 2309 259 8.301802 21.50166718 Nitrospirota bacterium 2026887 Bacteria Bacteria 85.9 1.04e-17   NR MBI5641173.1 2026887 g2305 i0 52.7 0.857142857142857 74 35 85.7 0 34 255 111 184 MBI5641173.1 hypothetical protein [Nitrospirota bacterium] diamond 222 85.9 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
30106639 30106639 PRJNA382558_S_NODE_632_length_353_cov_8.439873_g628_i0 PRJNA382558 632 353 8.439873 29.79275169 Nitrospira sp. 70125 Bacteria Bacteria 98.6 3.35e-23   NR MDD5435877.1 70125 g628 i0 51 2.54107648725212 100 46 82.4 1 351 61 74 173 MDD5435877.1 glycosyltransferase [Nitrospira sp.] diamond 897 98.6 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
31482809 31482809 PRJNA382558_S_NODE_4316_length_220_cov_7.775956_g4312_i0 PRJNA382558 4316 220 7.775956 17.1071032 Pseudomonadati 3379134 Bacteria Bacteria 68.2 1.78e-11   NR HET8760248.1 2306052 g4312 i0 49.2 4.05 63 30 85.9 1 200 12 1 61 HET8760248.1 HNH endonuclease [Nitrospiria bacterium] diamond 891 68.2 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria       Nitrospiria bacterium
32193308 32193308 PRJNA382558_S_NODE_3198_length_239_cov_5.613861_g3194_i0 PRJNA382558 3198 239 5.613861 13.41712779 Nitrospirae bacterium CG2_3 2026887 Bacteria Bacteria 89.4 5.88e-20   NR OIP63251.1 1805278 g3194 i0 57.1 0.96652719665272 77 33 96.7 0 233 3 65 141 OIP63251.1 MAG: hypothetical protein AUK29_06885 [Nitrospirae bacterium CG2_30_53_67] diamond 231 89.4 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirae bacterium CG2_30_53_67
32478191 32478191 PRJNA382558_S_NODE_1899_length_273_cov_7.385593_g1895_i0 PRJNA382558 1899 273 7.385593 20.16266889 Nitrospirota bacterium 2026887 Bacteria Bacteria 52 2.66e-5   NR MBI5641173.1 2026887 g1895 i0 66.7 0.395604395604396 36 12 39.6 0 131 24 10 45 MBI5641173.1 hypothetical protein [Nitrospirota bacterium] diamond 108 52 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium

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