RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA1123436" and tax_phylum = "Candidatus Tectimicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Tectimicrobiota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1123436 · 4 ✖

analysis 1

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
29743270 29743270 PRJNA1123436_P_NODE_107730_length_247_cov_0.885057_g106516_i0 PRJNA1123436 107730 247 0.885057 2.18609079 Bacteria 2 Bacteria Bacteria 126 6.4e-33   NR MEE9149516.1 2528274 g106516 i0 74.4 2.98785425101215 82 20 99.6 1 2 247 229 309 MEE9149516.1 NF038122 family metalloprotease [Candidatus Tectimicrobiota bacterium] diamond 738 126 1 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Candidatus Tectimicrobiota         Candidatus Tectimicrobiota bacterium
30007203 30007203 PRJNA1123436_P_NODE_126591_length_241_cov_0.916667_g125377_i0 PRJNA1123436 126591 241 0.916667 2.20916747 Candidatus Tectimicrobiota bacterium 2528274 Bacteria Bacteria 48.9 2.18e-4   NR MEE8301576.1 2528274 g125377 i0 61.1 1.04564315352697 36 14 44.8 0 133 240 69 104 MEE8301576.1 transposase [Candidatus Tectimicrobiota bacterium] diamond 252 48.9 1 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Candidatus Tectimicrobiota         Candidatus Tectimicrobiota bacterium
31555851 31555851 PRJNA1123436_P_NODE_119916_length_243_cov_0.905882_g118702_i0 PRJNA1123436 119916 243 0.905882 2.20129326 Candidatus Tectimicrobiota bacterium 2528274 Bacteria Bacteria 103 1.1399999999999999e-24   NR MBI2877351.1 2528274 g118702 i0 66.2 0.876543209876543 71 24 87.7 0 215 3 37 107 MBI2877351.1 hypothetical protein [Candidatus Tectimicrobiota bacterium] diamond 213 103 1 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Candidatus Tectimicrobiota         Candidatus Tectimicrobiota bacterium
32315207 32315207 PRJNA1123436_P_NODE_120299_length_243_cov_0.905882_g119085_i0 PRJNA1123436 120299 243 0.905882 2.20129326 Candidatus Tectimicrobiota bacterium 2528274 Bacteria Bacteria 97.4 2.93e-23   NR MDH3603386.1 2528274 g119085 i0 80.7 2.81481481481481 57 11 70.4 0 172 2 70 126 MDH3603386.1 recombinase family protein [Candidatus Tectimicrobiota bacterium] diamond 684 97.4 1 Bacteria Nitrospinota/Tectimicrobiota group Pseudomonadati Candidatus Tectimicrobiota         Candidatus Tectimicrobiota bacterium

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