RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "blastn", bioproject = "PRJEB6055" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 14 ✖

tax_clade 1

bioproject 1

  • PRJEB6055 · 14 ✖

analysis 1

  • blastn · 14 ✖

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
1400027 1400027 PRJEB6055_S_NODE_462_length_342_cov_22.006515_g438_i0 PRJEB6055 462 342 22.006515 75.2622813 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 309 1.7400000000000002e-79   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g438 i0 83.626 62.2134502923977 342 42 99 10 2 342 4007 3679 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 21277 309 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
2675603 2675603 PRJEB6055_S_NODE_1343_length_249_cov_2.672897_g1319_i0 PRJEB6055 1343 249 2.672897 6.65551353 Paracercomonas marina 372086 SAR_Eukaryotes SAR_Eukaryotes 374 4.23e-99   NTclustered gi|88792583|gb|DQ386164.1| 372086 g1319 i0 94.628 98.8192771084337 242 11 97 2 9 249 1959 1719 Paracercomonas marina 28S ribosomal RNA gene, partial sequence blastn 24606 374 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Paracercomonas Paracercomonas marina
2675605 2675605 PRJEB6055_S_NODE_143_length_473_cov_3.833333_g121_i0 PRJEB6055 143 473 3.833333 18.13166509 Paracercomonas marina 372086 SAR_Eukaryotes SAR_Eukaryotes 220 1.19e-52   NTclustered gi|756877536|ref|NC_026310.1| 372086 g121 i0 79.573 0.693446088794926 328 52 67 12 158 473 1518 1842 Paracercomonas marina strain ATCC 50344 mitochondrion, complete genome blastn 328 220 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Paracercomonas Paracercomonas marina
3542800 3542800 PRJEB6055_S_NODE_2823_length_195_cov_2.656250_g2799_i0 PRJEB6055 2823 195 2.65625 5.1796875 Lotharella 74819 SAR_Eukaryotes SAR_Eukaryotes 126 9.79e-25   NTclustered gi|220983373|dbj|AB453009.1| 74820 g2799 i0 84.921 28.8871794871795 126 18 64 1 43 167 3094 2969 Lotharella vacuolata gene for nuclear large subunit ribosomal RNA, partial sequence blastn 5633 126 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Lotharella Lotharella vacuolata
3951604 3951604 PRJEB6055_S_NODE_1524_length_237_cov_18360.935644_g1500_i0 PRJEB6055 1524 237 18360.935644 43515.41747628 Paracercomonas marina 372086 SAR_Eukaryotes SAR_Eukaryotes 302 1.91e-77   NTclustered gi|88792583|gb|DQ386164.1| 372086 g1500 i0 98.817 72.0801687763713 169 2 71 0 69 237 1538 1370 Paracercomonas marina 28S ribosomal RNA gene, partial sequence blastn 17083 302 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Paracercomonas Paracercomonas marina
8645372 8645372 PRJEB6055_S_NODE_1667_length_230_cov_19083.312821_g1643_i0 PRJEB6055 1667 230 19083.312821 43891.6194883 Cercomonadidae 45108 SAR_Eukaryotes SAR_Eukaryotes 300 6.64e-77   NTclustered gi|1695780|gb|U42448.1|CAU42448 45110 g1643 i0 99.39 71.4695652173913 164 1 71 0 67 230 769 606 Cercomonas ATCC50316 18S ribosomal RNA gene, complete sequence blastn 16438 303 0.99009900990099 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Cercomonas Cercomonas sp. ATCC 50316
9052811 9052811 PRJEB6055_S_NODE_448_length_345_cov_18.596774_g424_i0 PRJEB6055 448 345 18.596774 64.1588703 Paracercomonas crassicauda 466266 SAR_Eukaryotes SAR_Eukaryotes 632 9.17e-177   NTclustered gi|262262832|gb|FJ790725.1| 466266 g424 i0 99.71 98.7391304347826 345 1 100 0 1 345 389 45 Paracercomonas crassicauda strain ATCC 50316 18S ribosomal RNA gene, partial sequence blastn 34065 632 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Paracercomonas Paracercomonas crassicauda
10328568 10328568 PRJEB6055_S_NODE_1329_length_250_cov_2.418605_g1305_i0 PRJEB6055 1329 250 2.418605 6.0465125 Paracercomonas marina 372086 SAR_Eukaryotes SAR_Eukaryotes 340 4.31e-89   NTclustered gi|756877536|ref|NC_026310.1| 372086 g1305 i0 91.2 1 250 22 100 0 1 250 18121 17872 Paracercomonas marina strain ATCC 50344 mitochondrion, complete genome blastn 250 340 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Paracercomonas Paracercomonas marina
11603971 11603971 PRJEB6055_S_NODE_2810_length_195_cov_11.625000_g2786_i0 PRJEB6055 2810 195 11.625 22.66875 Paracercomonas marina 372086 SAR_Eukaryotes SAR_Eukaryotes 333 5.369999999999999e-87   NTclustered gi|88792583|gb|DQ386164.1| 372086 g2786 i0 97.449 145.74358974359 196 4 100 1 1 195 1731 1536 Paracercomonas marina 28S ribosomal RNA gene, partial sequence blastn 28420 333 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Paracercomonas Paracercomonas marina
11603979 11603979 PRJEB6055_S_NODE_5110_length_159_cov_2.435484_g5086_i0 PRJEB6055 5110 159 2.435484 3.87241956 Paracercomonas marina 372086 SAR_Eukaryotes SAR_Eukaryotes 176 7.49e-40   NTclustered gi|88792583|gb|DQ386164.1| 372086 g5086 i0 89.362 0.886792452830189 141 14 88 1 20 159 2160 2020 Paracercomonas marina 28S ribosomal RNA gene, partial sequence blastn 141 176 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Paracercomonas Paracercomonas marina
12471243 12471243 PRJEB6055_S_NODE_2330_length_207_cov_21561.197674_g2306_i0 PRJEB6055 2330 207 21561.197674 44631.67918518 Cercomonadidae 45108 SAR_Eukaryotes SAR_Eukaryotes 254 4.63e-63   NTclustered gi|1695780|gb|U42448.1|CAU42448 45110 g2306 i0 100 66.2270531400966 137 0 66 0 71 207 1139 1003 Cercomonas ATCC50316 18S ribosomal RNA gene, complete sequence blastn 13709 254 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Cercomonas Cercomonas sp. ATCC 50316
16702211 16702211 PRJEB6055_S_NODE_1534_length_237_cov_5.935644_g1510_i0 PRJEB6055 1534 237 5.935644 14.06747628 Paracercomonas marina 372086 SAR_Eukaryotes SAR_Eukaryotes 250 7.0299999999999995e-62   NTclustered gi|88792583|gb|DQ386164.1| 372086 g1510 i0 87.671 49.7721518987342 219 22 92 5 21 237 484 269 Paracercomonas marina 28S ribosomal RNA gene, partial sequence blastn 11796 250 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Paracercomonas Paracercomonas marina
16702220 16702220 PRJEB6055_S_NODE_2354_length_207_cov_4.168605_g2330_i0 PRJEB6055 2354 207 4.168605 8.62901235 Paracercomonas marina 372086 SAR_Eukaryotes SAR_Eukaryotes 311 2.71e-80   NTclustered gi|88792583|gb|DQ386164.1| 372086 g2330 i0 93.75 151.12077294686 208 12 100 1 1 207 2500 2707 Paracercomonas marina 28S ribosomal RNA gene, partial sequence blastn 31282 311 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Paracercomonas Paracercomonas marina
25218348 25218348 PRJEB6055_S_NODE_1480_length_240_cov_19.214634_g1456_i0 PRJEB6055 1480 240 19.214634 46.1151216 Cercomonadidae 45108 SAR_Eukaryotes SAR_Eukaryotes 435 1.83e-117   NTclustered gi|62184287|gb|AY884341.1| 321452 g1456 i0 99.58 100.0375 238 1 99 0 1 238 911 674 Cercomonas sp. strain 19-5C small subunit ribosomal RNA gene, partial sequence blastn 24009 438 0.993150684931507 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Cercomonas Cercomonas sp. strain 19-5C

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