RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "diamond", bioproject = "PRJNA608660" and tax_phylum = "Nitrospirota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrospirota · 9 ✖

tax_kingdom 1

bioproject 1

  • PRJNA608660 · 9 ✖

analysis 1

  • diamond · 9 ✖

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
15887570 15887570 PRJNA608660_P_NODE_2693_length_822_cov_7.014230_g2467_i0 PRJNA608660 2693 822 7.01423 57.6569706 Nitrospira sp. 70125 Bacteria Bacteria 325 8.189999999999999e-109   NR MBH0187608.1 70125 g2467 i0 97 1.82846715328467 167 5 60.9 0 18 518 83 249 MBH0187608.1 aldehyde dehydrogenase family protein [Nitrospira sp.] diamond 1503 325 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
19711120 19711120 PRJNA608660_P_NODE_14656_length_383_cov_2.023952_g14303_i0 PRJNA608660 14656 383 2.023952 7.75173616 Nitrospira 1234 Bacteria Bacteria 123 9.11e-30   NR WP_087473321.1 96242 g14303 i0 96.9 1.01827676240209 65 2 50.9 0 272 78 1 65 WP_087473321.1 ATP-binding protein [Nitrospira cf. moscoviensis SBR1015] diamond 390 123 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira cf. moscoviensis SBR1015
21548884 21548884 PRJNA608660_P_NODE_46377_length_168_cov_0.873950_g46020_i0 PRJNA608660 46377 168 0.87395 1.468236 Nitrospira lenta 1436998 Bacteria Bacteria 90.9 1.51e-20   NR WP_121990699.1 1436998 g46020 i0 100 0.785714285714286 44 0 78.6 0 35 166 56 99 WP_121990699.1 30S ribosomal protein S2 [Nitrospira lenta] diamond 132 90.9 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira lenta
28027743 28027743 PRJNA608660_P_NODE_11425_length_440_cov_7.749361_g11078_i0 PRJNA608660 11425 440 7.749361 34.0971884 Nitrospira sp. ST-bin4 1978764 Bacteria Bacteria 75.1 2.97e-13   NR OQW59010.1 1978764 g11078 i0 100 0.225 33 0 22.5 0 302 400 1 33 OQW59010.1 MAG: hypothetical protein BVN28_10975 [Nitrospira sp. ST-bin4] diamond 99 75.1 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp. ST-bin4
29177637 29177637 PRJNA608660_P_NODE_48549_length_164_cov_0.904348_g48192_i0 PRJNA608660 48549 164 0.904348 1.48313072 Nitrospira 1234 Bacteria Bacteria 109 1.78e-27   NR MBH0184527.1 70125 g48192 i0 98.1 3.95121951219512 54 1 98.8 0 2 163 35 88 MBH0184527.1 alanine--glyoxylate aminotransferase family protein [Nitrospira sp.] diamond 648 109 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
29543110 29543110 PRJNA608660_P_NODE_46010_length_168_cov_1.697479_g45653_i0 PRJNA608660 46010 168 1.697479 2.85176472 Nitrospira cf. moscoviensis SBR1 96242 Bacteria Bacteria 92.4 4.36e-20   NR WP_087474318.1 96242 g45653 i0 100 0.75 42 0 75 0 168 43 28 69 WP_087474318.1 PEP/pyruvate-binding domain-containing protein [Nitrospira cf. moscoviensis SBR1015] diamond 126 92.4 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira cf. moscoviensis SBR1015
30238087 30238087 PRJNA608660_P_NODE_15252_length_374_cov_1.812308_g14899_i0 PRJNA608660 15252 374 1.812308 6.77803192 Nitrospira sp. 70125 Bacteria Bacteria 195 5.48e-58   NR HEY7130345.1 70125 g14899 i0 84.9 0.850267379679144 106 15 85 1 9 326 145 249 HEY7130345.1 DUF4038 domain-containing protein [Nitrospira sp.] diamond 318 195 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
31818437 31818437 PRJNA608660_P_NODE_39917_length_188_cov_3.546763_g39560_i0 PRJNA608660 39917 188 3.546763 6.66791444 Nitrospira sp. 70125 Bacteria Bacteria 92.4 8.910000000000001e-21   NR MEQ1627923.1 70125 g39560 i0 93.5 0.734042553191489 46 3 73.4 0 144 7 1 46 MEQ1627923.1 DUF6502 family protein [Nitrospira sp.] diamond 138 92.4 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
32243338 32243338 PRJNA608660_P_NODE_5938_length_602_cov_9.504521_g5627_i0 PRJNA608660 5938 602 9.504521 57.21721642 Nitrospira 1234 Bacteria Bacteria 216 8.169999999999999e-62   NR MBH0190253.1 70125 g5627 i0 99.1 1.08637873754153 109 1 54.3 0 265 591 567 675 MBH0190253.1 hypothetical protein [Nitrospira sp.] diamond 654 217 0.995391705069124 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);;