RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA1061474" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_kingdom 2

tax_superkingdom 1

  • Archaea · 5 ✖

tax_clade 1

bioproject 1

  • PRJNA1061474 · 5 ✖

analysis 1

  • blastn · 5 ✖
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
15481724 15481724 PRJNA1061474_P_NODE_50593_length_247_cov_0.885057_g50347_i0 PRJNA1061474 50593 247 0.885057 2.18609079 Methanobacteriota archaeon 2026739 Archaea Archaea 302 2.01e-77   NTclustered gi|2874253753|emb|OY969693.1| 2026739 g50347 i0 88.755 1.0080971659919 249 25 100 3 1 247 885133 884886 MAG: Euryarchaeota archaeon isolate MFD04408.bin.c.4 genome assembly, chromosome: 1 blastn 249 302 1 Archaea   Methanobacteriati Methanobacteriota         Methanobacteriota archaeon
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
19304508 19304508 PRJNA1061474_P_NODE_45676_length_251_cov_0.865169_g45430_i0 PRJNA1061474 45676 251 0.865169 2.17157419 Methanocella paludicola 570267 Archaea Archaea 353 5.569999999999998e-93   NTclustered gi|282154984|dbj|AP011532.1| 304371 g45430 i0 92.032 2.21513944223108 251 20 100 0 1 251 2650432 2650682 Methanocella paludicola SANAE DNA, complete genome blastn 556 353 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanocellales Methanocellaceae Methanocella Methanocella paludicola

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