RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA1134759" and tax_phylum = "Streptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Streptophyta · 10 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1134759 · 10 ✖

analysis 1

  • blastn · 10 ✖
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
1031887 1031887 PRJNA1134759_P_NODE_27681_length_317_cov_1.032787_g27505_i0 PRJNA1134759 27681 317 1.032787 3.27393479 Magnoliopsida 3398 Plants Plants 568 2.3799999999999994e-157   NTclustered gi|1281061570|ref|XR_002715253.1| 3661 g27505 i0 99.051 99.6876971608833 316 3 99 0 1 316 1950 1635 PREDICTED: Cucurbita maxima Eukaryotic 28S ribosomal RNA (LOC111471776), rRNA blastn 31601 573 0.991273996509599 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Cucurbitales Cucurbitaceae Cucurbita Cucurbita maxima
1558638 1558638 PRJNA1134759_P_NODE_12342_length_447_cov_2.382353_g12166_i0 PRJNA1134759 12342 447 2.382353 10.64911791 Oryza sativa 4530 Plants Plants 357 8.189999999999997e-94   NTclustered gi|32993350|dbj|AK108141.1| 39947 g12166 i0 81.538 1.96644295302013 455 65 98 13 3 442 143 593 Oryza sativa Japonica Group cDNA clone:002-139-E09, full insert sequence blastn 879 357 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Oryza Oryza sativa
6662062 6662062 PRJNA1134759_P_NODE_49526_length_252_cov_0.871508_g49350_i0 PRJNA1134759 49526 252 0.871508 2.19620016 Aegilops tauschii 37682 Plants Plants 224 4.5799999999999997e-54   NTclustered gi|591390447|gb|JX295577.2| 37682 g49350 i0 92.025 15.2380952380952 163 8 96 5 1 161 1454712 1454871 Aegilops tauschii chromosome 1Ds prolamin gene locus, complete sequence blastn 3840 224 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Aegilops Aegilops tauschii
8684974 8684974 PRJNA1134759_P_NODE_37407_length_280_cov_5.415459_g37231_i0 PRJNA1134759 37407 280 5.415459 15.1632852 Eukaryota 2759 Plants Plants 95.3 4.23e-15   NTclustered gi|2029522904|ref|XR_005924537.1| 3635 g37231 i0 98.148 37.5428571428571 54 1 19 0 1 54 1905 1958 PREDICTED: Gossypium hirsutum 28S ribosomal RNA (LOC121226851), rRNA blastn 10512 95.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malvales Malvaceae Gossypium Gossypium hirsutum
10487679 10487679 PRJNA1134759_P_NODE_38329_length_278_cov_1.170732_g38153_i0 PRJNA1134759 38329 278 1.170732 3.25463496 Oryza sativa 4530 Plants Plants 191 5.2e-44   NTclustered gi|37989606|dbj|AK119983.1| 39947 g38153 i0 94.444 0.453237410071942 126 4 45 3 5 128 928 804 Oryza sativa Japonica Group cDNA clone:002-184-F09, full insert sequence blastn 126 191 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Oryza Oryza sativa
15059583 15059583 PRJNA1134759_P_NODE_35832_length_285_cov_2.047170_g35656_i0 PRJNA1134759 35832 285 2.04717 5.8344345 Asteraceae 4210 Plants Plants 527 3.59e-145   NTclustered gi|2127863804|ref|NC_058644.1| 4217 g35656 i0 100 134.968421052632 285 0 100 0 1 285 166676 166392 Arctium lappa mitochondrion, complete genome blastn 38466 527 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Arctium Arctium lappa
18135854 18135854 PRJNA1134759_P_NODE_19155_length_368_cov_4.600000_g18979_i0 PRJNA1134759 19155 368 4.6 16.928 Vitis vinifera 29760 Plants Plants 52.8 0.035   NTclustered gi|147777539|emb|AM432656.2| 29760 g18979 i0 96.774 0.0842391304347826 31 1 8 0 89 119 616 586 Vitis vinifera contig VV78X053000.2, whole genome shotgun sequence blastn 31 52.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Vitales Vitaceae Vitis Vitis vinifera
22708774 22708774 PRJNA1134759_P_NODE_55038_length_244_cov_0.912281_g54862_i0 PRJNA1134759 55038 244 0.912281 2.22596564 Malus 3749 Plants Plants 451 1.86e-122   NTclustered gi|2878394410|ref|XM_029109558.2| 3750 g54862 i0 100 70.4303278688525 244 0 100 0 1 244 2369 2126 PREDICTED: Malus domestica V-type proton ATPase subunit a3 (LOC103412077), mRNA blastn 17185 451 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Rosaceae Malus Malus domestica
24510129 24510129 PRJNA1134759_P_NODE_50700_length_250_cov_0.881356_g50524_i0 PRJNA1134759 50700 250 0.881356 2.20339 Triticum aestivum 4565 Plants Plants 265 2.67e-66   NTclustered gi|1282797651|gb|MG560141.1| 4565 g50524 i0 86.345 3.74 249 26 99 2 2 250 1940548 1940788 Triticum aestivum gamma gliadin-B1, gamma gliadin-B2, delta gliadin-B1, gamma gliadin-B4, gamma gliadin-B6, omega gliadin-B3, omega gliadin-B6, LMW-B2, and LMW-B3 genes, complete cds blastn 935 265 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Triticum Triticum aestivum
24510133 24510133 PRJNA1134759_P_NODE_51460_length_249_cov_0.886364_g51284_i0 PRJNA1134759 51460 249 0.886364 2.20704636 Malus domestica 3750 Plants Plants 460 3.16e-125   NTclustered gi|2810943376|gb|CP168774.1| 3750 g51284 i0 100 7.78313253012048 249 0 100 0 1 249 39388945 39389193 Malus domestica cultivar Golden Delicious chromosome 10 blastn 1938 460 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Rosaceae Malus Malus domestica

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