RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA879221" and tax_kingdom = "Thermoproteati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermoproteati · 6 ✖

bioproject 1

  • PRJNA879221 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
27907847 27907847 PRJNA879221_P_NODE_56465_length_245_cov_0.895349_g56325_i0 PRJNA879221 56465 245 0.895349 2.19360505 Nitrososphaera sp. 1971748 Archaea Archaea 63.2 2.38e-9   NR HZT36206.1 1971748 g56325 i0 40 0.979591836734694 80 45 98 1 4 243 222 298 HZT36206.1 hypothetical protein [Nitrososphaera sp.] diamond 240 63.2 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Nitrososphaera sp.
28065970 28065970 PRJNA879221_P_NODE_40465_length_273_cov_1.370000_g40325_i0 PRJNA879221 40465 273 1.37 3.7401 uncultured marine thaumarchaeote KM3_53_F 1167203 Archaea Archaea 57.8 1.49e-8   NR AIF11849.1 1456186 g40325 i0 66.7 0.428571428571429 39 13 42.9 0 259 143 44 82 AIF11849.1 hypothetical protein [uncultured marine thaumarchaeote KM3_53_F08] diamond 117 57.8 1 Archaea   Thermoproteati Nitrososphaerota         uncultured marine thaumarchaeote KM3_53_F08
29044952 29044952 PRJNA879221_P_NODE_20788_length_388_cov_1.098413_g20649_i0 PRJNA879221 20788 388 1.098413 4.26184244 uncultured marine thaumarchaeote KM3_53_F 1167203 Archaea Archaea 66.6 1.83e-11   NR AIF11849.1 1456186 g20649 i0 57.4 0.417525773195876 54 23 41.8 0 163 2 40 93 AIF11849.1 hypothetical protein [uncultured marine thaumarchaeote KM3_53_F08] diamond 162 66.6 1 Archaea   Thermoproteati Nitrososphaerota         uncultured marine thaumarchaeote KM3_53_F08
29960477 29960477 PRJNA879221_P_NODE_37611_length_285_cov_1.377358_g37471_i0 PRJNA879221 37611 285 1.377358 3.9254703 uncultured marine thaumarchaeote KM3_53_F 1167203 Archaea Archaea 57.8 1.71e-8   NR AIF11849.1 1456186 g37471 i0 57.4 0.494736842105263 47 20 49.5 0 283 143 47 93 AIF11849.1 hypothetical protein [uncultured marine thaumarchaeote KM3_53_F08] diamond 141 57.8 1 Archaea   Thermoproteati Nitrososphaerota         uncultured marine thaumarchaeote KM3_53_F08
30687084 30687084 PRJNA879221_P_NODE_6073_length_763_cov_3.957971_g5946_i0 PRJNA879221 6073 763 3.957971 30.19931873 uncultured marine thaumarchaeote KM3_53_F 1167203 Archaea Archaea 90.9 1.85e-19   NR AIF11849.1 1456186 g5946 i0 77.8 0.212319790301442 54 12 21.2 0 437 276 40 93 AIF11849.1 hypothetical protein [uncultured marine thaumarchaeote KM3_53_F08] diamond 162 90.9 1 Archaea   Thermoproteati Nitrososphaerota         uncultured marine thaumarchaeote KM3_53_F08
32394936 32394936 PRJNA879221_P_NODE_39199_length_278_cov_1.497561_g39059_i0 PRJNA879221 39199 278 1.497561 4.16321958 uncultured marine thaumarchaeote KM3_53_F 1167203 Archaea Archaea 87.4 3.42e-20   NR AIF11849.1 1456186 g39059 i0 75.9 0.58273381294964 54 13 58.3 0 72 233 40 93 AIF11849.1 hypothetical protein [uncultured marine thaumarchaeote KM3_53_F08] diamond 162 87.4 1 Archaea   Thermoproteati Nitrososphaerota         uncultured marine thaumarchaeote KM3_53_F08

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