RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "diamond", bioproject = "PRJNA474911" and tax_kingdom = "Viridiplantae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Viridiplantae · 9 ✖

tax_clade 1

bioproject 1

  • PRJNA474911 · 9 ✖

analysis 1

  • diamond · 9 ✖
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
8100719 8100719 PRJNA474911_P_NODE_7367_length_207_cov_0.876712_g7240_i0 PRJNA474911 7367 207 0.876712 1.81479384 Magnoliopsida 3398 Plants Plants 108 1.53e-25   NR KAK9683990.1 3572 g7240 i0 73.1 24.3188405797101 67 18 97.1 0 6 206 295 361 KAK9683990.1 hypothetical protein RND81_10G179400 [Saponaria officinalis] diamond 5034 108 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Caryophyllales Caryophyllaceae Saponaria Saponaria officinalis
15125024 15125024 PRJNA474911_P_NODE_5532_length_240_cov_1.072626_g5405_i0 PRJNA474911 5532 240 1.072626 2.5743024 Selaginella moellendorffii 88036 Plants Plants 92.4 6.1e-20   NR XP_002985543.1 88036 g5405 i0 60.6 4.625 71 28 88.8 0 213 1 181 251 XP_002985543.1 obg-like ATPase 1 [Selaginella moellendorffii] diamond 1110 92.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Lycopodiopsida Selaginellales Selaginellaceae Selaginella Selaginella moellendorffii
17024903 17024903 PRJNA474911_P_NODE_7354_length_207_cov_0.876712_g7227_i0 PRJNA474911 7354 207 0.876712 1.81479384 Magnoliopsida 3398 Plants Plants 114 8.72e-31   NR XP_062169893.1 3517 g7227 i0 75.4 7 69 17 100 0 1 207 28 96 XP_062169893.1 small ribosomal subunit protein eS19x [Alnus glutinosa] diamond 1449 114 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Betulaceae Alnus Alnus glutinosa
29019024 29019024 PRJNA474911_P_NODE_7168_length_208_cov_0.870748_g7041_i0 PRJNA474911 7168 208 0.870748 1.81115584 Asteraceae 4210 Plants Plants 53.9 2.64e-6   NR XP_023756589.1 4236 g7041 i0 52.9 5.8125 51 24 73.6 0 200 48 972 1022 XP_023756589.1 uncharacterized protein LOC111905146 [Lactuca sativa] diamond 1209 54.3 0.992633517495396 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Lactuca Lactuca sativa
29065894 29065894 PRJNA474911_P_NODE_8268_length_201_cov_0.914286_g8141_i0 PRJNA474911 8268 201 0.914286 1.83771486 Striga asiatica 4170 Plants Plants 84.7 3.01e-19   NR GER57402.1 4170 g8141 i0 71.2 1.80597014925373 59 17 88.1 0 182 6 4 62 GER57402.1 60S ribosomal protein L31 [Striga asiatica] diamond 363 84.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Orobanchaceae Striga Striga asiatica
29871268 29871268 PRJNA474911_P_NODE_2011_length_440_cov_1.823219_g1886_i0 PRJNA474911 2011 440 1.823219 8.0221636 Eukaryota 2759 Plants Plants 157 7.56e-45   NR BBG98548.1 3755 g1886 i0 61.4 49.9704545454545 140 53 95.5 1 440 21 28 166 BBG98548.1 Translation protein SH3-like family protein [Prunus dulcis] diamond 21987 158 0.993670886075949 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Rosaceae Prunus Prunus dulcis
30534670 30534670 PRJNA474911_P_NODE_4813_length_262_cov_1.258706_g4686_i0 PRJNA474911 4813 262 1.258706 3.29780972 Eukaryota 2759 Plants Plants 82 5.98e-18   NR XP_024369179.1 3218 g4686 i0 58 9.76717557251908 88 34 97.3 2 256 2 4 91 XP_024369179.1 60S ribosomal protein L36-2-like [Physcomitrium patens] diamond 2559 82 1 Eukaryota Embryophyta Viridiplantae Streptophyta Bryopsida Funariales Funariaceae Physcomitrium Physcomitrium patens
30771540 30771540 PRJNA474911_P_NODE_7934_length_203_cov_0.901408_g7807_i0 PRJNA474911 7934 203 0.901408 1.82985824 Oryza sativa Japonica Group 39947 Plants Plants 97.4 3.71e-24   NR BAF17818.2 39947 g7807 i0 70.1 6.91625615763547 67 20 99 0 1 201 47 113 BAF17818.2 Os05g0490800, partial [Oryza sativa Japonica Group] diamond 1404 97.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Oryza Oryza sativa
32305689 32305689 PRJNA474911_P_NODE_4339_length_279_cov_1.628440_g4212_i0 PRJNA474911 4339 279 1.62844 4.5433476 Eukaryota 2759 Plants Plants 101 8.52e-25   NR KAB1201704.1 262757 g4212 i0 56.3 2.96774193548387 96 35 100 3 279 1 58 149 KAB1201704.1 60S ribosomal protein L21-2 [Morella rubra] diamond 828 101 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Myricaceae Morella Morella rubra

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