RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA784298" and tax_phylum = "Streptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Streptophyta · 8 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA784298 · 8 ✖

analysis 1

  • diamond · 8 ✖
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
4593700 4593700 PRJNA784298_P_NODE_404_length_2024_cov_3.667863_g335_i0 PRJNA784298 404 2024 3.667863 74.23754712 Tanacetum cinerariifolium 118510 Plants Plants 614 7.090000000000001e-192   NR GEW75313.1 118510 g335 i0 58.1 0.856719367588933 578 209 85.4 5 268 1995 1726 2272 GEW75313.1 ATP synthase F1 subunit alpha, mitochondrial [Tanacetum cinerariifolium] diamond 1734 614 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Tanacetum Tanacetum cinerariifolium
7143738 7143738 PRJNA784298_P_NODE_1506_length_1052_cov_3.365679_g1355_i0 PRJNA784298 1506 1052 3.365679 35.40694308 root 1 Root_unresolved Root_unresolved 438 8.46e-136   NR GEU28496.1 118510 g1355 i0 62.8 1.60551330798479 344 91 98.1 1 1032 1 425 731 GEU28496.1 hypothetical protein [Tanacetum cinerariifolium] diamond 1689 438 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Tanacetum Tanacetum cinerariifolium
11417073 11417073 PRJNA784298_P_NODE_1709_length_976_cov_3.644518_g1549_i0 PRJNA784298 1709 976 3.644518 35.57049568 Ipomoea batatas 4120 Plants Plants 366 2.92e-111   NR GME07367.1 4120 g1549 i0 59.4 0.992827868852459 323 98 99.3 2 969 1 979 1268 GME07367.1 beta-ketoacyl-[acyl-carrier-protein] synthase II [Ipomoea batatas] diamond 969 366 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Convolvulaceae Ipomoea Ipomoea batatas
13519208 13519208 PRJNA784298_P_NODE_28171_length_223_cov_6.000000_g27970_i0 PRJNA784298 28171 223 6 13.38 Citrus sinensis 2711 Plants Plants 143 1.2199999999999999e-42   NR KDO41824.1 2711 g27970 i0 97.1 0.928251121076233 69 2 92.8 0 16 222 1 69 KDO41824.1 hypothetical protein CISIN_1g036041mg, partial [Citrus sinensis] diamond 207 143 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Rutaceae Citrus Citrus sinensis
17343561 17343561 PRJNA784298_P_NODE_194_length_2709_cov_8.823976_g159_i0 PRJNA784298 194 2709 8.823976 239.04150984 Tanacetum cinerariifolium 118510 Plants Plants 1044 0   NR GEU28371.1 118510 g159 i0 76.4 0.770764119601329 696 138 76.7 3 2 2080 8039 8711 GEU28371.1 adenylosuccinate synthetase 2, chloroplastic [Tanacetum cinerariifolium] diamond 2088 1044 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Tanacetum Tanacetum cinerariifolium
20339740 20339740 PRJNA784298_P_NODE_96_length_3743_cov_3.999455_g77_i0 PRJNA784298 96 3743 3.999455 149.69960065 Ipomoea batatas 4120 Plants Plants 914 1.99999999992776e-293   NR GME07336.1 4120 g77 i0 65.4 0.56505476890195 705 220 56.4 4 3633 1522 1 682 GME07336.1 UDP-glucose 6-dehydrogenase [Ipomoea batatas] diamond 2115 914 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Convolvulaceae Ipomoea Ipomoea batatas
28506408 28506408 PRJNA784298_P_NODE_27427_length_234_cov_2.869565_g27226_i0 PRJNA784298 27427 234 2.869565 6.7147821 Acer saccharum 4024 Plants Plants 75.1 9.72e-15   NR KAK1588277.1 4024 g27226 i0 59.3 0.756410256410256 59 24 75.6 0 52 228 79 137 KAK1588277.1 hypothetical protein Q3G72_021586 [Acer saccharum] diamond 177 75.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Sapindaceae Acer Acer saccharum
29106392 29106392 PRJNA784298_P_NODE_16908_length_301_cov_2.903509_g16707_i0 PRJNA784298 16908 301 2.903509 8.73956209 Closterium sp. Naga37s-1 2996811 Plants Plants 47 0.00222   NR CAI5525984.1 2996811 g16707 i0 45.3 0.747508305647841 75 29 65.8 5 57 254 152 223 CAI5525984.1 unnamed protein product [Closterium sp. Naga37s-1] diamond 225 47 1 Eukaryota   Viridiplantae Streptophyta Zygnematophyceae Desmidiales Closteriaceae Closterium Closterium sp. Naga37s-1

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