RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where bioproject = "PRJEB6054", tax_clade = "Sar" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 10 ✖

tax_clade 1

  • Sar · 10 ✖

bioproject 1

  • PRJEB6054 · 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
25523117 25523117 PRJEB6054_S_NODE_3585_length_249_cov_2.032710_g3496_i0 PRJEB6054 3585 249 2.03271 5.0614479 Paracercomonas marina 372086 SAR_Eukaryotes SAR_Eukaryotes 158 4.639999999999999e-34   NTclustered gi|756877536|ref|NC_026310.1| 372086 g3496 i0 81.771 0.891566265060241 192 31 77 4 58 249 1670 1857 Paracercomonas marina strain ATCC 50344 mitochondrion, complete genome blastn 222 158 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Paracercomonas Paracercomonas marina
25658820 25658820 PRJEB6054_S_NODE_1138_length_363_cov_12.838415_g1050_i0 PRJEB6054 1138 363 12.838415 46.60344645 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 313 1.43e-80   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g1050 i0 83.621 59.0853994490358 348 42 96 11 17 363 4011 3678 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 21448 313 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
25659028 25659028 PRJEB6054_S_NODE_4282_length_233_cov_64294.590909_g4193_i0 PRJEB6054 4282 233 64294.590909 149806.39681797 Paracercomonas crassicauda 466266 SAR_Eukaryotes SAR_Eukaryotes 302 1.88e-77   NTclustered gi|262262832|gb|FJ790725.1| 466266 g4193 i0 100 70.137339055794 163 0 70 0 71 233 763 601 Paracercomonas crassicauda strain ATCC 50316 18S ribosomal RNA gene, partial sequence blastn 16342 302 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Paracercomonas Paracercomonas crassicauda
25794908 25794908 PRJEB6054_S_NODE_1283_length_350_cov_40509.377778_g1194_i0 PRJEB6054 1283 350 40509.377778 141782.822223 Paracercomonas crassicauda 466266 SAR_Eukaryotes SAR_Eukaryotes 501 2.73e-137   NTclustered gi|262262832|gb|FJ790725.1| 466266 g1194 i0 99.278 77.1 277 2 79 0 74 350 1006 730 Paracercomonas crassicauda strain ATCC 50316 18S ribosomal RNA gene, partial sequence blastn 26985 501 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Paracercomonas Paracercomonas crassicauda
25795077 25795077 PRJEB6054_S_NODE_4019_length_238_cov_5.453202_g3930_i0 PRJEB6054 4019 238 5.453202 12.97862076 Paracercomonas marina 372086 SAR_Eukaryotes SAR_Eukaryotes 250 7.06e-62   NTclustered gi|88792583|gb|DQ386164.1| 372086 g3930 i0 88.571 50.0714285714286 210 19 87 5 31 238 472 266 Paracercomonas marina 28S ribosomal RNA gene, partial sequence blastn 11917 250 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Paracercomonas Paracercomonas marina
26067485 26067485 PRJEB6054_S_NODE_9877_length_178_cov_1.468531_g9788_i0 PRJEB6054 9877 178 1.468531 2.61398518 Paracercomonas marina 372086 SAR_Eukaryotes SAR_Eukaryotes 89.8 1.15e-13   NTclustered gi|756877536|ref|NC_026310.1| 372086 g9788 i0 98.039 0.286516853932584 51 1 29 0 121 171 1518 1568 Paracercomonas marina strain ATCC 50344 mitochondrion, complete genome blastn 51 89.8 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Paracercomonas Paracercomonas marina
26339554 26339554 PRJEB6054_S_NODE_703_length_416_cov_35087.569554_g617_i0 PRJEB6054 703 416 35087.569554 145964.28934464 Paracercomonas crassicauda 466266 SAR_Eukaryotes SAR_Eukaryotes 621 2.43e-173   NTclustered gi|262262832|gb|FJ790725.1| 466266 g617 i0 99.706 80.7524038461538 340 0 82 1 1 340 45 383 Paracercomonas crassicauda strain ATCC 50316 18S ribosomal RNA gene, partial sequence blastn 33593 621 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Paracercomonas Paracercomonas crassicauda
26475523 26475523 PRJEB6054_S_NODE_11080_length_170_cov_8.355556_g10991_i0 PRJEB6054 11080 170 8.355556 14.2044452 Paracercomonas marina 372086 SAR_Eukaryotes SAR_Eukaryotes 296 5.95e-76   NTclustered gi|88792583|gb|DQ386164.1| 372086 g10991 i0 99.387 97 163 1 96 0 7 169 1540 1378 Paracercomonas marina 28S ribosomal RNA gene, partial sequence blastn 16490 296 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Paracercomonas Paracercomonas marina
26475783 26475783 PRJEB6054_S_NODE_5584_length_216_cov_2.900552_g5495_i0 PRJEB6054 5584 216 2.900552 6.26519232 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 167 6.52e-37   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g5495 i0 83.243 11.3240740740741 185 27 84 4 35 216 3901 3718 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 2446 167 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
32946007 32946007 PRJEB6054_S_NODE_5242_length_221_cov_1.784946_g5153_i0 PRJEB6054 5242 221 1.784946 3.94473066 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 64.7 5.59e-12   NR MES1911722.1 1215613 g5153 i0 74.3 0.475113122171946 35 9 47.5 0 220 116 18 52 MES1911722.1 hypothetical protein [Cercozoa sp. M6MM] diamond 105 64.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);;