RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJNA980587" and tax_clade = "Cyanobacteriota/Melainabacteria group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

tax_clade 1

  • Cyanobacteriota/Melainabacteria group · 22 ✖

bioproject 1

  • PRJNA980587 · 22 ✖

analysis 1

  • diamond · 22 ✖
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
25182371 25182371 PRJNA980587_P_NODE_84780_length_247_cov_0.885057_g83987_i0 PRJNA980587 84780 247 0.885057 2.18609079 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 156 9.279999999999999e-47   NR MBX9724270.1 2364082 g83987 i0 90.2 0.995951417004049 82 8 99.6 0 247 2 37 118 MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium] diamond 246 156 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
25496120 25496120 PRJNA980587_P_NODE_94720_length_241_cov_0.916667_g93927_i0 PRJNA980587 94720 241 0.916667 2.20916747 unclassified Thermosynechococcus 2622553 Bacteria Bacteria 99.4 4.45e-22   NR WP_302676597.1 2622553 g93927 i0 60.5 7.96680497925311 81 31 99.6 1 2 241 619 699 WP_302676597.1 MULTISPECIES: cation-translocating P-type ATPase [unclassified Thermosynechococcus] diamond 1920 99.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Acaryochloridales Thermosynechococcaceae Thermosynechococcus  
26614472 26614472 PRJNA980587_P_NODE_88921_length_245_cov_0.895349_g88128_i0 PRJNA980587 88921 245 0.895349 2.19360505 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 144 2.73e-41   NR MBX9721335.1 2364082 g88128 i0 84 0.991836734693878 81 13 99.2 0 245 3 85 165 MBX9721335.1 F0F1 ATP synthase subunit alpha [Candidatus Obscuribacterales bacterium] diamond 243 144 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
26931311 26931311 PRJNA980587_P_NODE_90802_length_243_cov_1.800000_g90009_i0 PRJNA980587 90802 243 1.8 4.374 Geminocystis sp. 2664100 Bacteria Bacteria 55.5 1.18e-6   NR MCS7148143.1 2664100 g90009 i0 41.7 2.08641975308642 60 35 74.1 0 242 63 445 504 MCS7148143.1 peptide ligase PGM1-related protein [Geminocystis sp.] diamond 507 55.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Geminocystaceae Geminocystis Geminocystis sp.
27190225 27190225 PRJNA980587_P_NODE_69282_length_271_cov_1.555556_g68489_i0 PRJNA980587 69282 271 1.555556 4.21555676 Bacillati 1783272 Bacteria Bacteria 43.1 0.0406   NR WP_199248346.1 222819 g68489 i0 42.7 2.0479704797048 89 42 93 4 2 253 1166 1250 WP_199248346.1 CHAT domain-containing protein [[Phormidium] sp. ETS-05] diamond 555 43.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Oscillatoriaceae Koinonema [Phormidium] sp. ETS-05
27215653 27215653 PRJNA980587_P_NODE_82382_length_249_cov_0.875000_g81589_i0 PRJNA980587 82382 249 0.875 2.17875 Cyanobium sp. NAT70 2024872 Bacteria Bacteria 85.9 2.56e-17   NR MAR05673.1 2024872 g81589 i0 54.1 0.891566265060241 74 32 89.2 1 3 224 552 623 MAR05673.1 DNA polymerase [Cyanobium sp. NAT70] diamond 222 85.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Prochlorococcaceae Cyanobium Cyanobium sp. NAT70
27437304 27437304 PRJNA980587_P_NODE_61603_length_289_cov_1.425926_g60810_i0 PRJNA980587 61603 289 1.425926 4.12092614 Microcystis sp. M037S2 2771163 Bacteria Bacteria 61.6 1.25e-9   NR MCA2689081.1 2771163 g60810 i0 59.5 1.28719723183391 42 17 43.6 0 10 135 1 42 MCA2689081.1 hypothetical protein [Microcystis sp. M037S2] diamond 372 61.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Microcystaceae Microcystis Microcystis sp. M037S2
27443484 27443484 PRJNA980587_P_NODE_24863_length_497_cov_1.879717_g24072_i0 PRJNA980587 24863 497 1.879717 9.34219349 Cyanophyceae 3028117 Bacteria Bacteria 223 4.4e-72   NR WP_212664291.1 155977 g24072 i0 70.9 28.5392354124748 148 43 89.3 0 23 466 2 149 WP_212664291.1 MULTISPECIES: nucleoside-diphosphate kinase [Acaryochloris] diamond 14184 224 0.995535714285714 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Acaryochloridales Acaryochloridaceae Acaryochloris  
27468747 27468747 PRJNA980587_P_NODE_91683_length_243_cov_0.905882_g90890_i0 PRJNA980587 91683 243 0.905882 2.20129326 Candidatus Sericytochromatia bacterium 2762020 Bacteria Bacteria 101 5.429999999999999e-23   NR MFP5502976.1 2762020 g90890 i0 75.4 1.7037037037037 69 17 85.2 0 3 209 14 82 MFP5502976.1 biosynthetic arginine decarboxylase [Candidatus Sericytochromatia bacterium] diamond 414 101 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati   Candidatus Sericytochromatia       Candidatus Sericytochromatia bacterium
28037076 28037076 PRJNA980587_P_NODE_7205_length_1060_cov_2.545086_g6630_i0 PRJNA980587 7205 1060 2.545086 26.9779116 Anabaena sp. FACHB-1237 2692769 Bacteria Bacteria 50.1 0.00958   NR WP_190369220.1 2692769 g6630 i0 33.8 0.435849056603774 77 47 21.8 2 683 453 281 353 WP_190369220.1 methyltransferase [Anabaena sp. FACHB-1237] diamond 462 50.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Anabaena Anabaena sp. FACHB-1237
28137989 28137989 PRJNA980587_P_NODE_41045_length_363_cov_1.727586_g40252_i0 PRJNA980587 41045 363 1.727586 6.27113718 Bacteria 2 Bacteria Bacteria 43.9 0.0366   NR WP_075901322.1 207920 g40252 i0 40.4 1.28099173553719 57 32 47.1 2 172 2 9 63 WP_075901322.1 vWA domain-containing protein [Moorena bouillonii] diamond 465 44.3 0.99097065462754 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Coleofasciculales Coleofasciculaceae Moorena Moorena bouillonii
28232222 28232222 PRJNA980587_P_NODE_47346_length_335_cov_1.541985_g46553_i0 PRJNA980587 47346 335 1.541985 5.16564975 Cyanophyceae 3028117 Bacteria Bacteria 77.8 6.01e-16   NR WP_096606172.1 1954172 g46553 i0 35.6 1.85373134328358 104 62 88.7 1 19 315 1 104 WP_096606172.1 hypothetical protein [Calothrix sp. NIES-2100] diamond 621 77.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Calotrichaceae Calothrix Calothrix sp. NIES-2100
28668579 28668579 PRJNA980587_P_NODE_85407_length_247_cov_0.885057_g84614_i0 PRJNA980587 85407 247 0.885057 2.18609079 Cyanobacteria bacterium P01_E01_bin.42 3023285 Bacteria Bacteria 41.2 0.0486   NR MEM9541919.1 3023285 g84614 i0 33.8 0.825910931174089 68 42 80.2 2 41 238 5 71 MEM9541919.1 nuclear transport factor 2 family protein [Cyanobacteria bacterium P01_E01_bin.42] diamond 204 41.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium P01_E01_bin.42
28990570 28990570 PRJNA980587_P_NODE_15788_length_661_cov_2.163265_g15022_i0 PRJNA980587 15788 661 2.163265 14.29918165 Bacteria 2 Bacteria Bacteria 53.5 5.13e-5   NR WP_015190321.1 1173026 g15022 i0 31.5 3.01815431164902 162 85 72.2 5 526 50 3 141 WP_015190321.1 GNAT family N-acetyltransferase [Gloeocapsa sp. PCC 7428] diamond 1995 53.9 0.992578849721707 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Chroococcaceae Gloeocapsa Gloeocapsa sp. PCC 7428
30437243 30437243 PRJNA980587_P_NODE_61273_length_290_cov_1.373272_g60480_i0 PRJNA980587 61273 290 1.373272 3.9824888 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 174 3.87e-48   NR MBX9671577.1 2364082 g60480 i0 91.7 1.98620689655172 96 7 99.3 1 3 290 653 747 MBX9671577.1 hypothetical protein [Candidatus Obscuribacterales bacterium] diamond 576 174 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
30626362 30626362 PRJNA980587_P_NODE_93393_length_242_cov_0.911243_g92600_i0 PRJNA980587 93393 242 0.911243 2.20520806 Leptolyngbyaceae cyanobacterium M65_K2018_010 2747810 Bacteria Bacteria 79.7 3.39e-15   NR HIK46406.1 2747810 g92600 i0 49.4 1.89669421487603 77 35 90.5 1 2 220 69 145 HIK46406.1 carboxylate-amine ligase [Leptolyngbyaceae cyanobacterium M65_K2018_010] diamond 459 79.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae   Leptolyngbyaceae cyanobacterium M65_K2018_010
31100294 31100294 PRJNA980587_P_NODE_27915_length_461_cov_4.484536_g27122_i0 PRJNA980587 27915 461 4.484536 20.67371096 Planktothrix sp. UBA8402 2055759 Bacteria Bacteria 75.9 4.98e-15   NR HAN73250.1 2055759 g27122 i0 56.3 1.50325379609544 71 25 46.2 3 105 317 5 69 HAN73250.1 cold-shock protein [Planktothrix sp. UBA8402] diamond 693 75.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Planktothrix Planktothrix sp. UBA8402
31321680 31321680 PRJNA980587_P_NODE_12995_length_749_cov_1.687870_g12256_i0 PRJNA980587 12995 749 1.68787 12.6421463 Okeania sp. KiyG1 2720165 Bacteria Bacteria 135 1.49e-32   NR WP_202221293.1 2720165 g12256 i0 36.3 4.08945260347129 256 142 98.5 9 740 3 6 250 WP_202221293.1 peroxidase family protein [Okeania sp. KiyG1] diamond 3063 135 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Okeania Okeania sp. KiyG1
32176082 32176082 PRJNA980587_P_NODE_30638_length_435_cov_1.276243_g29845_i0 PRJNA980587 30638 435 1.276243 5.55165705 Pseudanabaenaceae cyanobacterium 3078745 Bacteria Bacteria 120 3.8699999999999997e-31   NR MFN3927180.1 3078745 g29845 i0 47.5 0.972413793103448 141 71 97.2 3 5 427 39 176 MFN3927180.1 VWA domain-containing protein [Pseudanabaenaceae cyanobacterium] diamond 423 120 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pseudanabaenales Pseudanabaenaceae   Pseudanabaenaceae cyanobacterium
32365924 32365924 PRJNA980587_P_NODE_59279_length_296_cov_0.878924_g58486_i0 PRJNA980587 59279 296 0.878924 2.60161504 Cyanobacteria bacterium RI_101 2775578 Bacteria Bacteria 51.2 7.32e-5   NR MBJ7901489.1 2775578 g58486 i0 46.7 0.456081081081081 45 24 45.6 0 122 256 384 428 MBJ7901489.1 TIGR03032 family protein [Cyanobacteria bacterium RI_101] diamond 135 51.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium RI_101
32649725 32649725 PRJNA980587_P_NODE_35000_length_400_cov_4.128440_g34207_i0 PRJNA980587 35000 400 4.12844 16.51376 Candidatus Sericytochromatia bacterium 2762020 Bacteria Bacteria 122 9.67e-33   NR MEB3328696.1 2762020 g34207 i0 50.5 4.9425 109 53 81.8 1 363 37 1 108 MEB3328696.1 nucleoside-diphosphate kinase [Candidatus Sericytochromatia bacterium] diamond 1977 122 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati   Candidatus Sericytochromatia       Candidatus Sericytochromatia bacterium
32681284 32681284 PRJNA980587_P_NODE_79340_length_251_cov_0.865169_g78547_i0 PRJNA980587 79340 251 0.865169 2.17157419 Calothrix sp. SM1_5_4 2720460 Bacteria Bacteria 95.9 7.430000000000001e-21   NR NJL25832.1 2720460 g78547 i0 56.3 0.956175298804781 80 35 95.6 0 250 11 296 375 NJL25832.1 hypothetical protein [Calothrix sp. SM1_5_4] diamond 240 95.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Calotrichaceae Calothrix Calothrix sp. SM1_5_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);;