RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA760904" 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

  • PRJNA760904 · 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
16044923 16044923 PRJNA760904_P_NODE_4033_length_416_cov_1.346939_g3976_i0 PRJNA760904 4033 416 1.346939 5.60326624 Lecythium sp. 3678_261K 238773 SAR_Eukaryotes SAR_Eukaryotes 401 3.4499999999999987e-107   NTclustered gi|33089893|gb|AY283756.1| 238773 g3976 i0 91.438 74.0408653846154 292 25 70 0 125 416 768 477 Lecythium sp. 3678_261K actin gene, partial cds blastn 30801 401 1 Eukaryota Sar   Cercozoa Thecofilosea Tectofilosida Chlamydophryidae Lecythium Lecythium sp. 3678_261K
17320562 17320562 PRJNA760904_P_NODE_2134_length_546_cov_2.192389_g2078_i0 PRJNA760904 2134 546 2.192389 11.97044394 Thaumatomastix sp. NIES-2378 717846 SAR_Eukaryotes SAR_Eukaryotes 505 3.429999999999999e-138   NTclustered gi|302563030|dbj|AB546338.1| 717846 g2078 i0 82.94 42.3717948717949 551 84 100 7 1 546 382 927 Thaumatomastix sp. NIES-2378 EFL mRNA for elongation factor like, partial cds blastn 23135 505 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida Thaumatomastigidae Thaumatomastix Thaumatomastix sp. NIES-2378
18593956 18593956 PRJNA760904_P_NODE_6495_length_342_cov_1.702602_g6438_i0 PRJNA760904 6495 342 1.702602 5.82289884 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 337 7.969999999999997e-88   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g6438 i0 84.928 58.6023391812866 345 38 100 10 1 342 3662 3995 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 20042 337 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
23695237 23695237 PRJNA760904_P_NODE_9959_length_288_cov_0.995349_g9902_i0 PRJNA760904 9959 288 0.995349 2.86660512 Thaumatomastix sp. NIES-2378 717846 SAR_Eukaryotes SAR_Eukaryotes 361 3.899999999999999e-95   NTclustered gi|302563030|dbj|AB546338.1| 717846 g9902 i0 91.571 24.2013888888889 261 22 91 0 2 262 85 345 Thaumatomastix sp. NIES-2378 EFL mRNA for elongation factor like, partial cds blastn 6970 361 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida Thaumatomastigidae Thaumatomastix Thaumatomastix sp. NIES-2378

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