RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA436017" and tax_phylum = "Cyanobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cyanobacteriota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJNA436017 · 8 ✖

analysis 1

  • diamond · 8 ✖
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
22107567 22107567 PRJNA436017_P_NODE_5378_length_391_cov_1.567797_g5082_i0 PRJNA436017 5378 391 1.567797 6.13008627 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 94.7 3.9200000000000006e-21   NR MBX9690859.1 2847862 g5082 i0 40 0.997442455242967 130 70 99.7 2 2 391 86 207 MBX9690859.1 AMP-binding protein [Cyanobacteriota bacterium] diamond 390 94.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
27771023 27771023 PRJNA436017_P_NODE_9324_length_285_cov_0.935484_g9026_i0 PRJNA436017 9324 285 0.935484 2.6661294 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 113 5.13e-28   NR MBX9694561.1 2847862 g9026 i0 70.2 0.884210526315789 84 21 84.2 1 240 1 15 98 MBX9694561.1 hypothetical protein [Cyanobacteriota bacterium] diamond 252 113 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
28370632 28370632 PRJNA436017_P_NODE_16346_length_204_cov_1.341317_g16048_i0 PRJNA436017 16346 204 1.341317 2.73628668 Richelia intracellularis 1164990 Bacteria Bacteria 58.5 5.1e-9   NR CDN15762.1 1164990 g16048 i0 66.7 1.20588235294118 42 14 61.8 0 198 73 4 45 CDN15762.1 hypothetical protein RintRC_0033 [Richelia intracellularis] diamond 246 58.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Richelia Richelia intracellularis
29934472 29934472 PRJNA436017_P_NODE_25651_length_161_cov_1.258065_g25353_i0 PRJNA436017 25651 161 1.258065 2.02548465 Cyanophyceae 3028117 Bacteria Bacteria 80.1 7.96e-16   NR WP_036536179.1 1501145 g25353 i0 69.8 5.92546583850932 53 16 98.8 0 161 3 351 403 WP_036536179.1 glutamate synthase subunit beta [Neosynechococcus sphagnicola] diamond 954 80.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Neosynechococcales Neosynechococcaceae Neosynechococcus Neosynechococcus sphagnicola
30044170 30044170 PRJNA436017_P_NODE_29731_length_150_cov_1.035398_g29433_i0 PRJNA436017 29731 150 1.035398 1.553097 Cyanobacteria bacterium P01_H01_bin.152 3023315 Bacteria Bacteria 72 4.82e-13   NR MEM1278527.1 3023315 g29433 i0 60.4 2.84 48 19 96 0 149 6 556 603 MEM1278527.1 glycoside hydrolase family 19 protein [Cyanobacteria bacterium P01_H01_bin.152] diamond 426 72 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteria bacterium P01_H01_bin.152
30297523 30297523 PRJNA436017_P_NODE_21952_length_174_cov_2.255474_g21654_i0 PRJNA436017 21952 174 2.255474 3.92452476 Nostocales cyanobacterium ELA608 3064516 Bacteria Bacteria 45.1 0.00148   NR MEI6371987.1 3064516 g21654 i0 40.4 0.982758620689655 57 34 98.3 0 172 2 15 71 MEI6371987.1 NADH-quinone oxidoreductase subunit C [Nostocales cyanobacterium ELA608] diamond 171 45.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales     Nostocales cyanobacterium ELA608
31292912 31292912 PRJNA436017_P_NODE_27695_length_155_cov_1.322034_g27397_i0 PRJNA436017 27695 155 1.322034 2.0491527 Cyanophyceae 3028117 Bacteria Bacteria 43.9 0.00443   NR OAB62278.1 322866 g27397 i0 47.5 2.36129032258065 40 21 77.4 0 20 139 634 673 OAB62278.1 hypothetical protein AY599_10795 [Leptolyngbya valderiana BDU 20041] diamond 366 43.9 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya Leptolyngbya valderiana
32098942 32098942 PRJNA436017_P_NODE_24418_length_165_cov_1.375000_g24120_i0 PRJNA436017 24418 165 1.375 2.26875 Nostoc sp. CHAB 5715 2780400 Bacteria Bacteria 48.1 1.47e-4   NR WP_229458700.1 2780400 g24120 i0 87.5 0.436363636363636 24 3 43.6 0 74 3 1 24 WP_229458700.1 hypothetical protein [Nostoc sp. CHAB 5715] diamond 72 48.1 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Nostocaceae Nostoc Nostoc sp. CHAB 5715

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