RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where bioproject = "PRJNA1068513", tax_phylum = "Nitrospirota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 12 ✖

tax_phylum 1

  • Nitrospirota · 12 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1068513 · 12 ✖

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
2732410 2732410 PRJNA1068513_S_NODE_3663_length_463_cov_33.312821_g3618_i0 PRJNA1068513 3663 463 33.312821 154.23836123 Nitrospira sp. 70125 Bacteria Bacteria 89.8 3.43e-13   NTclustered gi|2863125063|dbj|AP038805.1| 70125 g3618 i0 93.443 15.1511879049676 61 2 13 2 404 463 406641 406582 MAG: Nitrospira sp. AFB01 DNA, complete genome blastn 7015 89.8 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
2732448 2732448 PRJNA1068513_S_NODE_6423_length_360_cov_4.585366_g6377_i0 PRJNA1068513 6423 360 4.585366 16.5073176 Nitrospira sp. 70125 Bacteria Bacteria 78.7 5.63e-10   NTclustered gi|2863125063|dbj|AP038805.1| 70125 g6377 i0 95.918 11.0888888888889 49 0 13 2 313 359 406653 406605 MAG: Nitrospira sp. AFB01 DNA, complete genome blastn 3992 78.7 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
3564164 3564164 PRJNA1068513_S_NODE_7743_length_327_cov_0.858268_g7697_i0 PRJNA1068513 7743 327 0.858268 2.80653636 root 1 Root_unresolved Root_unresolved 86.1 3.03e-12   NTclustered gi|2863125063|dbj|AP038805.1| 70125 g7697 i0 93.22 21.2201834862385 59 2 18 2 1 58 406582 406639 MAG: Nitrospira sp. AFB01 DNA, complete genome blastn 6939 86.1 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
7391307 7391307 PRJNA1068513_S_NODE_10746_length_272_cov_1.175879_g10700_i0 PRJNA1068513 10746 272 1.175879 3.19839088 root 1 Root_unresolved Root_unresolved 76.8 1.48e-9   NTclustered gi|2863125063|dbj|AP038805.1| 70125 g10700 i0 90 16.7904411764706 60 4 21 2 1 58 406594 406653 MAG: Nitrospira sp. AFB01 DNA, complete genome blastn 4567 76.8 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
7834332 7834332 PRJNA1068513_S_NODE_10447_length_276_cov_1.807882_g10401_i0 PRJNA1068513 10447 276 1.807882 4.98975432 Nitrospira sp. 70125 Bacteria Bacteria 63.9 1.17e-5   NTclustered gi|2863125063|dbj|AP038805.1| 70125 g10401 i0 95 13.3695652173913 40 2 14 0 1 40 406608 406647 MAG: Nitrospira sp. AFB01 DNA, complete genome blastn 3690 63.9 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
9109403 9109403 PRJNA1068513_S_NODE_3088_length_493_cov_4.509524_g3043_i0 PRJNA1068513 3088 493 4.509524 22.23195332 Nitrospira sp. 70125 Bacteria Bacteria 65.8 6.18e-6   NTclustered gi|2863125063|dbj|AP038805.1| 70125 g3043 i0 91.667 7.38539553752535 48 2 9 2 435 480 406653 406606 MAG: Nitrospira sp. AFB01 DNA, complete genome blastn 3641 65.8 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
10385152 10385152 PRJNA1068513_S_NODE_3689_length_462_cov_3.408740_g3644_i0 PRJNA1068513 3689 462 3.40874 15.7483788 Nitrospira sp. 70125 Bacteria Bacteria 91.6 9.51e-14   NTclustered gi|2863125063|dbj|AP038805.1| 70125 g3644 i0 92.308 15.1580086580087 65 3 14 2 399 462 406641 406578 MAG: Nitrospira sp. AFB01 DNA, complete genome blastn 7003 91.6 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
11217022 11217022 PRJNA1068513_S_NODE_329_length_925_cov_53.713615_g304_i0 PRJNA1068513 329 925 53.713615 496.85093875 root 1 Root_unresolved Root_unresolved 76.8 5.55e-9   NTclustered gi|2863125063|dbj|AP038805.1| 70125 g304 i0 91.071 11.7362162162162 56 5 12 0 1 56 406588 406643 MAG: Nitrospira sp. AFB01 DNA, complete genome blastn 10856 76.8 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
13766949 13766949 PRJNA1068513_S_NODE_9111_length_299_cov_1.353982_g9065_i0 PRJNA1068513 9111 299 1.353982 4.04840618 root 1 Root_unresolved Root_unresolved 95.3 4.55e-15   NTclustered gi|2863125063|dbj|AP038805.1| 70125 g9065 i0 90.541 24.0535117056856 74 4 24 3 1 72 406581 406653 MAG: Nitrospira sp. AFB01 DNA, complete genome blastn 7192 95.3 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
21858691 21858691 PRJNA1068513_S_NODE_3738_length_460_cov_1.757106_g3693_i0 PRJNA1068513 3738 460 1.757106 8.0826876 Nitrospira sp. 70125 Bacteria Bacteria 84.2 1.58e-11   NTclustered gi|2863125063|dbj|AP038805.1| 70125 g3693 i0 94.444 11.1847826086957 54 3 12 0 407 460 406644 406591 MAG: Nitrospira sp. AFB01 DNA, complete genome blastn 5145 84.2 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
23966008 23966008 PRJNA1068513_S_NODE_679_length_762_cov_78.082729_g645_i0 PRJNA1068513 679 762 78.082729 594.99039498 root 1 Root_unresolved Root_unresolved 73.1 5.87e-8   NTclustered gi|2863125063|dbj|AP038805.1| 70125 g645 i0 91.071 5.62073490813648 56 2 7 3 1 55 406592 406645 MAG: Nitrospira sp. AFB01 DNA, complete genome blastn 4283 73.1 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
31742320 31742320 PRJNA1068513_S_NODE_8297_length_314_cov_5.360996_g8251_i0 PRJNA1068513 8297 314 5.360996 16.83352744 Nitrospirota bacterium 2026887 Bacteria Bacteria 100 2.2799999999999994e-23   NR HDH05801.1 2026887 g8251 i0 57.5 4.59554140127389 80 34 76.4 0 24 263 166 245 HDH05801.1 TIGR01777 family protein [Nitrospirota bacterium] diamond 1443 100 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota 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);;