RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where bioproject = "PRJNA1214993", tax_phylum = "Cercozoa" and tax_superkingdom = "Eukaryota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Eukaryota · 10 ✖

tax_phylum 1

  • Cercozoa · 10 ✖

tax_clade 1

bioproject 1

  • PRJNA1214993 · 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
10534138 10534138 PRJNA1214993_P_NODE_17109_length_271_cov_1.040404_g16923_i0 PRJNA1214993 17109 271 1.040404 2.81949484 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 105 4.5400000000000005e-27   NR ADK26622.1 323453 g16923 i0 93.9 0.542435424354244 49 3 54.2 0 1 147 82 130 ADK26622.1 rps22a [Heteromita sp. PRA-74] diamond 147 105 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
11809073 11809073 PRJNA1214993_P_NODE_8410_length_374_cov_2.465116_g8224_i0 PRJNA1214993 8410 374 2.465116 9.21953384 Heteromita globosa 45107 SAR_Eukaryotes SAR_Eukaryotes 564 3.7e-156   NTclustered gi|238617605|gb|FJ973380.1| 45107 g8224 i0 93.85 99.7486631016043 374 23 100 0 1 374 1559 1186 Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence blastn 37306 564 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita globosa
13083934 13083934 PRJNA1214993_P_NODE_11551_length_324_cov_1.533865_g11365_i0 PRJNA1214993 11551 324 1.533865 4.9697226 Heteromita globosa 45107 SAR_Eukaryotes SAR_Eukaryotes 477 4.2399999999999985e-130   NTclustered gi|238617605|gb|FJ973380.1| 45107 g11365 i0 93.252 90.5 326 19 100 3 1 324 2511 2187 Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence blastn 29322 477 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita globosa
14359257 14359257 PRJNA1214993_P_NODE_12212_length_315_cov_3.024793_g12026_i0 PRJNA1214993 12212 315 3.024793 9.52809795 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 327 4.37e-85   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g12026 i0 86.262 43.5555555555556 313 29 99 7 4 315 4008 3709 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 13720 327 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
14359439 14359439 PRJNA1214993_P_NODE_9152_length_361_cov_1.173611_g8966_i0 PRJNA1214993 9152 361 1.173611 4.23673571 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 230 1.14e-75   NR ADK47156.1 323453 g8966 i0 95.7 0.972299168975069 117 5 97.2 0 360 10 29 145 ADK47156.1 ribosomal protein S23a [Heteromita sp. PRA-74] diamond 351 230 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
18181856 18181856 PRJNA1214993_P_NODE_18455_length_261_cov_1.021277_g18269_i0 PRJNA1214993 18455 261 1.021277 2.66553297 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 137 1.94e-39   NR ADK26622.1 323453 g18269 i0 94.4 0.827586206896552 72 4 82.8 0 216 1 1 72 ADK26622.1 rps22a [Heteromita sp. PRA-74] diamond 216 137 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
24556537 24556537 PRJNA1214993_P_NODE_6520_length_421_cov_2.149425_g6335_i0 PRJNA1214993 6520 421 2.149425 9.04907925 Bigelowiella natans 227086 SAR_Eukaryotes SAR_Eukaryotes 122 8.26e-33   NR AAT09102.1 227086 g6335 i0 48.8 0.876484560570071 123 55 87.6 2 51 419 21 135 AAT09102.1 cysteine proteinase, partial [Bigelowiella natans] diamond 369 122 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Bigelowiella Bigelowiella natans
25271565 25271565 PRJNA1214993_P_NODE_6320_length_427_cov_3.022599_g6135_i0 PRJNA1214993 6320 427 3.022599 12.90649773 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 237 1.12e-74   NR MES1910618.1 1215613 g6135 i0 79.4 0.990632318501171 141 29 99.1 0 3 425 123 263 MES1910618.1 hypothetical protein [Cercozoa sp. M6MM] diamond 423 237 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
27009272 27009272 PRJNA1214993_P_NODE_26422_length_237_cov_2.993902_g26236_i0 PRJNA1214993 26422 237 2.993902 7.09554774 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 99.4 1.7699999999999998e-23   NR MES1909335.1 1215613 g26236 i0 59.7 0.911392405063291 72 29 91.1 0 218 3 7 78 MES1909335.1 Eukaryotic translation initiation factor 6 [Cercozoa sp. M6MM] diamond 216 99.4 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
32000885 32000885 PRJNA1214993_P_NODE_20058_length_252_cov_1.083799_g19872_i0 PRJNA1214993 20058 252 1.083799 2.73117348 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 76.3 3.61e-15   NR MES1909107.1 1215613 g19872 i0 51.3 1.91666666666667 80 37 95.2 2 244 5 8 85 MES1909107.1 hypothetical protein [Cercozoa sp. M6MM] diamond 483 76.3 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);;