RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJEB4632", tax_phylum = "Chlorophyta" and tax_superkingdom = "Eukaryota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Eukaryota · 7 ✖

tax_phylum 1

  • Chlorophyta · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB4632 · 7 ✖

analysis 1

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
3887687 3887687 PRJEB4632_P_NODE_664_length_269_cov_2.535714_g626_i0 PRJEB4632 664 269 2.535714 6.82107066 Ulothrix zonata 43941 Plants Plants 497 2.63e-136   NTclustered gi|530445654|emb|HE860533.1| 43941 g626 i0 100 99.1263940520446 269 0 100 0 1 269 292 24 Ulothrix zonata partial 28S rRNA gene, isolate Q19 blastn 26665 497 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Ulvophyceae Ulotrichales Ulotrichaceae Ulothrix Ulothrix zonata
7367602 7367602 PRJEB4632_P_NODE_1066_length_214_cov_4.141844_g1028_i0 PRJEB4632 1066 214 4.141844 8.86354616 Ulvaceae 3114 Plants Plants 361 2.7599999999999993e-95   NTclustered gi|2070425893|gb|MZ596105.1| 3116 g1028 i0 97.196 100.060747663551 214 5 100 1 1 214 2325 2537 Ulva intestinalis strain CNS00531 large subunit ribosomal RNA gene, partial sequence blastn 21413 363 0.994490358126722 Eukaryota core chlorophytes Viridiplantae Chlorophyta Ulvophyceae Ulvales Ulvaceae Ulva Ulva intestinalis
15363791 15363791 PRJEB4632_P_NODE_553_length_300_cov_2.449339_g515_i0 PRJEB4632 553 300 2.449339 7.348017 Sarcinofilum mucosum 141643 Plants Plants 473 5.03e-129   NTclustered gi|1197510887|ref|NC_034709.1| 141643 g515 i0 95.302 99.76 298 14 99 0 1 298 146630 146333 Trichosarcina mucosa culture SAG:4.90 chloroplast, complete genome blastn 29928 473 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Ulvophyceae Ulotrichales Sarcinofilaceae Sarcinofilum Sarcinofilum mucosum
16638358 16638358 PRJEB4632_P_NODE_954_length_243_cov_0.905882_g916_i0 PRJEB4632 954 243 0.905882 2.20129326 Diplosphaera sp. (in: green algae) 2911680 Plants Plants 383 6.84e-102   NTclustered gi|2644500050|gb|PP079688.1| 2911680 g916 i0 95.062 98.559670781893 243 12 100 0 1 243 1535 1777 Diplosphaera sp. (in: green algae) isolate C3 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 23950 383 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Prasiolales Stichococcaceae Diplosphaera Diplosphaera sp. (in: green algae)
19187101 19187101 PRJEB4632_P_NODE_656_length_271_cov_0.843434_g618_i0 PRJEB4632 656 271 0.843434 2.28570614 Chloroidium ellipsoideum 63676 Plants Plants 267 8.149999999999999e-67   NTclustered gi|1169296931|gb|KY364701.1| 63676 g618 i0 84.727 14.7380073800738 275 33 100 8 1 271 5423 5692 Chloroidium ellipsoideum 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 3994 267 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Watanabeales Watanabeaceae Chloroidium Chloroidium ellipsoideum
22666941 22666941 PRJEB4632_P_NODE_598_length_286_cov_4.023474_g560_i0 PRJEB4632 598 286 4.023474 11.50713564 Eukaryota 2759 Plants Plants 529 1e-145   NTclustered gi|1189013852|gb|MF034633.1| 43939 g560 i0 100 100.01048951049 286 0 100 0 1 286 947 662 Hazenia basiliensis strain ULVO-15 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 28603 529 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Ulvophyceae Ulotrichales Hazeniaceae Hazenia Hazenia basiliensis
23942365 23942365 PRJEB4632_P_NODE_639_length_275_cov_1.866337_g601_i0 PRJEB4632 639 275 1.866337 5.13242675 Eukaryota 2759 Plants Plants 503 5.809999999999998e-138   NTclustered gi|1189013852|gb|MF034633.1| 43939 g601 i0 99.636 100.010909090909 275 1 100 0 1 275 69 343 Hazenia basiliensis strain ULVO-15 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 27503 508 0.990157480314961 Eukaryota core chlorophytes Viridiplantae Chlorophyta Ulvophyceae Ulotrichales Hazeniaceae Hazenia Hazenia basiliensis

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