RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where tax_clade = "mixed libraries" and tax_superkingdom = "Eukaryota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Eukaryota · 10 ✖

tax_clade 1

  • mixed libraries · 10 ✖

analysis 1

tax_phylum 0

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
404670 404670 PRJNA382357_P_NODE_94481_length_248_cov_2.085561_g93742_i0 PRJNA382357 94481 248 2.085561 5.17219128 Seriatopora hystrix/Symbiodinium mixed library 1076621 Root_unresolved Root_unresolved 243 1.24e-59   NTclustered gi|349573075|gb|JN600029.1| 1076621 g93742 i0 100 1.39516129032258 131 0 53 0 1 131 1082 1212 Seriatopora hystrix/Symbiodinium mixed library clone ShD_B69 mRNA sequence blastn 346 243 1 Eukaryota mixed libraries             Seriatopora hystrix/Symbiodinium mixed library
6884694 6884694 PRJNA533623_P_NODE_65546_length_234_cov_7.161850_g63765_i0 PRJNA533623 65546 234 7.16185 16.758729 Seriatopora hystrix/Symbiodinium mixed library 1076621 Root_unresolved Root_unresolved 420 4.99e-113   NTclustered gi|349573075|gb|JN600029.1| 1076621 g63765 i0 100 0.97008547008547 227 0 97 0 1 227 1060 834 Seriatopora hystrix/Symbiodinium mixed library clone ShD_B69 mRNA sequence blastn 227 420 1 Eukaryota mixed libraries             Seriatopora hystrix/Symbiodinium mixed library
8163543 8163543 PRJNA546018_S_NODE_19007_length_373_cov_2.169872_g18682_i0 PRJNA546018 19007 373 2.169872 8.09362256 Seriatopora hystrix/Symbiodinium mixed library 1076621 Root_unresolved Root_unresolved 627 4.639999999999999e-175   NTclustered gi|349573075|gb|JN600029.1| 1076621 g18682 i0 99.708 0.919571045576407 343 0 92 1 22 364 735 394 Seriatopora hystrix/Symbiodinium mixed library clone ShD_B69 mRNA sequence blastn 343 627 1 Eukaryota mixed libraries             Seriatopora hystrix/Symbiodinium mixed library
11050299 11050299 PRJNA861969_P_NODE_41309_length_241_cov_0.916667_g41078_i0 PRJNA861969 41309 241 0.916667 2.20916747 Seriatopora hystrix/Symbiodinium mixed library 1076621 Root_unresolved Root_unresolved 165 2.67e-36   NTclustered gi|349573042|gb|JN599996.1| 1076621 g41078 i0 81.592 0.83402489626556 201 35 83 2 1 200 288 487 Seriatopora hystrix/Symbiodinium mixed library clone ShD_H94 mRNA sequence blastn 201 165 1 Eukaryota mixed libraries             Seriatopora hystrix/Symbiodinium mixed library
12238936 12238936 PRJNA781196_P_NODE_3790_length_779_cov_10.014164_g3459_i0 PRJNA781196 3790 779 10.014164 78.01033756 Seriatopora hystrix/Symbiodinium mixed library 1076621 Root_unresolved Root_unresolved 460 1.1000000000000002e-124   NTclustered gi|349573045|gb|JN599999.1| 1076621 g3459 i0 81.964 0.917843388960205 560 85 71 16 122 673 616 65 Seriatopora hystrix/Symbiodinium mixed library clone ShD_J72 mRNA sequence blastn 715 460 1 Eukaryota mixed libraries             Seriatopora hystrix/Symbiodinium mixed library
14586961 14586961 PRJNA565778_S_NODE_18032_length_260_cov_136.600897_g17736_i0 PRJNA565778 18032 260 136.600897 355.1623322 Seriatopora hystrix/Symbiodinium mixed library 1076621 Root_unresolved Root_unresolved 381 2.659999999999999e-101   NTclustered gi|349573075|gb|JN600029.1| 1076621 g17736 i0 100 0.792307692307692 206 0 79 0 23 228 1039 834 Seriatopora hystrix/Symbiodinium mixed library clone ShD_B69 mRNA sequence blastn 206 381 1 Eukaryota mixed libraries             Seriatopora hystrix/Symbiodinium mixed library
18693637 18693637 PRJNA855894_P_NODE_31495_length_247_cov_1.327586_g31373_i0 PRJNA855894 31495 247 1.327586 3.27913742 Seriatopora hystrix/Symbiodinium mixed library 1076621 Root_unresolved Root_unresolved 235 2.07e-57   NTclustered gi|349573086|gb|JN600040.1| 1076621 g31373 i0 89.947 0.765182186234818 189 10 77 1 59 247 481 302 Seriatopora hystrix/Symbiodinium mixed library clone ShD_C71 mRNA sequence blastn 189 235 1 Eukaryota mixed libraries             Seriatopora hystrix/Symbiodinium mixed library
21244458 21244458 PRJNA855894_P_NODE_34057_length_242_cov_0.911243_g33935_i0 PRJNA855894 34057 242 0.911243 2.20520806 Seriatopora hystrix/Symbiodinium mixed library 1076621 Root_unresolved Root_unresolved 409 1.12e-109   NTclustered gi|349573033|gb|JN599987.1| 1076621 g33935 i0 97.107 4.93801652892562 242 7 100 0 1 242 343 102 Seriatopora hystrix/Symbiodinium mixed library clone ShD_A86 mRNA sequence blastn 1195 409 1 Eukaryota mixed libraries             Seriatopora hystrix/Symbiodinium mixed library
21325560 21325560 PRJNA944150_P_NODE_13397_length_233_cov_1.663043_g13146_i0 PRJNA944150 13397 233 1.663043 3.87489019 Seriatopora hystrix/Symbiodinium mixed library 1076621 Root_unresolved Root_unresolved 431 2.2899999999999996e-116   NTclustered gi|349573075|gb|JN600029.1| 1076621 g13146 i0 100 1 233 0 100 0 1 233 476 708 Seriatopora hystrix/Symbiodinium mixed library clone ShD_B69 mRNA sequence blastn 233 431 1 Eukaryota mixed libraries             Seriatopora hystrix/Symbiodinium mixed library
23602698 23602698 PRJNA680334_S_NODE_46579_length_196_cov_3.263804_g46093_i0 PRJNA680334 46579 196 3.263804 6.39705584 Seriatopora hystrix/Symbiodinium mixed library 1076621 Root_unresolved Root_unresolved 329 6.99e-86   NTclustered gi|349573075|gb|JN600029.1| 1076621 g46093 i0 97.449 1 196 0 100 5 1 196 608 798 Seriatopora hystrix/Symbiodinium mixed library clone ShD_B69 mRNA sequence blastn 196 329 1 Eukaryota mixed libraries             Seriatopora hystrix/Symbiodinium mixed library

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