RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA1122875" and tax_phylum = "Myxococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Myxococcota · 10 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1122875 · 10 ✖

analysis 1

  • blastn · 10 ✖

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
2828554 2828554 PRJNA1122875_P_NODE_50123_length_244_cov_1.789474_g49899_i0 PRJNA1122875 50123 244 1.789474 4.36631656 Anaeromyxobacter oryzae 2918170 Bacteria Bacteria 89.8 1.68e-13   NTclustered gi|2199265233|dbj|AP025591.1| 2918170 g49899 i0 90.909 0.80327868852459 66 6 27 0 117 182 2587649 2587584 Anaeromyxobacter oryzae DNA, complete genome blastn 196 89.8 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Anaeromyxobacteraceae Anaeromyxobacter Anaeromyxobacter oryzae
7930325 7930325 PRJNA1122875_P_NODE_14027_length_445_cov_1.408602_g13803_i0 PRJNA1122875 14027 445 1.408602 6.2682789 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 243 2.38e-59   NTclustered gi|1950807334|gb|CP066680.1| 2026735 g13803 i0 82.474 133.4 291 37 64 12 69 351 309485 309201 MAG: Deltaproteobacteria bacterium isolate NC_groundwater_69_Ag_B-0.1um_32_21 chromosome blastn 59363 243 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
9205485 9205485 PRJNA1122875_P_NODE_18308_length_390_cov_1.173502_g18084_i0 PRJNA1122875 18308 390 1.173502 4.5766578000000004 Nannocystis punicea 2995304 Bacteria Bacteria 265 4.4e-66   NTclustered gi|2415023655|gb|CP114040.1| 2995304 g18084 i0 79.894 16.9358974358974 378 62 95 14 5 375 5060592 5060222 Nannocystis poenicansa strain FL3 chromosome, complete genome blastn 6605 265 1 Bacteria   Pseudomonadati Myxococcota   Nannocystales Nannocystaceae Nannocystis Nannocystis punicea
11756284 11756284 PRJNA1122875_P_NODE_43450_length_251_cov_0.865169_g43226_i0 PRJNA1122875 43450 251 0.865169 2.17157419 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 204 5.93e-48   NTclustered gi|2107977474|gb|CP070783.1| 2026735 g43226 i0 85.714 0.780876494023904 196 25 77 2 53 245 2303870 2303675 MAG: Deltaproteobacteria bacterium isolate bin162 chromosome blastn 196 204 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
15580574 15580574 PRJNA1122875_P_NODE_39593_length_264_cov_0.821990_g39369_i0 PRJNA1122875 39593 264 0.82199 2.1700536 Nannocystis punicea 2995304 Bacteria Bacteria 316 7.75e-82   NTclustered gi|2415023655|gb|CP114040.1| 2995304 g39369 i0 89.062 100.481060606061 256 26 97 2 10 264 5377423 5377169 Nannocystis poenicansa strain FL3 chromosome, complete genome blastn 26527 316 1 Bacteria   Pseudomonadati Myxococcota   Nannocystales Nannocystaceae Nannocystis Nannocystis punicea
16854961 16854961 PRJNA1122875_P_NODE_38974_length_266_cov_1.196891_g38750_i0 PRJNA1122875 38974 266 1.196891 3.18373006 Pendulispora brunnea 2905690 Bacteria Bacteria 344 3.58e-90   NTclustered gi|2698055994|gb|CP089982.1| 2905690 g38750 i0 91.051 138.932330827068 257 19 96 4 1 255 7408154 7408408 Pendulispora brunnea strain MSr12523 chromosome, complete genome blastn 36956 344 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Pendulisporaceae Pendulispora Pendulispora brunnea
18880355 18880355 PRJNA1122875_P_NODE_41015_length_258_cov_1.664865_g40791_i0 PRJNA1122875 41015 258 1.664865 4.2953517 Corallococcus 83461 Bacteria Bacteria 54.7 0.007   NTclustered gi|2851136330|gb|CP172866.1| 184914 g40791 i0 100 0.449612403100775 29 0 11 0 142 170 4421875 4421903 Corallococcus coralloides strain KYC2213 chromosome, complete genome blastn 116 54.7 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales Myxococcaceae Corallococcus Corallococcus coralloides
20155029 20155029 PRJNA1122875_P_NODE_12056_length_479_cov_1.911330_g11833_i0 PRJNA1122875 12056 479 1.91133 9.1552707 Myxococcia 32015 Bacteria Bacteria 503 1.07e-137   NTclustered gi|913610804|gb|CP012333.1| 1391654 g11833 i0 85.744 227.613778705637 484 60 100 9 1 479 3942281 3941802 Labilithrix luteola strain DSM 27648, complete genome blastn 109027 503 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Labilitrichaceae Labilithrix Labilithrix luteola
20155069 20155069 PRJNA1122875_P_NODE_22616_length_349_cov_1.347826_g22392_i0 PRJNA1122875 22616 349 1.347826 4.70391274 root 1 Root_unresolved Root_unresolved 54.7 0.009   NTclustered gi|908353314|gb|CP012159.1| 52 g22392 i0 94.286 0.275071633237822 35 2 10 0 147 181 9485916 9485950 Chondromyces crocatus strain Cm c5, complete genome blastn 96 54.7 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae Chondromyces Chondromyces crocatus
23230215 23230215 PRJNA1122875_P_NODE_5279_length_684_cov_3.188216_g5069_i0 PRJNA1122875 5279 684 3.188216 21.80739744 Cystobacter fuscus 43 Bacteria Bacteria 54.7 0.019   NTclustered gi|2579656172|gb|CP043491.1| 43 g5069 i0 96.875 0.0467836257309941 32 1 5 0 631 662 3993830 3993799 Cystobacter fuscus strain Cbf 10 chromosome, complete genome blastn 32 54.7 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);;