RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJNA772154", 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

  • PRJNA772154 · 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
3298618 3298618 PRJNA772154_P_NODE_21463_length_245_cov_0.906977_g21278_i0 PRJNA772154 21463 245 0.906977 2.22209365 Candidatus Nitrospira neomarina 3020899 Bacteria Bacteria 420 5.26e-113   NTclustered gi|2582130041|gb|CP116968.1| 3020899 g21278 i0 97.551 3.60816326530612 245 6 100 0 1 245 4112756 4112512 Candidatus Nitrospira neomarina strain DK chromosome, complete genome blastn 884 420 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Candidatus Nitrospira neomarina
4575671 4575671 PRJNA772154_P_NODE_20564_length_247_cov_0.896552_g20379_i0 PRJNA772154 20564 247 0.896552 2.21448344 Candidatus Nitrospira allomarina 3020900 Bacteria Bacteria 350 7.07e-92   NTclustered gi|2582126190|gb|CP116967.1| 3020900 g20379 i0 92.593 1.95546558704453 243 18 98 0 3 245 1729143 1728901 Candidatus Nitrospira allomarina strain VA chromosome, complete genome blastn 483 350 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Candidatus Nitrospira allomarina
13501171 13501171 PRJNA772154_P_NODE_20711_length_246_cov_0.901734_g20526_i0 PRJNA772154 20711 246 0.901734 2.21826564 Nitrospira sp. 70125 Bacteria Bacteria 228 3.4399999999999986e-55   NTclustered gi|2290911150|gb|CP060501.1| 70125 g20526 i0 83.333 1 246 41 100 0 1 246 2271152 2271397 MAG: Nitrospira sp. isolate NSFW chromosome, complete genome blastn 246 228 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
16049946 16049946 PRJNA772154_P_NODE_18233_length_252_cov_0.871508_g18048_i0 PRJNA772154 18233 252 0.871508 2.19620016 Candidatus Nitrospira neomarina 3020899 Bacteria Bacteria 392 1.1899999999999997e-104   NTclustered gi|2582130041|gb|CP116968.1| 3020899 g18048 i0 94.841 25.7103174603175 252 12 100 1 1 252 4181907 4181657 Candidatus Nitrospira neomarina strain DK chromosome, complete genome blastn 6479 392 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Candidatus Nitrospira neomarina
18599161 18599161 PRJNA772154_P_NODE_19675_length_249_cov_0.886364_g19490_i0 PRJNA772154 19675 249 0.886364 2.20704636 Candidatus Nitrospira neomarina 3020899 Bacteria Bacteria 455 1.47e-123   NTclustered gi|2582130041|gb|CP116968.1| 3020899 g19490 i0 99.598 3 249 1 100 0 1 249 3196639 3196887 Candidatus Nitrospira neomarina strain DK chromosome, complete genome blastn 747 455 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Candidatus Nitrospira neomarina
18599214 18599214 PRJNA772154_P_NODE_21415_length_245_cov_0.906977_g21230_i0 PRJNA772154 21415 245 0.906977 2.22209365 Candidatus Nitrospira kreftii 2652173 Bacteria Bacteria 169 2.1e-37   NTclustered gi|1884724763|gb|CP047423.1| 2652173 g21230 i0 81.863 0.83265306122449 204 33 82 3 13 214 3472918 3472717 Candidatus Nitrospira kreftii isolate comreactor17 chromosome, complete genome blastn 204 169 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Candidatus Nitrospira kreftii
31253923 31253923 PRJNA772154_P_NODE_18555_length_251_cov_0.876404_g18370_i0 PRJNA772154 18555 251 0.876404 2.19977404 Nitrospira sp. 70125 Bacteria Bacteria 151 5.699999999999998e-43   NR MCA9452610.1 70125 g18370 i0 91.6 0.99203187250996006 83 7 99.2 0 251 3 175 257 MCA9452610.1 hypothetical protein [Nitrospira sp.] diamond 249 151 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);;