RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA675331" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA675331 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
3198598 3198598 PRJNA675331_P_NODE_11523_length_297_cov_1.370536_g11351_i0 PRJNA675331 11523 297 1.370536 4.07049192 Oxytricha sp. LPJ-2005 329142 SAR_Eukaryotes SAR_Eukaryotes 385 2.3999999999999996e-102   NTclustered gi|67462291|gb|DQ062087.1| 329142 g11351 i0 90.169 30.2558922558923 295 29 99 0 1 295 318 24 Oxytricha sp. LPJ-2005 heat shock protein 70 mRNA, partial cds; macronuclear blastn 8986 385 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Oxytricha Oxytricha sp. LPJ-2005
3198695 3198695 PRJNA675331_P_NODE_3603_length_494_cov_1.194774_g3432_i0 PRJNA675331 3603 494 1.194774 5.90218356 Oxytricha sp. LPJ-2005 329142 SAR_Eukaryotes SAR_Eukaryotes 647 0   NTclustered gi|67462291|gb|DQ062087.1| 329142 g3432 i0 90.303 88.5121457489878 495 46 100 2 1 494 775 282 Oxytricha sp. LPJ-2005 heat shock protein 70 mRNA, partial cds; macronuclear blastn 43725 647 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Oxytricha Oxytricha sp. LPJ-2005
7026463 7026463 PRJNA675331_P_NODE_8306_length_340_cov_1.116105_g8134_i0 PRJNA675331 8306 340 1.116105 3.794757 Rimostrombidium veniliae 702563 SAR_Eukaryotes SAR_Eukaryotes 381 3.609999999999999e-101   NTclustered gi|759083337|gb|KM221993.1| 702563 g8134 i0 86.982 97.4941176470588 338 44 99 0 1 338 584 921 Rimostrombidium veniliae voucher LWW2007042901 alpha-tubulin gene, partial cds blastn 33148 381 1 Eukaryota Sar   Ciliophora Spirotrichea Choreotrichida Strobilidiidae Rimostrombidium Rimostrombidium veniliae
23600572 23600572 PRJNA675331_P_NODE_21479_length_245_cov_0.895349_g21307_i0 PRJNA675331 21479 245 0.895349 2.19360505 Oxytricha sp. LPJ-2005 329142 SAR_Eukaryotes SAR_Eukaryotes 326 1.18e-84   NTclustered gi|67462291|gb|DQ062087.1| 329142 g21307 i0 90.612 16.7673469387755 245 23 100 0 1 245 411 167 Oxytricha sp. LPJ-2005 heat shock protein 70 mRNA, partial cds; macronuclear blastn 4108 326 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Oxytricha Oxytricha sp. LPJ-2005

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