RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "blastn", bioproject = "PRJNA1204310" and tax_clade = "Cyanobacteriota/Melainabacteria group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Cyanobacteriota/Melainabacteria group · 13 ✖

bioproject 1

  • PRJNA1204310 · 13 ✖

analysis 1

  • blastn · 13 ✖
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
328847 328847 PRJNA1204310_P_NODE_21961_length_388_cov_2.187302_g21664_i0 PRJNA1204310 21961 388 2.187302 8.48673176 Dolichospermum sp. UHCC 0315A 1914871 Bacteria Bacteria 69.4 3.68e-7   NTclustered gi|1731522919|gb|CP043056.1| 1914871 g21664 i0 95.349 4.74484536082474 43 2 11 0 329 371 2166430 2166388 Dolichospermum sp. UHCC 0315A chromosome, complete genome blastn 1841 69.4 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Nostocales Aphanizomenonaceae Dolichospermum Dolichospermum sp. UHCC 0315A
329545 329545 PRJNA1204310_P_NODE_53461_length_251_cov_0.876404_g53164_i0 PRJNA1204310 53461 251 0.876404 2.19977404 Synechococcus sp. LTW-R 2751170 Bacteria Bacteria 436 5.369999999999999e-118   NTclustered gi|1891299085|gb|CP059060.1| 2751170 g53164 i0 98.008 1 251 5 100 0 1 251 973451 973201 Synechococcus sp. LTW-R chromosome, complete genome blastn 251 436 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae Synechococcus Synechococcus sp. LTW-R
2880621 2880621 PRJNA1204310_P_NODE_59003_length_245_cov_1.732558_g58706_i0 PRJNA1204310 59003 245 1.732558 4.2447671 Prochlorococcus marinus 1219 Bacteria Bacteria 54.7 0.006   NTclustered gi|123199600|gb|CP000552.1| 167542 g58706 i0 100 0.118367346938776 29 0 12 0 203 231 958886 958858 Prochlorococcus marinus str. MIT 9515, complete genome blastn 29 54.7 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Prochlorococcaceae Prochlorococcus Prochlorococcus marinus
6707373 6707373 PRJNA1204310_P_NODE_52386_length_252_cov_0.871508_g52089_i0 PRJNA1204310 52386 252 0.871508 2.19620016 Synechococcus sp. A15-44 1050646 Bacteria Bacteria 377 3.32e-100   NTclustered gi|1895761424|gb|CP047938.1| 1050646 g52089 i0 93.651 2.3015873015873 252 16 100 0 1 252 2189320 2189571 Synechococcus sp. A15-44 chromosome, complete genome blastn 580 377 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae Synechococcus Synechococcus sp. A15-44
9257643 9257643 PRJNA1204310_P_NODE_58248_length_246_cov_0.901734_g57951_i0 PRJNA1204310 58248 246 0.901734 2.21826564 Synechococcus sp. NB0720_010 2907159 Bacteria Bacteria 405 1.48e-108   NTclustered gi|2227925466|gb|CP090898.1| 2907159 g57951 i0 96.341 9.15040650406504 246 9 100 0 1 246 1319777 1320022 Synechococcus sp. NB0720_010 chromosome, complete genome blastn 2251 405 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae Synechococcus Synechococcus sp. NB0720_010
10533471 10533471 PRJNA1204310_P_NODE_55389_length_249_cov_0.886364_g55092_i0 PRJNA1204310 55389 249 0.886364 2.20704636 Synechococcus sp. W4D4 3392294 Bacteria Bacteria 309 1.21e-79   NTclustered gi|2908525189|gb|CP180404.1| 3392294 g55092 i0 89.669 1.94377510040161 242 25 97 0 1 242 1867262 1867503 Synechococcus sp. W4D4 chromosome, complete genome blastn 484 309 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae Synechococcus Synechococcus sp. W4D4
14358629 14358629 PRJNA1204310_P_NODE_55512_length_249_cov_0.886364_g55215_i0 PRJNA1204310 55512 249 0.886364 2.20704636 Synechococcus sp. LTW-R 2751170 Bacteria Bacteria 416 6.939999999999999e-112   NTclustered gi|1891299085|gb|CP059060.1| 2751170 g55215 i0 96.787 1 249 8 100 0 1 249 1421949 1422197 Synechococcus sp. LTW-R chromosome, complete genome blastn 249 416 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae Synechococcus Synechococcus sp. LTW-R
15632512 15632512 PRJNA1204310_P_NODE_57253_length_247_cov_0.896552_g56956_i0 PRJNA1204310 57253 247 0.896552 2.21448344 Synechococcus sp. LTW-R 2751170 Bacteria Bacteria 440 4.079999999999999e-119   NTclustered gi|1891299085|gb|CP059060.1| 2751170 g56956 i0 98.785 6.21862348178138 247 3 100 0 1 247 1507166 1507412 Synechococcus sp. LTW-R chromosome, complete genome blastn 1536 440 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae Synechococcus Synechococcus sp. LTW-R
18180260 18180260 PRJNA1204310_P_NODE_13735_length_477_cov_2.009901_g13438_i0 PRJNA1204310 13735 477 2.009901 9.58722777 Planktothrix sp. GU0601_MAG3 3078749 Bacteria Bacteria 52.8 0.046   NTclustered gi|2643647507|gb|CP136572.1| 3078749 g13438 i0 96.774 0.0649895178197065 31 1 6 0 141 171 1619742 1619772 MAG: Planktothrix sp. GU0601_MAG3 chromosome, complete genome blastn 31 52.8 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Planktothrix Planktothrix sp. GU0601_MAG3
18181431 18181431 PRJNA1204310_P_NODE_8195_length_606_cov_1.530957_g7909_i0 PRJNA1204310 8195 606 1.530957 9.27759942 Microcoleus anatoxicus 2705319 Bacteria Bacteria 93.5 3.54e-14   NTclustered gi|2812421464|gb|CP120853.1| 2705319 g7909 i0 77.114 3.28712871287129 201 20 31 16 392 579 3529853 3530040 MAG: Microcoleus anatoxicus isolate Neu2020_A chromosome, complete genome blastn 1992 93.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Oscillatoriales Microcoleaceae Microcoleus Microcoleus anatoxicus
18896642 18896642 PRJNA1204310_P_NODE_62295_length_242_cov_0.923077_g61998_i0 PRJNA1204310 62295 242 0.923077 2.23384634 Synechococcus 1129 Bacteria Bacteria 326 1.16e-84   NTclustered gi|2227925466|gb|CP090898.1| 2907159 g61998 i0 90.909 4.87603305785124 242 22 100 0 1 242 2094918 2095159 Synechococcus sp. NB0720_010 chromosome, complete genome blastn 1180 326 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae Synechococcus Synechococcus sp. NB0720_010
20171260 20171260 PRJNA1204310_P_NODE_31676_length_331_cov_1.782946_g31379_i0 PRJNA1204310 31676 331 1.782946 5.90155126 Synechococcus 1129 Bacteria Bacteria 56.5 0.002   NTclustered gi|147846875|emb|CT971583.1| 32051 g31379 i0 97.059 0.205438066465257 34 0 10 1 54 86 1058717 1058750 Synechococcus WH7803 complete genome sequence blastn 68 56.5 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae Synechococcus Synechococcus sp. WH 7803
23997185 23997185 PRJNA1204310_P_NODE_60339_length_244_cov_0.912281_g60042_i0 PRJNA1204310 60339 244 0.912281 2.22596564 Synechococcus 1129 Bacteria Bacteria 374 4.1399999999999986e-99   NTclustered gi|1891299085|gb|CP059060.1| 2751170 g60042 i0 94.606 2.98770491803279 241 13 99 0 1 241 1724104 1724344 Synechococcus sp. LTW-R chromosome, complete genome blastn 729 374 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Synechococcales Synechococcaceae Synechococcus Synechococcus sp. LTW-R

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