RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA670521" and tax_phylum = "Chloroflexota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chloroflexota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA670521 · 5 ✖

analysis 1

  • blastn · 5 ✖

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
1164885 1164885 PRJNA670521_P_NODE_18241_length_438_cov_1.252055_g17499_i0 PRJNA670521 18241 438 1.252055 5.4840009 Bacteria 2 Bacteria Bacteria 342 2.24e-89   NTclustered gi|156231356|gb|CP000804.1| 383372 g17499 i0 83.113 81.9269406392694 379 60 86 4 23 399 3691585 3691961 Roseiflexus castenholzii DSM 13941, complete genome blastn 35884 342 1 Bacteria   Bacillati Chloroflexota Chloroflexia Chloroflexales Roseiflexaceae Roseiflexus Roseiflexus castenholzii
4466296 4466296 PRJNA670521_P_NODE_78084_length_248_cov_0.880000_g77339_i0 PRJNA670521 78084 248 0.88 2.1824 uncultured Dehalococcoidia bacterium 498747 Bacteria Bacteria 52.8 0.022   NTclustered gi|2531949176|emb|OY282458.1| 498747 g77339 i0 100 0.112903225806452 28 0 11 0 71 98 433920 433947 MAG: uncultured Dehalococcoidia bacterium genome assembly, chromosome: 1 blastn 28 52.8 1 Bacteria   Bacillati Chloroflexota Dehalococcoidia       uncultured Dehalococcoidia bacterium
12117300 12117300 PRJNA670521_P_NODE_21550_length_409_cov_1.145833_g20807_i0 PRJNA670521 21550 409 1.145833 4.68645697 Dehalococcoidia bacterium 2026734 Bacteria Bacteria 255 2.79e-63   NTclustered gi|2621704004|emb|OY762959.1| 2026734 g20807 i0 80 57.7310513447433 370 55 88 16 1 359 187506 187867 MAG: Dehalococcoidia bacterium isolate a8fc5444-7059-4be1-bdcb-92646be6befe genome assembly, chromosome: 1 blastn 23612 255 1 Bacteria   Bacillati Chloroflexota Dehalococcoidia       Dehalococcoidia bacterium
13392085 13392085 PRJNA670521_P_NODE_16191_length_460_cov_1.591731_g15449_i0 PRJNA670521 16191 460 1.591731 7.3219626 Caldilineaceae bacterium 2614250 Bacteria Bacteria 87.9 1.22e-12   NTclustered gi|2621703348|emb|OY760647.1| 2614250 g15449 i0 82.828 1.71521739130435 99 16 21 1 190 287 3823844 3823746 MAG: Caldilineaceae bacterium isolate dd18155e-cfc5-4d95-bdad-01b25ac4382b genome assembly, chromosome: 1 blastn 789 87.9 1 Bacteria   Bacillati Chloroflexota Caldilineae Caldilineales Caldilineaceae   Caldilineaceae bacterium
14667293 14667293 PRJNA670521_P_NODE_73592_length_250_cov_0.870056_g72847_i0 PRJNA670521 73592 250 0.870056 2.17514 Aggregatilineales bacterium 2952883 Bacteria Bacteria 147 1.01e-30   NTclustered gi|2621706248|emb|OY764157.1| 2952883 g72847 i0 82.53 5.016 166 29 66 0 65 230 2372652 2372487 MAG: Aggregatilineales bacterium isolate e8f4d38d-de70-4490-8638-1b8803f995b9 genome assembly, chromosome: 1 blastn 1254 147 1 Bacteria   Bacillati Chloroflexota Anaerolineae Aggregatilineales     Aggregatilineales bacterium

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