RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA1180292" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA1180292 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
4144746 4144746 PRJNA1180292_P_NODE_11884_length_244_cov_0.912281_g11752_i0 PRJNA1180292 11884 244 0.912281 2.22596564 Phytophthora infestans 4787 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.022   NTclustered gi|301095059|ref|XM_002896586.1| 403677 g11752 i0 96.774 0.127049180327869 31 1 13 0 206 236 182 152 Phytophthora infestans T30-4 uncharacterized protein (PITG_17785), partial mRNA blastn 31 52.8 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora infestans
13071526 13071526 PRJNA1180292_P_NODE_7871_length_253_cov_0.866667_g7739_i0 PRJNA1180292 7871 253 0.866667 2.19266751 Saprolegnia diclina 112098 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.023   NTclustered gi|669166087|ref|XM_008620384.1| 1156394 g7739 i0 100 0.110671936758893 28 0 11 0 119 146 2518 2491 Saprolegnia diclina VS20 hypothetical protein mRNA blastn 28 52.8 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia diclina
21994487 21994487 PRJNA1180292_P_NODE_11298_length_246_cov_0.901734_g11166_i0 PRJNA1180292 11298 246 0.901734 2.21826564 Saprolegnia parasitica 101203 SAR_Eukaryotes SAR_Eukaryotes 139 1.66e-28   NTclustered gi|813142308|ref|XM_012343858.1| 695850 g11166 i0 92 2.55284552845528 100 7 41 1 4 103 890 988 Saprolegnia parasitica CBS 223.65 aspartate carbamoyltransferase mRNA blastn 628 139 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia parasitica
21994570 21994570 PRJNA1180292_P_NODE_6798_length_270_cov_1.786802_g6666_i0 PRJNA1180292 6798 270 1.786802 4.8243654 Phytophthora infestans 4787 SAR_Eukaryotes SAR_Eukaryotes 187 6.4999999999999984e-43   NTclustered gi|2661441985|ref|XR_009934438.1| 403677 g6666 i0 94.355 45.9333333333333 124 4 46 3 55 178 1292 1412 Phytophthora infestans T30-4 28S ribosomal RNA (PITG_33044), partial rRNA blastn 12402 187 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora infestans

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