RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "diamond", bioproject = "PRJNA846486" 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

  • PRJNA846486 · 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
26643087 26643087 PRJNA846486_P_NODE_79381_length_168_cov_0.873950_g79285_i0 PRJNA846486 79381 168 0.87395 1.468236 Nitrospira sp. 70125 Bacteria Bacteria 52.8 2.2e-7   NR HAN92590.1 70125 g79285 i0 100 0.482142857142857 27 0 48.2 0 2 82 45 71 HAN92590.1 hypothetical protein [Nitrospira sp.] diamond 81 52.8 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
27339384 27339384 PRJNA846486_P_NODE_86583_length_165_cov_0.896552_g86487_i0 PRJNA846486 86583 165 0.896552 1.4793108 Nitrospirota bacterium 2026887 Bacteria Bacteria 42.7 0.0129   NR MDH4230290.1 2026887 g86487 i0 63.6 3.65454545454545 33 12 60 0 157 59 489 521 MDH4230290.1 hypothetical protein [Nitrospirota bacterium] diamond 603 42.7 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
27528693 27528693 PRJNA846486_P_NODE_81883_length_167_cov_0.881356_g81787_i0 PRJNA846486 81883 167 0.881356 1.47186452 Nitrospira sp. 70125 Bacteria Bacteria 89.4 9.97e-20   NR MCG3776926.1 70125 g81787 i0 76.4 0.988023952095808 55 13 98.8 0 2 166 160 214 MCG3776926.1 Exodeoxyribonuclease 8 [Nitrospira sp.] diamond 165 89.4 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
28958178 28958178 PRJNA846486_P_NODE_84088_length_166_cov_0.888889_g83992_i0 PRJNA846486 84088 166 0.888889 1.47555574 Nitrospira 1234 Bacteria Bacteria 122 3.53e-33   NR MEQ1847315.1 70125 g83992 i0 100 1.95180722891566 54 0 97.6 0 3 164 159 212 MEQ1847315.1 hypothetical protein [Nitrospira sp.] diamond 324 122 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
30371178 30371178 PRJNA846486_P_NODE_79232_length_168_cov_0.873950_g79136_i0 PRJNA846486 79232 168 0.87395 1.468236 Nitrospirota bacterium 2026887 Bacteria Bacteria 61.2 1.16e-9   NR MEW6115633.1 2026887 g79136 i0 66.7 0.642857142857143 36 12 64.3 0 113 6 21 56 MEW6115633.1 hypothetical protein [Nitrospirota bacterium] diamond 108 61.2 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
30442434 30442434 PRJNA846486_P_NODE_86473_length_165_cov_0.896552_g86377_i0 PRJNA846486 86473 165 0.896552 1.4793108 Pseudomonadati 3379134 Bacteria Bacteria 56.2 1.39e-8   NR HNG04172.1 70125 g86377 i0 52.8 2.56363636363636 53 25 96.4 0 160 2 10 62 HNG04172.1 hypothetical protein [Nitrospira sp.] diamond 423 56.6 0.992932862190813 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
31887956 31887956 PRJNA846486_P_NODE_79297_length_168_cov_0.873950_g79201_i0 PRJNA846486 79297 168 0.87395 1.468236 Nitrospiraceae bacterium 2026770 Bacteria Bacteria 44.7 0.00281   NR HWI68417.1 2026770 g79201 i0 43.4 0.946428571428571 53 25 85.7 1 155 12 86 138 HWI68417.1 hypothetical protein [Nitrospiraceae bacterium] diamond 159 44.7 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium
32046322 32046322 PRJNA846486_P_NODE_81778_length_167_cov_0.881356_g81682_i0 PRJNA846486 81778 167 0.881356 1.47186452 Candidatus Nitronereus thalassa 3020898 Bacteria Bacteria 60.8 4.33e-9   NR WP_313833120.1 3020898 g81682 i0 52.7 0.988023952095808 55 26 98.8 0 3 167 54 108 WP_313833120.1 hypothetical protein [Candidatus Nitronereus thalassa] diamond 165 60.8 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Candidatus Nitronereus Candidatus Nitronereus thalassa
32434650 32434650 PRJNA846486_P_NODE_35499_length_226_cov_1.175141_g35403_i0 PRJNA846486 35499 226 1.175141 2.65581866 Pseudomonadati 3379134 Bacteria Bacteria 157 8.029999999999999e-43   NR MEI8014087.1 70125 g35403 i0 94.7 8.96017699115044 75 4 99.6 0 1 225 105 179 MEI8014087.1 arylsulfatase [Nitrospira sp.] diamond 2025 157 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);;