RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJEB27957" and tax_phylum = "Annelida"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Annelida · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB27957 · 3 ✖

analysis 1

  • diamond · 3 ✖
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
26906619 26906619 PRJEB27957_P_NODE_27442_length_292_cov_2.139918_g27332_i0 PRJEB27957 27442 292 2.139918 6.24856056 Paralvinella palmiformis 53620 Annelida Annelida 49.7 2.05e-5   NR KAK2157171.1 53620 g27332 i0 52.3 0.452054794520548 44 21 45.2 0 227 96 22 65 KAK2157171.1 hypothetical protein LSH36_196g03088 [Paralvinella palmiformis] diamond 132 49.7 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Terebellida Alvinellidae Paralvinella Paralvinella palmiformis
30159308 30159308 PRJEB27957_P_NODE_71792_length_201_cov_1.026316_g71682_i0 PRJEB27957 71792 201 1.026316 2.06289516 Lamellibrachia satsuma 104711 Annelida Annelida 50.1 5.55e-5   NR KAI0213684.1 104711 g71682 i0 61.8 0.507462686567164 34 13 50.7 0 103 2 626 659 KAI0213684.1 putative RNA-directed DNA polymerase from transposon BS [Lamellibrachia satsuma] diamond 102 50.1 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Sabellida Siboglinidae Lamellibrachia Lamellibrachia satsuma
31859840 31859840 PRJEB27957_P_NODE_104357_length_169_cov_0.866667_g104247_i0 PRJEB27957 104357 169 0.866667 1.46466723 Metazoa 33208 Annelida Annelida 43.5 0.00593   NR KAI0234953.1 104711 g104247 i0 73.1 4.61538461538461 26 7 46.2 0 27 104 62 87 KAI0234953.1 hypothetical protein LSAT2_014678, partial [Lamellibrachia satsuma] diamond 780 43.5 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Sabellida Siboglinidae Lamellibrachia Lamellibrachia satsuma

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