RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA982106" 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

  • PRJNA982106 · 5 ✖

analysis 1

  • blastn · 5 ✖

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
4791701 4791701 PRJNA982106_P_NODE_12544_length_302_cov_2.519651_g12304_i0 PRJNA982106 12544 302 2.519651 7.60934602 Saprolegnia diclina 112098 SAR_Eukaryotes SAR_Eukaryotes 152 2.69e-32   NTclustered gi|669149541|ref|XM_008612111.1| 1156394 g12304 i0 81.915 16.7152317880795 188 27 61 6 116 298 488 303 Saprolegnia diclina VS20 50S ribosomal protein L40e mRNA blastn 5048 152 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia diclina
8616999 8616999 PRJNA982106_P_NODE_31587_length_242_cov_0.911243_g31347_i0 PRJNA982106 31587 242 0.911243 2.20520806 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 172 1.6e-38   NTclustered gi|2795037829|ref|XM_067935177.1| 4785 g31347 i0 81.193 11.9917355371901 218 37 89 4 1 216 342 127 Phytophthora cinnamomi 60S ribosomal protein L11 (IUM83_10661), partial mRNA blastn 2902 172 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
11474740 11474740 PRJNA982106_P_NODE_21369_length_250_cov_17.819209_g21129_i0 PRJNA982106 21369 250 17.819209 44.5480225 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 457 4.1099999999999985e-124   NTclustered gi|2756222524|gb|PQ001538.1| 5875 g21129 i0 99.602 100.4 251 0 100 1 1 250 133 383 Theileria parva isolate 3_249 small subunit ribosomal RNA gene, partial sequence blastn 25100 457 1 Eukaryota Sar   Apicomplexa Aconoidasida Piroplasmida Theileriidae Theileria Theileria parva
13717661 13717661 PRJNA982106_P_NODE_3491_length_473_cov_2.395000_g3252_i0 PRJNA982106 3491 473 2.395 11.32835 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 267 1.51e-66   NTclustered gi|2795041697|ref|XM_067930728.1| 4785 g3252 i0 78.588 38.9217758985201 439 68 89 21 25 447 19 447 Phytophthora cinnamomi 60S ribosomal protein L27a (IUM83_06510), partial mRNA blastn 18410 267 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
25190101 25190101 PRJNA982106_P_NODE_26200_length_246_cov_0.890173_g25960_i0 PRJNA982106 26200 246 0.890173 2.18982558 Eimeria mitis 44415 SAR_Eukaryotes SAR_Eukaryotes 54.7 0.006   NTclustered gi|916507840|ref|XM_013498750.1| 44415 g25960 i0 100 0.117886178861789 29 0 12 0 99 127 933 961 Eimeria mitis uncharacterized protein (EMH_0009750), partial mRNA blastn 29 54.7 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Eimeriidae Eimeria Eimeria mitis

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