RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA1063685" and tax_clade = "CRuMs"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • CRuMs · 5 ✖

bioproject 1

  • PRJNA1063685 · 5 ✖

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
7832127 7832127 PRJNA1063685_S_NODE_28667_length_438_cov_29.098630_g28125_i0 PRJNA1063685 28667 438 29.09863 127.4519994 Diphylleia rotans 190327 Root_unresolved Root_unresolved 797 0   NTclustered gi|1200177731|gb|MF039365.1| 190327 g28125 i0 99.543 80.7511415525114 438 1 100 1 1 438 5767 5331 Diphylleia rotans isolate D_NIES3764 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 35369 797 1 Eukaryota CRuMs         Collodictyonidae Diphylleia Diphylleia rotans
11657996 11657996 PRJNA1063685_S_NODE_22570_length_486_cov_2.334140_g22030_i0 PRJNA1063685 22570 486 2.33414 11.3439204 Diphylleia rotans 190327 Root_unresolved Root_unresolved 887 0   NTclustered gi|1200177731|gb|MF039365.1| 190327 g22030 i0 99.588 36.6399176954733 486 2 100 0 1 486 4512 4997 Diphylleia rotans isolate D_NIES3764 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 17807 887 1 Eukaryota CRuMs         Collodictyonidae Diphylleia Diphylleia rotans
14208458 14208458 PRJNA1063685_S_NODE_58952_length_283_cov_43.676190_g58409_i0 PRJNA1063685 58952 283 43.67619 123.6036177 Diphylleia rotans 190327 Root_unresolved Root_unresolved 481 2.81e-131   NTclustered gi|1200177731|gb|MF039365.1| 190327 g58409 i0 99.62 36.5441696113074 263 1 93 0 21 283 2730 2992 Diphylleia rotans isolate D_NIES3764 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 10342 481 1 Eukaryota CRuMs         Collodictyonidae Diphylleia Diphylleia rotans
21856560 21856560 PRJNA1063685_S_NODE_53078_length_305_cov_8.215517_g52535_i0 PRJNA1063685 53078 305 8.215517 25.05732685 Diphylleia rotans 190327 Root_unresolved Root_unresolved 558 1.37e-154   NTclustered gi|1200177731|gb|MF039365.1| 190327 g52535 i0 99.672 48.9147540983607 305 1 100 0 1 305 3280 2976 Diphylleia rotans isolate D_NIES3764 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 14919 558 1 Eukaryota CRuMs         Collodictyonidae Diphylleia Diphylleia rotans
23131963 23131963 PRJNA1063685_S_NODE_48359_length_326_cov_6.110672_g47816_i0 PRJNA1063685 48359 326 6.110672 19.92079072 Diphylleia rotans 190327 Root_unresolved Root_unresolved 152 2.94e-32   NTclustered gi|1200177731|gb|MF039365.1| 190327 g47816 i0 92.453 47.0981595092025 106 8 33 0 1 106 4730 4835 Diphylleia rotans isolate D_NIES3764 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 15354 152 1 Eukaryota CRuMs         Collodictyonidae Diphylleia Diphylleia rotans

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