RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "diamond", bioproject = "PRJEB64798" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 10 ✖

tax_clade 1

bioproject 1

  • PRJEB64798 · 10 ✖

analysis 1

  • diamond · 10 ✖

tax_kingdom 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
26741541 26741541 PRJEB64798_P_NODE_177281_length_175_cov_8.706349_g175515_i0 PRJEB64798 177281 175 8.706349 15.23611075 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 41.2 0.0259   NR MES1912123.1 1215613 g175515 i0 54.8 1.47428571428571 42 19 72 0 171 46 88 129 MES1912123.1 hypothetical protein [Cercozoa sp. M6MM] diamond 258 41.2 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
27570868 27570868 PRJEB64798_P_NODE_218604_length_162_cov_7.044248_g216838_i0 PRJEB64798 218604 162 7.044248 11.41168176 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 47.8 2.11e-4   NR MES1910123.1 1215613 g216838 i0 50.9 0.981481481481482 53 24 94.4 1 157 5 4427 4479 MES1910123.1 hypothetical protein [Cercozoa sp. M6MM] diamond 159 47.8 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
28139428 28139428 PRJEB64798_P_NODE_141265_length_193_cov_1.368056_g139499_i0 PRJEB64798 141265 193 1.368056 2.64034808 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 61.2 5.75e-9   NR MES1915729.1 1215613 g139499 i0 44.8 3.66839378238342 58 32 90.2 0 174 1 300 357 MES1915729.1 hypothetical protein [Cercozoa sp. M6MM] diamond 708 61.2 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
28455041 28455041 PRJEB64798_P_NODE_106006_length_211_cov_6.901235_g104240_i0 PRJEB64798 106006 211 6.901235 14.56160585 Bigelowiella natans 227086 SAR_Eukaryotes SAR_Eukaryotes 47.8 1.18e-4   NR AAT09065.1 227086 g104240 i0 29.1 1.56398104265403 55 39 78.2 0 34 198 15 69 AAT09065.1 dynein outer arm light chain [Bigelowiella natans] diamond 330 47.8 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Bigelowiella Bigelowiella natans
28763737 28763737 PRJEB64798_P_NODE_238527_length_155_cov_13.358491_g236761_i0 PRJEB64798 238527 155 13.358491 20.70566105 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 44.3 0.00323   NR MES1911093.1 1215613 g236761 i0 45 2.67096774193548 40 21 77.4 1 24 143 645 683 MES1911093.1 hypothetical protein [Cercozoa sp. M6MM] diamond 414 44.7 0.991051454138702 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
30950218 30950218 PRJEB64798_P_NODE_215914_length_163_cov_2.929825_g214148_i0 PRJEB64798 215914 163 2.929825 4.77561475 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 77.4 3.52e-15   NR MES1911029.1 1215613 g214148 i0 72.5 5.68711656441718 51 14 93.9 0 9 161 122 172 MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] diamond 927 77.4 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
31234268 31234268 PRJEB64798_P_NODE_211655_length_164_cov_3.886957_g209889_i0 PRJEB64798 211655 164 3.886957 6.37460948 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 51.6 9.54e-6   NR MES1907830.1 1215613 g209889 i0 51 0.896341463414634 49 24 89.6 0 7 153 1523 1571 MES1907830.1 hypothetical protein [Cercozoa sp. M6MM] diamond 147 51.6 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
32468506 32468506 PRJEB64798_P_NODE_229519_length_159_cov_2.554545_g227753_i0 PRJEB64798 229519 159 2.554545 4.06172655 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 63.9 3.89e-10   NR MES1909783.1 1215613 g227753 i0 52.9 0.962264150943396 51 24 96.2 0 154 2 30 80 MES1909783.1 hypothetical protein [Cercozoa sp. M6MM] diamond 153 63.9 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
32625935 32625935 PRJEB64798_P_NODE_161800_length_182_cov_9.751880_g160034_i0 PRJEB64798 161800 182 9.75188 17.7484216 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 46.2 9.61e-4   NR MES1911673.1 1215613 g160034 i0 54.8 1.07142857142857 31 14 51.1 0 85 177 37 67 MES1911673.1 hypothetical protein [Cercozoa sp. M6MM] diamond 195 46.2 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
32752042 32752042 PRJEB64798_P_NODE_170000_length_179_cov_1.023077_g168234_i0 PRJEB64798 170000 179 1.023077 1.83130783 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 89 8.19e-19   NR MES1909201.1 1215613 g168234 i0 61 0.988826815642458 59 23 98.9 0 178 2 730 788 MES1909201.1 hypothetical protein [Cercozoa sp. M6MM] diamond 177 89 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM

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