RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJNA715461", tax_phylum = "Nitrospirota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 7 ✖

tax_phylum 1

  • Nitrospirota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA715461 · 7 ✖

analysis 1

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
1981145 1981145 PRJNA715461_S_NODE_742_length_298_cov_2.644444_g668_i0 PRJNA715461 742 298 2.644444 7.88044312 Nitrospira sp. 70125 Bacteria Bacteria 65.8 3.56e-6   NTclustered gi|2863125063|dbj|AP038805.1| 70125 g668 i0 97.368 11.9832214765101 38 1 13 0 261 298 406648 406611 MAG: Nitrospira sp. AFB01 DNA, complete genome blastn 3571 65.8 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
10909206 10909206 PRJNA715461_S_NODE_1049_length_245_cov_1.651163_g975_i0 PRJNA715461 1049 245 1.651163 4.04534935 Nitrospira sp. 70125 Bacteria Bacteria 80.5 1.01e-10   NTclustered gi|2863125063|dbj|AP038805.1| 70125 g975 i0 97.826 16.6938775510204 46 1 19 0 6 51 406603 406648 MAG: Nitrospira sp. AFB01 DNA, complete genome blastn 4090 80.5 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
12184449 12184449 PRJNA715461_S_NODE_110_length_802_cov_3430.444444_g71_i0 PRJNA715461 110 802 3430.444444 27512.16444088 Nitrospira sp. 70125 Bacteria Bacteria 122 6.05e-23   NTclustered gi|2863125063|dbj|AP038805.1| 70125 g71 i0 90.426 10.2406483790524 94 8 12 1 707 799 406667 406574 MAG: Nitrospira sp. AFB01 DNA, complete genome blastn 8213 122 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
16495111 16495111 PRJNA715461_S_NODE_1033_length_246_cov_0.878613_g959_i0 PRJNA715461 1033 246 0.878613 2.16138798 root 1 Root_unresolved Root_unresolved 73.1 1.71e-8   NTclustered gi|2863125063|dbj|AP038805.1| 70125 g959 i0 97.619 16.7113821138211 42 1 17 0 5 46 406607 406648 MAG: Nitrospira sp. AFB01 DNA, complete genome blastn 4111 73.1 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
17283201 17283201 PRJNA715461_S_NODE_1274_length_224_cov_5.271523_g1200_i0 PRJNA715461 1274 224 5.271523 11.80821152 Nitrospira sp. 70125 Bacteria Bacteria 71.3 5.49e-8   NTclustered gi|2863125063|dbj|AP038805.1| 70125 g1200 i0 97.561 17.4642857142857 41 1 18 0 1 41 406608 406648 MAG: Nitrospira sp. AFB01 DNA, complete genome blastn 3912 71.3 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
19832086 19832086 PRJNA715461_S_NODE_936_length_258_cov_1.924324_g862_i0 PRJNA715461 936 258 1.924324 4.96475592 Nitrospira sp. 70125 Bacteria Bacteria 78.7 3.87e-10   NTclustered gi|2863125063|dbj|AP038805.1| 70125 g862 i0 97.778 15.5193798449612 45 1 17 0 1 45 406604 406648 MAG: Nitrospira sp. AFB01 DNA, complete genome blastn 4004 78.7 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
22382708 22382708 PRJNA715461_S_NODE_938_length_258_cov_1.459459_g864_i0 PRJNA715461 938 258 1.459459 3.76540422 Nitrospira sp. 70125 Bacteria Bacteria 80.5 1.08e-10   NTclustered gi|2863125063|dbj|AP038805.1| 70125 g864 i0 97.826 15.9496124031008 46 1 18 0 207 252 406648 406603 MAG: Nitrospira sp. AFB01 DNA, complete genome blastn 4115 80.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);;