RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA797475" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA797475 · 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
4609797 4609797 PRJNA797475_P_NODE_27164_length_245_cov_0.895349_g27065_i0 PRJNA797475 27164 245 0.895349 2.19360505 Bodomorpha sp. HFCC 92 458884 SAR_Eukaryotes SAR_Eukaryotes 396 8.869999999999996e-106   NTclustered gi|197723521|gb|EF681900.2| 458884 g27065 i0 99.539 100.922448979592 217 1 89 0 1 217 217 1 Bodomorpha sp. HFCC 92 28S ribosomal RNA gene, partial sequence blastn 24726 396 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae Bodomorpha Bodomorpha sp. HFCC 92
5045079 5045079 PRJNA797475_P_NODE_22904_length_249_cov_2.625000_g22805_i0 PRJNA797475 22904 249 2.625 6.53625 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 455 1.47e-123   NTclustered gi|512134093|gb|KC575317.1| 175275 g22805 i0 99.598 99.9558232931727 249 1 100 0 1 249 392 144 Uncultured cercozoan clone B.17.1 18S ribosomal RNA gene, partial sequence blastn 24889 455 1 Eukaryota Sar   Cercozoa         uncultured Cercozoa
10985512 10985512 PRJNA797475_P_NODE_3069_length_556_cov_1.929607_g2971_i0 PRJNA797475 3069 556 1.929607 10.72861492 Gymnophrys sp. ATCC 50923 646463 SAR_Eukaryotes SAR_Eukaryotes 671 0   NTclustered gi|238617604|gb|FJ973379.1| 646463 g2971 i0 88.36 96.9964028776978 567 54 100 6 1 556 1430 1995 Gymnophrys sp. ATCC 50923 28S ribosomal RNA gene, partial sequence blastn 53930 671 1 Eukaryota Sar   Cercozoa       Gymnophrys Gymnophrys sp. ATCC 50923
25007974 25007974 PRJNA797475_P_NODE_8760_length_350_cov_2.209386_g8661_i0 PRJNA797475 8760 350 2.209386 7.732851 Cercozoa sp. Panama112 563759 SAR_Eukaryotes SAR_Eukaryotes 632 9.28e-177   NTclustered gi|219524795|gb|EU709158.1| 563759 g8661 i0 99.425 100.128571428571 348 2 99 0 1 348 1220 1567 Cercozoa sp. Panama112 18S ribosomal RNA gene, partial sequence blastn 35045 632 1 Eukaryota Sar   Cercozoa         Cercozoa sp. Panama112

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