RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJNA1093380" and tax_phylum = "Cyanobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cyanobacteriota · 11 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1093380 · 11 ✖

analysis 1

  • diamond · 11 ✖
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
26655854 26655854 PRJNA1093380_P_NODE_6401_length_283_cov_1.280952_g6295_i0 PRJNA1093380 6401 283 1.280952 3.62509416 Cyanobacteria bacterium PR.023 2067979 Bacteria Bacteria 134 3.58e-36   NR MBA4074325.1 2067979 g6295 i0 63.8 0.996466431095406 94 34 99.6 0 283 2 221 314 MBA4074325.1 hypothetical protein [Cyanobacteria bacterium PR.023] diamond 282 134 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium PR.023
27004219 27004219 PRJNA1093380_P_NODE_5242_length_290_cov_1.244240_g5136_i0 PRJNA1093380 5242 290 1.24424 3.608296 Cyanobacteriota bacterium erpe_2018_sw_21hr_WHONDRS-SW48-000092_B_bin.40 3070899 Bacteria Bacteria 44.7 0.0137   NR MDQ5938067.1 3070899 g5136 i0 50 1.0551724137931 44 21 45.5 1 139 8 691 733 MDQ5938067.1 protein O-mannosyl-transferase [Cyanobacteriota bacterium erpe_2018_sw_21hr_WHONDRS-SW48-000092_B_bin.40] diamond 306 44.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium erpe_2018_sw_21hr_WHONDRS-SW48-000092_B_bin.40
27121861 27121861 PRJNA1093380_P_NODE_10862_length_257_cov_1.255435_g10756_i0 PRJNA1093380 10862 257 1.255435 3.22646795 Bacillati 1783272 Bacteria Bacteria 113 5.7600000000000005e-27   NR MBA4050008.1 2067976 g10756 i0 71.4 6.88715953307393 84 24 98.1 0 6 257 128 211 MBA4050008.1 hypothetical protein [Cyanobacteria bacterium DS2.008] diamond 1770 113 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium DS2.008
27699753 27699753 PRJNA1093380_P_NODE_12024_length_251_cov_0.865169_g11918_i0 PRJNA1093380 12024 251 0.865169 2.17157419 Trichormus sp. 3088172 Bacteria Bacteria 63.2 1.55e-9   NR HEY9717315.1 3088172 g11918 i0 59.6 0.621513944223108 52 21 62.2 0 164 9 5 56 HEY9717315.1 DUF6088 family protein [Trichormus sp.] diamond 156 63.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Trichormus Trichormus sp.
28141693 28141693 PRJNA1093380_P_NODE_16585_length_242_cov_0.911243_g16479_i0 PRJNA1093380 16585 242 0.911243 2.20520806 Cyanobacteria bacterium REEB67 2800110 Bacteria Bacteria 128 1.25e-33   NR MBU6453638.1 2800110 g16479 i0 78.8 0.991735537190083 80 17 99.2 0 241 2 202 281 MBU6453638.1 electron transfer flavoprotein subunit alpha/FixB family protein [Cyanobacteria bacterium REEB67] diamond 240 128 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium REEB67
29719898 29719898 PRJNA1093380_P_NODE_9930_length_262_cov_1.857143_g9824_i0 PRJNA1093380 9930 262 1.857143 4.86571466 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 85.1 2.16e-17   NR MBX9694561.1 2847862 g9824 i0 57.3 1.01908396946565 89 32 97.3 3 3 257 104 190 MBX9694561.1 hypothetical protein [Cyanobacteriota bacterium] diamond 267 85.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
29742866 29742866 PRJNA1093380_P_NODE_11710_length_251_cov_2.595506_g11604_i0 PRJNA1093380 11710 251 2.595506 6.51472006 Cyanophyceae 3028117 Bacteria Bacteria 84.7 1.62e-17   NR MBU6450293.1 2800110 g11604 i0 85.4 3.44223107569721 48 7 57.4 0 105 248 1 48 MBU6450293.1 hypothetical protein [Cyanobacteria bacterium REEB67] diamond 864 85.1 0.995299647473561 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium REEB67
29814793 29814793 PRJNA1093380_P_NODE_13011_length_249_cov_0.875000_g12905_i0 PRJNA1093380 13011 249 0.875 2.17875 Cyanobacteria bacterium REEB67 2800110 Bacteria Bacteria 82.8 5.42e-17   NR MBU6450576.1 2800110 g12905 i0 74.5 1.30120481927711 55 14 66.3 0 1 165 188 242 MBU6450576.1 MBL fold metallo-hydrolase [Cyanobacteria bacterium REEB67] diamond 324 82.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium REEB67
30912209 30912209 PRJNA1093380_P_NODE_5594_length_287_cov_3.102804_g5488_i0 PRJNA1093380 5594 287 3.102804 8.90504748 Oscillatoriales 1150 Bacteria Bacteria 43.1 0.0467   NR WP_224413378.1 331517 g5488 i0 47.1 1.06620209059233 51 25 53.3 1 104 256 23 71 WP_224413378.1 chloride channel protein [Oscillatoria salina] diamond 306 43.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Oscillatoriaceae Oscillatoria Oscillatoria salina
31489945 31489945 PRJNA1093380_P_NODE_14116_length_247_cov_0.885057_g14010_i0 PRJNA1093380 14116 247 0.885057 2.18609079 Planktothrix sp. 3088171 Bacteria Bacteria 103 3.4e-24   NR HEY9777800.1 3088171 g14010 i0 56.8 0.983805668016194 81 35 98.4 0 3 245 239 319 HEY9777800.1 DUF3253 domain-containing protein [Planktothrix sp.] diamond 243 103 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Planktothrix Planktothrix sp.
31797137 31797137 PRJNA1093380_P_NODE_13117_length_249_cov_0.875000_g13011_i0 PRJNA1093380 13117 249 0.875 2.17875 Bacillati 1783272 Bacteria Bacteria 104 2.4e-26   NR MBA4079317.1 2067979 g13011 i0 67.5 2 83 26 98.8 1 3 248 57 139 MBA4079317.1 hypothetical protein [Cyanobacteria bacterium PR.023] diamond 498 104 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium PR.023

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