RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

  • Pseudomonadati · 13 ✖

bioproject 1

  • PRJNA454503 · 13 ✖

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
8095759 8095759 PRJNA454503_P_NODE_56567_length_211_cov_0.866667_g56238_i0 PRJNA454503 56567 211 0.866667 1.82866737 Nitrospira sp. 70125 Bacteria Bacteria 183 6.3e-42   NTclustered gi|2194436381|gb|CP092080.1| 70125 g56238 i0 82.775 0.990521327014218 209 33 98 2 1 206 225945 226153 MAG: Nitrospira sp. isolate UBC1 chromosome blastn 209 183 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
13196544 13196544 PRJNA454503_P_NODE_85391_length_202_cov_0.921986_g85062_i0 PRJNA454503 85391 202 0.921986 1.86241172 Nitrospira sp. 70125 Bacteria Bacteria 183 5.979999999999998e-42   NTclustered gi|2290907019|gb|CP060499.1| 70125 g85062 i0 83.333 128.316831683168 204 29 100 5 1 202 2684758 2684958 MAG: Nitrospira sp. isolate DH1 chromosome, complete genome blastn 25920 183 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
15745267 15745267 PRJNA454503_P_NODE_59233_length_210_cov_0.872483_g58904_i0 PRJNA454503 59233 210 0.872483 1.8322143 Nitrospira sp. 70125 Bacteria Bacteria 183 6.259999999999998e-42   NTclustered gi|2863129529|dbj|AP038806.1| 70125 g58904 i0 82.381 1 210 37 100 0 1 210 2296351 2296560 MAG: Nitrospira sp. NFB02 DNA, complete genome blastn 210 183 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
27549989 27549989 PRJNA454503_P_NODE_83104_length_203_cov_0.915493_g82775_i0 PRJNA454503 83104 203 0.915493 1.85845079 Nitrospira sp. 70125 Bacteria Bacteria 127 2.1399999999999993e-34   NR MEP7151888.1 70125 g82775 i0 88.1 1.98029556650246 67 8 99 0 202 2 170 236 MEP7151888.1 glycine cleavage system aminomethyltransferase GcvT [Nitrospira sp.] diamond 402 127 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
28844428 28844428 PRJNA454503_P_NODE_29528_length_240_cov_1.452514_g29199_i0 PRJNA454503 29528 240 1.452514 3.4860336 Nitrospira sp. 70125 Bacteria Bacteria 133 4.93e-36   NR HVG01435.1 70125 g29199 i0 93.1 1.8 72 5 90 0 23 238 1 72 HVG01435.1 signal recognition particle-docking protein FtsY [Nitrospira sp.] diamond 432 133 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
28876155 28876155 PRJNA454503_P_NODE_79388_length_204_cov_0.909091_g79059_i0 PRJNA454503 79388 204 0.909091 1.85454564 Nitrospira sp. 70125 Bacteria Bacteria 124 2.48e-32   NR HVG01398.1 70125 g79059 i0 95.5 0.985294117647059 67 3 98.5 0 3 203 94 160 HVG01398.1 homocysteine S-methyltransferase family protein [Nitrospira sp.] diamond 201 124 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
29318154 29318154 PRJNA454503_P_NODE_84689_length_202_cov_0.921986_g84360_i0 PRJNA454503 84689 202 0.921986 1.86241172 Nitrospira sp. ST-bin5 1978765 Bacteria Bacteria 69.3 5.71e-12   NR OQW66181.1 1978765 g84360 i0 79.5 0.579207920792079 39 8 57.9 0 6 122 259 297 OQW66181.1 MAG: DNA processing protein DprA [Nitrospira sp. ST-bin5] diamond 117 69.3 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp. ST-bin5
29665174 29665174 PRJNA454503_P_NODE_58630_length_210_cov_0.872483_g58301_i0 PRJNA454503 58630 210 0.872483 1.8322143 Nitrospira sp. 70125 Bacteria Bacteria 51.6 4.2e-6   NR HKY72020.1 70125 g58301 i0 82.8 0.414285714285714 29 5 41.4 0 2 88 104 132 HKY72020.1 response regulator [Nitrospira sp.] diamond 87 51.6 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
30613133 30613133 PRJNA454503_P_NODE_48293_length_217_cov_1.666667_g47964_i0 PRJNA454503 48293 217 1.666667 3.61666739 Nitrospira sp. 70125 Bacteria Bacteria 135 7.56e-36   NR MCE3223719.1 70125 g47964 i0 94.4 0.995391705069124 72 4 99.5 0 217 2 96 167 MCE3223719.1 uncharacterized protein [Nitrospira sp.] diamond 216 135 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
30865949 30865949 PRJNA454503_P_NODE_43734_length_222_cov_1.614907_g43405_i0 PRJNA454503 43734 222 1.614907 3.58509354 Nitrospira sp. 70125 Bacteria Bacteria 118 5.38e-30   NR HVG02790.1 70125 g43405 i0 84.7 0.972972972972973 72 11 97.3 0 3 218 170 241 HVG02790.1 tRNA preQ1(34) S-adenosylmethionine ribosyltransferase-isomerase QueA [Nitrospira sp.] diamond 216 118 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
31340073 31340073 PRJNA454503_P_NODE_83716_length_202_cov_1.843972_g83387_i0 PRJNA454503 83716 202 1.843972 3.72482344 Nitrospira sp. 70125 Bacteria Bacteria 50.1 5.24e-5   NR TKS58792.1 70125 g83387 i0 46.2 0.965346534653465 65 35 96.5 0 2 196 42 106 TKS58792.1 MAG: hypothetical protein EWM73_03406 [Nitrospira sp.] diamond 195 50.1 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
31940920 31940920 PRJNA454503_P_NODE_86477_length_202_cov_0.921986_g86148_i0 PRJNA454503 86477 202 0.921986 1.86241172 Nitrospira sp. 70125 Bacteria Bacteria 122 2.07e-33   NR HEX5549520.1 70125 g86148 i0 100 3.98019801980198 67 0 99.5 0 202 2 80 146 HEX5549520.1 SPFH domain-containing protein [Nitrospira sp.] diamond 804 122 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
32542513 32542513 PRJNA454503_P_NODE_43859_length_222_cov_1.614907_g43530_i0 PRJNA454503 43859 222 1.614907 3.58509354 Nitrospira sp. 70125 Bacteria Bacteria 115 5e-28   NR MEP7151511.1 70125 g43530 i0 76.7 0.986486486486487 73 17 98.6 0 2 220 525 597 MEP7151511.1 CHAT domain-containing protein [Nitrospira sp.] diamond 219 115 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);;