RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA293022 · 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
373360 373360 PRJNA293022_P_NODE_62921_length_175_cov_1.277778_g62184_i0 PRJNA293022 62921 175 1.277778 2.2361115 Fretibacterium fastidiosum 651822 Bacteria Bacteria 268 1.34e-67   NTclustered gi|2869663113|emb|OZ209244.1| 651822 g62184 i0 94.286 268.994285714286 175 10 100 0 1 175 69579 69405 Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 blastn 47074 268 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium Fretibacterium fastidiosum
1647959 1647959 PRJNA293022_P_NODE_23382_length_293_cov_1.594262_g22645_i0 PRJNA293022 23382 293 1.594262 4.67118766 Fretibacterium fastidiosum 651822 Bacteria Bacteria 309 1.4600000000000003e-79   NTclustered gi|2869663113|emb|OZ209244.1| 651822 g22645 i0 86.111 5.53242320819113 288 38 98 2 2 288 69934 69648 Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 blastn 1621 309 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium Fretibacterium fastidiosum
5476899 5476899 PRJNA293022_P_NODE_70805_length_167_cov_0.881356_g70068_i0 PRJNA293022 70805 167 0.881356 1.47186452 Fretibacterium fastidiosum 651822 Bacteria Bacteria 296 5.86e-76   NTclustered gi|2869663113|emb|OZ209244.1| 651822 g70068 i0 100 4.59281437125748 160 0 96 0 1 160 683572 683413 Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 blastn 767 296 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium Fretibacterium fastidiosum
8026507 8026507 PRJNA293022_P_NODE_19487_length_323_cov_1.635036_g18750_i0 PRJNA293022 19487 323 1.635036 5.28116628 Fretibacterium fastidiosum 651822 Bacteria Bacteria 549 8.819999999999997e-152   NTclustered gi|2869663113|emb|OZ209244.1| 651822 g18750 i0 97.508 322.272445820433 321 8 99 0 1 321 68297 68617 Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 blastn 104094 549 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium Fretibacterium fastidiosum
16950845 16950845 PRJNA293022_P_NODE_77314_length_163_cov_0.912281_g76577_i0 PRJNA293022 77314 163 0.912281 1.48701803 Fretibacterium fastidiosum 651822 Bacteria Bacteria 243 7.51e-60   NTclustered gi|2869663113|emb|OZ209244.1| 651822 g76577 i0 93.789 1.97546012269939 161 10 99 0 3 163 1290692 1290532 Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 blastn 322 243 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium Fretibacterium fastidiosum
20774644 20774644 PRJNA293022_P_NODE_1577_length_1025_cov_10.157787_g1201_i0 PRJNA293022 1577 1025 10.157787 104.11731675 Fretibacterium fastidiosum 651822 Bacteria Bacteria 1430 0   NTclustered gi|2869663113|emb|OZ209244.1| 651822 g1201 i0 91.934 569.695609756098 1029 72 100 10 4 1025 69644 68620 Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 blastn 583938 1430 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium Fretibacterium fastidiosum
21461458 21461458 PRJNA293022_P_NODE_37017_length_229_cov_4.511111_g36280_i0 PRJNA293022 37017 229 4.511111 10.33044419 Aminobacterium 81466 Bacteria Bacteria 302 1.84e-77   NTclustered gi|470486176|ref|NR_076740.1| 81468 g36280 i0 90.435 176.633187772926 230 20 99 2 2 229 1933 1704 Aminobacterium colombiense strain ALA-1 23S ribosomal RNA gene, complete sequence blastn 40449 302 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Aminobacterium Aminobacterium colombiense

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