RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA438572" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 13 ✖

tax_clade 1

bioproject 1

  • PRJNA438572 · 13 ✖

analysis 1

  • diamond · 13 ✖

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
2985574 2985574 PRJNA438572_P_NODE_12983_length_287_cov_1.280374_g12864_i0 PRJNA438572 12983 287 1.280374 3.67467338 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 107 7.01e-25   NR MES1906893.1 1215613 g12864 i0 70.8 1.34843205574913 65 19 67.9 0 3 197 94 158 MES1906893.1 hypothetical protein [Cercozoa sp. M6MM] diamond 387 107 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
2985765 2985765 PRJNA438572_P_NODE_2563_length_611_cov_5.254647_g2447_i0 PRJNA438572 2563 611 5.254647 32.10589317 Bigelowiella natans 227086 SAR_Eukaryotes SAR_Eukaryotes 182 8.109999999999997e-55   NR AAT09077.1 227086 g2447 i0 71.2 0.613747954173486 125 36 61.4 0 582 208 1 125 AAT09077.1 transcription factor BTF3 [Bigelowiella natans] diamond 375 182 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Bigelowiella Bigelowiella natans
4261949 4261949 PRJNA438572_P_NODE_144_length_1804_cov_24.692663_g124_i0 PRJNA438572 144 1804 24.692663 445.45564052 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 695 9.319999999999995e-247   NR MES1909605.1 1215613 g124 i0 77.1 4.40853658536585 433 99 72 0 1781 483 1 433 MES1909605.1 hypothetical protein [Cercozoa sp. M6MM] diamond 7953 701 0.991440798858773 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
10019184 10019184 PRJNA438572_P_NODE_24688_length_240_cov_2.778443_g24569_i0 PRJNA438572 24688 240 2.778443 6.6682632 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 138 5.63e-40   NR ADK47156.1 323453 g24569 i0 90.4 0.9125 73 7 91.3 0 219 1 1 73 ADK47156.1 ribosomal protein S23a [Heteromita sp. PRA-74] diamond 219 138 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
17012285 17012285 PRJNA438572_P_NODE_1654_length_744_cov_3.071535_g1550_i0 PRJNA438572 1654 744 3.071535 22.8522204 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 246 8.07e-80   NR ADK26622.1 323453 g1550 i0 88.5 0.524193548387097 130 15 52.4 0 25 414 1 130 ADK26622.1 rps22a [Heteromita sp. PRA-74] diamond 390 246 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
26917805 26917805 PRJNA438572_P_NODE_20942_length_247_cov_0.896552_g20823_i0 PRJNA438572 20942 247 0.896552 2.21448344 Bigelowiella natans 227086 SAR_Eukaryotes SAR_Eukaryotes 110 7.310000000000001e-27   NR AAO89069.1 227086 g20823 i0 67.1 0.959514170040486 79 25 96 1 3 239 89 166 AAO89069.1 cytosolic class I fructose-1,6-bisphosphate aldolase [Bigelowiella natans] diamond 237 110 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Bigelowiella Bigelowiella natans
28844285 28844285 PRJNA438572_P_NODE_12528_length_291_cov_1.431193_g12409_i0 PRJNA438572 12528 291 1.431193 4.16477163 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 119 5.600000000000001e-30   NR MES1909879.1 1215613 g12409 i0 60.4 3.88659793814433 96 36 99 1 289 2 111 204 MES1909879.1 hypothetical protein [Cercozoa sp. M6MM] diamond 1131 119 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
29428884 29428884 PRJNA438572_P_NODE_7309_length_374_cov_1.036545_g7190_i0 PRJNA438572 7309 374 1.036545 3.8766783 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 103 7.39e-24   NR AAT09089.1 227086 g7190 i0 49.5 1.67647058823529 103 50 81 1 311 9 8 110 AAT09089.1 calmodulin like myosin light chain [Bigelowiella natans] diamond 627 103 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Bigelowiella Bigelowiella natans
29444143 29444143 PRJNA438572_P_NODE_22590_length_244_cov_1.824561_g22471_i0 PRJNA438572 22590 244 1.824561 4.45192884 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 90.1 7.66e-19   NR MES1913326.1 1215613 g22471 i0 58.8 1.9672131147541 80 33 98.4 0 240 1 366 445 MES1913326.1 hypothetical protein [Cercozoa sp. M6MM] diamond 480 90.1 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
30486833 30486833 PRJNA438572_P_NODE_3313_length_541_cov_1.000000_g3195_i0 PRJNA438572 3313 541 1 5.41 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 88.2 2.1e-17   NR MES1908730.1 1215613 g3195 i0 48.7 0.432532347504621 78 40 43.3 0 8 241 169 246 MES1908730.1 hypothetical protein [Cercozoa sp. M6MM] diamond 234 88.2 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
31940758 31940758 PRJNA438572_P_NODE_18737_length_250_cov_0.966102_g18618_i0 PRJNA438572 18737 250 0.966102 2.415255 Bigelowiella natans 227086 SAR_Eukaryotes SAR_Eukaryotes 98.2 9.52e-24   NR AAT09077.1 227086 g18618 i0 60.8 0.888 74 29 88.8 0 225 4 1 74 AAT09077.1 transcription factor BTF3 [Bigelowiella natans] diamond 222 98.2 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Bigelowiella Bigelowiella natans
31940765 31940765 PRJNA438572_P_NODE_6977_length_381_cov_1.672078_g6858_i0 PRJNA438572 6977 381 1.672078 6.37061718 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 117 4.43e-28   NR MES1909771.1 1215613 g6858 i0 46 1.97637795275591 126 68 99.2 0 1 378 38 163 MES1909771.1 hypothetical protein [Cercozoa sp. M6MM] diamond 753 117 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
32115588 32115588 PRJNA438572_P_NODE_13618_length_281_cov_1.995192_g13499_i0 PRJNA438572 13618 281 1.995192 5.60648952 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 70.1 1.34e-11   NR MES1916036.1 1215613 g13499 i0 42.7 3.5017793594306 82 46 87.5 1 255 10 6 86 MES1916036.1 hypothetical protein [Cercozoa sp. M6MM] diamond 984 70.1 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);;