RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA526367" 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

  • PRJNA526367 · 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
3047090 3047090 PRJNA526367_P_NODE_46123_length_173_cov_1.282258_g45913_i0 PRJNA526367 46123 173 1.282258 2.21830634 uncultured Chloroflexia bacterium 1672391 Bacteria Bacteria 54.7 0.004   NTclustered gi|2874253882|emb|OY969938.1| 1672391 g45913 i0 100 0.167630057803468 29 0 17 0 134 162 1149712 1149684 MAG: uncultured Chloroflexia bacterium isolate MFD02416.bin.c.1 genome assembly, chromosome: 1 blastn 29 54.7 1 Bacteria   Bacillati Chloroflexota Chloroflexia       uncultured Chloroflexia bacterium
4323238 4323238 PRJNA526367_P_NODE_62724_length_154_cov_7.495238_g62514_i0 PRJNA526367 62724 154 7.495238 11.54266652 uncultured Caldilineaceae bacterium 543031 Bacteria Bacteria 124 2.64e-24   NTclustered gi|2531946084|emb|OY282381.1| 543031 g62514 i0 82 127.24025974026 150 23 95 3 6 151 1717859 1718008 MAG: uncultured Caldilineaceae bacterium genome assembly, chromosome: 1 blastn 19595 124 1 Bacteria   Bacillati Chloroflexota Caldilineae Caldilineales Caldilineaceae   uncultured Caldilineaceae bacterium
8766735 8766735 PRJNA526367_P_NODE_38807_length_185_cov_3.360294_g38597_i0 PRJNA526367 38807 185 3.360294 6.2165439 Herpetosiphon 64 Bacteria Bacteria 331 1.81e-86   NTclustered gi|265678392|ref|NR_028694.1| 70996 g38597 i0 100 99.2054054054054 179 0 97 0 7 185 1093 1271 Herpetosiphon geysericola strain GC-42 16S ribosomal RNA, partial sequence blastn 18353 331 1 Bacteria   Bacillati Chloroflexota Chloroflexia Herpetosiphonales Herpetosiphonaceae Herpetosiphon Herpetosiphon geysericola
10700145 10700145 PRJNA526367_P_NODE_52389_length_165_cov_4.232759_g52179_i0 PRJNA526367 52389 165 4.232759 6.98405235 uncultured Chloroflexia bacterium 1672391 Bacteria Bacteria 117 4.82e-22   NTclustered gi|2874253706|emb|OY969433.1| 1672391 g52179 i0 85.586 1.45454545454545 111 16 67 0 49 159 4789029 4789139 MAG: uncultured Chloroflexia bacterium isolate MFD00008.bin.1.123 genome assembly, chromosome: 1 blastn 240 117 1 Bacteria   Bacillati Chloroflexota Chloroflexia       uncultured Chloroflexia bacterium
18347843 18347843 PRJNA526367_P_NODE_59375_length_159_cov_3.709091_g59165_i0 PRJNA526367 59375 159 3.709091 5.89745469 Dehalococcoidia bacterium 2026734 Bacteria Bacteria 54.7 0.004   NTclustered gi|2891482139|emb|OZ219872.1| 2026734 g59165 i0 100 0.182389937106918 29 0 18 0 28 56 664704 664732 MAG: Dehalococcoidia bacterium isolate adc01b0e-c114-4b94-a05b-fd73c1a39460 genome assembly, chromosome: 6 blastn 29 54.7 1 Bacteria   Bacillati Chloroflexota Dehalococcoidia       Dehalococcoidia bacterium
24065668 24065668 PRJNA526367_P_NODE_38179_length_186_cov_3.693431_g37969_i0 PRJNA526367 38179 186 3.693431 6.86978166 Herpetosiphon 64 Bacteria Bacteria 261 2.43e-65   NTclustered gi|470482680|ref|NR_076546.1| 65 g37969 i0 92.896 5.90322580645161 183 8 97 4 1 180 1378 1198 Herpetosiphon aurantiacus strain DSM 785 23S ribosomal RNA gene, complete sequence blastn 1098 261 1 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);;