RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where bioproject = "PRJNA929522" and tax_clade = "Cyanobacteriota/Melainabacteria group"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_kingdom 1

tax_clade 1

  • Cyanobacteriota/Melainabacteria group · 15 ✖

bioproject 1

  • PRJNA929522 · 15 ✖
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
8558253 8558253 PRJNA929522_S_NODE_2487_length_423_cov_1.320000_g2417_i0 PRJNA929522 2487 423 1.32 5.5836 Calothrix sp. PCC 6303 1170562 Bacteria Bacteria 56.5 0.003   NTclustered gi|428233323|gb|CP003610.1| 1170562 g2417 i0 100 0.215130023640662 30 0 7 0 14 43 6273110 6273139 Calothrix sp. PCC 6303, complete genome blastn 91 56.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Calotrichaceae Calothrix Calothrix sp. PCC 6303
22931226 22931226 PRJNA929522_S_NODE_5498_length_299_cov_1.022124_g5428_i0 PRJNA929522 5498 299 1.022124 3.05615076 Planktothrix 54304 Bacteria Bacteria 54.7 0.008   NTclustered gi|2261189783|emb|LR882967.1| 132604 g5428 i0 100 0.193979933110368 29 0 10 0 230 258 2935600 2935628 Planktothrix pseudagardhii strain No.713 genome assembly, chromosome: I blastn 58 54.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Planktothrix Planktothrix pseudagardhii
23857727 23857727 PRJNA929522_S_NODE_8639_length_250_cov_0.870056_g8569_i0 PRJNA929522 8639 250 0.870056 2.17514 Nostoc sp. UHCC 0870 2914041 Bacteria Bacteria 52.8 0.023   NTclustered gi|2190707562|gb|CP091913.1| 2914041 g8569 i0 100 0.112 28 0 11 0 140 167 94571 94544 Nostoc sp. UHCC 0870 chromosome, complete genome blastn 28 52.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. UHCC 0870
25131461 25131461 PRJNA929522_S_NODE_1140_length_604_cov_1.977401_g1074_i0 PRJNA929522 1140 604 1.977401 11.94350204 Synechococcales cyanobacterium M58_A2018_015 2774348 Bacteria Bacteria 150 3.2e-40   NR MBF2000777.1 2774348 g1074 i0 59.2 0.620860927152318 125 50 61.6 1 373 2 215 339 MBF2000777.1 glycoside hydrolase family protein [Synechococcales cyanobacterium M58_A2018_015] diamond 375 150 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales     Synechococcales cyanobacterium M58_A2018_015
26803232 26803232 PRJNA929522_S_NODE_321_length_1037_cov_1.859959_g284_i0 PRJNA929522 321 1037 1.859959 19.28777483 Microcoleus asticus 2815231 Bacteria Bacteria 138 5.34e-32   NR WP_172186771.1 2815231 g284 i0 33.8 1.97010607521697 331 186 91.1 9 1024 80 823 1136 WP_172186771.1 Ig-like domain-containing protein [Microcoleus asticus] diamond 2043 138 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Microcoleus Microcoleus asticus
27277862 27277862 PRJNA929522_S_NODE_263_length_1116_cov_16.487057_g228_i0 PRJNA929522 263 1116 16.487057 183.99555612 Nostoc sp. EfeVER 1180 Bacteria Bacteria 52 4.17e-4   NR WP_322687120.1 3075406 g228 i0 45.2 0.166666666666667 62 32 16.1 2 1058 879 52 113 WP_322687120.1 hypothetical protein [Nostoc sp. EfeVER01] diamond 186 52 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. EfeVER01
28224856 28224856 PRJNA929522_S_NODE_666_length_771_cov_3.299427_g109_i1 PRJNA929522 666 771 3.299427 25.43858217 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 65.9 1.21e-8   NR HEY9814218.1 2364082 g109 i1 39.8 0.478599221789883 123 65 47.1 5 7 369 143 258 HEY9814218.1 hypothetical protein [Candidatus Obscuribacterales bacterium] diamond 369 65.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
28990242 28990242 PRJNA929522_S_NODE_6188_length_285_cov_1.731132_g6118_i0 PRJNA929522 6188 285 1.731132 4.9337262 Bacteria 2 Bacteria Bacteria 65.9 9.75e-12   NR QQR56461.1 2052166 g6118 i0 49.2 5.14736842105263 59 30 62.1 0 180 4 2 60 QQR56461.1 MAG: RNA-binding protein [Candidatus Melainabacteria bacterium] diamond 1467 65.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria         Candidatus Melainabacteria bacterium
29140954 29140954 PRJNA929522_S_NODE_4569_length_321_cov_1.447581_g4499_i0 PRJNA929522 4569 321 1.447581 4.6467350100000004 Umezakia ovalisporum 75695 Bacteria Bacteria 46.6 0.00383   NR WP_280649709.1 75695 g4499 i0 33.3 0.813084112149533 87 52 75.7 2 40 282 170 256 WP_280649709.1 hypothetical protein [Umezakia ovalisporum] diamond 261 46.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nodulariaceae Umezakia Umezakia ovalisporum
29835286 29835286 PRJNA929522_S_NODE_131_length_1381_cov_5.166667_g109_i0 PRJNA929522 131 1381 5.166667 71.35167127 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 111 6.04e-24   NR HEY9814218.1 2364082 g109 i0 32.5 0.5756698044895 265 162 56 11 1176 403 4 258 HEY9814218.1 hypothetical protein [Candidatus Obscuribacterales bacterium] diamond 795 111 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
30341374 30341374 PRJNA929522_S_NODE_9112_length_247_cov_0.885057_g9042_i0 PRJNA929522 9112 247 0.885057 2.18609079 Synechococcales cyanobacterium 2478492 Bacteria Bacteria 79.3 2.29e-16   NR MEB3355417.1 2478492 g9042 i0 76 0.607287449392713 50 12 60.7 0 2 151 115 164 MEB3355417.1 GNAT family protein [Synechococcales cyanobacterium] diamond 150 79.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales     Synechococcales cyanobacterium
30561756 30561756 PRJNA929522_S_NODE_9513_length_245_cov_0.872093_g9443_i0 PRJNA929522 9513 245 0.872093 2.13662785 Candidatus Sericytochromatia bacterium 2762020 Bacteria Bacteria 68.6 3.03e-11   NR MFN8671812.1 2762020 g9443 i0 46.2 0.955102040816327 78 40 94.3 2 2 232 409 485 MFN8671812.1 acyl-CoA dehydrogenase family protein [Candidatus Sericytochromatia bacterium] diamond 234 68.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati   Candidatus Sericytochromatia       Candidatus Sericytochromatia bacterium
31605168 31605168 PRJNA929522_S_NODE_4956_length_311_cov_2.743697_g4886_i0 PRJNA929522 4956 311 2.743697 8.53289767 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 55.1 2.72e-6   NR HEY9814218.1 2364082 g4886 i0 40.2 0.983922829581994 102 51 95.5 5 311 15 155 249 HEY9814218.1 hypothetical protein [Candidatus Obscuribacterales bacterium] diamond 306 55.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
31984627 31984627 PRJNA929522_S_NODE_7338_length_266_cov_2.191710_g7268_i0 PRJNA929522 7338 266 2.19171 5.8299486 candidate division WOR-1 bacterium DG_54_3 1703775 Bacteria Bacteria 44.3 0.0144   NR KPJ65960.1 1703775 g7268 i0 41.2 0.575187969924812 51 30 57.5 0 222 70 680 730 KPJ65960.1 MAG: hypothetical protein AMJ44_09185 [candidate division WOR-1 bacterium DG_54_3] diamond 153 44.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati           candidate division WOR-1 bacterium DG_54_3
32522891 32522891 PRJNA929522_S_NODE_5439_length_300_cov_1.837004_g5369_i0 PRJNA929522 5439 300 1.837004 5.511012 Cyanobacteria bacterium J06553_1 3023125 Bacteria Bacteria 76.3 1.22e-13   NR MEL7520467.1 3023125 g5369 i0 38.7 1.86 93 54 93 1 299 21 316 405 MEL7520467.1 reverse transcriptase family protein [Cyanobacteria bacterium J06553_1] diamond 558 76.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium J06553_1

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