RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA795983 · 19 ✖

analysis 1

  • diamond · 19 ✖
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
10984008 10984008 PRJNA795983_S_NODE_21149_length_302_cov_1.152838_g21024_i0 PRJNA795983 21149 302 1.152838 3.48157076 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 186 3.77e-58   NR MBX9724270.1 2364082 g21024 i0 91 1.98675496688742 100 9 99.3 0 301 2 71 170 MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium] diamond 600 186 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
16082779 16082779 PRJNA795983_S_NODE_4893_length_505_cov_2.145833_g4769_i0 PRJNA795983 4893 505 2.145833 10.83645665 Cyanobium sp. ARS6 2024869 Bacteria Bacteria 219 8.01e-70   NR CAI8350359.1 2024869 g4769 i0 70.3 2.63762376237624 148 44 87.9 0 475 32 46 193 CAI8350359.1 MAG: Nucleoside diphosphate kinase [Cyanobium sp. ARS6] diamond 1332 219 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Prochlorococcaceae Cyanobium Cyanobium sp. ARS6
27338404 27338404 PRJNA795983_S_NODE_43783_length_235_cov_2.820988_g43658_i0 PRJNA795983 43783 235 2.820988 6.6293218 Rivularia sp. MS3 3012223 Bacteria Bacteria 51.2 3.53e-5   NR MBV6624128.1 3012223 g43658 i0 40 0.893617021276596 70 40 89.4 1 25 234 36 103 MBV6624128.1 DUF4114 domain-containing protein [Rivularia sp. MS3] diamond 210 51.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Rivulariaceae Rivularia Rivularia sp. MS3
27884219 27884219 PRJNA795983_S_NODE_37345_length_249_cov_0.875000_g37220_i0 PRJNA795983 37345 249 0.875 2.17875 Cyanophyceae 3028117 Bacteria Bacteria 61.6 7.21e-9   NR MBC6420387.1 2653674 g37220 i0 57.1 11.3253012048193 49 21 59 0 147 1 175 223 MBC6420387.1 NAD(+) kinase [Hormoscilla sp. SP12CHS1] diamond 2820 62 0.993548387096774 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Gomontiellales Gomontiellaceae Hormoscilla Hormoscilla sp. SP12CHS1
28443615 28443615 PRJNA795983_S_NODE_19286_length_311_cov_1.693277_g19161_i0 PRJNA795983 19286 311 1.693277 5.26609147 Nostoc sphaeroides 446679 Bacteria Bacteria 53.1 1.75e-5   NR WP_118171756.1 446679 g19161 i0 37.4 0.877813504823151 91 53 87.8 1 27 299 220 306 WP_118171756.1 cytochrome P450 [Nostoc sphaeroides] diamond 273 53.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sphaeroides
28538378 28538378 PRJNA795983_S_NODE_20767_length_304_cov_0.982684_g20642_i0 PRJNA795983 20767 304 0.982684 2.98735936 Synechococcus sp. MIT S9451 3082543 Bacteria Bacteria 80.9 3.16e-15   NR WP_413744073.1 3082543 g20642 i0 57.5 2.15131578947368 73 28 72 1 221 3 1816 1885 WP_413744073.1 cadherin-like domain-containing protein [Synechococcus sp. MIT S9451] diamond 654 80.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae Synechococcus Synechococcus sp. MIT S9451
28569661 28569661 PRJNA795983_S_NODE_38807_length_246_cov_2.560694_g38682_i0 PRJNA795983 38807 246 2.560694 6.29930724 uncultured Synechococcus sp. 154535 Bacteria Bacteria 158 4.5599999999999985e-43   NR WP_288916497.1 154535 g38682 i0 96.3 2.96341463414634 81 3 98.8 0 2 244 576 656 WP_288916497.1 30S ribosomal protein S12 [uncultured Synechococcus sp.] diamond 729 158 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae Synechococcus uncultured Synechococcus sp.
28862918 28862918 PRJNA795983_S_NODE_44368_length_229_cov_2.576923_g44243_i0 PRJNA795983 44368 229 2.576923 5.90115367 Calothrix 1186 Bacteria Bacteria 55.1 1.38e-6   NR BAY80701.1 1973488 g44243 i0 37.7 7.46724890829694 69 38 83.8 1 192 1 45 113 BAY80701.1 dehydrogenase containing FAD binding domain protein [Calothrix parasitica NIES-267] diamond 1710 55.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Calotrichaceae Calothrix Calothrix parasitica
29959028 29959028 PRJNA795983_S_NODE_35611_length_251_cov_1.893258_g35486_i0 PRJNA795983 35611 251 1.893258 4.75207758 Candidatus Obscuribacter sp. 2711154 Bacteria Bacteria 64.7 1.52e-10   NR MBL8086383.1 2711154 g35486 i0 56.7 0.800796812749004 67 21 80.1 2 50 250 61 119 MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.] diamond 201 64.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales Candidatus Obscuribacteraceae Candidatus Obscuribacter Candidatus Obscuribacter sp.
30211637 30211637 PRJNA795983_S_NODE_9152_length_401_cov_1.341463_g9027_i0 PRJNA795983 9152 401 1.341463 5.37926663 Okeania sp. SIO2C9 2607791 Bacteria Bacteria 63.2 1.36e-8   NR WP_293154749.1 2607791 g9027 i0 33.9 0.860349127182045 115 72 86 1 6 350 68 178 WP_293154749.1 glycosyltransferase family 4 protein [Okeania sp. SIO2C9] diamond 345 63.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Okeania Okeania sp. SIO2C9
30401840 30401840 PRJNA795983_S_NODE_20333_length_306_cov_1.150215_g20208_i0 PRJNA795983 20333 306 1.150215 3.5196579 Coleofasciculaceae cyanobacterium SM2_3_26 2720472 Bacteria Bacteria 43.1 0.0413   NR NJK27803.1 2720472 g20208 i0 58.6 0.284313725490196 29 12 28.4 0 229 143 178 206 NJK27803.1 CHAD domain-containing protein [Coleofasciculaceae cyanobacterium SM2_3_26] diamond 87 43.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Coleofasciculales Coleofasciculaceae   Coleofasciculaceae cyanobacterium SM2_3_26
31285992 31285992 PRJNA795983_S_NODE_14415_length_342_cov_1.572491_g14290_i0 PRJNA795983 14415 342 1.572491 5.37791922 Leptolyngbyaceae cyanobacterium JSC-12 864702 Bacteria Bacteria 92.8 3.02e-19   NR EKQ68290.1 864702 g14290 i0 37.3 0.964912280701754 110 65 96.5 1 3 332 287 392 EKQ68290.1 NAD-dependent aldehyde dehydrogenase [Leptolyngbyaceae cyanobacterium JSC-12] diamond 330 92.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae   Leptolyngbyaceae cyanobacterium JSC-12
31760525 31760525 PRJNA795983_S_NODE_31437_length_263_cov_1.621053_g31312_i0 PRJNA795983 31437 263 1.621053 4.26336939 Oculatellaceae cyanobacterium Prado106 2929566 Bacteria Bacteria 60.8 2.06e-8   NR MCU0566371.1 2929566 g31312 i0 43 0.901140684410646 79 42 90.1 2 242 6 1175 1250 MCU0566371.1 DUF4347 domain-containing protein [Oculatellaceae cyanobacterium Prado106] diamond 237 60.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oculatellales Oculatellaceae   Oculatellaceae cyanobacterium Prado106
31792007 31792007 PRJNA795983_S_NODE_8817_length_406_cov_2.048048_g8692_i0 PRJNA795983 8817 406 2.048048 8.31507488 Limnospira platensis 118562 Bacteria Bacteria 211 5.11e-68   NR MDV7395947.1 3080829 g8692 i0 84.7 0.87192118226601 118 15 87.2 1 404 51 4 118 MDV7395947.1 citrate/2-methylcitrate synthase [Arthrospira platensis SPKY1] diamond 354 211 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Sirenicapillariaceae Limnospira Limnospira platensis
31918758 31918758 PRJNA795983_S_NODE_37857_length_248_cov_0.880000_g37732_i0 PRJNA795983 37857 248 0.88 2.1824 Scytonema sp. PMC 1069.18 2684455 Bacteria Bacteria 61.2 1.18e-8   NR MEC4814498.1 2684455 g37732 i0 67.3 0.592741935483871 49 16 59.3 0 3 149 164 212 MEC4814498.1 DUF4335 domain-containing protein [Scytonema sp. PMC 1069.18] diamond 147 61.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Scytonemataceae Scytonema Scytonema sp. PMC 1069.18
31950273 31950273 PRJNA795983_S_NODE_12637_length_357_cov_2.140845_g12512_i0 PRJNA795983 12637 357 2.140845 7.64281665 Cyanobacteria bacterium J06582_2 3023143 Bacteria Bacteria 45.1 0.02   NR MEL7079402.1 3023143 g12512 i0 32.5 1.77310924369748 83 45 60.5 2 6 221 229 311 MEL7079402.1 reverse transcriptase domain-containing protein [Cyanobacteria bacterium J06582_2] diamond 633 45.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium J06582_2
31950298 31950298 PRJNA795983_S_NODE_617_length_1129_cov_4.502841_g562_i0 PRJNA795983 617 1129 4.502841 50.83707489 Heteroscytonema crispum 439476 Bacteria Bacteria 348 1.5899999999999998e-113   NR MFH7027526.1 1735366 g562 i0 49.3 8.47121346324181 355 171 91.9 4 6 1043 95 449 MFH7027526.1 DUF6851 domain-containing protein [Heteroscytonema crispum UTEX LB 1556] diamond 9564 348 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Heteroscytonemataceae Heteroscytonema Heteroscytonema crispum
32456821 32456821 PRJNA795983_S_NODE_19459_length_310_cov_1.763713_g19334_i0 PRJNA795983 19459 310 1.763713 5.4675103 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 43.1 0.0472   NR MEB3259607.1 2847862 g19334 i0 38.9 0.52258064516129 54 24 52.3 1 14 175 166 210 MEB3259607.1 phosphoribosylanthranilate isomerase [Cyanobacteriota bacterium] diamond 162 43.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
32465997 32465997 PRJNA795983_S_NODE_29279_length_270_cov_1.441624_g29154_i0 PRJNA795983 29279 270 1.441624 3.8923848 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 45.4 0.00574   NR MCC5645442.1 2780402 g29154 i0 44.1 1.51111111111111 59 22 53.3 2 124 267 147 205 MCC5645442.1 hypothetical protein [Nostoc sp. CHAB 5824] diamond 408 45.8 0.991266375545852 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. CHAB 5824

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