RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA488043" and tax_kingdom = "Thermoproteati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermoproteati · 6 ✖

bioproject 1

  • PRJNA488043 · 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
1724475 1724475 PRJNA488043_P_NODE_11282_length_300_cov_6.996310_g9041_i0 PRJNA488043 11282 300 6.99631 20.98893 Candidatus Nitrosotenuis cloacae 1603555 Archaea Archaea 521 1.7699999999999996e-143   NTclustered gi|808354332|gb|CP011097.2| 1603555 g9041 i0 98 27.9 300 6 100 0 1 300 121161 121460 Candidatus Nitrosotenuis cloacae strain SAT1, complete genome blastn 8370 521 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis cloacae
11928501 11928501 PRJNA488043_P_NODE_16790_length_205_cov_1.670455_g14548_i0 PRJNA488043 16790 205 1.670455 3.42443275 Candidatus Nitrosotenuis cloacae 1603555 Archaea Archaea 351 1.58e-92   NTclustered gi|808354332|gb|CP011097.2| 1603555 g14548 i0 98.02 26.3170731707317 202 4 99 0 4 205 740101 739900 Candidatus Nitrosotenuis cloacae strain SAT1, complete genome blastn 5395 351 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis cloacae
14478581 14478581 PRJNA488043_P_NODE_932_length_1950_cov_4.498178_g148_i2 PRJNA488043 932 1950 4.498178 87.714471 Candidatus Nitrosotenuis aquarius 1846278 Archaea Archaea 2900 0   NTclustered gi|1279207014|gb|CP024808.1| 1846278 g148 i2 93.327 18.9164102564103 1963 112 100 8 1 1950 1535573 1533617 Candidatus Nitrosotenuis aquarius strain AQ6F chromosome, complete genome blastn 36887 2900 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis aquarius
22126267 22126267 PRJNA488043_P_NODE_14018_length_243_cov_1.457944_g11776_i0 PRJNA488043 14018 243 1.457944 3.54280392 Candidatus Nitrosotenuis cloacae 1603555 Archaea Archaea 150 7.55e-32   NTclustered gi|808354332|gb|CP011097.2| 1603555 g11776 i0 91.667 0.893004115226337 108 9 44 0 135 242 704266 704159 Candidatus Nitrosotenuis cloacae strain SAT1, complete genome blastn 217 150 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis cloacae
24675950 24675950 PRJNA488043_P_NODE_460_length_5141_cov_4.026995_g148_i0 PRJNA488043 460 5141 4.026995 207.02781295 Candidatus Nitrosotenuis aquarius 1846278 Archaea Archaea 3476 0   NTclustered gi|1279207014|gb|CP024808.1| 1846278 g148 i0 92.402 9.03948648122933 2435 148 92 11 2727 5141 1533156 1535573 Candidatus Nitrosotenuis aquarius strain AQ6F chromosome, complete genome blastn 46472 3476 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis aquarius
24676006 24676006 PRJNA488043_P_NODE_900_length_1997_cov_4.404472_g148_i1 PRJNA488043 900 1997 4.404472 87.95730584 Candidatus Nitrosotenuis aquarius 1846278 Archaea Archaea 2880 0   NTclustered gi|1279207014|gb|CP024808.1| 1846278 g148 i1 92.587 18.528292438658 2010 120 100 9 1 1997 1533580 1535573 Candidatus Nitrosotenuis aquarius strain AQ6F chromosome, complete genome blastn 37001 2880 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis aquarius

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