RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA982106 · 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
3822996 3822996 PRJNA982106_P_NODE_22603_length_249_cov_1.443182_g22363_i0 PRJNA982106 22603 249 1.443182 3.59352318 Magnoliopsida 3398 Plants Plants 424 4.15e-114   NTclustered gi|2865139578|gb|PQ516471.1| 137943 g22363 i0 97.571 99.1686746987952 247 6 99 0 3 249 4548 4302 Aralia undulata isolate MS1 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 24693 424 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Apiales Araliaceae Aralia Aralia undulata
3823159 3823159 PRJNA982106_P_NODE_4423_length_429_cov_2.176966_g4184_i0 PRJNA982106 4423 429 2.176966 9.33918414 root 1 Root_unresolved Root_unresolved 741 0   NTclustered gi|823227643|gb|KM582842.1| 2711 g4184 i0 98.798 184.263403263403 416 5 97 0 1 416 588 173 Citrus sinensis isolate RM13_Hh1 clone RM13_Hh1-3 16S ribosomal RNA gene, partial sequence; chloroplast blastn 79049 747 0.991967871485944 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Rutaceae Citrus Citrus sinensis
7649233 7649233 PRJNA982106_P_NODE_6166_length_382_cov_1.453074_g5926_i0 PRJNA982106 6166 382 1.453074 5.55074268 Eukaryota 2759 Plants Plants 132 4.55e-26   NTclustered gi|1373956363|ref|XM_024547730.1| 3218 g5926 i0 89.423 0.604712041884817 104 11 27 0 4 107 618 515 PREDICTED: Physcomitrella patens RING-box protein 1a-like (LOC112295784), mRNA blastn 231 132 1 Eukaryota Embryophyta Viridiplantae Streptophyta Bryopsida Funariales Funariaceae Physcomitrium Physcomitrium patens
8616720 8616720 PRJNA982106_P_NODE_17747_length_267_cov_1.190722_g17507_i0 PRJNA982106 17747 267 1.190722 3.17922774 Brassica rapa 3711 Plants Plants 52.8 0.024   NTclustered gi|1516505974|emb|LR031569.1| 3711 g17507 i0 100 0.104868913857678 28 0 10 0 78 105 6874487 6874460 Brassica rapa genome, scaffold: A06 blastn 28 52.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Brassica Brassica rapa
8923949 8923949 PRJNA982106_P_NODE_25607_length_247_cov_0.885057_g25367_i0 PRJNA982106 25607 247 0.885057 2.18609079 Glycine 3846 Plants Plants 457 4.05e-124   NTclustered gi|210145310|dbj|AK244001.1| 3847 g25367 i0 100 47.9271255060729 247 0 100 0 1 247 1262 1016 Glycine max cDNA, clone: GMFL01-01-N07 blastn 11838 457 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Glycine Glycine max
10199626 10199626 PRJNA982106_P_NODE_19088_length_259_cov_1.177419_g18848_i0 PRJNA982106 19088 259 1.177419 3.04951521 Citrus 2706 Plants Plants 473 4.25e-129   NTclustered gi|2249528609|gb|ON685430.1| 2711 g18848 i0 99.614 100.034749034749 259 1 100 0 1 259 2549 2807 Citrus sinensis isolate BPTPS119 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 25909 473 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Rutaceae Citrus Citrus sinensis
11474721 11474721 PRJNA982106_P_NODE_19469_length_256_cov_1.683060_g19229_i0 PRJNA982106 19469 256 1.68306 4.3086336 Glycine 3846 Plants Plants 473 4.189999999999999e-129   NTclustered gi|2616762076|gb|OR687435.1| 3847 g19229 i0 100 51.765625 256 0 100 0 1 256 156895 157150 Glycine max mitochondrion, complete genome blastn 13252 473 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Glycine Glycine max
12442819 12442819 PRJNA982106_P_NODE_15010_length_285_cov_0.872642_g14770_i0 PRJNA982106 15010 285 0.872642 2.4870297 Selenicereus monacanthus 1195128 Plants Plants 518 2.16e-142   NTclustered gi|2569529600|ref|NC_081468.1| 1195128 g14770 i0 99.647 80.8070175438596 283 1 99 0 1 283 813990 813708 Selenicereus monacanthus mitochondrion, complete genome blastn 23030 518 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Caryophyllales Cactaceae Selenicereus Selenicereus monacanthus
13717368 13717368 PRJNA982106_P_NODE_17511_length_268_cov_1.579487_g17271_i0 PRJNA982106 17511 268 1.579487 4.23302516 Metasequoia glyptostroboides 3371 Plants Plants 488 1.5799999999999998e-133   NTclustered gi|849123719|ref|NC_027423.1| 3371 g17271 i0 99.627 91.2723880597015 268 0 100 1 1 268 64625 64359 Metasequoia glyptostroboides chloroplast, complete genome blastn 24461 488 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Cupressales Cupressaceae Metasequoia Metasequoia glyptostroboides
18815712 18815712 PRJNA982106_P_NODE_30555_length_242_cov_3.218935_g30315_i0 PRJNA982106 30555 242 3.218935 7.7898227 Phyllostachys edulis 38705 Plants Plants 121 5.889999999999999e-23   NTclustered gi|242382958|emb|FP092199.1| 38705 g30315 i0 79.882 7.51239669421488 169 30 69 4 54 220 77 243 Phyllostachys edulis cDNA clone: bphyem001l12, full insert sequence blastn 1818 121 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Phyllostachys Phyllostachys edulis
20090218 20090218 PRJNA982106_P_NODE_17876_length_266_cov_1.300518_g17636_i0 PRJNA982106 17876 266 1.300518 3.45937788 Jacobaea vulgaris 98722 Plants Plants 56.5 0.002   NTclustered gi|2918395481|emb|OZ238157.1| 98722 g17636 i0 92.308 0.484962406015038 39 3 15 0 34 72 84034097 84034135 Jacobaea vulgaris genome assembly, chromosome: 9 blastn 129 56.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Jacobaea Jacobaea vulgaris
20397250 20397250 PRJNA982106_P_NODE_10416_length_322_cov_5.261044_g10176_i0 PRJNA982106 10416 322 5.261044 16.94056168 Magnoliopsida 3398 Plants Plants 279 1.27e-70   NTclustered gi|2292905072|gb|ON931349.1| 3635 g10176 i0 100 113.139751552795 151 0 72 0 171 321 3762 3912 Gossypium hirsutum chromosome SI3Amt_1 mitochondrion sequence blastn 36431 279 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malvales Malvaceae Gossypium Gossypium hirsutum
21365932 21365932 PRJNA982106_P_NODE_24877_length_247_cov_1.488506_g24637_i0 PRJNA982106 24877 247 1.488506 3.67660982 Zea mays 4577 Plants Plants 398 2.4899999999999996e-106   NTclustered gi|291190958|gb|AC230000.3| 4577 g24637 i0 95.918 236.534412955466 245 10 99 0 3 247 50952 51196 Zea mays BAC clone CH201-395O17 from chromosome unknown, complete sequence blastn 58424 398 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Zea Zea mays
21673494 21673494 PRJNA982106_P_NODE_31377_length_242_cov_0.911243_g31137_i0 PRJNA982106 31377 242 0.911243 2.20520806 Pyrus 3766 Plants Plants 440 3.9799999999999986e-119   NTclustered gi|2806199034|ref|XM_068470027.1| 23211 g31137 i0 99.585 116.380165289256 241 1 99 0 1 241 343 583 PREDICTED: Pyrus communis major strawberry allergen Fra a 1-3-like (LOC137730994), mRNA blastn 28164 442 0.995475113122172 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Rosaceae Pyrus Pyrus communis
23916613 23916613 PRJNA982106_P_NODE_30379_length_243_cov_0.905882_g30139_i0 PRJNA982106 30379 243 0.905882 2.20129326 Pyrus x bretschneideri 225117 Plants Plants 435 1.86e-117   NTclustered gi|2250526016|ref|XM_048577871.1| 225117 g30139 i0 98.776 68.8148148148148 245 1 100 2 1 243 152 396 PREDICTED: Pyrus x bretschneideri protein DELETION OF SUV3 SUPPRESSOR 1(I)-like (LOC125474334), transcript variant X1, mRNA blastn 16722 435 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Rosaceae Pyrus Pyrus x bretschneideri
25190181 25190181 PRJNA982106_P_NODE_29820_length_243_cov_0.905882_g29580_i0 PRJNA982106 29820 243 0.905882 2.20129326 Humulus lupulus 3486 Plants Plants 80.5 1e-10   NTclustered gi|2646076229|ref|XR_009868808.1| 3486 g29580 i0 85.526 3.440329218107 76 11 31 0 168 243 3647 3572 PREDICTED: Humulus lupulus uncharacterized LOC133777754 (LOC133777754), transcript variant X10, ncRNA blastn 836 80.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Cannabaceae Humulus Humulus lupulus

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