RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA558770" and tax_phylum = "Nitrospirota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrospirota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA558770 · 7 ✖

analysis 1

  • blastn · 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
1815184 1815184 PRJNA558770_P_NODE_219402_length_234_cov_3.110553_g217397_i0 PRJNA558770 219402 234 3.110553 7.27869402 Nitrospira sp. 70125 Bacteria Bacteria 84.2 7.43e-12   NTclustered gi|2194432121|gb|CP092081.1| 70125 g217397 i0 92.982 19.1538461538462 57 4 24 0 160 216 3728487 3728543 MAG: Nitrospira sp. isolate UBC2 chromosome blastn 4482 84.2 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
3089696 3089696 PRJNA558770_P_NODE_180503_length_234_cov_4.623116_g178498_i0 PRJNA558770 180503 234 4.623116 10.81809144 Nitrospira sp. KM1 1936990 Bacteria Bacteria 69.4 2.08e-7   NTclustered gi|1808878785|dbj|AP022671.1| 1936990 g178498 i0 89.286 0.239316239316239 56 5 24 1 166 220 1603609 1603664 Nitrospira sp. KM1 DNA, complete genome blastn 56 69.4 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp. KM1
10743526 10743526 PRJNA558770_P_NODE_209389_length_234_cov_3.437186_g207384_i0 PRJNA558770 209389 234 3.437186 8.04301524 Candidatus Nitrospira neomarina 3020899 Bacteria Bacteria 63.9 9.68e-6   NTclustered gi|2582130041|gb|CP116968.1| 3020899 g207384 i0 90.196 0.405982905982906 51 2 21 3 164 213 4222962 4223010 Candidatus Nitrospira neomarina strain DK chromosome, complete genome blastn 95 63.9 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Candidatus Nitrospira neomarina
10743676 10743676 PRJNA558770_P_NODE_216929_length_234_cov_3.185930_g214924_i0 PRJNA558770 216929 234 3.18593 7.4550762 Dissulfurispira thermophila 2715679 Bacteria Bacteria 67.6 7.48e-7   NTclustered gi|1901208073|dbj|AP022873.1| 2715679 g214924 i0 87.719 0.683760683760684 57 7 24 0 4 60 732197 732141 Dissulfurispira thermophila T55J DNA, complete genome blastn 160 67.6 1 Bacteria   Pseudomonadati Nitrospirota Thermodesulfovibrionia Thermodesulfovibrionales Dissulfurispiraceae Dissulfurispira Dissulfurispira thermophila
12019534 12019534 PRJNA558770_P_NODE_280730_length_234_cov_1.723618_g278725_i0 PRJNA558770 280730 234 1.723618 4.03326612 Nitrospira sp. 70125 Bacteria Bacteria 128 3.38e-25   NTclustered gi|2290915413|gb|CP060502.1| 70125 g278725 i0 97.333 1.28205128205128 75 2 64 0 1 75 201046 201120 MAG: Nitrospira sp. isolate NSFW plasmid pNSFW1, complete sequence blastn 300 128 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
13293934 13293934 PRJNA558770_P_NODE_243791_length_234_cov_2.447236_g241786_i0 PRJNA558770 243791 234 2.447236 5.72653224 Candidatus Nitrospira inopinata 1715989 Bacteria Bacteria 54.7 0.006   NTclustered gi|952974062|emb|LN885086.1| 1715989 g241786 i0 96.875 0.136752136752137 32 1 14 0 187 218 1439484 1439453 Nitrospira sp. ENR4 genome assembly NiCh1, chromosome : 1 blastn 32 54.7 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Candidatus Nitrospira inopinata
19666875 19666875 PRJNA558770_P_NODE_275656_length_234_cov_1.804020_g273651_i0 PRJNA558770 275656 234 1.80402 4.2214068 Candidatus Nitrospira kreftii 2652173 Bacteria Bacteria 73.1 1.61e-8   NTclustered gi|1884724763|gb|CP047423.1| 2652173 g273651 i0 93.75 0.205128205128205 48 3 21 0 160 207 3845399 3845446 Candidatus Nitrospira kreftii isolate comreactor17 chromosome, complete genome blastn 48 73.1 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Candidatus Nitrospira kreftii

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);;