RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

30 rows where analysis = "diamond", bioproject = "PRJEB83711" 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 · 30 ✖

bioproject 1

  • PRJEB83711 · 30 ✖

analysis 1

  • diamond · 30 ✖
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
7796859 7796859 PRJEB83711_P_NODE_60487_length_252_cov_0.871508_g60221_i0 PRJEB83711 60487 252 0.871508 2.19620016 Cyanobacteria bacterium UBA11049 2055787 Bacteria Bacteria 169 1.4e-49   NR HCF28948.1 2055787 g60221 i0 96.4 0.988095238095238 83 3 98.8 0 250 2 125 207 HCF28948.1 family 2 glycosyl transferase [Cyanobacteria bacterium UBA11049] diamond 249 169 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium UBA11049
11622894 11622894 PRJEB83711_P_NODE_56850_length_254_cov_1.364641_g56584_i0 PRJEB83711 56850 254 1.364641 3.46618814 cyanobacterium TDX16 1503470 Bacteria Bacteria 95.9 9.05e-23   NR OWY58681.1 1503470 g56584 i0 53.7 0.968503937007874 82 38 96.9 0 253 8 12 93 OWY58681.1 hypothetical protein B7486_78665, partial [cyanobacterium TDX16] diamond 246 95.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         cyanobacterium TDX16
14172942 14172942 PRJEB83711_P_NODE_60292_length_252_cov_0.871508_g60026_i0 PRJEB83711 60292 252 0.871508 2.19620016 Candidatus Gastranaerophilales bacterium 2137880 Bacteria Bacteria 129 1.65e-33   NR MDD3237259.1 2137880 g60026 i0 75.9 0.94047619047619 79 19 94 0 245 9 48 126 MDD3237259.1 Mur ligase family protein [Candidatus Gastranaerophilales bacterium] diamond 237 129 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Gastranaerophilales     Candidatus Gastranaerophilales bacterium
16721428 16721428 PRJEB83711_P_NODE_70974_length_246_cov_0.901734_g70708_i0 PRJEB83711 70974 246 0.901734 2.21826564 Myxacorys chilensis 2594884 Bacteria Bacteria 167 8.68e-48   NR MBW4542037.1 1601998 g70708 i0 100 1 82 0 100 0 1 246 290 371 MBW4542037.1 aldehyde dehydrogenase [Myxacorys chilensis ATA2-1-KO14] diamond 246 167 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Myxacorys Myxacorys chilensis
26907765 26907765 PRJEB83711_P_NODE_42862_length_282_cov_1.387560_g42596_i0 PRJEB83711 42862 282 1.38756 3.9129192 Cyanobacteria bacterium P01_A01_bin.40 3023249 Bacteria Bacteria 181 1.05e-53   NR MEM7760001.1 3023249 g42596 i0 97.8 0.98936170212766 93 2 98.9 0 281 3 5 97 MEM7760001.1 HigA family addiction module antitoxin [Cyanobacteria bacterium P01_A01_bin.40] diamond 279 181 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium P01_A01_bin.40
27571458 27571458 PRJEB83711_P_NODE_71504_length_246_cov_0.901734_g71238_i0 PRJEB83711 71504 246 0.901734 2.21826564 Candidatus Gastranaerophilales bacterium 2137880 Bacteria Bacteria 67.8 5.68e-11   NR MCR5261300.1 2137880 g71238 i0 63 0.560975609756098 46 17 56.1 0 107 244 466 511 MCR5261300.1 glucosaminidase domain-containing protein [Candidatus Gastranaerophilales bacterium] diamond 138 67.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Gastranaerophilales     Candidatus Gastranaerophilales bacterium
27950404 27950404 PRJEB83711_P_NODE_61665_length_251_cov_0.876404_g61399_i0 PRJEB83711 61665 251 0.876404 2.19977404 Leptolyngbyaceae cyanobacterium 3088178 Bacteria Bacteria 148 1.54e-42   NR HEY9781057.1 3088178 g61399 i0 83.1 2.95219123505976 83 14 99.2 0 3 251 36 118 HEY9781057.1 photosystem II biogenesis protein Psp29 [Leptolyngbyaceae cyanobacterium] diamond 741 148 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae   Leptolyngbyaceae cyanobacterium
28234275 28234275 PRJEB83711_P_NODE_54146_length_259_cov_1.344086_g53880_i0 PRJEB83711 54146 259 1.344086 3.48118274 Cyanobacteria bacterium UBA11049 2055787 Bacteria Bacteria 154 2.01e-44   NR HCF27785.1 2055787 g53880 i0 83.7 2.98841698841699 86 14 99.6 0 1 258 37 122 HCF27785.1 hypothetical protein [Cyanobacteria bacterium UBA11049] diamond 774 154 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium UBA11049
28543135 28543135 PRJEB83711_P_NODE_59547_length_252_cov_0.871508_g59281_i0 PRJEB83711 59547 252 0.871508 2.19620016 Microcoleus 44471 Bacteria Bacteria 142 2.79e-37   NR MBD1834463.1 2692764 g59281 i0 79.5 1.97619047619048 83 17 98.8 0 2 250 449 531 MBD1834463.1 PAS domain S-box protein [Cyanobacteria bacterium FACHB-472] diamond 498 142 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium FACHB-472
28732413 28732413 PRJEB83711_P_NODE_42147_length_284_cov_1.109005_g41881_i0 PRJEB83711 42147 284 1.109005 3.1495742 Cyanophyceae 3028117 Bacteria Bacteria 124 1.33e-30   NR WP_029630397.1 1161 g41881 i0 64.5 4.91197183098592 93 33 98.2 0 283 5 1140 1232 WP_029630397.1 MULTISPECIES: filamentous hemagglutinin N-terminal domain-containing protein [Nostocales] diamond 1395 125 0.992 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales      
28834413 28834413 PRJEB83711_P_NODE_59488_length_252_cov_0.871508_g59222_i0 PRJEB83711 59488 252 0.871508 2.19620016 Chroococcidiopsidales cyanobacterium LEGE 13417 1828829 Bacteria Bacteria 81.6 7.33e-16   NR MBE9017555.1 1828829 g59222 i0 52.1 0.845238095238095 71 34 84.5 0 252 40 307 377 MBE9017555.1 DNA polymerase III subunit beta [Chroococcidiopsidales cyanobacterium LEGE 13417] diamond 213 81.6 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales     Chroococcidiopsidales cyanobacterium LEGE 13417
28897466 28897466 PRJEB83711_P_NODE_74788_length_244_cov_0.912281_g74522_i0 PRJEB83711 74788 244 0.912281 2.22596564 Phormidium sp. 1199 Bacteria Bacteria 125 3.28e-33   NR HEY9296610.1 1199 g74522 i0 78.8 0.983606557377049 80 17 98.4 0 3 242 187 266 HEY9296610.1 IS982 family transposase [Phormidium sp.] diamond 240 125 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Oscillatoriaceae Phormidium Phormidium sp.
29055586 29055586 PRJEB83711_P_NODE_31588_length_320_cov_0.947368_g31322_i0 PRJEB83711 31588 320 0.947368 3.0315776 Chroococcidiopsis sp. CCMEE 29 155894 Bacteria Bacteria 159 4.88e-44   NR WP_250124526.1 155894 g31322 i0 79.8 0.975 104 21 97.5 0 320 9 388 491 WP_250124526.1 AAA family ATPase [Chroococcidiopsis sp. CCMEE 29] diamond 312 159 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Chroococcidiopsidaceae Chroococcidiopsis Chroococcidiopsis sp. CCMEE 29
29143076 29143076 PRJEB83711_P_NODE_72329_length_245_cov_0.906977_g72063_i0 PRJEB83711 72329 245 0.906977 2.22209365 Bacteria 2 Bacteria Bacteria 140 1.21e-36   NR HCF25896.1 2055787 g72063 i0 82.7 3.96734693877551 81 14 99.2 0 2 244 746 826 HCF25896.1 type I secretion system permease/ATPase [Cyanobacteria bacterium UBA11049] diamond 972 140 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium UBA11049
29244916 29244916 PRJEB83711_P_NODE_59629_length_252_cov_0.871508_g59363_i0 PRJEB83711 59629 252 0.871508 2.19620016 Stenomitos sp. 3088177 Bacteria Bacteria 110 4.47e-29   NR HEY9856164.1 3088177 g59363 i0 60 2.89285714285714 80 32 95.2 0 2 241 41 120 HEY9856164.1 glycine cleavage system protein GcvH [Stenomitos sp.] diamond 729 110 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Stenomitos Stenomitos sp.
29307966 29307966 PRJEB83711_P_NODE_59989_length_252_cov_0.871508_g59723_i0 PRJEB83711 59989 252 0.871508 2.19620016 Candidatus Gastranaerophilales bacterium 2137880 Bacteria Bacteria 100 1.88e-22   NR MCD7780448.1 2137880 g59723 i0 70.1 1.5952380952381 67 20 79.8 0 3 203 535 601 MCD7780448.1 ABC transporter ATP-binding protein/permease [Candidatus Gastranaerophilales bacterium] diamond 402 100 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Gastranaerophilales     Candidatus Gastranaerophilales bacterium
29402741 29402741 PRJEB83711_P_NODE_23449_length_367_cov_1.258503_g23183_i0 PRJEB83711 23449 367 1.258503 4.61870601 Richelia intracellularis HH 1164990 Bacteria Bacteria 173 8.249999999999999e-54   NR CCH68009.1 1165094 g23183 i0 97.6 0.686648501362398 84 2 68.7 0 2 253 9 92 CCH68009.1 hypothetical protein RINTHH_18540 [Richelia intracellularis HH01] diamond 252 173 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Richelia Richelia intracellularis
29402754 29402754 PRJEB83711_P_NODE_74789_length_244_cov_0.912281_g74523_i0 PRJEB83711 74789 244 0.912281 2.22596564 Iningainema tapete 2806730 Bacteria Bacteria 128 6.11e-33   NR WP_337907040.1 2806730 g74523 i0 91.3 0.848360655737705 69 6 84.8 0 1 207 414 482 WP_337907040.1 C-terminal helicase domain-containing protein [Iningainema tapete] diamond 207 128 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Scytonemataceae Iningainema Iningainema tapete
29489986 29489986 PRJEB83711_P_NODE_75430_length_244_cov_0.912281_g75164_i0 PRJEB83711 75430 244 0.912281 2.22596564 Cyanophyceae 3028117 Bacteria Bacteria 126 9.86e-34   NR WP_068510605.1 1080068 g75164 i0 76.3 5.9016393442623 80 19 98.4 0 242 3 109 188 WP_068510605.1 YdcF family protein [Leptolyngbya sp. O-77] diamond 1440 127 0.992125984251969 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya Leptolyngbya sp. O-77
29560458 29560458 PRJEB83711_P_NODE_77350_length_243_cov_0.917647_g77084_i0 PRJEB83711 77350 243 0.917647 2.22988221 Leptolyngbyaceae cyanobacterium 3088178 Bacteria Bacteria 83.2 1.22e-18   NR HEY9781053.1 3088178 g77084 i0 76.8 0.691358024691358 56 11 66.7 1 3 164 45 100 HEY9781053.1 YkvA family protein [Leptolyngbyaceae cyanobacterium] diamond 168 83.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae   Leptolyngbyaceae cyanobacterium
29686635 29686635 PRJEB83711_P_NODE_66790_length_248_cov_0.891429_g66524_i0 PRJEB83711 66790 248 0.891429 2.21074392 Chroococcidiopsis sp. CCMEE 29 155894 Bacteria Bacteria 53.9 4.47e-6   NR WP_250125578.1 155894 g66524 i0 77.4 0.737903225806452 31 7 37.5 0 97 5 8 38 WP_250125578.1 anthranilate synthase component I [Chroococcidiopsis sp. CCMEE 29] diamond 183 53.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Chroococcidiopsidaceae Chroococcidiopsis Chroococcidiopsis sp. CCMEE 29
29781615 29781615 PRJEB83711_P_NODE_76511_length_243_cov_0.917647_g76245_i0 PRJEB83711 76511 243 0.917647 2.22988221 Chroococcidiopsis sp. CCALA 3088168 Bacteria Bacteria 149 3.82e-40   NR WP_199197622.1 869949 g76245 i0 90 5.92592592592593 80 8 98.8 0 242 3 27 106 WP_199197622.1 FtsK/SpoIIIE domain-containing protein [Chroococcidiopsis sp. CCALA 051] diamond 1440 149 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Chroococcidiopsidaceae Chroococcidiopsis Chroococcidiopsis sp. CCALA 051
30097420 30097420 PRJEB83711_P_NODE_59512_length_252_cov_0.871508_g59246_i0 PRJEB83711 59512 252 0.871508 2.19620016 Cyanobacteria bacterium P01_C01_bin.89 3023266 Bacteria Bacteria 53.1 1.63e-6   NR MEM6501491.1 3023266 g59246 i0 92 0.892857142857143 25 2 29.8 0 176 250 1 25 MEM6501491.1 VOC family protein [Cyanobacteria bacterium P01_C01_bin.89] diamond 225 53.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium P01_C01_bin.89
30690414 30690414 PRJEB83711_P_NODE_63413_length_250_cov_0.881356_g63147_i0 PRJEB83711 63413 250 0.881356 2.20339 Cyanophyceae 3028117 Bacteria Bacteria 134 2.99e-36   NR MBW4472975.1 1382958 g63147 i0 75.6 15.744 82 20 98.4 0 4 249 88 169 MBW4472975.1 histone deacetylase [Stenomitos rutilans HA7619-LM2] diamond 3936 135 0.992592592592593 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Stenomitos Stenomitos rutilans
30697758 30697758 PRJEB83711_P_NODE_77054_length_243_cov_0.917647_g76788_i0 PRJEB83711 77054 243 0.917647 2.22988221 Aliterella atlantica 1827278 Bacteria Bacteria 164 1.1399999999999999e-46   NR WP_045054641.1 1827278 g76788 i0 97.5 0.987654320987654 80 2 98.8 0 3 242 115 194 WP_045054641.1 glycosyltransferase family 4 protein [Aliterella atlantica] diamond 240 164 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Aliterellaceae Aliterella Aliterella atlantica
30950809 30950809 PRJEB83711_P_NODE_79274_length_242_cov_0.923077_g79008_i0 PRJEB83711 79274 242 0.923077 2.23384634 Cyanobacteria bacterium UBA11049 2055787 Bacteria Bacteria 79 6.38e-15   NR HCF30408.1 2055787 g79008 i0 78.6 0.520661157024793 42 9 52.1 0 117 242 1 42 HCF30408.1 4-amino-4-deoxy-L-arabinose transferase [Cyanobacteria bacterium UBA11049] diamond 126 79 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium UBA11049
30982363 30982363 PRJEB83711_P_NODE_61914_length_251_cov_0.876404_g61648_i0 PRJEB83711 61914 251 0.876404 2.19977404 Chroococcidiopsis sp. [FACHB-1243] 2692781 Bacteria Bacteria 164 1.55e-45   NR WP_192157562.1 2692781 g61648 i0 96.4 0.99203187250996006 83 3 99.2 0 1 249 497 579 WP_192157562.1 penicillin-binding protein 2 [Chroococcidiopsis sp. [FACHB-1243]] diamond 249 164 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Chroococcidiopsidaceae Chroococcidiopsis Chroococcidiopsis sp. [FACHB-1243]
31013790 31013790 PRJEB83711_P_NODE_71495_length_246_cov_0.901734_g71229_i0 PRJEB83711 71495 246 0.901734 2.21826564 Chroococcidiopsis sp. CCMEE 29 155894 Bacteria Bacteria 100 1.22e-22   NR WP_346016647.1 155894 g71229 i0 74.7 0.914634146341463 75 19 91.5 0 225 1 5 79 WP_346016647.1 efflux RND transporter periplasmic adaptor subunit [Chroococcidiopsis sp. CCMEE 29] diamond 225 100 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Chroococcidiopsidaceae Chroococcidiopsis Chroococcidiopsis sp. CCMEE 29
31077129 31077129 PRJEB83711_P_NODE_45675_length_276_cov_1.039409_g45409_i0 PRJEB83711 45675 276 1.039409 2.86876884 Candidatus Gastranaerophilales bacterium 2137880 Bacteria Bacteria 163 3.3699999999999998e-46   NR MDD3237458.1 2137880 g45409 i0 85.9 1 92 13 100 0 276 1 169 260 MDD3237458.1 trigger factor [Candidatus Gastranaerophilales bacterium] diamond 276 163 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Gastranaerophilales     Candidatus Gastranaerophilales bacterium
32279146 32279146 PRJEB83711_P_NODE_61579_length_251_cov_0.876404_g61313_i0 PRJEB83711 61579 251 0.876404 2.19977404 Myxosarcina sp. GI1 1541065 Bacteria Bacteria 149 1.7e-40   NR WP_036477786.1 1541065 g61313 i0 90.4 1.9840637450199201 83 8 99.2 0 249 1 254 336 WP_036477786.1 DUF2079 domain-containing protein [Myxosarcina sp. GI1] diamond 498 149 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pleurocapsales Hyellaceae Myxosarcina Myxosarcina sp. GI1

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