RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "blastn", bioproject = "PRJNA773247" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

bioproject 1

  • PRJNA773247 · 2 ✖

analysis 1

  • blastn · 2 ✖

tax_phylum 0

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
6311164 6311164 PRJNA773247_P_NODE_9645_length_509_cov_7.389908_g9562_i0 PRJNA773247 9645 509 7.389908 37.61463172 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 460 6.98e-125   NTclustered gi|676390326|ref|XM_009040194.1| 44056 g9562 i0 87.719 80.7053045186641 399 43 78 6 8 403 532 137 Aureococcus anophagefferens hypothetical protein mRNA blastn 41079 462 0.995670995670996 Eukaryota Sar     Pelagophyceae Pelagomonadales Pelagomonadaceae Aureococcus Aureococcus anophagefferens
18600532 18600532 PRJNA773247_P_NODE_17515_length_348_cov_6.560000_g17431_i0 PRJNA773247 17515 348 6.56 22.8288 Thraustochytrium sp. ATCC 26185 672127 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.033   NTclustered gi|1059921657|gb|KX651613.1| 672127 g17431 i0 100 0.0804597701149425 28 0 8 0 310 337 2818 2845 Thraustochytrium sp. ATCC 26185 polyunsaturated fatty acid synthase subunit B (PUFAs-B) gene, complete cds blastn 28 52.8 1 Eukaryota Sar     Bigyra Thraustochytrida Thraustochytriidae Thraustochytrium Thraustochytrium sp. ATCC 26185

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