RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJNA940501" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 15 ✖

tax_clade 1

bioproject 1

  • PRJNA940501 · 15 ✖

analysis 1

  • diamond · 15 ✖

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
2193043 2193043 PRJNA940501_S_NODE_11282_length_444_cov_26.705736_g10477_i0 PRJNA940501 11282 444 26.705736 118.57346784 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 106 1.72e-24   NR MES1911029.1 1215613 g10477 i0 53.6 0.756756756756757 112 49 75 2 435 103 185 294 MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] diamond 336 106 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
13671519 13671519 PRJNA940501_S_NODE_12911_length_422_cov_4.108179_g12101_i0 PRJNA940501 12911 422 4.108179 17.33651538 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 141 1.09e-38   NR ACF24576.1 67809 g12101 i0 78.8 4.24407582938389 85 18 60.4 0 5 259 181 265 ACF24576.1 phosphoglycerate mutase [Gymnochlora stellata] diamond 1791 142 0.992957746478873 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Gymnochlora Gymnochlora stellata
22595234 22595234 PRJNA940501_S_NODE_153718_length_210_cov_1.125749_g152900_i0 PRJNA940501 153718 210 1.1257490000000001 2.3640729 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 122 2.9799999999999997e-30   NR MES1909201.1 1215613 g152900 i0 78.3 5.87142857142857 69 14 98.6 1 2 208 626 693 MES1909201.1 hypothetical protein [Cercozoa sp. M6MM] diamond 1233 122 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
27025188 27025188 PRJNA940501_S_NODE_362722_length_155_cov_1.678571_g361904_i0 PRJNA940501 362722 155 1.678571 2.60178505 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 76.3 1.59e-14   NR MES1915306.1 1215613 g361904 i0 62.7 0.987096774193548 51 19 98.7 0 2 154 364 414 MES1915306.1 hypothetical protein [Cercozoa sp. M6MM] diamond 153 76.3 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
27183059 27183059 PRJNA940501_S_NODE_350382_length_157_cov_2.061404_g349564_i0 PRJNA940501 350382 157 2.061404 3.23640428 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 70.9 1.4e-12   NR MES1907829.1 1215613 g349564 i0 63.5 0.993630573248408 52 19 99.4 0 156 1 174 225 MES1907829.1 hypothetical protein [Cercozoa sp. M6MM] diamond 156 70.9 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
27278180 27278180 PRJNA940501_S_NODE_324783_length_162_cov_1.579832_g323965_i0 PRJNA940501 324783 162 1.579832 2.55932784 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 47 4e-4   NR MES1913147.1 1215613 g323965 i0 48.1 1.94444444444444 52 27 96.3 0 162 7 267 318 MES1913147.1 hypothetical protein [Cercozoa sp. M6MM] diamond 315 47 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
27594035 27594035 PRJNA940501_S_NODE_22684_length_350_cov_4.198697_g21866_i0 PRJNA940501 22684 350 4.198697 14.6954395 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 94.4 8.25e-20   NR MES1906893.1 1215613 g21866 i0 68.8 0.548571428571429 64 20 54.9 0 3 194 419 482 MES1906893.1 hypothetical protein [Cercozoa sp. M6MM] diamond 192 94.4 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
27657282 27657282 PRJNA940501_S_NODE_79164_length_253_cov_2.438095_g78346_i0 PRJNA940501 79164 253 2.438095 6.16838035 Paulinella micropora 1928728 SAR_Eukaryotes SAR_Eukaryotes 53.5 3.45e-6   NR BBE07971.1 1928728 g78346 i0 63 0.545454545454545 46 16 54.5 1 1 138 158 202 BBE07971.1 GTP-binding protein [Paulinella micropora] diamond 138 53.5 1 Eukaryota Sar   Cercozoa Imbricatea Euglyphida Paulinellidae Paulinella Paulinella micropora
27689018 27689018 PRJNA940501_S_NODE_202084_length_192_cov_1.892617_g201266_i0 PRJNA940501 202084 192 1.892617 3.63382464 Gymnochlora stellata 67809 SAR_Eukaryotes SAR_Eukaryotes 46.6 2.96e-4   NR ACF24561.1 67809 g201266 i0 67.7 3.015625 31 10 48.4 0 2 94 107 137 ACF24561.1 multiprotein bridging factor type 1 [Gymnochlora stellata] diamond 579 46.6 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Gymnochlora Gymnochlora stellata
29582779 29582779 PRJNA940501_S_NODE_9310_length_483_cov_13.743182_g8526_i0 PRJNA940501 9310 483 13.743182 66.37956906 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 189 6.900000000000001e-59   NR ADK26622.1 323453 g8526 i0 83.3 0.633540372670807 102 17 63.4 0 3 308 29 130 ADK26622.1 rps22a [Heteromita sp. PRA-74] diamond 306 189 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
29835611 29835611 PRJNA940501_S_NODE_298971_length_167_cov_2.274194_g298153_i0 PRJNA940501 298971 167 2.274194 3.79790398 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 47 4.24e-4   NR MES1912100.1 1215613 g298153 i0 43.6 0.988023952095808 55 31 98.8 0 3 167 456 510 MES1912100.1 hypothetical protein [Cercozoa sp. M6MM] diamond 165 47 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
29968855 29968855 PRJNA940501_S_NODE_96731_length_240_cov_1.796954_g95913_i0 PRJNA940501 96731 240 1.796954 4.3126896 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 61.6 1.49e-9   NR MES1909107.1 1215613 g95913 i0 47.4 2.075 57 30 71.3 0 240 70 44 100 MES1909107.1 hypothetical protein [Cercozoa sp. M6MM] diamond 498 62 0.993548387096774 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
30056638 30056638 PRJNA940501_S_NODE_120971_length_225_cov_2.357143_g120153_i0 PRJNA940501 120971 225 2.357143 5.30357175 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 65.1 8.91e-11   NR MES1915609.1 1215613 g120153 i0 48.1 2.05333333333333 77 34 94.7 1 11 223 94 170 MES1915609.1 hypothetical protein [Cercozoa sp. M6MM] diamond 462 65.1 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
31384141 31384141 PRJNA940501_S_NODE_373756_length_153_cov_1.709091_g372938_i0 PRJNA940501 373756 153 1.709091 2.61490923 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 84 3.91e-19   NR ADK26622.1 323453 g372938 i0 88.1 0.823529411764706 42 5 82.4 0 151 26 89 130 ADK26622.1 rps22a [Heteromita sp. PRA-74] diamond 126 84 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
32428099 32428099 PRJNA940501_S_NODE_51019_length_283_cov_3.229167_g50201_i0 PRJNA940501 51019 283 3.229167 9.13854261 Bigelowiella natans 227086 SAR_Eukaryotes SAR_Eukaryotes 45.4 0.00566   NR AAT09059.1 227086 g50201 i0 68.8 0.339222614840989 32 10 33.9 0 1 96 213 244 AAT09059.1 translation initiation factor 6 [Bigelowiella natans] diamond 96 45.4 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Bigelowiella Bigelowiella natans

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