RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJEB83101" and tax_phylum = "Myxococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Myxococcota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJEB83101 · 6 ✖

analysis 1

  • blastn · 6 ✖

tax_clade 0

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
142570 142570 PRJEB83101_P_NODE_66121_length_252_cov_2.692737_g65816_i0 PRJEB83101 66121 252 2.692737 6.78569724 Archangium violaceum 83451 Bacteria Bacteria 69.4 2.27e-7   NTclustered gi|1981856374|gb|CP069338.1| 83451 g65816 i0 91.837 0.353174603174603 49 4 19 0 38 86 472842 472890 Archangium violaceum strain SDU34 chromosome, complete genome blastn 89 69.4 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Archangiaceae Archangium Archangium violaceum
3968163 3968163 PRJEB83101_P_NODE_45464_length_284_cov_1.473934_g45159_i0 PRJEB83101 45464 284 1.473934 4.18597256 Archangium violaceum 83451 Bacteria Bacteria 475 1.3099999999999999e-129   NTclustered gi|2619762464|gb|CP137851.1| 83451 g45159 i0 97.153 3.21830985915493 281 8 99 0 1 281 10813485 10813765 Archangium violaceum strain KYC5002 chromosome, complete genome blastn 914 475 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Archangiaceae Archangium Archangium violaceum
12896703 12896703 PRJEB83101_P_NODE_89471_length_231_cov_2.626582_g89166_i0 PRJEB83101 89471 231 2.626582 6.06740442 Sorangium cellulosum 56 Bacteria Bacteria 52.8 0.021   NTclustered gi|161158851|emb|AM746676.1| 448385 g89166 i0 100 0.121212121212121 28 0 12 0 62 89 11765760 11765787 Sorangium cellulosum 'So ce 56' complete genome blastn 28 52.8 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae Sorangium Sorangium cellulosum
14170623 14170623 PRJEB83101_P_NODE_50712_length_275_cov_1.262376_g50407_i0 PRJEB83101 50712 275 1.262376 3.471534 Cystobacter fuscus 43 Bacteria Bacteria 436 5.969999999999999e-118   NTclustered gi|2579656172|gb|CP043491.1| 43 g50407 i0 95.273 63.5781818181818 275 13 100 0 1 275 2346309 2346035 Cystobacter fuscus strain Cbf 10 chromosome, complete genome blastn 17484 436 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Archangiaceae Cystobacter Cystobacter fuscus
15444520 15444520 PRJEB83101_P_NODE_42293_length_290_cov_1.437788_g41988_i0 PRJEB83101 42293 290 1.437788 4.1695852 Archangium gephyra 48 Bacteria Bacteria 497 2.8699999999999993e-136   NTclustered gi|2809295724|gb|CP102578.1| 48 g41988 i0 97.586 1 290 7 100 0 1 290 1591295 1591006 Archangium gephyra strain SDU49 chromosome, complete genome blastn 290 497 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Archangiaceae Archangium Archangium gephyra
22675144 22675144 PRJEB83101_P_NODE_84278_length_243_cov_0.917647_g83973_i0 PRJEB83101 84278 243 0.917647 2.22988221 Archangiaceae 39 Bacteria Bacteria 315 2.5299999999999998e-81   NTclustered gi|2579656172|gb|CP043491.1| 43 g83973 i0 90.377 98.0946502057613 239 23 98 0 4 242 7399215 7398977 Cystobacter fuscus strain Cbf 10 chromosome, complete genome blastn 23837 315 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Archangiaceae Cystobacter Cystobacter fuscus

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