RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where tax_clade = "eukaryote SCGC" and tax_superkingdom = "Eukaryota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Eukaryota · 6 ✖

tax_clade 1

  • eukaryote SCGC · 6 ✖

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
602143 602143 PRJNA630162_P_NODE_31161_length_323_cov_3.576642_g29639_i0 PRJNA630162 31161 323 3.576642 11.55255366 eukaryote SCGC AAA074-C16 1010495 Root_unresolved Root_unresolved 311 4.53e-80   NTclustered gi|336111305|gb|JF488758.1| 1010495 g29639 i0 84.858 63.953560371517 317 38 97 9 12 323 2 313 Eukaryote SCGC AAA074-C16 16S ribosomal RNA gene, partial sequence; mitochondrial blastn 20657 311 1 Eukaryota eukaryote SCGC             eukaryote SCGC AAA074-C16
5081392 5081392 PRJNA928559_P_NODE_26624_length_627_cov_11.277978_g25111_i0 PRJNA928559 26624 627 11.277978 70.71292206 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 259 3.42e-64   NTclustered gi|336111297|gb|JF488750.1| 1010475 g25111 i0 77.582 40.4481658692185 455 84 70 15 11 450 602 151 Eukaryote SCGC AAA074-A06 16S ribosomal RNA gene, partial sequence; mitochondrial blastn 25361 259 1 Eukaryota eukaryote SCGC             eukaryote SCGC AAA074-A06
7100638 7100638 PRJNA743294_P_NODE_19846_length_364_cov_3.439863_g19390_i0 PRJNA743294 19846 364 3.439863 12.52110132 eukaryote SCGC AAA074-C16 1010495 Root_unresolved Root_unresolved 246 1.48e-60   NTclustered gi|336111305|gb|JF488758.1| 1010495 g19390 i0 81.115 57.771978021978 323 48 85 12 54 364 139 460 Eukaryote SCGC AAA074-C16 16S ribosomal RNA gene, partial sequence; mitochondrial blastn 21029 246 1 Eukaryota eukaryote SCGC             eukaryote SCGC AAA074-C16
8645945 8645945 PRJEB64798_P_NODE_13967_length_534_cov_12.055670_g12309_i0 PRJEB64798 13967 534 12.05567 64.3772778 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 492 2.61e-134   NTclustered gi|336111309|gb|JF488762.1| 1010461 g12309 i0 83.333 91.9700374531835 540 83 100 7 1 534 135 673 Eukaryote SCGC AAA071-M11 16S ribosomal RNA gene, partial sequence; mitochondrial blastn 49112 492 1 Eukaryota eukaryote SCGC             eukaryote SCGC AAA071-M11
12630281 12630281 PRJNA630162_P_NODE_138410_length_167_cov_1.644068_g136887_i0 PRJNA630162 138410 167 1.644068 2.74559356 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 165 1.72e-36   NTclustered gi|336111309|gb|JF488762.1| 1010461 g136887 i0 84.94 72.9700598802395 166 21 98 4 1 163 711 547 Eukaryote SCGC AAA071-M11 16S ribosomal RNA gene, partial sequence; mitochondrial blastn 12186 165 1 Eukaryota eukaryote SCGC             eukaryote SCGC AAA071-M11
14641796 14641796 PRJNA641707_P_NODE_194512_length_198_cov_6.818792_g191849_i0 PRJNA641707 194512 198 6.818792 13.50120816 eukaryote SCGC AAA071-L13 1010456 Root_unresolved Root_unresolved 185 1.62e-42   NTclustered gi|336111346|gb|JF488799.1| 1010456 g191849 i0 92.969 77.4191919191919 128 7 65 2 1 128 922 797 Eukaryote SCGC AAA071-L13 18S ribosomal RNA gene, partial sequence blastn 15329 185 1 Eukaryota eukaryote SCGC             eukaryote SCGC AAA071-L13

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