RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJNA1108487" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 21 ✖

tax_clade 1

bioproject 1

  • PRJNA1108487 · 21 ✖

analysis 1

  • diamond · 21 ✖

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
213397 213397 PRJNA1108487_P_NODE_1701_length_515_cov_3.457014_g1635_i0 PRJNA1108487 1701 515 3.457014 17.8036221 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 191 5.7800000000000006e-58   NR MES1912193.1 1215613 g1635 i0 65.4 4.68932038834951 162 56 94.4 0 489 4 2 163 MES1912193.1 60S ribosomal protein L7B [Cercozoa sp. M6MM] diamond 2415 191 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
2764122 2764122 PRJNA1108487_P_NODE_10803_length_244_cov_0.912281_g10737_i0 PRJNA1108487 10803 244 0.912281 2.22596564 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 100 2.93e-23   NR MES1912552.1 1215613 g10737 i0 75 1.37704918032787 56 14 68.9 0 241 74 294 349 MES1912552.1 hypothetical protein [Cercozoa sp. M6MM] diamond 336 100 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
7398381 7398381 PRJNA1108487_P_NODE_2726_length_411_cov_2.692308_g2660_i0 PRJNA1108487 2726 411 2.692308 11.06538588 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 234 5.06e-75   NR MES1915178.1 1215613 g2660 i0 77.2 2.97810218978102 136 31 99.3 0 2 409 56 191 MES1915178.1 hypothetical protein [Cercozoa sp. M6MM] diamond 1224 234 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
11692100 11692100 PRJNA1108487_P_NODE_350_length_1025_cov_11.172269_g306_i0 PRJNA1108487 350 1025 11.172269 114.51575725 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 362 1.42e-121   NR MES1911029.1 1215613 g306 i0 63.5 0.866341463414634 296 102 85.5 3 23 898 1 294 MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] diamond 888 362 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
15516036 15516036 PRJNA1108487_P_NODE_4673_length_324_cov_1.243028_g4607_i0 PRJNA1108487 4673 324 1.243028 4.02741072 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 170 3.38e-48   NR MES1907382.1 1215613 g4607 i0 74.8 2.96296296296296 107 26 99.1 1 1 321 239 344 MES1907382.1 hypothetical protein [Cercozoa sp. M6MM] diamond 960 170 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
23165747 23165747 PRJNA1108487_P_NODE_4119_length_342_cov_1.412639_g4053_i0 PRJNA1108487 4119 342 1.412639 4.83122538 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 117 4.8e-28   NR AAP72162.1 188940 g4053 i0 72.1 6.7280701754386 86 21 74.6 2 3 257 93 176 AAP72162.1 heat shock protein 90, partial [Thaumatomonas sp. (SA)] diamond 2301 117 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida Thaumatomastigidae Thaumatomonas Thaumatomonas sp. (SA)
26592673 26592673 PRJNA1108487_P_NODE_3581_length_362_cov_1.951557_g3515_i0 PRJNA1108487 3581 362 1.951557 7.06463634 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 43.9 0.00658   NR MES1916909.1 1215613 g3515 i0 53.5 1.22651933701657 43 16 35.6 1 259 131 38 76 MES1916909.1 hypothetical protein [Cercozoa sp. M6MM] diamond 444 43.9 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
26655973 26655973 PRJNA1108487_P_NODE_2621_length_419_cov_2.184971_g2555_i0 PRJNA1108487 2621 419 2.184971 9.15502849 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 168 9.48e-49   NR MES1912384.1 1215613 g2555 i0 56.4 1.00238663484487 140 60 99.5 1 3 419 141 280 MES1912384.1 hypothetical protein [Cercozoa sp. M6MM] diamond 420 168 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
26655975 26655975 PRJNA1108487_P_NODE_3921_length_349_cov_1.413043_g3855_i0 PRJNA1108487 3921 349 1.413043 4.93152007 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 119 1.82e-28   NR MES1910326.1 1215613 g3855 i0 46.6 0.997134670487106 116 62 99.7 0 2 349 349 464 MES1910326.1 hypothetical protein [Cercozoa sp. M6MM] diamond 348 119 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
28015423 28015423 PRJNA1108487_P_NODE_4245_length_337_cov_1.772727_g4179_i0 PRJNA1108487 4245 337 1.772727 5.97408999 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 65.1 1.56e-9   NR MES1910277.1 1215613 g4179 i0 50.7 0.632047477744807 71 34 63.2 1 213 1 2 71 MES1910277.1 hypothetical protein [Cercozoa sp. M6MM] diamond 213 65.1 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
28646875 28646875 PRJNA1108487_P_NODE_567_length_858_cov_3.052229_g511_i0 PRJNA1108487 567 858 3.052229 26.18812482 Bigelowiella natans 227086 SAR_Eukaryotes SAR_Eukaryotes 183 3.25e-54   NR AAT09077.1 227086 g511 i0 63.3 0.524475524475524 150 54 52.1 1 839 393 1 150 AAT09077.1 transcription factor BTF3 [Bigelowiella natans] diamond 450 183 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Bigelowiella Bigelowiella natans
28899181 28899181 PRJNA1108487_P_NODE_7268_length_269_cov_1.183673_g7202_i0 PRJNA1108487 7268 269 1.183673 3.18408037 Bigelowiella natans 227086 SAR_Eukaryotes SAR_Eukaryotes 97.4 3.13e-22   NR AAT09094.1 227086 g7202 i0 54.4 1.00371747211896 90 36 94.8 2 5 259 119 208 AAT09094.1 F-actin capping protein beta subunit [Bigelowiella natans] diamond 270 97.4 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Bigelowiella Bigelowiella natans
29593607 29593607 PRJNA1108487_P_NODE_9830_length_247_cov_0.959770_g9764_i0 PRJNA1108487 9830 247 0.95977 2.3706319 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 120 3.47e-31   NR MES1911029.1 1215613 g9764 i0 70.2 1.96761133603239 84 23 99.6 1 2 247 136 219 MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] diamond 486 120 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
29688405 29688405 PRJNA1108487_P_NODE_1230_length_597_cov_15.250000_g1165_i0 PRJNA1108487 1230 597 15.25 91.0425 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 229 3.07e-74   NR ADK26622.1 323453 g1165 i0 82.3 0.653266331658292 130 23 65.3 0 41 430 1 130 ADK26622.1 rps22a [Heteromita sp. PRA-74] diamond 390 229 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
29878318 29878318 PRJNA1108487_P_NODE_5391_length_306_cov_1.145923_g5325_i0 PRJNA1108487 5391 306 1.145923 3.50652438 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 102 5.96e-25   NR MES1913460.1 1215613 g5325 i0 48.1 7.84313725490196 104 49 99 3 303 1 22 123 MES1913460.1 hypothetical protein [Cercozoa sp. M6MM] diamond 2400 102 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
30572994 30572994 PRJNA1108487_P_NODE_4173_length_340_cov_1.168539_g4107_i0 PRJNA1108487 4173 340 1.168539 3.9730326 Paulinella micropora 1928728 SAR_Eukaryotes SAR_Eukaryotes 82.8 6.84e-17   NR BBE07971.1 1928728 g4107 i0 71.4 0.555882352941176 63 17 55.6 1 3 191 141 202 BBE07971.1 GTP-binding protein [Paulinella micropora] diamond 189 82.8 1 Eukaryota Sar   Cercozoa Imbricatea Euglyphida Paulinellidae Paulinella Paulinella micropora
31015588 31015588 PRJNA1108487_P_NODE_4915_length_317_cov_1.598361_g4849_i0 PRJNA1108487 4915 317 1.598361 5.06680437 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 77.8 2.61e-14   NR MES1909841.1 1215613 g4849 i0 39.8 1.06940063091483 113 53 92.7 4 316 23 18 130 MES1909841.1 hypothetical protein [Cercozoa sp. M6MM] diamond 339 77.8 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
31363464 31363464 PRJNA1108487_P_NODE_556_length_863_cov_2.400000_g500_i0 PRJNA1108487 556 863 2.4 20.712 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 157 4.229999999999999e-42   NR MES1907597.1 1215613 g500 i0 48.6 1.1784472769409 175 87 60.5 3 792 271 2 174 MES1907597.1 hypothetical protein [Cercozoa sp. M6MM] diamond 1017 157 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
31711254 31711254 PRJNA1108487_P_NODE_4457_length_330_cov_2.984436_g4391_i0 PRJNA1108487 4457 330 2.984436 9.8486388 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 50.1 2.6e-4   NR MES1912577.1 1215613 g4391 i0 32.9 1.38181818181818 76 48 66.4 1 234 16 31 106 MES1912577.1 hypothetical protein [Cercozoa sp. M6MM] diamond 456 50.1 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
31996001 31996001 PRJNA1108487_P_NODE_7158_length_270_cov_1.979695_g7092_i0 PRJNA1108487 7158 270 1.979695 5.3451765 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 83.2 1.19e-17   NR MES1913636.1 1215613 g7092 i0 48.8 1.95555555555556 86 35 94.4 2 5 259 45 122 MES1913636.1 hypothetical protein [Cercozoa sp. M6MM] diamond 528 83.2 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
32059185 32059185 PRJNA1108487_P_NODE_8678_length_252_cov_0.871508_g8612_i0 PRJNA1108487 8678 252 0.871508 2.19620016 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 86.7 1.24e-17   NR MES1917203.1 1215613 g8612 i0 53.6 1 84 37 97.6 1 248 3 72 155 MES1917203.1 hypothetical protein [Cercozoa sp. M6MM] diamond 252 86.7 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);;