RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where bioproject = "PRJNA407368", tax_kingdom = "Pseudomonadati" and tax_phylum = "Nitrospirota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Nitrospirota · 9 ✖

tax_kingdom 1

  • Pseudomonadati · 9 ✖

bioproject 1

  • PRJNA407368 · 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
15109464 15109464 PRJNA407368_S_NODE_7272_length_193_cov_88.292683_g7170_i0 PRJNA407368 7272 193 88.292683 170.40487819 Leptospirillum 179 Bacteria Bacteria 148 2.0599999999999997e-31   NTclustered gi|470476041|ref|NR_076316.1| 180 g7170 i0 81.347 109 193 27 97 6 6 193 375 563 Leptospirillum ferrooxidans strain C2-3 23S ribosomal RNA gene, complete sequence blastn 21037 148 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Leptospirillum Leptospirillum ferrooxidans
28450337 28450337 PRJNA407368_S_NODE_7926_length_182_cov_4.424837_g7824_i0 PRJNA407368 7926 182 4.424837 8.05320334 Candidatus Manganitrophus 2758103 Bacteria Bacteria 39.7 0.035   NR MFQ5779148.1 2306052 g7824 i0 47.5 1.33516483516484 40 21 65.9 0 12 131 10 49 MFQ5779148.1 transcriptional regulator [Nitrospiria bacterium] diamond 243 39.7 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria       Nitrospiria bacterium
29317496 29317496 PRJNA407368_S_NODE_9849_length_158_cov_1.705426_g9747_i0 PRJNA407368 9849 158 1.705426 2.69457308 Nitrospirota bacterium 2026887 Bacteria Bacteria 68.2 3.45e-12   NR MCZ6800013.1 2026887 g9747 i0 61.9 0.79746835443038 42 16 79.7 0 135 10 37 78 MCZ6800013.1 hypothetical protein [Nitrospirota bacterium] diamond 126 68.2 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
30297108 30297108 PRJNA407368_S_NODE_3192_length_330_cov_10.368771_g3090_i0 PRJNA407368 3192 330 10.368771 34.2169443 Nitrospiraceae bacterium 2026770 Bacteria Bacteria 83.6 3.29e-17   NR HSL03525.1 2026770 g3090 i0 82.8 0.527272727272727 58 9 52.7 1 156 329 1 57 HSL03525.1 CBS domain-containing protein [Nitrospiraceae bacterium] diamond 174 83.6 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium
30423353 30423353 PRJNA407368_S_NODE_2453_length_389_cov_7.027778_g2351_i0 PRJNA407368 2453 389 7.027778 27.33805642 Nitrospirota bacterium 2026887 Bacteria Bacteria 65.5 2.06e-9   NR TAL08174.1 2026887 g2351 i0 43.3 0.462724935732648 60 34 46.3 0 152 331 104 163 TAL08174.1 MAG: collagen-like protein, partial [Nitrospirota bacterium] diamond 180 65.5 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
30549337 30549337 PRJNA407368_S_NODE_453_length_938_cov_8.715072_g414_i0 PRJNA407368 453 938 8.715072 81.74737536 Nitrospira sp. 70125 Bacteria Bacteria 108 3.89e-24   NR TKB79292.1 70125 g414 i0 50 0.729211087420043 116 57 36.8 1 345 1 1 116 TKB79292.1 MAG: hypothetical protein E8D42_07795 [Nitrospira sp.] diamond 684 108 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
30787271 30787271 PRJNA407368_S_NODE_9654_length_160_cov_2.603053_g9552_i0 PRJNA407368 9654 160 2.603053 4.1648848 root 1 Root_unresolved Root_unresolved 52.8 2.86e-6   NR MCW5796789.1 70125 g9552 i0 48 1.8 50 19 90 2 156 13 198 242 MCW5796789.1 hypothetical protein [Nitrospira sp.] diamond 288 52.8 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
30865262 30865262 PRJNA407368_S_NODE_7014_length_198_cov_2.307692_g6912_i0 PRJNA407368 7014 198 2.307692 4.56923016 Nitrospira sp. 70125 Bacteria Bacteria 58.5 4.97e-8   NR HNP40728.1 70125 g6912 i0 42.9 0.954545454545455 63 36 95.5 0 9 197 44 106 HNP40728.1 hypothetical protein [Nitrospira sp.] diamond 189 58.5 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
31687266 31687266 PRJNA407368_S_NODE_8097_length_180_cov_1.847682_g7995_i0 PRJNA407368 8097 180 1.847682 3.3258276 Nitrospiraceae bacterium 2026770 Bacteria Bacteria 63.5 4.69e-10   NR HEU0069504.1 2026770 g7995 i0 50.9 0.95 57 28 95 0 173 3 203 259 HEU0069504.1 hypothetical protein [Nitrospiraceae bacterium] diamond 171 63.5 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae 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);;