RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", tax_clade = "Pyramimonas subgenus I" and tax_phylum = "Chlorophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chlorophyta · 10 ✖

tax_kingdom 1

tax_clade 1

  • Pyramimonas subgenus I · 10 ✖

analysis 1

  • blastn · 10 ✖
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
2721152 2721152 PRJNA1041773_P_NODE_69863_length_262_cov_2.190476_g69530_i0 PRJNA1041773 69863 262 2.190476 5.73904712 Pyramimonas olivacea 36892 Plants Plants 407 4.43e-109   NTclustered gi|371782121|emb|HE610153.1| 36892 g69530 i0 94.656 100.507633587786 262 14 100 0 1 262 2590 2329 Pyramimonas olivacea 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain M1668 blastn 26333 407 1 Eukaryota Pyramimonas subgenus I Viridiplantae Chlorophyta Pyramimonadophyceae Pyramimonadales Pyramimonadaceae Pyramimonas Pyramimonas olivacea
6149066 6149066 PRJNA1218816_P_NODE_22365_length_454_cov_2.194226_g21932_i0 PRJNA1218816 22365 454 2.194226 9.96178604 Eukaryota 2759 Plants Plants 204 1.15e-47   NTclustered gi|371782121|emb|HE610153.1| 36892 g21932 i0 94.656 45.5550660792952 131 7 29 0 262 392 3322 3452 Pyramimonas olivacea 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain M1668 blastn 20682 204 1 Eukaryota Pyramimonas subgenus I Viridiplantae Chlorophyta Pyramimonadophyceae Pyramimonadales Pyramimonadaceae Pyramimonas Pyramimonas olivacea
9293990 9293990 PRJNA193544_S_NODE_3228_length_155_cov_14.738095_g3213_i0 PRJNA193544 3228 155 14.738095 22.84404725 Pyramimonas olivacea 36892 Plants Plants 171 3.37e-38   NTclustered gi|5851735|dbj|AB017122.3| 36892 g3213 i0 86.624 101.858064516129 157 17 100 4 1 155 1254 1408 Pyramimonas olivacea gene for 18S rRNA, partial sequence blastn 15788 171 1 Eukaryota Pyramimonas subgenus I Viridiplantae Chlorophyta Pyramimonadophyceae Pyramimonadales Pyramimonadaceae Pyramimonas Pyramimonas olivacea
9982390 9982390 PRJNA168635_P_NODE_3328_length_457_cov_254.264706_g2929_i0 PRJNA168635 3328 457 254.264706 1161.98970642 Pyramimonas 36882 Plants Plants 241 8.81e-59   NTclustered gi|371782121|emb|HE610153.1| 36892 g2929 i0 85.965 51.5557986870897 228 29 49 3 232 457 3325 3551 Pyramimonas olivacea 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain M1668 blastn 23561 241 1 Eukaryota Pyramimonas subgenus I Viridiplantae Chlorophyta Pyramimonadophyceae Pyramimonadales Pyramimonadaceae Pyramimonas Pyramimonas olivacea
10134563 10134563 PRJNA766854_P_NODE_2208_length_288_cov_3.057915_g2082_i0 PRJNA766854 2208 288 3.057915 8.8067952 Pyramimonas 36882 Plants Plants 150 9.18e-32   NTclustered gi|371782121|emb|HE610153.1| 36892 g2082 i0 96.667 31.59375 90 3 31 0 1 90 2318 2229 Pyramimonas olivacea 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain M1668 blastn 9099 150 1 Eukaryota Pyramimonas subgenus I Viridiplantae Chlorophyta Pyramimonadophyceae Pyramimonadales Pyramimonadaceae Pyramimonas Pyramimonas olivacea
10181329 10181329 PRJNA928559_P_NODE_132928_length_307_cov_6.102564_g131359_i0 PRJNA928559 132928 307 6.102564 18.73487148 Eukaryota 2759 Plants Plants 204 7.469999999999998e-48   NTclustered gi|371782121|emb|HE610153.1| 36892 g131359 i0 94.118 45.9609120521173 136 5 44 2 5 139 2575 2708 Pyramimonas olivacea 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain M1668 blastn 14110 206 0.990291262135922 Eukaryota Pyramimonas subgenus I Viridiplantae Chlorophyta Pyramimonadophyceae Pyramimonadales Pyramimonadaceae Pyramimonas Pyramimonas olivacea
12097411 12097411 PRJNA642647_P_NODE_330_length_616_cov_70.822107_g284_i0 PRJNA642647 330 616 70.822107 436.26417912 Pyramimonas olivacea 36892 Plants Plants 641 2.8499999999999993e-179   NTclustered gi|290770791|emb|FN563103.1| 36892 g284 i0 85.714 89.2775974025974 623 72 99 13 1 613 1460 845 Pyramimonas olivacea plastid 16S rRNA gene (partial), ITS1, tRNA-Ile gene, tRNA-Ala gene and 23S rRNA gene (partial), strain M1668 blastn 54995 641 1 Eukaryota Pyramimonas subgenus I Viridiplantae Chlorophyta Pyramimonadophyceae Pyramimonadales Pyramimonadaceae Pyramimonas Pyramimonas olivacea
14309758 14309758 PRJNA1123436_P_NODE_9932_length_916_cov_9.527877_g8898_i0 PRJNA1123436 9932 916 9.527877 87.27535332 Pyramimonas olivacea 36892 Plants Plants 514 9.82e-141   NTclustered gi|371782121|emb|HE610153.1| 36892 g8898 i0 84.259 62.6975982532751 540 72 59 9 153 689 2009 1480 Pyramimonas olivacea 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain M1668 blastn 57431 514 1 Eukaryota Pyramimonas subgenus I Viridiplantae Chlorophyta Pyramimonadophyceae Pyramimonadales Pyramimonadaceae Pyramimonas Pyramimonas olivacea
16454357 16454357 PRJNA630162_P_NODE_75753_length_206_cov_13.503185_g74230_i0 PRJNA630162 75753 206 13.503185 27.8165611 Pyramimonas 36882 Plants Plants 206 1.3099999999999999e-48   NTclustered gi|371782121|emb|HE610153.1| 36892 g74230 i0 85.222 104.490291262136 203 27 98 3 2 202 3549 3348 Pyramimonas olivacea 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain M1668 blastn 21525 206 1 Eukaryota Pyramimonas subgenus I Viridiplantae Chlorophyta Pyramimonadophyceae Pyramimonadales Pyramimonadaceae Pyramimonas Pyramimonas olivacea
23945077 23945077 PRJEB64798_P_NODE_119399_length_206_cov_47.796178_g117633_i0 PRJEB64798 119399 206 47.796178 98.46012668 Pyramimonas 36882 Plants Plants 211 2.81e-50   NTclustered gi|371782121|emb|HE610153.1| 36892 g117633 i0 85.714 104.514563106796 203 26 98 3 1 201 3550 3349 Pyramimonas olivacea 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain M1668 blastn 21530 211 1 Eukaryota Pyramimonas subgenus I Viridiplantae Chlorophyta Pyramimonadophyceae Pyramimonadales Pyramimonadaceae Pyramimonas Pyramimonas olivacea

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