RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "blastn", bioproject = "PRJEB4632" and tax_kingdom = "Viridiplantae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_clade 2

tax_superkingdom 1

tax_kingdom 1

  • Viridiplantae · 19 ✖

bioproject 1

  • PRJEB4632 · 19 ✖

analysis 1

  • blastn · 19 ✖
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
990065 990065 PRJEB4632_P_NODE_1081_length_206_cov_6.842105_g1043_i0 PRJEB4632 1081 206 6.842105 14.0947363 Eukaryota 2759 Plants Plants 381 2.0199999999999994e-101   NTclustered gi|1893169201|gb|MT735327.1| 3349 g1043 i0 100 103.5 206 0 100 0 1 206 796 1001 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 21321 381 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Pinus Pinus sylvestris
2265286 2265286 PRJEB4632_P_NODE_662_length_270_cov_1.071066_g624_i0 PRJEB4632 662 270 1.071066 2.8918782 Rosaceae 3745 Plants Plants 497 2.6399999999999998e-136   NTclustered gi|2183121001|gb|OK585101.1| 3750 g624 i0 100 192.322222222222 269 0 99 0 1 269 108813 109081 Malus domestica cultivar Red Fuji-TS03 plastid, complete genome blastn 51927 499 0.995991983967936 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Rosaceae Malus Malus domestica
3887687 3887687 PRJEB4632_P_NODE_664_length_269_cov_2.535714_g626_i0 PRJEB4632 664 269 2.535714 6.82107066 Ulothrix zonata 43941 Plants Plants 497 2.63e-136   NTclustered gi|530445654|emb|HE860533.1| 43941 g626 i0 100 99.1263940520446 269 0 100 0 1 269 292 24 Ulothrix zonata partial 28S rRNA gene, isolate Q19 blastn 26665 497 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Ulvophyceae Ulotrichales Ulotrichaceae Ulothrix Ulothrix zonata
7367602 7367602 PRJEB4632_P_NODE_1066_length_214_cov_4.141844_g1028_i0 PRJEB4632 1066 214 4.141844 8.86354616 Ulvaceae 3114 Plants Plants 361 2.7599999999999993e-95   NTclustered gi|2070425893|gb|MZ596105.1| 3116 g1028 i0 97.196 100.060747663551 214 5 100 1 1 214 2325 2537 Ulva intestinalis strain CNS00531 large subunit ribosomal RNA gene, partial sequence blastn 21413 363 0.994490358126722 Eukaryota core chlorophytes Viridiplantae Chlorophyta Ulvophyceae Ulvales Ulvaceae Ulva Ulva intestinalis
7367609 7367609 PRJEB4632_P_NODE_706_length_260_cov_2.978610_g668_i0 PRJEB4632 706 260 2.97861 7.744386 Magnoliopsida 3398 Plants Plants 475 1.1899999999999999e-129   NTclustered gi|2699132188|emb|OZ022203.1| 3755 g668 i0 99.615 111.273076923077 260 1 100 0 1 260 1211000 1211259 Prunus dulcis genome assembly, chromosome: 7 blastn 28931 475 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Rosaceae Prunus Prunus dulcis
9918217 9918217 PRJEB4632_P_NODE_1088_length_201_cov_6.593750_g1050_i0 PRJEB4632 1088 201 6.59375 13.2534375 Rosales 3744 Plants Plants 372 1.18e-98   NTclustered gi|2810943367|gb|CP168765.1| 3750 g1050 i0 100 102.960199004975 201 0 100 0 1 201 35457 35257 Malus domestica cultivar Golden Delicious chromosome 01 blastn 20695 372 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Rosaceae Malus Malus domestica
9918225 9918225 PRJEB4632_P_NODE_748_length_251_cov_2.651685_g710_i0 PRJEB4632 748 251 2.651685 6.65572935 Pinus 3337 Plants Plants 459 1.1499999999999996e-124   NTclustered gi|1878849209|gb|MT796545.1| 3339 g710 i0 99.602 105.972111553785 251 1 100 0 1 251 6278 6528 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 26599 459 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Pinus Pinus contorta
10264401 10264401 PRJEB4632_P_NODE_609_length_283_cov_1.523810_g571_i0 PRJEB4632 609 283 1.52381 4.3123823 Poa annua 93036 Plants Plants 518 2.14e-142   NTclustered gi|1347727320|ref|NC_036973.1| 93036 g571 i0 99.647 195 283 1 100 0 1 283 97943 97661 Poa annua plastid, complete genome blastn 55185 518 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Poa Poa annua
11193417 11193417 PRJEB4632_P_NODE_629_length_277_cov_1.862745_g591_i0 PRJEB4632 629 277 1.862745 5.15980365 Pinus 3337 Plants Plants 507 4.53e-139   NTclustered gi|1878849209|gb|MT796545.1| 3339 g591 i0 99.639 103.436823104693 277 1 100 0 1 277 313 37 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 28652 512 0.990234375 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Pinus Pinus contorta
15017869 15017869 PRJEB4632_P_NODE_432_length_333_cov_1.738462_g394_i0 PRJEB4632 432 333 1.738462 5.78907846 Poaceae 4479 Plants Plants 608 1.479999999999999e-169   NTclustered gi|1214171912|gb|KY636002.1| 4483 g394 i0 99.699 181.453453453453 332 1 99 0 2 333 97271 96940 Aegilops bicornis voucher AE 788 chloroplast, partial genome blastn 60424 614 0.990228013029316 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Aegilops Aegilops bicornis
15363791 15363791 PRJEB4632_P_NODE_553_length_300_cov_2.449339_g515_i0 PRJEB4632 553 300 2.449339 7.348017 Sarcinofilum mucosum 141643 Plants Plants 473 5.03e-129   NTclustered gi|1197510887|ref|NC_034709.1| 141643 g515 i0 95.302 99.76 298 14 99 0 1 298 146630 146333 Trichosarcina mucosa culture SAG:4.90 chloroplast, complete genome blastn 29928 473 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Ulvophyceae Ulotrichales Sarcinofilaceae Sarcinofilum Sarcinofilum mucosum
16638358 16638358 PRJEB4632_P_NODE_954_length_243_cov_0.905882_g916_i0 PRJEB4632 954 243 0.905882 2.20129326 Diplosphaera sp. (in: green algae) 2911680 Plants Plants 383 6.84e-102   NTclustered gi|2644500050|gb|PP079688.1| 2911680 g916 i0 95.062 98.559670781893 243 12 100 0 1 243 1535 1777 Diplosphaera sp. (in: green algae) isolate C3 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 23950 383 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Prasiolales Stichococcaceae Diplosphaera Diplosphaera sp. (in: green algae)
19187101 19187101 PRJEB4632_P_NODE_656_length_271_cov_0.843434_g618_i0 PRJEB4632 656 271 0.843434 2.28570614 Chloroidium ellipsoideum 63676 Plants Plants 267 8.149999999999999e-67   NTclustered gi|1169296931|gb|KY364701.1| 63676 g618 i0 84.727 14.7380073800738 275 33 100 8 1 271 5423 5692 Chloroidium ellipsoideum 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 3994 267 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Watanabeales Watanabeaceae Chloroidium Chloroidium ellipsoideum
21392121 21392121 PRJEB4632_P_NODE_1017_length_232_cov_2.754717_g979_i0 PRJEB4632 1017 232 2.754717 6.39094344 Salix 40685 Plants Plants 429 8.2e-116   NTclustered gi|1881064953|gb|MT808329.1| 75704 g979 i0 100 100 232 0 100 0 1 232 467 236 Salix alba isolate DM300 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 23200 429 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malpighiales Salicaceae Salix Salix alba
21392126 21392126 PRJEB4632_P_NODE_497_length_314_cov_2.987552_g459_i0 PRJEB4632 497 314 2.987552 9.38091328 Poales 38820 Plants Plants 575 1.4099999999999994e-159   NTclustered gi|1042812848|gb|KT153030.1| 4499 g459 i0 99.682 1128.48089171975 314 1 100 0 1 314 19 332 Avena fatua 18S ribosomal RNA gene, partial sequence blastn 354343 575 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Avena Avena fatua
21392131 21392131 PRJEB4632_P_NODE_777_length_250_cov_1.638418_g739_i0 PRJEB4632 777 250 1.638418 4.096045 Pinus 3337 Plants Plants 462 8.83e-126   NTclustered gi|1893169201|gb|MT735327.1| 3349 g739 i0 100 104.272 250 0 100 0 1 250 5081 4832 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 26068 462 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Pinus Pinus sylvestris
22666941 22666941 PRJEB4632_P_NODE_598_length_286_cov_4.023474_g560_i0 PRJEB4632 598 286 4.023474 11.50713564 Eukaryota 2759 Plants Plants 529 1e-145   NTclustered gi|1189013852|gb|MF034633.1| 43939 g560 i0 100 100.01048951049 286 0 100 0 1 286 947 662 Hazenia basiliensis strain ULVO-15 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 28603 529 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Ulvophyceae Ulotrichales Hazeniaceae Hazenia Hazenia basiliensis
23942365 23942365 PRJEB4632_P_NODE_639_length_275_cov_1.866337_g601_i0 PRJEB4632 639 275 1.866337 5.13242675 Eukaryota 2759 Plants Plants 503 5.809999999999998e-138   NTclustered gi|1189013852|gb|MF034633.1| 43939 g601 i0 99.636 100.010909090909 275 1 100 0 1 275 69 343 Hazenia basiliensis strain ULVO-15 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 27503 508 0.990157480314961 Eukaryota core chlorophytes Viridiplantae Chlorophyta Ulvophyceae Ulotrichales Hazeniaceae Hazenia Hazenia basiliensis
25216180 25216180 PRJEB4632_P_NODE_420_length_338_cov_1.686792_g382_i0 PRJEB4632 420 338 1.686792 5.70135696 Sapindales 41937 Plants Plants 608 1.509999999999999e-169   NTclustered gi|1198028429|ref|NC_034690.1| 2708 g382 i0 99.112 192 338 3 100 0 1 338 110206 109869 Citrus limon plastid, complete genome blastn 64896 614 0.990228013029316 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Rutaceae Citrus Citrus x limon

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