RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJEB10140" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 5 ✖

tax_clade 1

bioproject 1

  • PRJEB10140 · 5 ✖

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
2561313 2561313 PRJEB10140_P_NODE_111163_length_328_cov_2.774194_g93858_i0 PRJEB10140 111163 328 2.774194 9.09935632 Rosculus vulgaris 2231165 SAR_Eukaryotes SAR_Eukaryotes 259 1.69e-64   NTclustered gi|1402550474|gb|MH488760.1| 2231165 g93858 i0 81.682 29.0030487804878 333 41 100 15 1 328 2550 2867 Rosculus vulgaris isolate CCA sequence blastn 9513 259 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus vulgaris
2562665 2562665 PRJEB10140_P_NODE_27483_length_1213_cov_4.492268_g16550_i0 PRJEB10140 27483 1213 4.492268 54.49121084 Rosculus sp. 2231160 SAR_Eukaryotes SAR_Eukaryotes 2073 0   NTclustered gi|1402550473|gb|MH488759.1| 2231160 g16550 i0 97.457 16.3066776586974 1219 23 100 7 1 1213 144 1360 Rosculus sp. isolate CSA small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence blastn 19780 2073 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus sp.
19138182 19138182 PRJEB10140_P_NODE_266116_length_166_cov_0.871795_g248807_i0 PRJEB10140 266116 166 0.871795 1.4471797 Verrucomonas longifila 629764 SAR_Eukaryotes SAR_Eukaryotes 99 1.76e-16   NTclustered gi|290760489|gb|GQ144692.1| 629764 g248807 i0 89.744 41.6265060240964 78 6 47 2 22 99 1320 1245 Cercozoa sp. CC-2009f large subunit ribosomal RNA gene, partial sequence blastn 6910 99 1 Eukaryota Sar   Cercozoa Thecofilosea Ventricleftida   Verrucomonas Verrucomonas longifila
27000737 27000737 PRJEB10140_P_NODE_17342_length_1653_cov_3.018080_g9903_i0 PRJEB10140 17342 1653 3.01808 49.8888624 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 66.2 2.54e-7   NR MES1909332.1 1215613 g9903 i0 39.4 0.357531760435572 66 39 12 1 1187 990 224 288 MES1909332.1 hypothetical protein [Cercozoa sp. M6MM] diamond 591 66.2 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
30854084 30854084 PRJEB10140_P_NODE_280374_length_163_cov_1.368421_g263065_i0 PRJEB10140 280374 163 1.368421 2.23052623 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 52.8 1.2e-6   NR MES1913088.1 1215613 g263065 i0 56.8 0.680981595092024 37 16 68.1 0 5 115 119 155 MES1913088.1 hypothetical protein [Cercozoa sp. M6MM] diamond 111 52.8 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);;