RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where bioproject = "PRJNA917598", tax_phylum = "Nitrospirota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 13 ✖

tax_phylum 1

  • Nitrospirota · 13 ✖

tax_kingdom 1

bioproject 1

  • PRJNA917598 · 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
1251201 1251201 PRJNA917598_P_NODE_2361_length_1636_cov_5.682662_g1941_i0 PRJNA917598 2361 1636 5.682662 92.96835032 Nitrospira sp. 70125 Bacteria Bacteria 640 1.2199999999999995e-227   NR MBS0172180.1 70125 g1941 i0 91.2 0.623471882640587 340 30 62.3 0 1510 491 1 340 MBS0172180.1 DUF4917 family protein [Nitrospira sp.] diamond 1020 640 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
2527289 2527289 PRJNA917598_P_NODE_75042_length_261_cov_1.585106_g74098_i0 PRJNA917598 75042 261 1.585106 4.13712666 Nitrospira 1234 Bacteria Bacteria 460 3.3399999999999995e-125   NTclustered gi|2290907019|gb|CP060499.1| 70125 g74098 i0 98.467 155.103448275862 261 4 100 0 1 261 2683650 2683390 MAG: Nitrospira sp. isolate DH1 chromosome, complete genome blastn 40482 460 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
3447926 3447926 PRJNA917598_P_NODE_85283_length_248_cov_0.880000_g84339_i0 PRJNA917598 85283 248 0.88 2.1824 Nitrospira sp. 70125 Bacteria Bacteria 414 2.48e-111   NTclustered gi|2194428397|gb|CP092079.1| 70125 g84339 i0 96.787 18.0483870967742 249 7 100 1 1 248 2119061 2119309 MAG: Nitrospira sp. isolate UBC3 chromosome blastn 4476 414 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
7274664 7274664 PRJNA917598_P_NODE_59246_length_293_cov_1.777273_g58302_i0 PRJNA917598 59246 293 1.777273 5.20740989 Nitrospira sp. 70125 Bacteria Bacteria 514 2.88e-141   NTclustered gi|2511640680|gb|CP126121.1| 70125 g58302 i0 98.294 244.501706484642 293 5 100 0 1 293 200922 200630 MAG: Nitrospira sp. isolate bin_001 chromosome, complete genome blastn 71639 514 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
27182499 27182499 PRJNA917598_P_NODE_91862_length_243_cov_2.017647_g90918_i0 PRJNA917598 91862 243 2.017647 4.90288221 Nitrospira sp. LK70 2039809 Bacteria Bacteria 143 1.9e-39   NR NGZ10726.1 2039809 g90918 i0 77.8 1 81 18 100 0 243 1 246 326 NGZ10726.1 hypothetical protein [Nitrospira sp. LK70] diamond 243 143 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp. LK70
27189831 27189831 PRJNA917598_P_NODE_73522_length_264_cov_2.094241_g72578_i0 PRJNA917598 73522 264 2.094241 5.52879624 Nitrospira 1234 Bacteria Bacteria 45.4 0.00501   NR HSN03606.1 70125 g72578 i0 35.3 2.89772727272727 85 50 96.6 1 262 8 125 204 HSN03606.1 UDP-glucose 4-epimerase GalE [Nitrospira sp.] diamond 765 45.4 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
27845765 27845765 PRJNA917598_P_NODE_41104_length_358_cov_1.589474_g40160_i0 PRJNA917598 41104 358 1.589474 5.69031692 Nitrospira sp. CG24C 1985131 Bacteria Bacteria 85.1 1.93e-16   NR THJ14130.1 1985131 g40160 i0 46.2 2.35474860335196 91 49 76.3 0 63 335 630 720 THJ14130.1 MAG: DEAD/DEAH box helicase [Nitrospira sp. CG24C] diamond 843 85.1 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp. CG24C
27940718 27940718 PRJNA917598_P_NODE_33785_length_395_cov_2.242236_g32841_i0 PRJNA917598 33785 395 2.242236 8.8568322 Nitrospira sp. 70125 Bacteria Bacteria 101 4.22e-24   NR MDH4187660.1 70125 g32841 i0 73.7 0.432911392405063 57 15 43.3 0 1 171 115 171 MDH4187660.1 L,D-transpeptidase family protein [Nitrospira sp.] diamond 171 101 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
28824487 28824487 PRJNA917598_P_NODE_81528_length_250_cov_0.870056_g80584_i0 PRJNA917598 81528 250 0.870056 2.17514 Nitrospirota bacterium 2026887 Bacteria Bacteria 42.7 0.0397   NR HUL01084.1 2026887 g80584 i0 32.3 0.744 62 42 74.4 0 63 248 94 155 HUL01084.1 molybdopterin-dependent oxidoreductase [Nitrospirota bacterium] diamond 186 42.7 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
28831918 28831918 PRJNA917598_P_NODE_39168_length_367_cov_1.309524_g38224_i0 PRJNA917598 39168 367 1.309524 4.80595308 Pseudomonadati 3379134 Bacteria Bacteria 162 1.1799999999999998e-47   NR MDH4085866.1 70125 g38224 i0 60.5 1.94550408719346 119 47 97.3 0 3 359 92 210 MDH4085866.1 hypothetical protein [Nitrospira sp.] diamond 714 163 0.993865030674847 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
30719696 30719696 PRJNA917598_P_NODE_81394_length_250_cov_0.870056_g80450_i0 PRJNA917598 81394 250 0.870056 2.17514 Nitrospira sp. 70125 Bacteria Bacteria 134 5.79e-37   NR HNG55227.1 70125 g80450 i0 83.8 0.96 80 13 96 0 9 248 4 83 HNG55227.1 dNTP triphosphohydrolase [Nitrospira sp.] diamond 240 134 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
30948412 30948412 PRJNA917598_P_NODE_63154_length_285_cov_1.386792_g62210_i0 PRJNA917598 63154 285 1.386792 3.9523572 Pseudomonadati 3379134 Bacteria Bacteria 84.3 2.91e-18   NR HKY72928.1 70125 g62210 i0 47.1 3.63157894736842 87 46 91.6 0 23 283 1 87 HKY72928.1 isoprenylcysteine carboxylmethyltransferase family protein [Nitrospira sp.] diamond 1035 85.1 0.990599294947121 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
32459181 32459181 PRJNA917598_P_NODE_3899_length_1256_cov_2.604396_g3294_i0 PRJNA917598 3899 1256 2.604396 32.71121376 Nitrospira bacterium SG8_35_4 1704025 Bacteria Bacteria 195 5.21e-54   NR KPJ98059.1 1704025 g3294 i0 40.8 1.34235668789809 282 151 66.2 3 1224 394 103 373 KPJ98059.1 MAG: hypothetical protein AMK71_12050 [Nitrospira bacterium SG8_35_4] diamond 1686 195 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria       Nitrospira bacterium SG8_35_4

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