RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "blastn", bioproject = "PRJNA827593" and tax_phylum = "Nitrososphaerota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrososphaerota · 15 ✖

tax_kingdom 1

bioproject 1

  • PRJNA827593 · 15 ✖

analysis 1

  • blastn · 15 ✖

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
821162 821162 PRJNA827593_P_NODE_32681_length_360_cov_1.505226_g32382_i0 PRJNA827593 32681 360 1.505226 5.4188136 Candidatus Nitrosotalea okcheonensis 1903276 Archaea Archaea 344 5.03e-90   NTclustered gi|1279331958|emb|LT841358.1| 1903276 g32382 i0 83.889 1.78055555555556 360 58 100 0 1 360 378983 378624 Nitrosotalea sp. CS isolate NCS1 genome assembly, chromosome: 1 blastn 641 344 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosotaleales Nitrosotaleaceae Nitrosotalea Candidatus Nitrosotalea okcheonensis
2096571 2096571 PRJNA827593_P_NODE_29722_length_380_cov_1.254072_g29423_i0 PRJNA827593 29722 380 1.254072 4.7654736 Nitrosotalea devaniterrae 1078905 Archaea Archaea 431 3.9799999999999997e-116   NTclustered gi|1003583480|emb|LN890280.1| 1078905 g29423 i0 87.105 2 380 49 100 0 1 380 995136 995515 Candidatus Nitrosotalea devanaterra genome assembly, chromosome: 1 blastn 760 431 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosotaleales Nitrosotaleaceae Nitrosotalea Nitrosotalea devaniterrae
2096971 2096971 PRJNA827593_P_NODE_52582_length_274_cov_2.457711_g52283_i0 PRJNA827593 52582 274 2.457711 6.73412814 Nitrosotalea devaniterrae 1078905 Archaea Archaea 279 1.06e-70   NTclustered gi|1003583480|emb|LN890280.1| 1078905 g52283 i0 85.199 1.01094890510949 277 36 100 5 1 274 430975 431249 Candidatus Nitrosotalea devanaterra genome assembly, chromosome: 1 blastn 277 279 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosotaleales Nitrosotaleaceae Nitrosotalea Nitrosotalea devaniterrae
3371844 3371844 PRJNA827593_P_NODE_28763_length_387_cov_1.961783_g28464_i0 PRJNA827593 28763 387 1.961783 7.59210021 Nitrosotalea devaniterrae 1078905 Archaea Archaea 372 2.5e-98   NTclustered gi|1003583480|emb|LN890280.1| 1078905 g28464 i0 85.014 1.02325581395349 367 53 95 2 1 366 377599 377234 Candidatus Nitrosotalea devanaterra genome assembly, chromosome: 1 blastn 396 372 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosotaleales Nitrosotaleaceae Nitrosotalea Nitrosotalea devaniterrae
8474502 8474502 PRJNA827593_P_NODE_6167_length_907_cov_2.676259_g5909_i0 PRJNA827593 6167 907 2.676259 24.27366913 Nitrosotalea devaniterrae 1078905 Archaea Archaea 784 0   NTclustered gi|1003583480|emb|LN890280.1| 1078905 g5909 i0 82.428 1.03528114663727 939 125 100 21 1 907 431246 432176 Candidatus Nitrosotalea devanaterra genome assembly, chromosome: 1 blastn 939 784 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosotaleales Nitrosotaleaceae Nitrosotalea Nitrosotalea devaniterrae
11025019 11025019 PRJNA827593_P_NODE_42689_length_309_cov_3.262712_g42390_i0 PRJNA827593 42689 309 3.262712 10.08178008 Nitrosotalea devaniterrae 1078905 Archaea Archaea 285 2.6099999999999997e-72   NTclustered gi|1003583480|emb|LN890280.1| 1078905 g42390 i0 84.483 0.938511326860841 290 43 94 2 1 289 785730 785442 Candidatus Nitrosotalea devanaterra genome assembly, chromosome: 1 blastn 290 285 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosotaleales Nitrosotaleaceae Nitrosotalea Nitrosotalea devaniterrae
11025386 11025386 PRJNA827593_P_NODE_63489_length_247_cov_2.034483_g63190_i0 PRJNA827593 63489 247 2.034483 5.02517301 Nitrosotalea devaniterrae 1078905 Archaea Archaea 268 2.04e-67   NTclustered gi|1003583480|emb|LN890280.1| 1078905 g63190 i0 86.235 1 247 34 100 0 1 247 346169 345923 Candidatus Nitrosotalea devanaterra genome assembly, chromosome: 1 blastn 247 268 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosotaleales Nitrosotaleaceae Nitrosotalea Nitrosotalea devaniterrae
13574280 13574280 PRJNA827593_P_NODE_12591_length_616_cov_1.804788_g12299_i0 PRJNA827593 12591 616 1.804788 11.11749408 Nitrosotalea devaniterrae 1078905 Archaea Archaea 671 0   NTclustered gi|1003583480|emb|LN890280.1| 1078905 g12299 i0 86.364 2.00324675324675 616 82 99 2 1 615 737015 737629 Candidatus Nitrosotalea devanaterra genome assembly, chromosome: 1 blastn 1234 671 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosotaleales Nitrosotaleaceae Nitrosotalea Nitrosotalea devaniterrae
14848999 14848999 PRJNA827593_P_NODE_24332_length_426_cov_1.575071_g24033_i0 PRJNA827593 24332 426 1.575071 6.70980246 Candidatus Nitrosotalea okcheonensis 1903276 Archaea Archaea 549 1.1899999999999996e-151   NTclustered gi|1279331958|emb|LT841358.1| 1903276 g24033 i0 90.754 4.88262910798122 411 38 96 0 16 426 1165101 1164691 Nitrosotalea sp. CS isolate NCS1 genome assembly, chromosome: 1 blastn 2080 549 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosotaleales Nitrosotaleaceae Nitrosotalea Candidatus Nitrosotalea okcheonensis
16123593 16123593 PRJNA827593_P_NODE_26813_length_403_cov_1.842424_g26514_i0 PRJNA827593 26813 403 1.842424 7.42496872 Candidatus Nitrosotalea okcheonensis 1903276 Archaea Archaea 289 2.71e-73   NTclustered gi|1279331958|emb|LT841358.1| 1903276 g26514 i0 82.111 0.846153846153846 341 57 84 4 65 403 894700 894362 Nitrosotalea sp. CS isolate NCS1 genome assembly, chromosome: 1 blastn 341 289 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosotaleales Nitrosotaleaceae Nitrosotalea Candidatus Nitrosotalea okcheonensis
17399921 17399921 PRJNA827593_P_NODE_60574_length_252_cov_1.759777_g60275_i0 PRJNA827593 60574 252 1.759777 4.43463804 Nitrosotalea devaniterrae 1078905 Archaea Archaea 305 1.59e-78   NTclustered gi|1003583480|emb|LN890280.1| 1078905 g60275 i0 88.492 1.98809523809524 252 29 100 0 1 252 834153 833902 Candidatus Nitrosotalea devanaterra genome assembly, chromosome: 1 blastn 501 305 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosotaleales Nitrosotaleaceae Nitrosotalea Nitrosotalea devaniterrae
21222968 21222968 PRJNA827593_P_NODE_22297_length_447_cov_3.235294_g21998_i0 PRJNA827593 22297 447 3.235294 14.46176418 Nitrosotalea devaniterrae 1078905 Archaea Archaea 475 2.1699999999999993e-129   NTclustered gi|1003583480|emb|LN890280.1| 1078905 g21998 i0 87.143 0.939597315436242 420 52 94 2 1 419 1394869 1394451 Candidatus Nitrosotalea devanaterra genome assembly, chromosome: 1 blastn 420 475 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosotaleales Nitrosotaleaceae Nitrosotalea Nitrosotalea devaniterrae
21222993 21222993 PRJNA827593_P_NODE_23617_length_433_cov_2.177778_g23318_i0 PRJNA827593 23617 433 2.177778 9.42977874 Nitrosotalea devaniterrae 1078905 Archaea Archaea 553 9.399999999999999e-153   NTclustered gi|1003583480|emb|LN890280.1| 1078905 g23318 i0 91.019 2.80369515011547 412 34 95 1 2 413 309734 310142 Candidatus Nitrosotalea devanaterra genome assembly, chromosome: 1 blastn 1214 553 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosotaleales Nitrosotaleaceae Nitrosotalea Nitrosotalea devaniterrae
22497793 22497793 PRJNA827593_P_NODE_29778_length_379_cov_2.480392_g29479_i0 PRJNA827593 29778 379 2.480392 9.40068568 Nitrosotalea devaniterrae 1078905 Archaea Archaea 412 1.4399999999999994e-110   NTclustered gi|1003583480|emb|LN890280.1| 1078905 g29479 i0 86.28 2.72823218997361 379 52 100 0 1 379 346549 346171 Candidatus Nitrosotalea devanaterra genome assembly, chromosome: 1 blastn 1034 412 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosotaleales Nitrosotaleaceae Nitrosotalea Nitrosotalea devaniterrae
25047894 25047894 PRJNA827593_P_NODE_59980_length_254_cov_1.276243_g59681_i0 PRJNA827593 59980 254 1.276243 3.24165722 Nitrosotalea devaniterrae 1078905 Archaea Archaea 331 2.6500000000000002e-86   NTclustered gi|1003583480|emb|LN890280.1| 1078905 g59681 i0 90.438 2.11417322834646 251 24 99 0 3 253 309470 309720 Candidatus Nitrosotalea devanaterra genome assembly, chromosome: 1 blastn 537 331 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosotaleales Nitrosotaleaceae Nitrosotalea Nitrosotalea devaniterrae

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