RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA1061474" and tax_kingdom = "Thermoproteati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermoproteati · 3 ✖

bioproject 1

  • PRJNA1061474 · 3 ✖

analysis 1

  • blastn · 3 ✖

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
178942 178942 PRJNA1061474_P_NODE_49541_length_248_cov_0.880000_g49295_i0 PRJNA1061474 49541 248 0.88 2.1824 Nitrosotalea devaniterrae 1078905 Archaea Archaea 342 1.1899999999999999e-89   NTclustered gi|1003583480|emb|LN890280.1| 1078905 g49295 i0 91.837 4.97177419354839 245 20 99 0 4 248 1414687 1414931 Candidatus Nitrosotalea devanaterra genome assembly, chromosome: 1 blastn 1233 342 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosotaleales Nitrosotaleaceae Nitrosotalea Nitrosotalea devaniterrae
2729503 2729503 PRJNA1061474_P_NODE_53963_length_244_cov_0.900585_g53717_i0 PRJNA1061474 53963 244 0.900585 2.1974274 Candidatus Nitrosotalea okcheonensis 1903276 Archaea Archaea 276 1.1999999999999998e-69   NTclustered gi|1279331958|emb|LT841358.1| 1903276 g53717 i0 87.19 1.99180327868852 242 31 99 0 3 244 413671 413912 Nitrosotalea sp. CS isolate NCS1 genome assembly, chromosome: 1 blastn 486 276 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosotaleales Nitrosotaleaceae Nitrosotalea Candidatus Nitrosotalea okcheonensis
18030626 18030626 PRJNA1061474_P_NODE_51135_length_246_cov_0.890173_g50889_i0 PRJNA1061474 51135 246 0.890173 2.18982558 Candidatus Nitrosotalea okcheonensis 1903276 Archaea Archaea 372 1.5e-98   NTclustered gi|1279331958|emb|LT841358.1| 1903276 g50889 i0 93.902 3 246 15 100 0 1 246 1531859 1532104 Nitrosotalea sp. CS isolate NCS1 genome assembly, chromosome: 1 blastn 738 372 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosotaleales Nitrosotaleaceae Nitrosotalea Candidatus Nitrosotalea okcheonensis

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