RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "blastn", bioproject = "PRJEB15333" and tax_phylum = "Streptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Streptophyta · 15 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB15333 · 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
21632 21632 PRJEB15333_P_NODE_19641_length_164_cov_0.904348_g19557_i0 PRJEB15333 19641 164 0.904348 1.48313072 Triticum aestivum 4565 Plants Plants 281 1.6000000000000001e-71   NTclustered gi|300681466|emb|FN564430.1| 4565 g19557 i0 98.148 230.140243902439 162 2 98 1 4 164 747226 747065 Triticum aestivum chromosome 3B-specific BAC library, contig ctg0464b blastn 37743 281 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Triticum Triticum aestivum
11189181 11189181 PRJEB15333_P_NODE_16849_length_169_cov_1.150000_g16765_i0 PRJEB15333 16849 169 1.15 1.9435 Magnoliopsida 3398 Plants Plants 302 1.27e-77   NTclustered gi|57340780|gb|AY727965.1| 3772 g16765 i0 98.824 100.579881656805 170 1 100 1 1 169 1494 1663 Roridula gorgonias 26S ribosomal RNA gene, partial sequence blastn 16998 303 0.996699669966997 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Ericales Roridulaceae Roridula Roridula gorgonias
11189189 11189189 PRJEB15333_P_NODE_6829_length_253_cov_15.220588_g6745_i0 PRJEB15333 6829 253 15.220588 38.50808764 Pinus 3337 Plants Plants 462 8.95e-126   NTclustered gi|1878849209|gb|MT796545.1| 3339 g6745 i0 99.605 103.296442687747 253 1 100 0 1 253 267 15 Pinus contorta isolate DM604 small subunit ribosomal RNA gene, partial sequence; 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 26134 462 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Pinus Pinus contorta
12775185 12775185 PRJEB15333_P_NODE_12671_length_192_cov_1.454545_g12587_i0 PRJEB15333 12671 192 1.454545 2.7927264 Ziziphus jujuba 326968 Plants Plants 52.8 0.017   NTclustered gi|2739574731|gb|CP157405.1| 326968 g12587 i0 100 0.145833333333333 28 0 15 0 116 143 8254457 8254430 Ziziphus jujuba isolate TW-2024b chromosome 03 blastn 28 52.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Rhamnaceae Ziziphus Ziziphus jujuba
13739297 13739297 PRJEB15333_P_NODE_11511_length_200_cov_21.708609_g11427_i0 PRJEB15333 11511 200 21.708609 43.417218 Pinus 3337 Plants Plants 361 2.5399999999999998e-95   NTclustered gi|1878849209|gb|MT796545.1| 3339 g11427 i0 99.497 105.935 199 0 99 1 1 198 5661 5463 Pinus contorta isolate DM604 small subunit ribosomal RNA gene, partial sequence; 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 21187 361 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Pinus Pinus contorta
13739299 13739299 PRJEB15333_P_NODE_17911_length_167_cov_0.881356_g17827_i0 PRJEB15333 17911 167 0.881356 1.47186452 Taxus 25628 Plants Plants 309 7.53e-80   NTclustered gi|1836279763|gb|MN965361.1| 25629 g17827 i0 100 5.08982035928144 167 0 100 0 1 167 9036 8870 Taxus baccata clone TaxN5 apocytochrome b (cob), ATP synthase F0 subunit 8 (atp8), cytochrome c oxidase subunit 3 (cox3), and succinate dehydrogenase subunit 4 (sdh4) genes, complete cds; and cytochrome c oxidase subunit 2 (cox2) gene, exon 1 and partial cds; mitochondrial blastn 850 309 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Cupressales Taxaceae Taxus Taxus baccata
14049757 14049757 PRJEB15333_P_NODE_20512_length_162_cov_0.920354_g20428_i0 PRJEB15333 20512 162 0.920354 1.49097348 Triticum aestivum 4565 Plants Plants 161 2.15e-35   NTclustered gi|300681452|emb|FN564429.1| 4565 g20428 i0 85 0.987654320987654 160 23 99 1 2 161 1346154 1345996 Triticum aestivum chromosome 3B-specific BAC library, contig ctg0382b blastn 160 161 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Triticum Triticum aestivum
15013697 15013697 PRJEB15333_P_NODE_8312_length_233_cov_0.836957_g8228_i0 PRJEB15333 8312 233 0.836957 1.95010981 Boronia 68528 Plants Plants 54.7 0.006   NTclustered gi|1877790089|gb|MN082905.1| 1764331 g8228 i0 82.857 1.39914163090129 70 2 29 9 135 202 217 278 Boronia excelsa voucher BRI AQ745462 photosystem II protein D1 (psbA) gene, partial cds; and psbA-trnH intergenic spacer, partial sequence; chloroplast blastn 326 54.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Rutaceae Boronia Boronia excelsa
16288521 16288521 PRJEB15333_P_NODE_17493_length_168_cov_0.873950_g17409_i0 PRJEB15333 17493 168 0.87395 1.468236 Musa 4640 Plants Plants 298 1.64e-76   NTclustered gi|2046372313|dbj|LC609770.1| 4641 g17409 i0 98.802 100.39880952381 167 2 99 0 1 167 42379 42213 Musa acuminata cv. Morado chloroplast DNA, complete genome blastn 16867 298 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Zingiberales Musaceae Musa Musa acuminata
17873227 17873227 PRJEB15333_P_NODE_14735_length_180_cov_0.931298_g14651_i0 PRJEB15333 14735 180 0.931298 1.6763364 Cenchrus americanus 4543 Plants Plants 52.8 0.015   NTclustered gi|2415735785|gb|OP293260.1| 4543 g14651 i0 100 0.311111111111111 28 0 16 0 92 119 717 690 Cenchrus americanus chloroplast ferritin mRNA, complete cds; nuclear gene for chloroplast product blastn 56 52.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Cenchrus Cenchrus americanus
22662772 22662772 PRJEB15333_P_NODE_17258_length_168_cov_1.764706_g17174_i0 PRJEB15333 17258 168 1.764706 2.96470608 Eukaryota 2759 Plants Plants 303 3.53e-78   NTclustered gi|170516003|gb|EU161308.1| 3311 g17174 i0 99.401 99.9880952380952 167 1 99 0 2 168 2514 2348 Ginkgo biloba 26S ribosomal RNA gene, partial sequence blastn 16798 305 0.99344262295082 Eukaryota Embryophyta Viridiplantae Streptophyta Ginkgoopsida Ginkgoales Ginkgoaceae Ginkgo Ginkgo biloba
22662776 22662776 PRJEB15333_P_NODE_5758_length_273_cov_15.165179_g5674_i0 PRJEB15333 5758 273 15.165179 41.40093867 Pinus 3337 Plants Plants 499 7.45e-137   NTclustered gi|1893169201|gb|MT735327.1| 3349 g5674 i0 99.634 106.003663003663 273 1 100 0 1 273 7494 7222 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 28939 499 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Pinus Pinus sylvestris
22973595 22973595 PRJEB15333_P_NODE_19019_length_165_cov_0.896552_g18935_i0 PRJEB15333 19019 165 0.896552 1.4793108 Pinus taeda 3352 Plants Plants 267 4.53e-67   NTclustered gi|297747440|gb|AC241324.1| 3352 g18935 i0 95.758 1 165 7 100 0 1 165 75523 75359 Pinus taeda clone PT_7Ba3321I06, complete sequence blastn 165 267 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Pinus Pinus taeda
23938209 23938209 PRJEB15333_P_NODE_11339_length_202_cov_1.333333_g11255_i0 PRJEB15333 11339 202 1.333333 2.69333266 root 1 Root_unresolved Root_unresolved 368 1.54e-97   NTclustered gi|1941613371|dbj|LC571883.1| 3324 g11255 i0 99.505 101 202 1 100 0 1 202 82777 82978 Keteleeria davidiana Chaw 1470 chloroplast DNA, complete genome blastn 20402 368 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Keteleeria Keteleeria davidiana
25211906 25211906 PRJEB15333_P_NODE_21560_length_155_cov_2.198113_g21476_i0 PRJEB15333 21560 155 2.198113 3.40707515 root 1 Root_unresolved Root_unresolved 287 3.21e-73   NTclustered gi|1836279487|gb|MN965243.1| 3329 g21476 i0 100 114.716129032258 155 0 100 0 1 155 41239 41085 Picea abies clone PicN3 small subunit ribosomal RNA (rrnS) gene, complete sequence; mitochondrial blastn 17781 287 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Picea Picea abies

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