RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA473201" and tax_phylum = "Cyanobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cyanobacteriota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA473201 · 6 ✖

analysis 1

  • diamond · 6 ✖
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
30044486 30044486 PRJNA473201_P_NODE_81031_length_243_cov_0.905882_g80289_i0 PRJNA473201 81031 243 0.905882 2.20129326 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 82.4 2.65e-16   NR MEB3301815.1 2847862 g80289 i0 56 0.925925925925926 75 32 91.4 1 242 21 218 292 MEB3301815.1 hypothetical protein [Cyanobacteriota bacterium] diamond 225 82.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
30834451 30834451 PRJNA473201_P_NODE_32034_length_350_cov_1.079422_g31292_i0 PRJNA473201 32034 350 1.079422 3.777977 Kaiparowitsia implicata 2303525 Bacteria Bacteria 79 2.67e-14   NR MBW4655182.1 2057771 g31292 i0 43.4 1.90285714285714 113 61 96 3 1 336 352 462 MBW4655182.1 hypothetical protein [Kaiparowitsia implicata GSE-PSE-MK54-09C] diamond 666 79 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oculatellales Oculatellaceae Kaiparowitsia Kaiparowitsia implicata
30897800 30897800 PRJNA473201_P_NODE_69834_length_249_cov_0.875000_g69092_i0 PRJNA473201 69834 249 0.875 2.17875 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 146 1.72e-41   NR MBX9693802.1 2847862 g69092 i0 90.2 1.97590361445783 82 8 98.8 0 247 2 49 130 MBX9693802.1 mannose-1-phosphate guanylyltransferase [Cyanobacteriota bacterium] diamond 492 146 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
31814584 31814584 PRJNA473201_P_NODE_82377_length_242_cov_1.804734_g81635_i0 PRJNA473201 82377 242 1.804734 4.36745628 Leptolyngbya ectocarpi 1202 Bacteria Bacteria 50.1 9.37e-5   NR WP_193993377.1 1202 g81635 i0 38.2 1.40082644628099 55 24 68.2 1 7 171 405 449 WP_193993377.1 hypothetical protein [Leptolyngbya ectocarpi] diamond 339 50.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya Leptolyngbya ectocarpi
32115641 32115641 PRJNA473201_P_NODE_22978_length_411_cov_1.366864_g22236_i0 PRJNA473201 22978 411 1.366864 5.61781104 Bacteria 2 Bacteria Bacteria 67.8 9.33e-12   NR WP_106290132.1 292586 g22236 i0 54.8 0.883211678832117 62 28 45.3 0 188 3 37 98 WP_106290132.1 hypothetical protein [Merismopedia glauca] diamond 363 67.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Merismopediaceae Merismopedia Merismopedia glauca
32605434 32605434 PRJNA473201_P_NODE_86040_length_241_cov_0.910714_g85298_i0 PRJNA473201 86040 241 0.910714 2.19482074 Drouetiella sp. 3088174 Bacteria Bacteria 137 2.5599999999999996e-35   NR HEY9677651.1 3088174 g85298 i0 77.5 1.99170124481328 80 18 99.6 0 241 2 500 579 HEY9677651.1 hypothetical protein [Drouetiella sp.] diamond 480 137 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oculatellales Oculatellaceae Drouetiella Drouetiella sp.

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