RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "blastn", bioproject = "PRJNA1215774" and tax_phylum = "Streptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Streptophyta · 16 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1215774 · 16 ✖

analysis 1

  • blastn · 16 ✖
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
2321011 2321011 PRJNA1215774_P_NODE_53542_length_287_cov_9.093458_g53222_i0 PRJNA1215774 53542 287 9.093458 26.09822446 Ulmaceae 3474 Plants Plants 531 2.799999999999999e-146   NTclustered gi|19919540|gb|AF479099.1| 45187 g53222 i0 100 100 287 0 100 0 1 287 296 10 Zelkova serrata 26S ribosomal RNA gene, complete sequence blastn 28700 531 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Ulmaceae Zelkova Zelkova serrata
2882109 2882109 PRJNA1215774_P_NODE_51123_length_295_cov_1.040541_g50803_i0 PRJNA1215774 51123 295 1.040541 3.06959595 Triticum aestivum 4565 Plants Plants 540 4.79e-149   NTclustered gi|1251765982|dbj|AK447493.1| 4565 g50803 i0 99.661 1 295 1 100 0 1 295 4496 4202 Triticum aestivum mRNA, clone: tplb0033a11, cultivar Chinese Spring blastn 295 540 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Triticum Triticum aestivum
2882283 2882283 PRJNA1215774_P_NODE_62203_length_265_cov_2.010417_g61883_i0 PRJNA1215774 62203 265 2.010417 5.32760505 Zea mays 4577 Plants Plants 490 4.3299999999999986e-134   NTclustered gi|1897987733|ref|XR_004850596.1| 4577 g61883 i0 100 100 265 0 100 0 1 265 1580 1844 PREDICTED: Zea mays 28S ribosomal RNA (LOC118472458), rRNA blastn 26500 490 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Zea Zea mays
6148622 6148622 PRJNA1215774_P_NODE_86265_length_226_cov_5.392157_g85945_i0 PRJNA1215774 86265 226 5.392157 12.18627482 Ulmaceae 3474 Plants Plants 411 2.8799999999999995e-110   NTclustered gi|1812758613|gb|MT117138.1| 160986 g85945 i0 99.556 99.9247787610619 225 1 99 0 1 225 4090 4314 Zelkova carpinifolia voucher DM16560 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 22583 411 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Ulmaceae Zelkova Zelkova carpinifolia
8698509 8698509 PRJNA1215774_P_NODE_17567_length_517_cov_4.864865_g17248_i0 PRJNA1215774 17567 517 4.864865 25.15135205 Ulmus 24735 Plants Plants 950 0   NTclustered gi|1812758597|gb|MT117122.1| 172265 g17248 i0 99.807 100.137330754352 517 1 100 0 1 517 1952 2468 Ulmus glabra voucher DM13808 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 51771 950 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Ulmaceae Ulmus Ulmus glabra
8698705 8698705 PRJNA1215774_P_NODE_60847_length_269_cov_1.076531_g60527_i0 PRJNA1215774 60847 269 1.076531 2.89586839 Eukaryota 2759 Plants Plants 479 9.539999999999999e-131   NTclustered gi|1721134033|emb|LR130855.1| 38872 g60527 i0 98.881 99.9330855018587 268 3 99 0 2 269 1180 1447 Fraxinus americana genomic DNA containing ETS-18S-ITS1-5.8S-ITS2-26S region, specimen voucher R.E. Weaver & J. Nickerson 968-79 (A) blastn 26882 481 0.995841995841996 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Fraxinus Fraxinus americana
10535424 10535424 PRJNA1215774_P_NODE_80829_length_243_cov_0.905882_g80509_i0 PRJNA1215774 80829 243 0.905882 2.20129326 Ziziphus jujuba 326968 Plants Plants 182 2.68e-41   NTclustered gi|2618432160|ref|XM_048462194.2| 326968 g80509 i0 83.168 26.2716049382716 202 31 82 3 40 238 111 312 PREDICTED: Ziziphus jujuba transmembrane 9 superfamily member 2 (LOC107429142), mRNA blastn 6384 182 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Rhamnaceae Ziziphus Ziziphus jujuba
11810203 11810203 PRJNA1215774_P_NODE_75790_length_246_cov_1.757225_g75470_i0 PRJNA1215774 75790 246 1.757225 4.3227735 Cannabis sativa 3483 Plants Plants 52.8 0.022   NTclustered gi|2748541476|gb|CP158647.1| 3483 g75470 i0 100 0.113821138211382 28 0 11 0 69 96 69990848 69990875 Cannabis sativa cultivar ERBxHO40_23 chromosome 4 blastn 28 52.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Cannabaceae Cannabis Cannabis sativa
15073181 15073181 PRJNA1215774_P_NODE_29492_length_390_cov_1.198738_g29172_i0 PRJNA1215774 29492 390 1.198738 4.6750782 Eukaryota 2759 Plants Plants 715 0   NTclustered gi|194703603|gb|BT040881.1| 4577 g29172 i0 100 57.1102564102564 387 0 99 0 4 390 1058 1444 Zea mays full-length cDNA clone ZM_BFc0144J03 mRNA, complete cds blastn 22273 715 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Zea Zea mays
15073365 15073365 PRJNA1215774_P_NODE_75532_length_247_cov_0.885057_g75212_i0 PRJNA1215774 75532 247 0.885057 2.18609079 Oleaceae 4144 Plants Plants 451 1.88e-122   NTclustered gi|1642527651|ref|NC_042274.1| 13597 g75212 i0 100 99.497975708502 244 0 99 0 1 244 38658 38901 Ligustrum vulgare voucher G:G.Besnard 02-2007 chloroplast, complete genome blastn 24576 455 0.991208791208791 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Ligustrum Ligustrum vulgare
17623501 17623501 PRJNA1215774_P_NODE_74094_length_247_cov_5.678161_g73774_i0 PRJNA1215774 74094 247 5.678161 14.02505767 Eukaryota 2759 Plants Plants 350 7.07e-92   NTclustered gi|195616321|gb|EU957873.1| 4577 g73774 i0 92.713 46.0202429149798 247 11 100 4 1 247 993 1232 Zea mays clone 1628308 zinc finger protein mRNA, complete cds blastn 11367 350 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Zea Zea mays
18897308 18897308 PRJNA1215774_P_NODE_85875_length_231_cov_2.886076_g85555_i0 PRJNA1215774 85875 231 2.886076 6.66683556 Eukaryota 2759 Plants Plants 405 1.38e-108   NTclustered gi|1721134033|emb|LR130855.1| 38872 g85555 i0 98.268 100 231 4 100 0 1 231 4585 4815 Fraxinus americana genomic DNA containing ETS-18S-ITS1-5.8S-ITS2-26S region, specimen voucher R.E. Weaver & J. Nickerson 968-79 (A) blastn 23100 405 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Fraxinus Fraxinus americana
20172082 20172082 PRJNA1215774_P_NODE_84096_length_241_cov_0.916667_g83776_i0 PRJNA1215774 84096 241 0.916667 2.20916747 Rosales 3744 Plants Plants 154 5.78e-33   NTclustered gi|4691276|emb|AJ236706.1| 3486 g83776 i0 83.636 74.5394190871369 165 26 68 1 76 240 243 406 Humulus lupulus Hl7SL-1 gene for signal recognition particle blastn 17964 154 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Cannabaceae Humulus Humulus lupulus
20732643 20732643 PRJNA1215774_P_NODE_54177_length_286_cov_1.300469_g53857_i0 PRJNA1215774 54177 286 1.300469 3.71934134 Triticum aestivum 4565 Plants Plants 435 2.25e-117   NTclustered gi|1282798539|gb|MG560142.1| 4565 g53857 i0 94.056 55.0174825174825 286 17 100 0 1 286 4322362 4322647 Triticum aestivum omega gliadin-D1, omega gliadin-D2, omega gliadin-D3, gamma gliadin-D1, delta gliadin-D1, gamma gliadin-D2, gamma gliadin-D3, gamma gliadin-D4, LMW-D1, LMW-D2, LMW-D3, LMW-D6, and LMW-D7 genes, complete cds blastn 15735 435 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Triticum Triticum aestivum
21447363 21447363 PRJNA1215774_P_NODE_12837_length_610_cov_5.169460_g12521_i0 PRJNA1215774 12837 610 5.16946 31.533706 Ulmaceae 3474 Plants Plants 1116 0   NTclustered gi|1812758593|gb|MT117118.1| 102694 g12521 i0 99.672 100.008196721311 610 2 100 0 1 610 3748 3139 Ulmus crassifolia voucher DM13822 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 61005 1122 0.994652406417112 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Ulmaceae Ulmus Ulmus crassifolia
25271957 25271957 PRJNA1215774_P_NODE_86400_length_226_cov_2.013072_g86080_i0 PRJNA1215774 86400 226 2.013072 4.54954272 Viridiplantae 33090 Plants Plants 405 1.34e-108   NTclustered gi|109657675|gb|DQ647867.1| 3175 g86080 i0 99.111 104.300884955752 225 2 99 0 2 226 1971 1747 Klebsormidium flaccidum large subunit ribosomal RNA gene, partial sequence; mitochondrial blastn 23572 405 1 Eukaryota   Viridiplantae Streptophyta Klebsormidiophyceae Klebsormidiales Klebsormidiaceae Klebsormidium Klebsormidium flaccidum

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