RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA879067" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA879067 · 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
7234781 7234781 PRJNA879067_P_NODE_99986_length_262_cov_2.269841_g96500_i0 PRJNA879067 99986 262 2.269841 5.94698342 Pyrinomonadaceae bacterium 2283092 Bacteria Bacteria 351 2.1e-92   NTclustered gi|2874253710|emb|OY969475.1| 2283092 g96500 i0 93.991 50.0152671755725 233 13 89 1 31 262 1821874 1821642 MAG: Pyrinomonadaceae bacterium isolate MFD01916.bin.c.1 genome assembly, chromosome: 1 blastn 13104 351 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia Blastocatellales Pyrinomonadaceae   Pyrinomonadaceae bacterium
8508892 8508892 PRJNA879067_P_NODE_75227_length_361_cov_1.423611_g71741_i0 PRJNA879067 75227 361 1.423611 5.13923571 Edaphobacter sp. 12200R-103 2703788 Bacteria Bacteria 111 5.57e-20   NTclustered gi|1804497213|gb|CP048114.1| 2703788 g71741 i0 95.652 0.382271468144044 69 3 19 0 29 97 3369453 3369521 Edaphobacter sp. 12200R-103 chromosome, complete genome blastn 138 111 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Edaphobacter Edaphobacter sp. 12200R-103
12335373 12335373 PRJNA879067_P_NODE_87890_length_306_cov_2.819742_g84404_i0 PRJNA879067 87890 306 2.819742 8.62841052 Terriglobus roseus 392734 Bacteria Bacteria 435 2.43e-117   NTclustered gi|390410848|gb|CP003379.1| 926566 g84404 i0 92.459 103.434640522876 305 22 99 1 1 304 927239 926935 Terriglobus roseus DSM 18391, complete genome blastn 31651 435 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Terriglobus Terriglobus roseus
17816217 17816217 PRJNA879067_P_NODE_100974_length_259_cov_1.204301_g97488_i0 PRJNA879067 100974 259 1.204301 3.11913959 Acidobacteriota 57723 Bacteria Bacteria 56.5 0.002   NTclustered gi|2874253693|emb|OY969419.1| 194844 g97488 i0 97.059 11.015444015444 34 0 13 1 204 236 227727 227760 MAG: uncultured Acidobacteriaceae bacterium isolate MFD03346.bin.1.13 genome assembly, chromosome: 1 blastn 2853 56.5 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae   uncultured Acidobacteriaceae bacterium
21258599 21258599 PRJNA879067_P_NODE_97117_length_273_cov_1.325000_g93631_i0 PRJNA879067 97117 273 1.325 3.61725 uncultured Acidobacteriota bacterium 171953 Bacteria Bacteria 422 1.66e-113   NTclustered gi|76574288|gb|DQ139436.1| 171953 g93631 i0 97.561 34.8241758241758 246 6 90 0 1 246 246 1 Uncultured Acidobacteria bacterium clone CAL6 23S ribosomal RNA gene, partial sequence blastn 9507 422 1 Bacteria   Pseudomonadati Acidobacteriota         uncultured Acidobacteriota bacterium
25081253 25081253 PRJNA879067_P_NODE_47280_length_548_cov_8.694737_g43806_i0 PRJNA879067 47280 548 8.694737 47.64715876 Geothrix sp. 1962974 Bacteria Bacteria 67.6 1.93e-6   NTclustered gi|2515262989|gb|CP126625.1| 1962974 g43806 i0 93.333 1.07116788321168 45 3 8 0 54 98 117118 117074 MAG: Geothrix sp. isolate L227-G1 chromosome, complete genome blastn 587 67.6 1 Bacteria   Pseudomonadati Acidobacteriota Holophagae Holophagales Holophagaceae Geothrix Geothrix sp.

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