RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA812001" and tax_phylum = "Cyanobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cyanobacteriota · 16 ✖

tax_kingdom 1

bioproject 1

  • PRJNA812001 · 16 ✖

analysis 1

  • diamond · 16 ✖
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
2086323 2086323 PRJNA812001_P_NODE_34402_length_323_cov_1.576000_g34156_i0 PRJNA812001 34402 323 1.576 5.09048 Oculatellaceae cyanobacterium 3088181 Bacteria Bacteria 185 1.17e-53   NR HEY9759752.1 3088181 g34156 i0 90.7 0.993808049535604 107 10 99.4 0 2 322 335 441 HEY9759752.1 IS66 family transposase [Oculatellaceae cyanobacterium] diamond 321 185 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oculatellales Oculatellaceae   Oculatellaceae cyanobacterium
9738906 9738906 PRJNA812001_P_NODE_5348_length_670_cov_1.941374_g5112_i0 PRJNA812001 5348 670 1.941374 13.0072058 Leptolyngbyaceae cyanobacterium 3088178 Bacteria Bacteria 193 1.28e-59   NR HEY9781411.1 3088178 g5112 i0 96.9 0.434328358208955 97 3 43.4 0 215 505 29 125 HEY9781411.1 hypothetical protein [Leptolyngbyaceae cyanobacterium] diamond 291 193 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae   Leptolyngbyaceae cyanobacterium
11014783 11014783 PRJNA812001_P_NODE_60769_length_274_cov_1.532338_g60523_i0 PRJNA812001 60769 274 1.532338 4.19860612 Synechocystis sp. PCC 75 1143 Bacteria Bacteria 181 3.2899999999999997e-56   NR WP_009634242.1 927677 g60523 i0 100 0.996350364963504 91 0 99.6 0 273 1 89 179 WP_009634242.1 50S ribosomal protein L6 [Synechocystis sp. PCC 7509] diamond 273 181 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Merismopediaceae Synechocystis Synechocystis sp. PCC 7509
13564008 13564008 PRJNA812001_P_NODE_14651_length_422_cov_21.839542_g14405_i0 PRJNA812001 14651 422 21.839542 92.16286724 Oculatellaceae cyanobacterium 3088181 Bacteria Bacteria 233 1.87e-75   NR HEY9760471.1 3088181 g14405 i0 92.7 0.874407582938389 123 9 87.4 0 370 2 1 123 HEY9760471.1 sigma-70 family RNA polymerase sigma factor [Oculatellaceae cyanobacterium] diamond 369 233 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oculatellales Oculatellaceae   Oculatellaceae cyanobacterium
16112739 16112739 PRJNA812001_P_NODE_1213_length_1318_cov_2.782329_g1061_i0 PRJNA812001 1213 1318 2.782329 36.67109622 Oculatellaceae cyanobacterium 3088181 Bacteria Bacteria 400 1.71e-127   NR HEY9756366.1 3088181 g1061 i0 98.1 0.475720789074355 209 4 47.6 0 1256 630 511 719 HEY9756366.1 ATP-dependent chaperone ClpB [Oculatellaceae cyanobacterium] diamond 627 400 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oculatellales Oculatellaceae   Oculatellaceae cyanobacterium
27243899 27243899 PRJNA812001_P_NODE_119083_length_244_cov_0.888889_g118837_i0 PRJNA812001 119083 244 0.888889 2.16888916 Planktothrix agardhii 1160 Bacteria Bacteria 123 5.09e-33   NR WP_027250391.1 1160 g118837 i0 85.1 0.823770491803279 67 10 82.4 0 205 5 1 67 WP_027250391.1 hypothetical protein [Planktothrix agardhii] diamond 201 123 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Planktothrix Planktothrix agardhii
27875459 27875459 PRJNA812001_P_NODE_44145_length_301_cov_1.245614_g43899_i0 PRJNA812001 44145 301 1.245614 3.74929814 Oculatellaceae cyanobacterium 3088181 Bacteria Bacteria 142 2.69e-39   NR HEY9683963.1 3088181 g43899 i0 79.8 0.837209302325581 84 17 83.7 0 2 253 231 314 HEY9683963.1 M50 family metallopeptidase [Oculatellaceae cyanobacterium] diamond 252 142 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oculatellales Oculatellaceae   Oculatellaceae cyanobacterium
29517270 29517270 PRJNA812001_P_NODE_136190_length_234_cov_3.142857_g135944_i0 PRJNA812001 136190 234 3.142857 7.35428538 Oculatellaceae cyanobacterium 3088181 Bacteria Bacteria 92.4 1.02e-19   NR HEY9754461.1 3088181 g135944 i0 88.9 0.692307692307692 54 6 69.2 0 232 71 367 420 HEY9754461.1 glutamate formimidoyltransferase [Oculatellaceae cyanobacterium] diamond 162 92.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oculatellales Oculatellaceae   Oculatellaceae cyanobacterium
29548769 29548769 PRJNA812001_P_NODE_110950_length_245_cov_0.895349_g110704_i0 PRJNA812001 110950 245 0.895349 2.19360505 Microcoleus sp. FACHB-672 2692825 Bacteria Bacteria 71.2 1.87e-12   NR WP_416361002.1 2692825 g110704 i0 73.1 0.636734693877551 52 14 63.7 0 88 243 3 54 WP_416361002.1 tetratricopeptide repeat protein [Microcoleus sp. FACHB-672] diamond 156 71.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Microcoleus Microcoleus sp. FACHB-672
29864706 29864706 PRJNA812001_P_NODE_54651_length_283_cov_1.100000_g54405_i0 PRJNA812001 54651 283 1.1 3.113 Oculatellaceae cyanobacterium 3088181 Bacteria Bacteria 165 4.5e-46   NR HEY9754461.1 3088181 g54405 i0 91.1 0.954063604240283 90 8 95.4 0 1 270 126 215 HEY9754461.1 glutamate formimidoyltransferase [Oculatellaceae cyanobacterium] diamond 270 165 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oculatellales Oculatellaceae   Oculatellaceae cyanobacterium
30022861 30022861 PRJNA812001_P_NODE_134311_length_241_cov_0.916667_g134065_i0 PRJNA812001 134311 241 0.916667 2.20916747 Gloeocapsa sp. UFS-A4-WI-NPMV-4B04 2839657 Bacteria Bacteria 141 8.17e-37   NR MBW4640620.1 2839657 g134065 i0 93.7 0.983402489626556 79 5 98.3 0 3 239 660 738 MBW4640620.1 efflux RND transporter permease subunit [Gloeocapsa sp. UFS-A4-WI-NPMV-4B04] diamond 237 141 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Chroococcaceae Gloeocapsa Gloeocapsa sp. UFS-A4-WI-NPMV-4B04
30117334 30117334 PRJNA812001_P_NODE_117872_length_244_cov_0.900585_g117626_i0 PRJNA812001 117872 244 0.900585 2.1974274 unclassified Thermosynechococcus 2622553 Bacteria Bacteria 132 4.429999999999999e-35   NR WP_297050360.1 2622553 g117626 i0 80.8 1.91803278688525 78 15 95.9 0 3 236 180 257 WP_297050360.1 MULTISPECIES: response regulator [unclassified Thermosynechococcus] diamond 468 132 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Acaryochloridales Thermosynechococcaceae Thermosynechococcus  
30433790 30433790 PRJNA812001_P_NODE_57053_length_279_cov_1.689320_g56807_i0 PRJNA812001 57053 279 1.68932 4.7132028 Oculatellaceae cyanobacterium 3088181 Bacteria Bacteria 111 3.88e-26   NR HEY9754461.1 3088181 g56807 i0 84.5 0.763440860215054 71 11 76.3 0 1 213 499 569 HEY9754461.1 glutamate formimidoyltransferase [Oculatellaceae cyanobacterium] diamond 213 111 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oculatellales Oculatellaceae   Oculatellaceae cyanobacterium
30780949 30780949 PRJNA812001_P_NODE_30754_length_333_cov_2.050000_g30508_i0 PRJNA812001 30754 333 2.05 6.8265 Oculatellaceae cyanobacterium 3088181 Bacteria Bacteria 194 1.42e-56   NR HEY9754461.1 3088181 g30508 i0 96 0.900900900900901 100 4 90.1 0 302 3 1 100 HEY9754461.1 glutamate formimidoyltransferase [Oculatellaceae cyanobacterium] diamond 300 194 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oculatellales Oculatellaceae   Oculatellaceae cyanobacterium
30780951 30780951 PRJNA812001_P_NODE_53714_length_284_cov_1.312796_g53468_i0 PRJNA812001 53714 284 1.312796 3.72834064 Anabaena sp. PCC 71 1167 Bacteria Bacteria 60.8 2.54e-8   NR WP_016952950.1 163908 g53468 i0 55.7 0.644366197183099 61 27 64.4 0 282 100 180 240 WP_016952950.1 HlyD family secretion protein [Anabaena sp. PCC 7108] diamond 183 60.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Anabaena Anabaena sp. PCC 7108
31887479 31887479 PRJNA812001_P_NODE_9397_length_510_cov_2.135011_g9151_i0 PRJNA812001 9397 510 2.135011 10.8885561 Oculatellaceae cyanobacterium 3088181 Bacteria Bacteria 267 7.6e-87   NR HEY9683963.1 3088181 g9151 i0 78.4 0.982352941176471 167 36 98.2 0 5 505 45 211 HEY9683963.1 M50 family metallopeptidase [Oculatellaceae cyanobacterium] diamond 501 267 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oculatellales Oculatellaceae   Oculatellaceae cyanobacterium

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