RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "blastn", bioproject = "PRJEB30004" 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 · 15 ✖

bioproject 1

  • PRJEB30004 · 15 ✖

analysis 1

  • blastn · 15 ✖
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
3539220 3539220 PRJEB30004_P_NODE_536263_length_181_cov_2.957746_g520636_i0 PRJEB30004 536263 181 2.957746 5.35352026 Eukaryota 2759 Plants Plants 324 2.95e-84   NTclustered gi|121308528|dbj|AB026935.1| 3322 g520636 i0 98.895 104 181 2 100 0 1 181 364 544 Cedrus deodara gene for 18S ribosomal RNA, partial sequence blastn 18824 324 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Cedrus Cedrus deodara
4816464 4816464 PRJEB30004_P_NODE_420024_length_219_cov_0.794444_g404397_i0 PRJEB30004 420024 219 0.794444 1.73983236 Rosaceae 3745 Plants Plants 405 1.29e-108   NTclustered gi|2500400398|gb|OQ735273.1| 3765 g404397 i0 100 195 219 0 100 0 1 219 107557 107775 Rosa x damascena voucher JTWR-33 plastid, complete genome blastn 42705 405 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Rosaceae Rosa Rosa x damascena
6416013 6416013 PRJEB30004_P_NODE_34046_length_1358_cov_66.207733_g24485_i0 PRJEB30004 34046 1358 66.207733 899.10101414 Cannabis sativa 3483 Plants Plants 56.5 0.011   NTclustered gi|2748541248|gb|CP158646.1| 3483 g24485 i0 100 0.0662739322533137 30 0 2 0 643 672 75903640 75903611 Cannabis sativa cultivar ERBxHO40_23 chromosome 3 blastn 90 56.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Cannabaceae Cannabis Cannabis sativa
7701357 7701357 PRJEB30004_P_NODE_575327_length_172_cov_1.541353_g559700_i0 PRJEB30004 575327 172 1.541353 2.65112716 Oryza sativa 4530 Plants Plants 255 1.02e-63   NTclustered gi|32994295|dbj|AK109086.1| 39947 g559700 i0 93.567 128.616279069767 171 11 99 0 2 172 1616 1786 Oryza sativa Japonica Group cDNA clone:002-154-H10, full insert sequence blastn 22122 255 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Oryza Oryza sativa
8641927 8641927 PRJEB30004_P_NODE_631387_length_160_cov_2.454545_g615760_i0 PRJEB30004 631387 160 2.454545 3.927272 Cedrus 3321 Plants Plants 296 5.55e-76   NTclustered gi|20467285|gb|AY056507.1| 93692 g615760 i0 100 100.1 160 0 100 0 1 160 823 664 Cedrus libani 26S ribosomal RNA gene, partial sequence blastn 16016 296 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Cedrus Cedrus libani
15016332 15016332 PRJEB30004_P_NODE_180432_length_408_cov_2.612466_g164824_i0 PRJEB30004 180432 408 2.612466 10.65886128 Magnoliopsida 3398 Plants Plants 671 0   NTclustered gi|1878849207|gb|MT796543.1| 3512 g164824 i0 98.677 100.735294117647 378 5 100 0 1 378 5298 4921 Quercus rubra isolate DM598 small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 41100 676 0.992603550295858 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Fagaceae Quercus Quercus rubra
15353508 15353508 PRJEB30004_P_NODE_623133_length_162_cov_1.609756_g607506_i0 PRJEB30004 623133 162 1.609756 2.60780472 Triticum aestivum 4565 Plants Plants 300 4.36e-77   NTclustered gi|1251759963|dbj|AK458291.1| 4565 g607506 i0 100 1.85185185185185 162 0 100 0 1 162 1759 1598 Triticum aestivum mRNA, clone: tplb0026b18a, cultivar Chinese Spring blastn 300 300 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Triticum Triticum aestivum
16291413 16291413 PRJEB30004_P_NODE_635173_length_160_cov_1.033058_g619546_i0 PRJEB30004 635173 160 1.033058 1.6528928 Plantago 26867 Plants Plants 279 5.59e-71   NTclustered gi|2169218499|gb|OK523409.1| 101997 g619546 i0 98.125 100 160 3 100 0 1 160 3578 3419 Plantago atrata isolate Patr4 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 26S ribosomal RNA gene, complete sequence blastn 16000 279 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Plantaginaceae Plantago Plantago atrata
16612937 16612937 PRJEB30004_P_NODE_304974_length_278_cov_2.351464_g289347_i0 PRJEB30004 304974 278 2.351464 6.53706992 Zea mays 4577 Plants Plants 514 2.7199999999999996e-141   NTclustered gi|195603344|gb|EU950990.1| 4577 g289347 i0 100 1 278 0 100 0 1 278 858 1135 Zea mays clone 678996 mRNA sequence blastn 278 514 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Zea Zea mays
19159237 19159237 PRJEB30004_P_NODE_254296_length_318_cov_1.677419_g238669_i0 PRJEB30004 254296 318 1.677419 5.33419242 Zea mays 4577 Plants Plants 588 1.84e-163   NTclustered gi|195603344|gb|EU950990.1| 4577 g238669 i0 100 1 318 0 100 0 1 318 847 530 Zea mays clone 678996 mRNA sequence blastn 318 588 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Zea Zea mays
19175339 19175339 PRJEB30004_P_NODE_592116_length_168_cov_2.224806_g576489_i0 PRJEB30004 592116 168 2.224806 3.73767408 Magnolia sinica 86752 Plants Plants 62.1 2.34e-5   NTclustered gi|2548685305|ref|XM_058220263.1| 86752 g576489 i0 97.297 9.21428571428571 37 0 21 1 81 116 1931 1967 PREDICTED: Magnolia sinica calmodulin-binding protein 60 B-like (LOC131224844), transcript variant X3, mRNA blastn 1548 62.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Magnoliales Magnoliaceae Magnolia Magnolia sinica
20115079 20115079 PRJEB30004_P_NODE_415776_length_220_cov_2.088398_g400149_i0 PRJEB30004 415776 220 2.088398 4.5944756 Fagaceae 3503 Plants Plants 385 1.69e-102   NTclustered gi|19919548|gb|AF479107.1| 28927 g400149 i0 98.182 100 220 4 100 0 1 220 303 84 Chrysolepis sempervirens 26S ribosomal RNA gene, complete sequence blastn 22000 385 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Fagaceae Chrysolepis Chrysolepis sempervirens
20115173 20115173 PRJEB30004_P_NODE_569156_length_173_cov_2.828358_g553529_i0 PRJEB30004 569156 173 2.828358 4.89305934 Pinus 3337 Plants Plants 320 3.61e-83   NTclustered gi|1893169201|gb|MT735327.1| 3349 g553529 i0 100 105 173 0 100 0 1 173 6268 6096 Pinus sylvestris isolate DM309 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 18165 320 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Pinus Pinus sylvestris
24256051 24256051 PRJEB30004_P_NODE_177880_length_412_cov_9.546917_g162273_i0 PRJEB30004 177880 412 9.546917 39.33329804 Pinus sylvestris 3349 Plants Plants 710 0   NTclustered gi|1893169201|gb|MT735327.1| 3349 g162273 i0 97.816 104.521844660194 412 8 100 1 1 412 8202 7792 Pinus sylvestris isolate DM309 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 43063 710 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Pinus Pinus sylvestris
24273329 24273329 PRJEB30004_P_NODE_543940_length_179_cov_3.635714_g528313_i0 PRJEB30004 543940 179 3.635714 6.50792806 Larix sp. WSU-cult 194337 Plants Plants 196 6.62e-46   NTclustered gi|30527339|gb|AY095476.1| 194337 g528313 i0 86.667 202.944134078212 180 20 100 4 1 179 2921 3097 Larix sp. MJZ-2002 26S ribosomal RNA gene, partial sequence blastn 36327 196 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Larix Larix sp. WSU-cult

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