RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA898105" and tax_phylum = "Rotifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Rotifera · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA898105 · 4 ✖

analysis 1

  • blastn · 4 ✖
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
873849 873849 PRJNA898105_P_NODE_1341_length_532_cov_2.013072_g1144_i0 PRJNA898105 1341 532 2.013072 10.70954304 Philodina citrina 468664 Rotifera other_Eukaryota 673 0   NTclustered gi|407227484|emb|FR856884.1| 468664 g1144 i0 89.552 34.5413533834586 536 48 100 8 1 532 1803 2334 Philodina citrina complete mitochondrial genome blastn 18376 673 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Philodinida Philodinidae Philodina Philodina citrina
4702405 4702405 PRJNA898105_P_NODE_404_length_1077_cov_2.753984_g273_i0 PRJNA898105 404 1077 2.753984 29.66040768 Asplanchna sp. 3231738 Rotifera other_Eukaryota 392 5.679999999999999e-104   NTclustered gi|2778092479|gb|PP988071.1| 3231738 g273 i0 75.05 19.0092850510678 1006 169 90 73 77 1046 1413 2372 Asplanchna sp. chromosome I mitochondrion, complete sequence blastn 20473 392 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Ploima Asplanchnidae Asplanchna Asplanchna sp.
11077315 11077315 PRJNA898105_P_NODE_3329_length_320_cov_1.554656_g3129_i0 PRJNA898105 3329 320 1.554656 4.9748992 Brachionus angularis 396692 Rotifera other_Eukaryota 324 5.76e-84   NTclustered gi|1999716438|gb|MT875426.1| 396692 g3129 i0 85.127 77.375 316 47 99 0 1 316 824 509 Brachionus angularis chromosome II mitochondrion, complete sequence blastn 24760 324 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Ploima Brachionidae Brachionus Brachionus angularis
17452031 17452031 PRJNA898105_P_NODE_3954_length_290_cov_1.064516_g3754_i0 PRJNA898105 3954 290 1.064516 3.0870964 Lepadellidae sp. SHQC150123a 1804024 Rotifera other_Eukaryota 303 6.71e-78   NTclustered gi|1009658444|gb|KU720095.1| 1804024 g3754 i0 86.545 94.448275862069 275 37 95 0 16 290 391 665 Lepadellidae sp. SHQC150123a cytochrome oxidase subunit I (COI) gene, partial cds; mitochondrial blastn 27390 303 1 Eukaryota Opisthokonta Metazoa Rotifera Eurotatoria Ploima Lepadellidae   Lepadellidae sp. SHQC150123a

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