RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA1164198" and tax_phylum = "Chloroflexota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chloroflexota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1164198 · 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
4138797 4138797 PRJNA1164198_P_NODE_19304_length_282_cov_1.483254_g19035_i0 PRJNA1164198 19304 282 1.483254 4.18277628 uncultured Chloroflexia bacterium 1672391 Bacteria Bacteria 324 4.99e-84   NTclustered gi|2874254066|emb|OY970149.1| 1672391 g19035 i0 87.857 682.255319148936 280 28 98 6 4 279 566875 566598 MAG: uncultured Chloroflexia bacterium isolate MFD05747.bin.c.2 genome assembly, chromosome: 1 blastn 192396 324 1 Bacteria   Bacillati Chloroflexota Chloroflexia       uncultured Chloroflexia bacterium
7417381 7417381 PRJNA1164198_P_NODE_1886_length_896_cov_1.591738_g1708_i0 PRJNA1164198 1886 896 1.591738 14.26197248 Chloroflexus 1107 Bacteria Bacteria 778 0   NTclustered gi|470482818|ref|NR_076553.1| 1108 g1708 i0 84.635 526.6640625 794 108 88 14 86 876 432 1214 Chloroflexus aurantiacus strain J-10-fl 23S ribosomal RNA gene, complete sequence blastn 471891 784 0.99234693877551 Bacteria   Bacillati Chloroflexota Chloroflexia Chloroflexales Chloroflexaceae Chloroflexus Chloroflexus aurantiacus
9239853 9239853 PRJNA1164198_P_NODE_15908_length_310_cov_1.780591_g15639_i0 PRJNA1164198 15908 310 1.780591 5.5198321 Dehalococcoidia bacterium 2026734 Bacteria Bacteria 71.3 7.99e-8   NTclustered gi|2621701384|emb|OY760104.1| 2026734 g15639 i0 89.286 1.04193548387097 56 6 18 0 8 63 2421757 2421812 MAG: Dehalococcoidia bacterium isolate 85321599-0a94-4039-bbde-d148f9b3e6b5 genome assembly, chromosome: 1 blastn 323 71.3 1 Bacteria   Bacillati Chloroflexota Dehalococcoidia       Dehalococcoidia bacterium
21441476 21441476 PRJNA1164198_P_NODE_3797_length_646_cov_1.996510_g3551_i0 PRJNA1164198 3797 646 1.99651 12.8974546 Roseiflexus 120961 Bacteria Bacteria 333 2.0500000000000006e-86   NTclustered gi|470482403|ref|NR_076530.1| 120962 g3551 i0 78.442 58.0495356037152 552 89 83 26 62 599 1761 1226 Roseiflexus castenholzii strain HLO8 23S ribosomal RNA gene, complete sequence blastn 37500 335 0.994029850746269 Bacteria   Bacillati Chloroflexota Chloroflexia Chloroflexales Roseiflexaceae Roseiflexus Roseiflexus castenholzii
21988671 21988671 PRJNA1164198_P_NODE_12838_length_346_cov_1.135531_g12569_i0 PRJNA1164198 12838 346 1.135531 3.92893726 uncultured Chloroflexia bacterium 1672391 Bacteria Bacteria 484 2.7199999999999994e-132   NTclustered gi|2874253812|emb|OY969796.1| 1672391 g12569 i0 91.931 53.5924855491329 347 26 100 2 1 346 3034399 3034054 MAG: uncultured Chloroflexia bacterium isolate MFD01872.bin.1.103 genome assembly, chromosome: 1 blastn 18543 484 1 Bacteria   Bacillati Chloroflexota Chloroflexia       uncultured Chloroflexia bacterium
22716410 22716410 PRJNA1164198_P_NODE_298_length_1918_cov_3.444444_g250_i0 PRJNA1164198 298 1918 3.444444 66.06443592 Herpetosiphon 64 Bacteria Bacteria 3109 0   NTclustered gi|470482680|ref|NR_076546.1| 65 g250 i0 95.95 84.3149113660063 1926 61 100 16 1 1918 18 1934 Herpetosiphon aurantiacus strain DSM 785 23S ribosomal RNA gene, complete sequence blastn 161716 3114 0.998394348105331 Bacteria   Bacillati Chloroflexota Chloroflexia Herpetosiphonales Herpetosiphonaceae Herpetosiphon Herpetosiphon aurantiacus

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