RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA414036" and tax_phylum = "Apicomplexa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Apicomplexa · 5 ✖

tax_clade 1

bioproject 1

  • PRJNA414036 · 5 ✖

analysis 1

  • diamond · 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
29712777 29712777 PRJNA414036_P_NODE_66570_length_193_cov_2.284810_g64831_i0 PRJNA414036 66570 193 2.28481 4.4096833 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 64.3 9.89e-11   NR CAB38638.1 5827 g64831 i0 51.6 72.6217616580311 64 31 99.5 0 192 1 71 134 CAB38638.1 RNA helicase, partial [Plasmodium cynomolgi] diamond 14016 64.3 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium cynomolgi
30770810 30770810 PRJNA414036_P_NODE_14254_length_388_cov_4.345609_g12586_i0 PRJNA414036 14254 388 4.345609 16.86096292 Babesia caballi 5871 SAR_Eukaryotes SAR_Eukaryotes 60.8 8.35e-8   NR XP_067714125.1 5871 g12586 i0 40.4 0.842783505154639 109 65 84.3 0 21 347 307 415 XP_067714125.1 DUF748 domain-containing protein [Babesia caballi] diamond 327 60.8 1 Eukaryota Sar   Apicomplexa Aconoidasida Piroplasmida Babesiidae Babesia Babesia caballi
31055297 31055297 PRJNA414036_P_NODE_24495_length_306_cov_4.287823_g22763_i0 PRJNA414036 24495 306 4.287823 13.12073838 Babesia caballi 5871 SAR_Eukaryotes SAR_Eukaryotes 84.3 1.95e-16   NR XP_067717679.1 5871 g22763 i0 43.8 0.941176470588235 96 54 94.1 0 8 295 523 618 XP_067717679.1 uncharacterized protein BcabD6B2_50450 [Babesia caballi] diamond 288 84.3 1 Eukaryota Sar   Apicomplexa Aconoidasida Piroplasmida Babesiidae Babesia Babesia caballi
31561101 31561101 PRJNA414036_P_NODE_65736_length_195_cov_11.837500_g63997_i0 PRJNA414036 65736 195 11.8375 23.083125 Babesia caballi 5871 SAR_Eukaryotes SAR_Eukaryotes 43.5 0.0106   NR XP_067716249.1 5871 g63997 i0 42 1.13846153846154 50 29 76.9 0 190 41 296 345 XP_067716249.1 uncharacterized protein BcabD6B2_36150 [Babesia caballi] diamond 222 43.5 1 Eukaryota Sar   Apicomplexa Aconoidasida Piroplasmida Babesiidae Babesia Babesia caballi
32178833 32178833 PRJNA414036_P_NODE_4558_length_533_cov_3.853414_g3705_i0 PRJNA414036 4558 533 3.853414 20.53869662 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 77.4 7.05e-13   NR XP_067712751.1 5871 g3705 i0 42.9 42.078799249531 84 48 47.3 0 272 523 1290 1373 XP_067712751.1 ABC1 family protein [Babesia caballi] diamond 22428 77.4 1 Eukaryota Sar   Apicomplexa Aconoidasida Piroplasmida Babesiidae Babesia Babesia caballi

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