RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA758770" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_clade 1

bioproject 1

  • PRJNA758770 · 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
4568794 4568794 PRJNA758770_S_NODE_17324_length_288_cov_0.902326_g17198_i0 PRJNA758770 17324 288 0.902326 2.59869888 Phytophthora infestans 4787 SAR_Eukaryotes SAR_Eukaryotes 422 1.76e-113   NTclustered gi|301106317|ref|XM_002902196.1| 403677 g17198 i0 93.056 4.95486111111111 288 20 100 0 1 288 4507 4220 Phytophthora infestans T30-4 carbamoyl-phosphate synthase [ammonia], putative (PITG_10454), partial mRNA blastn 1427 422 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora infestans
4569031 4569031 PRJNA758770_S_NODE_27144_length_249_cov_0.880682_g27018_i0 PRJNA758770 27144 249 0.880682 2.19289818 Tenuicylindrus belgicus 1398096 SAR_Eukaryotes SAR_Eukaryotes 80.5 1.03e-10   NTclustered gi|2328369222|ref|NC_067957.1| 1398096 g27018 i0 88.06 4.98393574297189 67 8 27 0 145 211 22427 22361 Tenuicylindrus belgicus chloroplast, complete genome blastn 1241 80.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Leptocylindrales Leptocylindraceae Tenuicylindrus Tenuicylindrus belgicus
4569170 4569170 PRJNA758770_S_NODE_32444_length_242_cov_0.923077_g32318_i0 PRJNA758770 32444 242 0.923077 2.23384634 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 348 2.48e-91   NTclustered gi|2795042893|ref|XM_067923745.1| 4785 g32318 i0 92.562 4 242 18 100 0 1 242 1076 1317 Phytophthora cinnamomi Mitochondrial-processing peptidase subunit beta (IUM83_00012), partial mRNA blastn 968 348 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
5844163 5844163 PRJNA758770_S_NODE_24725_length_251_cov_1.752809_g24599_i0 PRJNA758770 24725 251 1.752809 4.39955059 Phytophthora sojae 67593 SAR_Eukaryotes SAR_Eukaryotes 134 7.9e-27   NTclustered gi|695432814|ref|XM_009532735.1| 67593 g24599 i0 85.385 2.7410358565737 130 17 51 2 104 232 88 216 Phytophthora sojae hypothetical protein mRNA blastn 688 134 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora sojae
19867469 19867469 PRJNA758770_S_NODE_23356_length_253_cov_0.866667_g23230_i0 PRJNA758770 23356 253 0.866667 2.19266751 Phytophthora capsici 4784 SAR_Eukaryotes SAR_Eukaryotes 457 4.16e-124   NTclustered gi|189084892|gb|BT032423.1| 4784 g23230 i0 99.209 5.86166007905138 253 2 100 0 1 253 100 352 Phytophthora capsici clone CBOU101-D10 mRNA sequence blastn 1483 457 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora capsici
21143458 21143458 PRJNA758770_S_NODE_7837_length_388_cov_1.238095_g7711_i0 PRJNA758770 7837 388 1.238095 4.8038086 Phytophthora capsici 4784 SAR_Eukaryotes SAR_Eukaryotes 701 0   NTclustered gi|189084949|gb|BT032481.1| 4784 g7711 i0 99.481 7.59020618556701 385 2 99 0 4 388 470 86 Phytophthora capsici clone CBOU177-N03 mRNA sequence blastn 2945 701 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora capsici
24967138 24967138 PRJNA758770_S_NODE_23440_length_253_cov_0.866667_g23314_i0 PRJNA758770 23440 253 0.866667 2.19266751 Hyaloperonospora parasitica 123356 SAR_Eukaryotes SAR_Eukaryotes 54.7 0.006   NTclustered gi|170285697|emb|CU672270.3| 123356 g23314 i0 100 0.114624505928854 29 0 11 0 79 107 1761 1789 H.parasitica DNA sequence from clone HpEmoy2-20J10, complete sequence blastn 29 54.7 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Hyaloperonospora Hyaloperonospora parasitica

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