RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA797475" 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

  • PRJNA797475 · 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
27717711 27717711 PRJNA797475_P_NODE_16224_length_277_cov_1.509804_g16125_i0 PRJNA797475 16224 277 1.509804 4.18215708 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 44.7 0.0125   NR MEB3260244.1 2847862 g16125 i0 36.8 0.823104693140794 76 44 80.1 2 55 276 2404 2477 MEB3260244.1 amino acid adenylation domain-containing protein [Cyanobacteriota bacterium] diamond 228 44.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
29138383 29138383 PRJNA797475_P_NODE_23809_length_248_cov_1.760000_g23710_i0 PRJNA797475 23809 248 1.76 4.3648 Pseudanabaena cinerea 2661616 Bacteria Bacteria 50.4 4.65e-6   NR WP_199302249.1 2661616 g23710 i0 36.5 0.762096774193548 63 40 76.2 0 246 58 6 68 WP_199302249.1 tetratricopeptide repeat protein [Pseudanabaena cinerea] diamond 189 50.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pseudanabaenales Pseudanabaenaceae Pseudanabaena Pseudanabaena cinerea
29485180 29485180 PRJNA797475_P_NODE_25910_length_246_cov_0.890173_g25811_i0 PRJNA797475 25910 246 0.890173 2.18982558 Coleofasciculus sp. LEGE 3100458 Bacteria Bacteria 116 1.18e-28   NR WP_193933289.1 2777969 g25811 i0 68.2 2.08536585365854 85 23 98.8 1 2 244 196 280 WP_193933289.1 MFS transporter, partial [Coleofasciculus sp. LEGE 07092] diamond 513 116 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Coleofasciculales Coleofasciculaceae Coleofasciculus Coleofasciculus sp. LEGE 07092
29611420 29611420 PRJNA797475_P_NODE_25210_length_247_cov_0.885057_g25111_i0 PRJNA797475 25210 247 0.885057 2.18609079 Chroococcidiopsis sp. CCMEE 29 155894 Bacteria Bacteria 147 3.909999999999999e-41   NR WP_250125609.1 155894 g25111 i0 95.1 9.95951417004049 82 4 99.6 0 2 247 55 136 WP_250125609.1 aspartate carbamoyltransferase catalytic subunit [Chroococcidiopsis sp. CCMEE 29] diamond 2460 147 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcidiopsidales Chroococcidiopsidaceae Chroococcidiopsis Chroococcidiopsis sp. CCMEE 29
31485309 31485309 PRJNA797475_P_NODE_30996_length_228_cov_4.232258_g30897_i0 PRJNA797475 30996 228 4.232258 9.64954824 Bacteria 2 Bacteria Bacteria 63.2 1.93e-9   NR WP_124971646.1 1122 g30897 i0 50.9 1.89473684210526 57 28 75 0 56 226 16 72 WP_124971646.1 aminomethyl-transferring glycine dehydrogenase [Aphanothece sacrum] diamond 432 63.5 0.995275590551181 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Chroococcales Aphanothecaceae Aphanothece Aphanothece sacrum
32709067 32709067 PRJNA797475_P_NODE_29960_length_241_cov_0.916667_g29861_i0 PRJNA797475 29960 241 0.916667 2.20916747 Acaryochloris sp. IP29b_bin.148 2969218 Bacteria Bacteria 125 3.7099999999999997e-34   NR WP_299411010.1 2969218 g29861 i0 73.4 0.983402489626556 79 21 98.3 0 3 239 83 161 WP_299411010.1 RICIN domain-containing protein [Acaryochloris sp. IP29b_bin.148] diamond 237 125 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Acaryochloridales Acaryochloridaceae Acaryochloris Acaryochloris sp. IP29b_bin.148

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