RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJEB50332" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 5 ✖

tax_clade 1

bioproject 1

  • PRJEB50332 · 5 ✖

analysis 1

  • blastn · 5 ✖

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
1393872 1393872 PRJEB50332_P_NODE_4342_length_287_cov_1.646018_g4260_i0 PRJEB50332 4342 287 1.646018 4.72407166 Bodomorpha minima 188950 SAR_Eukaryotes SAR_Eukaryotes 475 1.3299999999999996e-129   NTclustered gi|300676732|gb|GQ377662.1| 188950 g4260 i0 96.516 99.0592334494773 287 10 100 0 1 287 792 1078 Bodomorpha minima alpha-tubulin (Atub) gene, partial cds blastn 28430 475 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae Bodomorpha Bodomorpha minima
7771871 7771871 PRJEB50332_P_NODE_3387_length_316_cov_2.196078_g3305_i0 PRJEB50332 3387 316 2.196078 6.93960648 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 241 5.88e-59   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g3305 i0 81.447 38.25 318 37 100 15 1 316 4021 3724 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 12087 241 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
12873037 12873037 PRJEB50332_P_NODE_9451_length_227_cov_1.951807_g9369_i0 PRJEB50332 9451 227 1.951807 4.43060189 Bodomorpha minima 188950 SAR_Eukaryotes SAR_Eukaryotes 387 4.88e-103   NTclustered gi|238617630|gb|FJ973394.1| 188950 g9369 i0 97.357 80.3392070484581 227 6 100 0 1 227 597 371 Bodomorpha minima strain ATCC 50339 actin (act) gene, partial cds blastn 18237 387 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae Bodomorpha Bodomorpha minima
14147820 14147820 PRJEB50332_P_NODE_6072_length_252_cov_2.560209_g5990_i0 PRJEB50332 6072 252 2.560209 6.45172668 Bodomorpha minima 188950 SAR_Eukaryotes SAR_Eukaryotes 460 3.2e-125   NTclustered gi|300676732|gb|GQ377662.1| 188950 g5990 i0 99.603 25.1587301587302 252 1 100 0 1 252 590 339 Bodomorpha minima alpha-tubulin (Atub) gene, partial cds blastn 6340 460 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae Bodomorpha Bodomorpha minima
21796116 21796116 PRJEB50332_P_NODE_1458_length_457_cov_1.982323_g1377_i0 PRJEB50332 1458 457 1.982323 9.05921611 Bodomorpha minima 188950 SAR_Eukaryotes SAR_Eukaryotes 774 0   NTclustered gi|238617602|gb|FJ973377.1| 188950 g1377 i0 97.368 22.781181619256 456 10 99 2 1 454 328 783 Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence blastn 10411 774 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae Bodomorpha Bodomorpha minima

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