RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA1105232" and tax_phylum = "Apicomplexa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Apicomplexa · 3 ✖

tax_clade 1

bioproject 1

  • PRJNA1105232 · 3 ✖

analysis 1

  • blastn · 3 ✖

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
212574 212574 PRJNA1105232_S_NODE_3681_length_299_cov_1.628000_g3465_i0 PRJNA1105232 3681 299 1.628 4.86772 Plasmodium cynomolgi 5827 SAR_Eukaryotes SAR_Eukaryotes 189 2.0299999999999993e-43   NTclustered gi|457872809|ref|XM_004223276.1| 1120755 g3465 i0 79.137 2.42809364548495 278 54 92 4 14 289 342 67 Plasmodium cynomolgi strain B histone H2A (PCYB_113970) mRNA, complete cds blastn 726 189 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium cynomolgi
7865314 7865314 PRJNA1105232_S_NODE_1987_length_377_cov_3.326220_g1771_i0 PRJNA1105232 1987 377 3.32622 12.5398494 Plasmodium chabaudi 5825 SAR_Eukaryotes SAR_Eukaryotes 220 9.3e-53   NTclustered gi|1027955952|ref|XM_016798456.1| 31271 g1771 i0 77.6 19.790450928382 375 76 98 8 5 375 917 547 Plasmodium chabaudi chabaudi rRNA 2'-O-methyltransferase fibrillarin, putative (PCHAS_1035900), partial mRNA blastn 7461 220 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium chabaudi
9140208 9140208 PRJNA1105232_S_NODE_6348_length_241_cov_2.369792_g6132_i0 PRJNA1105232 6348 241 2.369792 5.71119872 Plasmodium falciparum 5833 SAR_Eukaryotes SAR_Eukaryotes 174 4.4399999999999997e-39   NTclustered gi|124804503|ref|XM_001347986.1| 36329 g6132 i0 84.659 48.6182572614108 176 25 73 1 37 212 1551 1378 Plasmodium falciparum 3D7 heat shock protein 70 (PF3D7_1134000), partial mRNA blastn 11717 174 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium falciparum

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