RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA1120203", tax_clade = "Sar" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA1120203 · 6 ✖

analysis 1

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
1027978 1027978 PRJNA1120203_P_NODE_59521_length_291_cov_2.830275_g58505_i0 PRJNA1120203 59521 291 2.830275 8.23610025 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 496 1.04e-135   NTclustered gi|23504780|emb|AJ506007.1| 204812 g58505 i0 98.921 91.8281786941581 278 2 95 1 3 279 434 711 Uncultured rhizosphere cercozoan partial 18S rRNA gene, clone RSC-CHU-27 blastn 26722 501 0.99001996007984 Eukaryota Sar   Cercozoa         uncultured rhizosphere cercozoan
7928064 7928064 PRJNA1120203_P_NODE_61647_length_287_cov_0.953271_g60631_i0 PRJNA1120203 61647 287 0.953271 2.73588777 uncultured Cercozoa 175275 SAR_Eukaryotes SAR_Eukaryotes 442 1.3499999999999993e-119   NTclustered gi|1002343650|gb|KU738528.1| 175275 g60631 i0 96.324 91.7909407665505 272 5 95 2 3 274 38 304 Uncultured Cercozoa clone OTU_835 18S ribosomal RNA gene, partial sequence blastn 26344 442 1 Eukaryota Sar   Cercozoa         uncultured Cercozoa
11231348 11231348 PRJNA1120203_P_NODE_70749_length_266_cov_9.896373_g69733_i0 PRJNA1120203 70749 266 9.896373 26.32435218 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 449 7.38e-122   NTclustered gi|113926796|emb|AM114804.1| 175275 g69733 i0 98.81 94.781954887218 252 3 95 0 1 252 638 889 Uncultured cercozoan partial 18S rRNA gene, clone WIM44 blastn 25212 449 1 Eukaryota Sar   Cercozoa         uncultured Cercozoa
11753207 11753207 PRJNA1120203_P_NODE_29470_length_436_cov_6.721763_g28455_i0 PRJNA1120203 29470 436 6.721763 29.30688668 Lotharella oceanica 641309 SAR_Eukaryotes SAR_Eukaryotes 69.4 4.18e-7   NTclustered gi|1009104511|ref|NC_029731.1| 641309 g28455 i0 76.562 0.357798165137615 128 29 29 1 306 432 22583 22456 Lotharella oceanica strain CCMP622 mitochondrion, complete genome blastn 156 69.4 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Lotharella Lotharella oceanica
12506783 12506783 PRJNA1120203_P_NODE_63530_length_282_cov_2.162679_g62514_i0 PRJNA1120203 63530 282 2.162679 6.09875478 Cercomonadidae 45108 SAR_Eukaryotes SAR_Eukaryotes 481 2.799999999999999e-131   NTclustered gi|1002343602|gb|KU738480.1| 175275 g62514 i0 99.248 92.4042553191489 266 2 94 0 3 268 38 303 Uncultured Cercozoa clone OTU_318 18S ribosomal RNA gene, partial sequence blastn 26058 481 1 Eukaryota Sar   Cercozoa         uncultured Cercozoa
16852442 16852442 PRJNA1120203_P_NODE_63594_length_282_cov_1.564593_g62578_i0 PRJNA1120203 63594 282 1.564593 4.41215226 uncultured Cercozoa 175275 SAR_Eukaryotes SAR_Eukaryotes 472 1.6799999999999998e-128   NTclustered gi|38195286|gb|AY360709.1| 175275 g62578 i0 98.502 90.145390070922 267 4 95 0 3 269 138 404 Uncultured cercozoan clone 10-4Fu05 small subunit ribosomal RNA gene, partial sequence blastn 25421 472 1 Eukaryota Sar   Cercozoa         uncultured Cercozoa

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