RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA767802" and tax_phylum = "Chlorophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chlorophyta · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA767802 · 6 ✖

analysis 1

  • blastn · 6 ✖
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
5848764 5848764 PRJNA767802_P_NODE_7445_length_279_cov_2.386957_g7372_i0 PRJNA767802 7445 279 2.386957 6.65961003 Ulothrix zonata 43941 Plants Plants 510 3.5299999999999996e-140   NTclustered gi|530445654|emb|HE860533.1| 43941 g7372 i0 99.642 99.8709677419355 279 1 100 0 1 279 37 315 Ulothrix zonata partial 28S rRNA gene, isolate Q19 blastn 27864 510 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Ulvophyceae Ulotrichales Ulotrichaceae Ulothrix Ulothrix zonata
7123954 7123954 PRJNA767802_P_NODE_9706_length_231_cov_5.763736_g9633_i0 PRJNA767802 9706 231 5.763736 13.31423016 Desmochloris halophila 138176 Plants Plants 305 1.43e-78   NTclustered gi|371782086|emb|HE610118.1| 138176 g9633 i0 92.891 92.2121212121212 211 14 91 1 1 211 2792 2583 Desmochloris halophila 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain UTEX 2073 blastn 21301 305 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Ulvophyceae Chlorocystidales Chlorocystidaceae Desmochloris Desmochloris halophila
10949311 10949311 PRJNA767802_P_NODE_7849_length_269_cov_2.040909_g7776_i0 PRJNA767802 7849 269 2.040909 5.49004521 Sarcinofilum mucosum 141643 Plants Plants 444 3.48e-120   NTclustered gi|1197510887|ref|NC_034709.1| 141643 g7776 i0 96.992 127.07063197026 266 5 100 2 4 269 147462 147200 Trichosarcina mucosa culture SAG:4.90 chloroplast, complete genome blastn 34182 444 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Ulvophyceae Ulotrichales Sarcinofilaceae Sarcinofilum Sarcinofilum mucosum
13498959 13498959 PRJNA767802_P_NODE_4651_length_388_cov_5.477876_g4578_i0 PRJNA767802 4651 388 5.477876 21.25415888 Ulva sp. EE2 707363 Plants Plants 254 9.47e-63   NTclustered gi|284177801|gb|GQ421591.1| 707363 g4578 i0 84.646 7.19587628865979 254 39 65 0 22 275 686 939 Ulva sp. EE2 glyceraldehyde-3-phosphate dehydrogenase (GapA) mRNA, partial cds blastn 2792 254 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Ulvophyceae Ulvales Ulvaceae Ulva Ulva sp. EE2
17783670 17783670 PRJNA767802_P_NODE_5454_length_346_cov_1.730640_g5381_i0 PRJNA767802 5454 346 1.73064 5.9880144 Cephaleuros 173369 Plants Plants 147 1.46e-30   NTclustered gi|2210642948|gb|ON040817.1| 173370 g5381 i0 87.402 36.7052023121387 127 16 37 0 130 256 227 353 Cephaleuros parasiticus isolate Osm7 large subunit ribosomal RNA gene, partial sequence blastn 12700 147 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Ulvophyceae Trentepohliales Trentepohliaceae Cephaleuros Cephaleuros parasiticus
19057826 19057826 PRJNA767802_P_NODE_7715_length_272_cov_2.076233_g7642_i0 PRJNA767802 7715 272 2.076233 5.64735376 Eukaryota 2759 Plants Plants 113 1.13e-20   NTclustered gi|2082259818|ref|XM_001690833.2| 3055 g7642 i0 80 2.67647058823529 160 27 58 5 52 208 440 597 Chlamydomonas reinhardtii ribosomal protein L18 (CHLRE_12g512600v5), mRNA blastn 728 113 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Chlamydomonadaceae Chlamydomonas Chlamydomonas reinhardtii

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