RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA561212" and tax_phylum = "Chloroflexota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chloroflexota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA561212 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
8783601 8783601 PRJNA561212_P_NODE_10107_length_347_cov_1.218978_g9896_i0 PRJNA561212 10107 347 1.218978 4.22985366 Herpetosiphon 64 Bacteria Bacteria 603 7.229999999999999e-168   NTclustered gi|470482680|ref|NR_076546.1| 65 g9896 i0 99.696 5.68876080691643 329 1 95 0 10 338 1267 1595 Herpetosiphon aurantiacus strain DSM 785 23S ribosomal RNA gene, complete sequence blastn 1974 603 1 Bacteria   Bacillati Chloroflexota Chloroflexia Herpetosiphonales Herpetosiphonaceae Herpetosiphon Herpetosiphon aurantiacus
9473940 9473940 PRJNA561212_P_NODE_19368_length_258_cov_1.427027_g19157_i0 PRJNA561212 19368 258 1.427027 3.68172966 uncultured Chloroflexia bacterium 1672391 Bacteria Bacteria 58.4 5.05e-4   NTclustered gi|2874253860|emb|OY969916.1| 1672391 g19157 i0 100 0.12015503875969 31 0 12 0 190 220 4726206 4726236 MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1 blastn 31 58.4 1 Bacteria   Bacillati Chloroflexota Chloroflexia       uncultured Chloroflexia bacterium
23497939 23497939 PRJNA561212_P_NODE_9019_length_366_cov_1.197952_g8808_i0 PRJNA561212 9019 366 1.197952 4.38450432 Herpetosiphon aurantiacus 65 Bacteria Bacteria 575 1.6699999999999995e-159   NTclustered gi|159889572|gb|CP000875.1| 316274 g8808 i0 95.798 31.1065573770492 357 13 97 2 10 364 4626685 4627041 Herpetosiphon aurantiacus DSM 785, complete genome blastn 11385 575 1 Bacteria   Bacillati Chloroflexota Chloroflexia Herpetosiphonales Herpetosiphonaceae Herpetosiphon Herpetosiphon aurantiacus
24771741 24771741 PRJNA561212_P_NODE_3320_length_606_cov_2.864916_g3114_i0 PRJNA561212 3320 606 2.864916 17.36139096 Candidatus Promineifilum breve 1806508 Bacteria Bacteria 573 1.0399999999999995e-158   NTclustered gi|1041165931|emb|LN890655.2| 1806508 g3114 i0 84.114 68.029702970297 598 90 98 5 2 597 597223 597817 Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I blastn 41226 573 1 Bacteria   Bacillati Chloroflexota Ardenticatenia Candidatus Promineifilales Candidatus Promineifilaceae Candidatus Promineifilum Candidatus Promineifilum breve

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