RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJNA1159911", 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 · 7 ✖

tax_kingdom 1

  • Pseudomonadati · 7 ✖

bioproject 1

  • PRJNA1159911 · 7 ✖

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
6140786 6140786 PRJNA1159911_P_NODE_385_length_8028_cov_5.116908_g378_i0 PRJNA1159911 385 8028 5.116908 410.78537424 Pseudomonadati 3379134 Bacteria Bacteria 915 1.58e-305   NR WP_121990529.1 1436998 g378 i0 87 1.56203288490284 523 68 19.5 0 3224 4792 1 523 WP_121990529.1 oleate hydratase [Nitrospira lenta] diamond 12540 915 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira lenta
14336897 14336897 PRJNA1159911_P_NODE_5292_length_1526_cov_5.432897_g5028_i0 PRJNA1159911 5292 1526 5.432897 82.90600822 Nitrospirales bacterium 2358460 Bacteria Bacteria 739 6.47e-264   NR MEE8241163.1 2358460 g5028 i0 75.7 0.914154652686763 465 113 91.4 0 2 1396 80 544 MEE8241163.1 group II intron reverse transcriptase/maturase [Nitrospirales bacterium] diamond 1395 739 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales     Nitrospirales bacterium
21985300 21985300 PRJNA1159911_P_NODE_80298_length_262_cov_1.629630_g79756_i0 PRJNA1159911 80298 262 1.62963 4.2696306 Nitrospira sp. 70125 Bacteria Bacteria 58.4 5.14e-4   NTclustered gi|2863129529|dbj|AP038806.1| 70125 g79756 i0 97.059 0.129770992366412 34 1 13 0 229 262 3852676 3852709 MAG: Nitrospira sp. NFB02 DNA, complete genome blastn 34 58.4 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
24533189 24533189 PRJNA1159911_P_NODE_11340_length_957_cov_4.557692_g10909_i0 PRJNA1159911 11340 957 4.557692 43.61711244 Pseudomonadati 3379134 Bacteria Bacteria 226 4.58e-65   NR HMS83766.1 70125 g10909 i0 76.6 7.5141065830721 141 33 44.2 0 424 2 1 141 HMS83766.1 hypothetical protein [Nitrospira sp.] diamond 7191 228 0.991228070175439 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
28322918 28322918 PRJNA1159911_P_NODE_100086_length_242_cov_0.911243_g99544_i0 PRJNA1159911 100086 242 0.911243 2.20520806 Nitrospira 1234 Bacteria Bacteria 47 5.13e-4   NR MBH0184546.1 70125 g99544 i0 100 1.09090909090909 22 0 27.3 0 240 175 136 157 MBH0184546.1 hypothetical protein [Nitrospira sp.] diamond 264 47 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
28670452 28670452 PRJNA1159911_P_NODE_92847_length_247_cov_0.885057_g92305_i0 PRJNA1159911 92847 247 0.885057 2.18609079 Bacteria 2 Bacteria Bacteria 125 2.88e-31   NR TMQ29352.1 2026887 g92305 i0 68.8 5.84210526315789 80 25 97.2 0 6 245 40 119 TMQ29352.1 MAG: hypothetical protein E6K65_09535 [Nitrospirota bacterium] diamond 1443 125 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
31747042 31747042 PRJNA1159911_P_NODE_72997_length_277_cov_1.166667_g72455_i0 PRJNA1159911 72997 277 1.166667 3.23166759 Nitrospira sp. 70125 Bacteria Bacteria 48.5 4.64e-4   NR BFU93025.1 70125 g72455 i0 79.3 0.314079422382672 29 6 31.4 0 3 89 278 306 BFU93025.1 MAG: hypothetical protein NTAFB01_42120 [Nitrospira sp.] diamond 87 48.5 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);;