RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "blastn", bioproject = "PRJEB14175" and tax_phylum = "Nitrososphaerota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrososphaerota · 11 ✖

tax_kingdom 1

bioproject 1

  • PRJEB14175 · 11 ✖

analysis 1

  • blastn · 11 ✖

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
25607174 25607174 PRJEB14175_P_NODE_112569_length_332_cov_24.560886_g110303_i0 PRJEB14175 112569 332 24.560886 81.54214152 Archaea 2157 Archaea Archaea 279 1.32e-70   NTclustered gi|663502579|gb|KF900394.1| 1455910 g110303 i0 83.117 14.6295180722892 308 51 92 1 4 310 15809 15502 Uncultured marine thaumarchaeote AD1000_36_B08 genomic sequence blastn 4857 281 0.99288256227758 Archaea   Thermoproteati Nitrososphaerota         uncultured marine thaumarchaeote AD1000_36_B08
25641991 25641991 PRJEB14175_P_NODE_212058_length_219_cov_2.126582_g209791_i0 PRJEB14175 212058 219 2.126582 4.65721458 Candidatus Nitrososphaera evergladensis SR1 1459636 Archaea Archaea 198 2.35e-46   NTclustered gi|665992324|gb|CP007174.1| 1459636 g209791 i0 83.732 6.26027397260274 209 34 95 0 11 219 1977401 1977193 Candidatus Nitrososphaera evergladensis SR1, complete genome blastn 1371 198 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Candidatus Nitrososphaera evergladensis
25784331 25784331 PRJEB14175_P_NODE_91315_length_378_cov_3.602524_g89049_i0 PRJEB14175 91315 378 3.602524 13.61754072 Candidatus Nitrosocosmicus oleophilus 1353260 Archaea Archaea 588 2.2199999999999993e-163   NTclustered gi|937513727|gb|CP012850.1| 1353260 g89049 i0 96.61 0.936507936507937 354 12 94 0 23 376 2058511 2058158 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 354 588 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus oleophilus
25909738 25909738 PRJEB14175_P_NODE_113324_length_331_cov_5.396296_g111058_i0 PRJEB14175 113324 331 5.396296 17.86173976 Candidatus Nitrosocosmicus oleophilus 1353260 Archaea Archaea 566 9e-157   NTclustered gi|937513727|gb|CP012850.1| 1353260 g111058 i0 99.677 59.9607250755287 310 0 93 1 1 309 848204 847895 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 19847 566 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus oleophilus
25913647 25913647 PRJEB14175_P_NODE_196188_length_231_cov_2.482353_g193921_i0 PRJEB14175 196188 231 2.482353 5.73423543 Candidatus Nitrosocosmicus oleophilus 1353260 Archaea Archaea 385 1.79e-102   NTclustered gi|937513727|gb|CP012850.1| 1353260 g193921 i0 100 2.3030303030303 208 0 90 0 24 231 1508819 1508612 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 532 385 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus oleophilus
26048339 26048339 PRJEB14175_P_NODE_167117_length_257_cov_5.469388_g164850_i0 PRJEB14175 167117 257 5.469388 14.05632716 Candidatus Nitrosocosmicus oleophilus 1353260 Archaea Archaea 200 7.89e-47   NTclustered gi|937513727|gb|CP012850.1| 1353260 g164850 i0 97.436 0.455252918287938 117 3 46 0 2 118 255929 256045 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 117 200 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus oleophilus
26051772 26051772 PRJEB14175_P_NODE_24637_length_743_cov_8.856305_g22668_i0 PRJEB14175 24637 743 8.856305 65.80234615 Candidatus Nitrosocosmicus oleophilus 1353260 Archaea Archaea 1321 0   NTclustered gi|937513727|gb|CP012850.1| 1353260 g22668 i0 99.586 71.2099596231494 725 1 97 1 21 743 848664 849388 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 52909 1321 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus oleophilus
26183134 26183134 PRJEB14175_P_NODE_135878_length_295_cov_5.286325_g133611_i0 PRJEB14175 135878 295 5.286325 15.59465875 Candidatus Nitrosocosmicus oleophilus 1353260 Archaea Archaea 514 2.9099999999999997e-141   NTclustered gi|937513727|gb|CP012850.1| 1353260 g133611 i0 99.296 2.85084745762712 284 2 96 0 1 284 463211 463494 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 841 514 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus oleophilus
26319239 26319239 PRJEB14175_P_NODE_143807_length_284_cov_7.071749_g141540_i0 PRJEB14175 143807 284 7.071749 20.08376716 Nitrosopumilus cobalaminigenes 1470066 Archaea Archaea 267 8.599999999999999e-67   NTclustered gi|1869221159|gb|CP026993.1| 1470066 g141540 i0 85.057 6.88732394366197 261 39 92 0 1 261 112025 112285 Nitrosopumilus cobalaminigenes strain HCA1 chromosome, complete genome blastn 1956 267 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus cobalaminigenes
26321248 26321248 PRJEB14175_P_NODE_188447_length_237_cov_6.403409_g186180_i0 PRJEB14175 188447 237 6.403409 15.17607933 Candidatus Nitrosocosmicus oleophilus 1353260 Archaea Archaea 399 6.589999999999999e-107   NTclustered gi|937513727|gb|CP012850.1| 1353260 g186180 i0 100 3.42194092827004 216 0 91 0 22 237 886353 886138 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 811 399 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus oleophilus
26461739 26461739 PRJEB14175_P_NODE_36768_length_615_cov_9.106498_g34602_i0 PRJEB14175 36768 615 9.106498 56.0049627 Candidatus Nitrosocosmicus oleophilus 1353260 Archaea Archaea 1040 0   NTclustered gi|937513727|gb|CP012850.1| 1353260 g34602 i0 97.997 0.973983739837398 599 12 97 0 1 599 2706478 2705880 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 599 1040 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus oleophilus

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