RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA385073" and tax_phylum = "Synergistota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Synergistota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA385073 · 7 ✖

analysis 1

  • blastn · 7 ✖

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
406270 406270 PRJNA385073_P_NODE_50501_length_246_cov_0.890173_g50339_i0 PRJNA385073 50501 246 0.890173 2.18982558 Fretibacterium fastidiosum 651822 Bacteria Bacteria 327 3.3e-85   NTclustered gi|2869663113|emb|OZ209244.1| 651822 g50339 i0 90.763 96.5325203252033 249 17 100 6 1 246 68887 68642 Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 blastn 23747 327 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium Fretibacterium fastidiosum
9334122 9334122 PRJNA385073_P_NODE_39168_length_255_cov_5.384615_g39006_i0 PRJNA385073 39168 255 5.384615 13.73076825 Synergistaceae bacterium 2053624 Bacteria Bacteria 370 5.63e-98   NTclustered gi|2626233883|emb|OY821326.1| 2053624 g39006 i0 92.913 57.5803921568627 254 18 99 0 2 255 47153 46900 MAG: Synergistaceae bacterium isolate a20e232d-ae79-494a-a7eb-231c2e3632a3 genome assembly, chromosome: 1 blastn 14683 370 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Synergistaceae   Synergistaceae bacterium
10609991 10609991 PRJNA385073_P_NODE_48989_length_247_cov_0.885057_g48827_i0 PRJNA385073 48989 247 0.885057 2.18609079 Synergistaceae bacterium 2053624 Bacteria Bacteria 193 1.26e-44   NTclustered gi|2626233883|emb|OY821326.1| 2053624 g48827 i0 89.474 3.5748987854251 152 16 62 0 96 247 2140407 2140256 MAG: Synergistaceae bacterium isolate a20e232d-ae79-494a-a7eb-231c2e3632a3 genome assembly, chromosome: 1 blastn 883 193 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Synergistaceae   Synergistaceae bacterium
15709367 15709367 PRJNA385073_P_NODE_7693_length_450_cov_2.190981_g7533_i0 PRJNA385073 7693 450 2.190981 9.8594145 uncultured Dethiosulfovibrio sp. 185448 Bacteria Bacteria 243 2.41e-59   NTclustered gi|2621705290|emb|OY763420.1| 185448 g7533 i0 86.161 21.3222222222222 224 31 50 0 210 433 1393025 1393248 MAG: uncultured Dethiosulfovibrio sp. isolate 94f88398-021e-4021-9552-bf231e535e7d genome assembly, chromosome: 1 blastn 9595 243 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Dethiosulfovibrionaceae Dethiosulfovibrio uncultured Dethiosulfovibrio sp.
18257127 18257127 PRJNA385073_P_NODE_19855_length_319_cov_4.483740_g19693_i0 PRJNA385073 19855 319 4.48374 14.3031306 Synergistaceae bacterium 2053624 Bacteria Bacteria 514 3.17e-141   NTclustered gi|2626233883|emb|OY821326.1| 2053624 g19693 i0 96.753 2.90909090909091 308 10 97 0 12 319 633619 633312 MAG: Synergistaceae bacterium isolate a20e232d-ae79-494a-a7eb-231c2e3632a3 genome assembly, chromosome: 1 blastn 928 514 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Synergistaceae   Synergistaceae bacterium
18257201 18257201 PRJNA385073_P_NODE_22655_length_306_cov_1.484979_g22493_i0 PRJNA385073 22655 306 1.484979 4.54403574 Synergistaceae bacterium 2053624 Bacteria Bacteria 483 8.539999999999998e-132   NTclustered gi|2626233883|emb|OY821326.1| 2053624 g22493 i0 95.098 1 306 15 100 0 1 306 633312 633617 MAG: Synergistaceae bacterium isolate a20e232d-ae79-494a-a7eb-231c2e3632a3 genome assembly, chromosome: 1 blastn 306 483 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Synergistaceae   Synergistaceae bacterium
22082111 22082111 PRJNA385073_P_NODE_23178_length_303_cov_2.008696_g23016_i0 PRJNA385073 23178 303 2.008696 6.08634888 Synergistaceae bacterium 2053624 Bacteria Bacteria 459 1.4199999999999996e-124   NTclustered gi|2626233883|emb|OY821326.1| 2053624 g23016 i0 94.314 2.97029702970297 299 17 99 0 2 300 633615 633317 MAG: Synergistaceae bacterium isolate a20e232d-ae79-494a-a7eb-231c2e3632a3 genome assembly, chromosome: 1 blastn 900 459 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Synergistaceae   Synergistaceae 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);;