RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA474426" and tax_phylum = "Nitrospirota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrospirota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJNA474426 · 8 ✖

analysis 1

  • diamond · 8 ✖

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
29081958 29081958 PRJNA474426_P_NODE_32288_length_168_cov_0.873950_g32083_i0 PRJNA474426 32288 168 0.87395 1.468236 Pseudomonadati 3379134 Bacteria Bacteria 62.4 1.58e-9   NR UCH81010.1 2026770 g32083 i0 59.6 1.89285714285714 52 19 92.9 1 13 168 173 222 UCH81010.1 MAG: hypothetical protein JSW20_14945, partial [Nitrospiraceae bacterium] diamond 318 62.4 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium
29349994 29349994 PRJNA474426_P_NODE_16969_length_248_cov_0.994975_g16764_i0 PRJNA474426 16969 248 0.994975 2.467538 Nitrospira sp. 70125 Bacteria Bacteria 153 3.1799999999999992e-43   NR TKB53108.1 70125 g16764 i0 96.2 2.86693548387097 79 3 95.6 0 247 11 256 334 TKB53108.1 MAG: chemotaxis protein MotB [Nitrospira sp.] diamond 711 153 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
29602175 29602175 PRJNA474426_P_NODE_12410_length_299_cov_6.528000_g12205_i0 PRJNA474426 12410 299 6.528 19.51872 Nitrospiraceae bacterium 2026770 Bacteria Bacteria 84.7 1.29e-16   NR MBX9658599.1 2026770 g12205 i0 100 0.40133779264214 40 0 40.1 0 3 122 500 539 MBX9658599.1 aminotransferase class III-fold pyridoxal phosphate-dependent enzyme [Nitrospiraceae bacterium] diamond 120 84.7 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium
29633690 29633690 PRJNA474426_P_NODE_33490_length_166_cov_0.888889_g33285_i0 PRJNA474426 33490 166 0.888889 1.47555574 Nitrospira sp. 70125 Bacteria Bacteria 62.8 1.08e-9   NR MCE3224790.1 70125 g33285 i0 51.9 1.95180722891566 54 25 97.6 1 3 164 305 357 MCE3224790.1 cytidine monophosphate-N-acetylneuraminic acid hydroxylase isoform [Nitrospira sp.] diamond 324 62.8 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
29776383 29776383 PRJNA474426_P_NODE_24551_length_197_cov_1.979730_g24346_i0 PRJNA474426 24551 197 1.97973 3.9000681 Thermodesulfovibrionales 2811503 Bacteria Bacteria 63.2 2.54e-10   NR MBA4371790.1 2067987 g24346 i0 49.2 1.88832487309645 63 32 95.9 0 9 197 1 63 MBA4371790.1 hypothetical protein [Thermodesulfovibrio sp.] diamond 372 63.2 1 Bacteria   Pseudomonadati Nitrospirota Thermodesulfovibrionia Thermodesulfovibrionales Thermodesulfovibrionaceae Thermodesulfovibrio Thermodesulfovibrio sp.
30771531 30771531 PRJNA474426_P_NODE_11974_length_306_cov_2.587549_g11769_i0 PRJNA474426 11974 306 2.587549 7.91789994 Nitrospira sp. ST-bin5 1978765 Bacteria Bacteria 111 2.7300000000000003e-26   NR OQW67694.1 1978765 g11769 i0 98.1 0.529411764705882 54 1 52.9 0 163 2 208 261 OQW67694.1 MAG: hypothetical protein BVN29_02195 [Nitrospira sp. ST-bin5] diamond 162 111 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp. ST-bin5
31372040 31372040 PRJNA474426_P_NODE_35416_length_163_cov_1.798246_g35211_i0 PRJNA474426 35416 163 1.798246 2.93114098 Nitrospira defluvii 330214 Bacteria Bacteria 57.4 3.24e-8   NR CBK43883.1 330214 g35211 i0 58 1.82208588957055 50 21 92 0 6 155 20 69 CBK43883.1 conserved protein of unknown function [Nitrospira defluvii] diamond 297 57.4 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira defluvii
32747465 32747465 PRJNA474426_P_NODE_3080_length_587_cov_5.464684_g2908_i0 PRJNA474426 3080 587 5.464684 32.07769508 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 100 6.3e-23   NR HNK51866.1 70125 g2908 i0 78.6 0.572402044293015 56 12 28.6 0 400 567 1 56 HNK51866.1 hypothetical protein [Nitrospira sp.] diamond 336 100 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);;