RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where bioproject = "PRJNA951810" and tax_phylum = "Nitrospinota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Nitrospinota · 9 ✖

tax_kingdom 1

bioproject 1

  • PRJNA951810 · 9 ✖
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
13691392 13691392 PRJNA951810_P_NODE_63971_length_310_cov_2.978903_g63628_i0 PRJNA951810 63971 310 2.978903 9.2345993 Bacteria 2 Bacteria Bacteria 94.7 3.9200000000000006e-21   NR PIQ96754.1 1974049 g63628 i0 80 4.28709677419355 50 10 48.4 0 1 150 182 231 PIQ96754.1 MAG: acyltransferase [Nitrospinae bacterium CG11_big_fil_rev_8_21_14_0_20_56_8] diamond 1329 95.5 0.991623036649215 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Nitrospinota         Nitrospinae bacterium CG11_big_fil_rev_8_21_14_0_20_56_8
18789502 18789502 PRJNA951810_P_NODE_59995_length_310_cov_3.565401_g59652_i0 PRJNA951810 59995 310 3.565401 11.0527431 Nitrospinaceae bacterium 2358456 Bacteria Bacteria 132 3.62e-26   NTclustered gi|2107941210|gb|CP070799.1| 2358456 g59652 i0 89.423 6.65806451612903 104 11 34 0 1 104 1955245 1955142 MAG: Nitrospinaceae bacterium isolate bin1391 chromosome blastn 2064 132 1 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Nitrospinota Nitrospinia Nitrospinales Nitrospinaceae   Nitrospinaceae bacterium
21666348 21666348 PRJNA951810_P_NODE_67457_length_309_cov_16.161017_g67114_i0 PRJNA951810 67457 309 16.161017 49.93754253 Bacteria 2 Bacteria Bacteria 73.9 5.41e-14   NR GIS84322.1 2024844 g67114 i0 68.1 1.84466019417476 47 15 45.6 0 164 304 28 74 GIS84322.1 MAG: hypothetical protein CM1200mP16_06220 [Nitrospina sp.] diamond 570 73.9 1 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Nitrospinota Nitrospinia Nitrospinales Nitrospinaceae Nitrospina Nitrospina sp.
27089000 27089000 PRJNA951810_P_NODE_169642_length_242_cov_7.650888_g169297_i0 PRJNA951810 169642 242 7.650888 18.51514896 Nitrospinota bacterium 2026769 Bacteria Bacteria 73.2 2.94e-13   NR RMF83474.1 2026769 g169297 i0 42.9 2.83884297520661 77 44 95.5 0 3 233 6 82 RMF83474.1 MAG: peptidoglycan-binding protein, partial [Nitrospinota bacterium] diamond 687 73.2 1 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Nitrospinota         Nitrospinota bacterium
28137852 28137852 PRJNA951810_P_NODE_84005_length_299_cov_2.650442_g83661_i0 PRJNA951810 84005 299 2.650442 7.92482158 Bacteria 2 Bacteria Bacteria 73.2 1.69e-14   NR MBI3585379.1 2026769 g83661 i0 66.7 4.37458193979933 48 16 48.2 0 293 150 28 75 MBI3585379.1 acylphosphatase [Nitrospinota bacterium] diamond 1308 73.6 0.994565217391304 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Nitrospinota         Nitrospinota bacterium
28162876 28162876 PRJNA951810_P_NODE_24125_length_409_cov_6.175595_g23785_i0 PRJNA951810 24125 409 6.175595 25.25818355 Nitrospina sp. 2024844 Bacteria Bacteria 128 4.2e-33   NR HIB44106.1 2024844 g23785 i0 60.8 0.711491442542787 97 38 71.1 0 292 2 7 103 HIB44106.1 radical SAM protein [Nitrospina sp.] diamond 291 128 1 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Nitrospinota Nitrospinia Nitrospinales Nitrospinaceae Nitrospina Nitrospina sp.
28194145 28194145 PRJNA951810_P_NODE_59666_length_310_cov_3.620253_g59323_i0 PRJNA951810 59666 310 3.620253 11.2227843 Nitrospinae bacterium AH_259_B05_G02_I21 2935765 Bacteria Bacteria 79 1.21e-14   NR MDA2915522.1 2935765 g59323 i0 77.1 1.85806451612903 48 11 46.5 0 308 165 170 217 MDA2915522.1 IscS subfamily cysteine desulfurase [Nitrospinae bacterium AH_259_B05_G02_I21] diamond 576 79 1 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Nitrospinota         Nitrospinae bacterium AH_259_B05_G02_I21
28737565 28737565 PRJNA951810_P_NODE_101087_length_292_cov_4.461187_g100743_i0 PRJNA951810 101087 292 4.461187 13.02666604 Nitrospinota/Tectimicrobiota group 1802340 Bacteria Bacteria 122 6.4e-30   NR MDH5457136.1 2026769 g100743 i0 67.7 7.84931506849315 96 31 98.6 0 290 3 81 176 MDH5457136.1 hypothetical protein [Nitrospinota bacterium] diamond 2292 123 0.991869918699187 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Nitrospinota         Nitrospinota bacterium
32340235 32340235 PRJNA951810_P_NODE_132079_length_271_cov_6.207071_g131734_i0 PRJNA951810 132079 271 6.207071 16.82116241 Bacteria 2 Bacteria Bacteria 53.1 2.95e-6   NR MCH7615782.1 2026769 g131734 i0 51.1 3.83025830258303 45 22 49.8 0 266 132 73 117 MCH7615782.1 tetratricopeptide repeat protein [Nitrospinota bacterium] diamond 1038 53.1 1 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Nitrospinota         Nitrospinota 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);;