RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA853203" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 7 ✖

tax_clade 1

bioproject 1

  • PRJNA853203 · 7 ✖

analysis 1

  • blastn · 7 ✖

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
2116935 2116935 PRJNA853203_P_NODE_46222_length_243_cov_0.917647_g46073_i0 PRJNA853203 46222 243 0.917647 2.22988221 Phytophthora litchii 100870 SAR_Eukaryotes SAR_Eukaryotes 438 1.4399999999999996e-118   NTclustered gi|2248512916|ref|NC_063792.1| 100870 g46073 i0 99.177 99.7901234567901 243 2 100 0 1 243 1081 839 Phytophthora litchii isolate SHS3 mitochondrion, complete genome blastn 24249 438 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora litchii
5944619 5944619 PRJNA853203_P_NODE_29625_length_251_cov_2.039326_g29476_i0 PRJNA853203 29625 251 2.039326 5.11870826 Albugo laibachii 653948 SAR_Eukaryotes SAR_Eukaryotes 99 2.88e-16   NTclustered gi|325194684|emb|FR825494.1| 890382 g29476 i0 92.754 24.808764940239 69 4 27 1 184 251 206 138 Albugo laibachii Nc14, genomic contig CONTIG_2365_NC14_v4_847_33331 blastn 6227 99 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo laibachii
5944796 5944796 PRJNA853203_P_NODE_8425_length_293_cov_2.195455_g8276_i0 PRJNA853203 8425 293 2.195455 6.43268315 Albugo laibachii 653948 SAR_Eukaryotes SAR_Eukaryotes 399 8.419999999999998e-107   NTclustered gi|325194231|emb|FR825088.1| 890382 g8276 i0 91.696 1.21843003412969 289 22 98 2 1 287 1208 920 Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85 blastn 357 399 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo laibachii
12320703 12320703 PRJNA853203_P_NODE_35470_length_248_cov_1.177143_g35321_i0 PRJNA853203 35470 248 1.177143 2.91931464 Phytophthora infestans 4787 SAR_Eukaryotes SAR_Eukaryotes 243 1.24e-59   NTclustered gi|301113801|ref|XM_002998625.1| 403677 g35321 i0 84.274 1 248 39 100 0 1 248 3385 3632 Phytophthora infestans T30-4 uncharacterized protein (PITG_06580), partial mRNA blastn 248 243 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora infestans
15262749 15262749 PRJNA853203_P_NODE_49912_length_228_cov_2.058065_g49763_i0 PRJNA853203 49912 228 2.058065 4.6923882 Peronosporaceae 4777 SAR_Eukaryotes SAR_Eukaryotes 281 2.38e-71   NTclustered gi|2235892989|tpg|BK012092.1| 129355 g49763 i0 88.987 3.99122807017544 227 25 99 0 2 228 23050 23276 TPA_asm: Phytophthora lateralis strain SMST21 mitochondrion, complete genome blastn 910 281 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora lateralis
19967995 19967995 PRJNA853203_P_NODE_30836_length_251_cov_0.876404_g30687_i0 PRJNA853203 30836 251 0.876404 2.19977404 Phytophthora sojae 67593 SAR_Eukaryotes SAR_Eukaryotes 459 1.1499999999999996e-124   NTclustered gi|695467766|ref|XM_009541409.1| 67593 g30687 i0 99.602 87.4342629482072 251 1 100 0 1 251 251 1 Phytophthora sojae hypothetical protein mRNA blastn 21946 459 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora sojae
22518344 22518344 PRJNA853203_P_NODE_8018_length_297_cov_0.901786_g7869_i0 PRJNA853203 8018 297 0.901786 2.67830442 Albugo laibachii 653948 SAR_Eukaryotes SAR_Eukaryotes 516 8.14e-142   NTclustered gi|325194231|emb|FR825088.1| 890382 g7869 i0 97.98 14.1616161616162 297 6 100 0 1 297 1547 1251 Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85 blastn 4206 516 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo laibachii

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