RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJEB48218" and tax_clade = "Embryophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Embryophyta · 17 ✖

bioproject 1

  • PRJEB48218 · 17 ✖

analysis 1

  • diamond · 17 ✖
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
7714979 7714979 PRJEB48218_S_NODE_27767_length_161_cov_2.318182_g26805_i0 PRJEB48218 27767 161 2.318182 3.73227302 Tanacetum cinerariifolium 118510 Plants Plants 104 2.35e-24   NR GEV93426.1 118510 g26805 i0 98.1 0.987577639751553 53 1 98.8 0 160 2 328 380 GEV93426.1 cytochrome b, mitochondrial [Tanacetum cinerariifolium] diamond 159 104 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Tanacetum Tanacetum cinerariifolium
23014662 23014662 PRJEB48218_S_NODE_3819_length_622_cov_6.504216_g2955_i0 PRJEB48218 3819 622 6.504216 40.45622352 Helianthus 4231 Plants Plants 141 7.76e-39   NR KAJ0566953.1 4232 g2955 i0 57.6 2.54662379421222 132 50 63.7 3 618 223 1 126 KAJ0566953.1 putative Phytocyanin domain, cupredoxin [Helianthus annuus] diamond 1584 141 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Helianthus Helianthus annuus
26653352 26653352 PRJEB48218_S_NODE_22421_length_191_cov_2.364198_g21459_i0 PRJEB48218 22421 191 2.364198 4.51561818 Ambrosia artemisiifolia 4212 Plants Plants 108 5.77e-28   NR KAI7726418.1 4212 g21459 i0 100 0.848167539267016 54 0 84.8 0 179 18 1 54 KAI7726418.1 hypothetical protein M8C21_027356 [Ambrosia artemisiifolia] diamond 162 108 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Ambrosia Ambrosia artemisiifolia
27318118 27318118 PRJEB48218_S_NODE_25763_length_170_cov_2.539007_g24801_i0 PRJEB48218 25763 170 2.539007 4.3163119 Ambrosia artemisiifolia 4212 Plants Plants 115 6.45e-29   NR KAI7727358.1 4212 g24801 i0 98.2 0.988235294117647 56 0 97.1 1 4 168 21 76 KAI7727358.1 hypothetical protein M8C21_003504 [Ambrosia artemisiifolia] diamond 168 115 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Ambrosia Ambrosia artemisiifolia
27949573 27949573 PRJEB48218_S_NODE_5005_length_493_cov_8.062500_g4064_i0 PRJEB48218 5005 493 8.0625 39.748125 Helianthus annuus 4232 Plants Plants 159 2.93e-46   NR KAJ0857764.1 4232 g4064 i0 64.6 1.54563894523327 127 40 76.1 2 37 411 59 182 KAJ0857764.1 hypothetical protein HanRHA438_Chr13g0593831 [Helianthus annuus] diamond 762 159 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Helianthus Helianthus annuus
28581118 28581118 PRJEB48218_S_NODE_30307_length_151_cov_3.180328_g29345_i0 PRJEB48218 30307 151 3.180328 4.80229528 Ipomoea batatas 4120 Plants Plants 55.8 1.06e-7   NR GMC56265.1 4120 g29345 i0 53.1 0.973509933774834 49 23 97.4 0 4 150 108 156 GMC56265.1 hypothetical protein Iba_chr01fCG5430 [Ipomoea batatas] diamond 147 55.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Convolvulaceae Ipomoea Ipomoea batatas
29174366 29174366 PRJEB48218_S_NODE_29329_length_155_cov_1.944444_g28367_i0 PRJEB48218 29329 155 1.944444 3.0138882 Asteraceae 4210 Plants Plants 84 2.41e-19   NR KAI3728668.1 4217 g28367 i0 73.3 1.74193548387097 45 12 87.1 0 19 153 61 105 KAI3728668.1 hypothetical protein L6452_17309 [Arctium lappa] diamond 270 84 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Arctium Arctium lappa
29528301 29528301 PRJEB48218_S_NODE_21010_length_201_cov_2.790698_g20048_i0 PRJEB48218 21010 201 2.790698 5.60930298 Ambrosia artemisiifolia 4212 Plants Plants 129 6.52e-37   NR KAI7756890.1 4212 g20048 i0 97 1 67 2 100 0 1 201 14 80 KAI7756890.1 hypothetical protein M8C21_030304 [Ambrosia artemisiifolia] diamond 201 129 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Ambrosia Ambrosia artemisiifolia
30128009 30128009 PRJEB48218_S_NODE_24492_length_177_cov_1.844595_g23530_i0 PRJEB48218 24492 177 1.844595 3.26493315 Tanacetum cinerariifolium 118510 Plants Plants 87 1.4e-20   NR GFB69917.1 118510 g23530 i0 77.8 1.83050847457627 54 12 91.5 0 16 177 14 67 GFB69917.1 F-box domain, FBD domain, leucine-rich repeat domain, L domain-like protein [Tanacetum cinerariifolium] diamond 324 87 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Tanacetum Tanacetum cinerariifolium
30216241 30216241 PRJEB48218_S_NODE_19852_length_210_cov_2.762431_g18890_i0 PRJEB48218 19852 210 2.762431 5.8011051 Eukaryota 2759 Plants Plants 42.4 0.0151   NR XP_058099716.1 86752 g18890 i0 38.5 1.14285714285714 39 24 55.7 0 7 123 18 56 XP_058099716.1 uncharacterized protein LOC131244072 [Magnolia sinica] diamond 240 42.7 0.992974238875878 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Magnoliales Magnoliaceae Magnolia Magnolia sinica
30633621 30633621 PRJEB48218_S_NODE_28633_length_157_cov_3.718750_g27671_i0 PRJEB48218 28633 157 3.71875 5.8384375 Helianthus annuus 4232 Plants Plants 39.7 0.0355   NR KAJ0433403.1 4232 g27671 i0 91.3 0.439490445859873 23 1 43.9 1 148 80 61 82 KAJ0433403.1 putative RPM1-interacting protein 4/NOI4 [Helianthus annuus] diamond 69 39.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Helianthus Helianthus annuus
30665384 30665384 PRJEB48218_S_NODE_27193_length_163_cov_3.261194_g26231_i0 PRJEB48218 27193 163 3.261194 5.31574622 Tagetes erecta 13708 Plants Plants 56.2 1.71e-8   NR KAK1425909.1 13708 g26231 i0 96.9 0.588957055214724 32 1 58.9 0 151 56 1 32 KAK1425909.1 hypothetical protein QVD17_21271 [Tagetes erecta] diamond 96 56.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Tagetes Tagetes erecta
30949925 30949925 PRJEB48218_S_NODE_7854_length_340_cov_3.327974_g6892_i0 PRJEB48218 7854 340 3.327974 11.3151116 Tagetes erecta 13708 Plants Plants 84.3 1.21e-18   NR KAK1439149.1 13708 g6892 i0 56.3 1.35882352941176 80 28 66.2 2 3 227 2 79 KAK1439149.1 hypothetical protein QVD17_04964 [Tagetes erecta] diamond 462 84.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Tagetes Tagetes erecta
31297388 31297388 PRJEB48218_S_NODE_7115_length_365_cov_3.145833_g6153_i0 PRJEB48218 7115 365 3.145833 11.48229045 Ambrosia artemisiifolia 4212 Plants Plants 236 1.8300000000000003e-73   NR KAI7747654.1 4212 g6153 i0 100 0.986301369863014 120 0 98.6 0 2 361 369 488 KAI7747654.1 hypothetical protein M8C21_017523 [Ambrosia artemisiifolia] diamond 360 236 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Ambrosia Ambrosia artemisiifolia
31392497 31392497 PRJEB48218_S_NODE_19856_length_210_cov_2.685083_g18894_i0 PRJEB48218 19856 210 2.685083 5.6386743 Helianthus annuus 4232 Plants Plants 111 2.53e-30   NR KAJ0433403.1 4232 g18894 i0 85.1 0.957142857142857 67 9 95.7 1 9 209 1 66 KAJ0433403.1 putative RPM1-interacting protein 4/NOI4 [Helianthus annuus] diamond 201 111 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Helianthus Helianthus annuus
31771825 31771825 PRJEB48218_S_NODE_30097_length_152_cov_2.430894_g29135_i0 PRJEB48218 30097 152 2.430894 3.69495888 Helianthus annuus 4232 Plants Plants 45.4 0.00112   NR XP_021971930.1 4232 g29135 i0 82.1 1.75657894736842 28 5 55.3 0 48 131 188 215 XP_021971930.1 uncharacterized protein LOC110867101 [Helianthus annuus] diamond 267 45.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Helianthus Helianthus annuus
32018260 32018260 PRJEB48218_S_NODE_18538_length_220_cov_2.418848_g17576_i0 PRJEB48218 18538 220 2.418848 5.3214656 Asteraceae 4210 Plants Plants 102 2.0099999999999994e-23   NR KAI7754796.1 4212 g17576 i0 100 4.90909090909091 53 0 72.3 0 38 196 1 53 KAI7754796.1 hypothetical protein M8C21_018795 [Ambrosia artemisiifolia] diamond 1080 102 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Ambrosia Ambrosia artemisiifolia

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