RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA937226" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 3

tax_superkingdom 1

tax_clade 1

bioproject 1

  • PRJNA937226 · 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
1255749 1255749 PRJNA937226_S_NODE_22761_length_176_cov_1.614173_g22634_i0 PRJNA937226 22761 176 1.614173 2.84094448 Cryptosporidium 5806 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.015   NTclustered gi|2785771450|ref|XM_067212390.1| 117008 g22634 i0 100 0.318181818181818 28 0 16 0 134 161 1332 1305 Cryptosporidium andersoni uncharacterized protein (cand_021600), partial mRNA blastn 56 52.8 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Cryptosporidiidae Cryptosporidium Cryptosporidium andersoni
11115493 11115493 PRJNA937226_S_NODE_1069_length_538_cov_3.697342_g950_i0 PRJNA937226 1069 538 3.697342 19.89169996 Babesia ovata 189622 SAR_Eukaryotes SAR_Eukaryotes 771 0   NTclustered gi|1624698158|ref|XM_029013947.1| 189622 g950 i0 96.574 471.652416356877 467 13 86 3 1 465 62 527 Babesia ovata endonuclease-reverse transcriptase (BOVATA_050300), partial mRNA blastn 253749 771 1 Eukaryota Sar   Apicomplexa Aconoidasida Piroplasmida Babesiidae Babesia Babesia ovata
16214907 16214907 PRJNA937226_S_NODE_20913_length_182_cov_2.736842_g20786_i0 PRJNA937226 20913 182 2.736842 4.98105244 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 337 3.82e-88   NTclustered gi|1111669722|ref|NC_032051.1| 112090 g20786 i0 100 109.549450549451 182 0 100 0 1 182 2321 2140 Aphanomyces astaci isolate AP03 mitochondrion, complete genome blastn 19938 337 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
17833288 17833288 PRJNA937226_S_NODE_15034_length_208_cov_1.962264_g14907_i0 PRJNA937226 15034 208 1.962264 4.08150912 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 315 2.1e-81   NTclustered gi|833494855|ref|XM_012915027.1| 5866 g14907 i0 93.81 837.038461538462 210 11 100 2 1 208 298 89 Babesia bigemina hypothetical protein, conserved partial mRNA blastn 174104 318 0.990566037735849 Eukaryota Sar   Apicomplexa Aconoidasida Piroplasmida Babesiidae Babesia Babesia bigemina
18763591 18763591 PRJNA937226_S_NODE_19335_length_188_cov_1.870504_g19208_i0 PRJNA937226 19335 188 1.870504 3.51654752 Trachelocercidae sp. 3 BS-2022 2930473 SAR_Eukaryotes SAR_Eukaryotes 56.5 0.001   NTclustered gi|2261268975|emb|OX095823.1| 2930473 g19208 i0 100 0.308510638297872 30 0 16 0 159 188 38 9 Trachelocercidae sp. 3 BS-2022 partial 18S rRNA gene, isolate SAMEA13863269, clone N34:18S_rRNA::TRINITY_DN3988_c0_g1_i52:177-1769(-) blastn 58 56.5 1 Eukaryota Sar   Ciliophora Karyorelictea Protostomatida Trachelocercidae   Trachelocercidae sp. 3 BS-2022

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