RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA415856" and tax_phylum = "Nitrososphaerota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrososphaerota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJNA415856 · 8 ✖

analysis 1

  • diamond · 8 ✖

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
19545251 19545251 PRJNA415856_P_NODE_44476_length_164_cov_0.886957_g44215_i0 PRJNA415856 44476 164 0.886957 1.45460948 Archaea 2157 Archaea Archaea 102 6.649999999999998e-24   NR MBI3638791.1 2026795 g44215 i0 88.9 8.89024390243902 54 6 98.8 0 1 162 57 110 MBI3638791.1 4-hydroxyphenylacetate 3-hydroxylase family protein [Nitrososphaerota archaeon] diamond 1458 102 1 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota archaeon
28608091 28608091 PRJNA415856_P_NODE_49447_length_162_cov_0.902655_g49186_i0 PRJNA415856 49447 162 0.902655 1.4623011 Nitrososphaeria 1643678 Archaea Archaea 70.5 6.07e-13   NR RPJ25338.1 2026768 g49186 i0 88.6 1.66666666666667 44 5 81.5 0 31 162 1 44 RPJ25338.1 MAG: hypothetical protein EHM25_13540, partial [Nitrosopumilales archaeon] diamond 270 70.5 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales     Nitrosopumilales archaeon
28906960 28906960 PRJNA415856_P_NODE_48388_length_162_cov_1.469027_g48127_i0 PRJNA415856 48388 162 1.469027 2.37982374 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 111 4.68e-29   NR HEX2407753.1 2169593 g48127 i0 88.7 9.81481481481481 53 6 98.1 0 2 160 56 108 HEX2407753.1 DDE-type integrase/transposase/recombinase [Nitrososphaeraceae archaeon] diamond 1590 111 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
30517910 30517910 PRJNA415856_P_NODE_26613_length_180_cov_1.557252_g26352_i0 PRJNA415856 26613 180 1.557252 2.8030536 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 90.5 7.95e-20   NR HJR46673.1 2169593 g26352 i0 78.9 1.9 57 12 95 0 8 178 1 57 HJR46673.1 site-specific integrase [Nitrososphaeraceae archaeon] diamond 342 90.5 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
31813978 31813978 PRJNA415856_P_NODE_46477_length_163_cov_0.894737_g46216_i0 PRJNA415856 46477 163 0.894737 1.45842131 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 120 1.45e-33   NR HET6640053.1 2169593 g46216 i0 100 1.95092024539877 53 0 97.5 0 161 3 64 116 HET6640053.1 cbb3-type cytochrome c oxidase subunit I [Nitrososphaeraceae archaeon] diamond 318 120 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
31908887 31908887 PRJNA415856_P_NODE_28457_length_177_cov_1.367188_g28196_i0 PRJNA415856 28457 177 1.367188 2.41992276 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 79.3 2.11e-16   NR HXW12010.1 2169593 g28196 i0 77.6 0.983050847457627 58 13 98.3 0 2 175 42 99 HXW12010.1 hypothetical protein [Nitrososphaeraceae archaeon] diamond 174 79.3 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
32257283 32257283 PRJNA415856_P_NODE_50138_length_162_cov_0.902655_g49877_i0 PRJNA415856 50138 162 0.902655 1.4623011 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 48.5 2.96e-5   NR MDW0283126.1 2169593 g49877 i0 66.7 1.09259259259259 30 10 55.6 0 2 91 93 122 MDW0283126.1 ArsR family transcriptional regulator [Nitrososphaeraceae archaeon] diamond 177 48.5 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
32446994 32446994 PRJNA415856_P_NODE_11919_length_254_cov_1.068293_g11658_i0 PRJNA415856 11919 254 1.068293 2.71346422 Nitrososphaera sp. 1971748 Archaea Archaea 43.9 0.0163   NR HVX03469.1 1971748 g11658 i0 37.8 0.874015748031496 74 36 87.4 3 27 248 405 468 HVX03469.1 glycosyltransferase family 2 protein [Nitrososphaera sp.] diamond 222 43.9 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Nitrososphaera sp.

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