RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1041773 · 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
18860154 18860154 PRJNA1041773_P_NODE_60875_length_278_cov_1.502439_g60542_i0 PRJNA1041773 60875 278 1.502439 4.17678042 Nodosilinea sp. 2497642 Bacteria Bacteria 122 1.68e-30   NR HSM81080.1 2497642 g60542 i0 73.9 8.96762589928058 88 17 88.5 1 265 20 322 409 HSM81080.1 hypothetical protein [Nodosilinea sp.] diamond 2493 122 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nodosilineales Nodosilineaceae Nodosilinea Nodosilinea sp.
26908632 26908632 PRJNA1041773_P_NODE_100702_length_241_cov_0.916667_g100369_i0 PRJNA1041773 100702 241 0.916667 2.20916747 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 145 2.69e-39   NR MDA0772471.1 2847862 g100369 i0 83.8 1.99170124481328 80 13 99.6 0 1 240 62 141 MDA0772471.1 cbb3-type cytochrome c oxidase subunit I [Cyanobacteriota bacterium] diamond 480 145 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
28014565 28014565 PRJNA1041773_P_NODE_84605_length_248_cov_0.880000_g84272_i0 PRJNA1041773 84605 248 0.88 2.1824 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 139 4.4e-36   NR MEY3369634.1 2847862 g84272 i0 81.5 0.979838709677419 81 15 98 0 246 4 931 1011 MEY3369634.1 hypothetical protein [Cyanobacteriota bacterium] diamond 243 139 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
28108924 28108924 PRJNA1041773_P_NODE_101045_length_241_cov_0.916667_g100712_i0 PRJNA1041773 101045 241 0.916667 2.20916747 Cylindrospermopsis raciborskii 77022 Bacteria Bacteria 44.3 7.77e-4   NR WP_161489547.1 77022 g100712 i0 100 0.261410788381743 21 0 26.1 0 185 123 32 52 WP_161489547.1 hypothetical protein [Cylindrospermopsis raciborskii] diamond 63 44.3 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Aphanizomenonaceae Cylindrospermopsis Cylindrospermopsis raciborskii
30058611 30058611 PRJNA1041773_P_NODE_93831_length_244_cov_0.900585_g93498_i0 PRJNA1041773 93831 244 0.900585 2.1974274 Cyanophyceae 3028117 Bacteria Bacteria 92.8 8.73e-20   NR WP_190649315.1 47251 g93498 i0 61 1.84426229508197 77 30 94.7 0 242 12 99 175 WP_190649315.1 MULTISPECIES: protelomerase family protein [Leptolyngbya] diamond 450 92.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Leptolyngbya  
30730275 30730275 PRJNA1041773_P_NODE_103854_length_233_cov_2.212500_g103521_i0 PRJNA1041773 103854 233 2.2125 5.155125 Scytonematopsis contorta 1049027 Bacteria Bacteria 96.7 3.4300000000000004e-21   NR MBW4507940.1 1049028 g103521 i0 54.5 4.95708154506438 77 35 99.1 0 232 2 232 308 MBW4507940.1 prolyl oligopeptidase family serine peptidase [Scytonematopsis contorta HA4267-MV1] diamond 1155 96.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Scytonemataceae Scytonematopsis Scytonematopsis contorta
31449353 31449353 PRJNA1041773_P_NODE_40136_length_334_cov_2.149425_g39803_i0 PRJNA1041773 40136 334 2.149425 7.1790795 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 56.2 1.69e-6   NR NEP52929.1 2607842 g39803 i0 58.1 0.772455089820359 43 18 38.6 0 332 204 1 43 NEP52929.1 tetratricopeptide repeat-containing protein [Moorena sp. SIO3C2] diamond 258 56.6 0.992932862190813 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Coleofasciculales Coleofasciculaceae Moorena Moorena sp. SIO3C2
32596153 32596153 PRJNA1041773_P_NODE_48300_length_307_cov_1.632479_g47967_i0 PRJNA1041773 48300 307 1.632479 5.01171053 Cylindrospermopsis raciborskii 77022 Bacteria Bacteria 213 3.809999999999999e-67   NR WP_240866944.1 77022 g47967 i0 100 0.996742671009772 102 0 99.7 0 1 306 170 271 WP_240866944.1 SDR family oxidoreductase [Cylindrospermopsis raciborskii] diamond 306 213 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Aphanizomenonaceae Cylindrospermopsis Cylindrospermopsis raciborskii

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