RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "blastn", bioproject = "PRJNA1041773" and tax_clade = "core chlorophytes"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • core chlorophytes · 13 ✖

bioproject 1

  • PRJNA1041773 · 13 ✖

analysis 1

  • blastn · 13 ✖
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
170083 170083 PRJNA1041773_P_NODE_28781_length_389_cov_2.060127_g28450_i0 PRJNA1041773 28781 389 2.060127 8.01389403 Desmochloris halophila 138176 Plants Plants 279 1.5700000000000002e-70   NTclustered gi|984294686|gb|KT390147.1| 138176 g28450 i0 80 21.9948586118252 395 65 100 13 1 389 1007 1393 Desmochloris halophila clone ZX14-0.2-28 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 8556 279 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Ulvophyceae Chlorocystidales Chlorocystidaceae Desmochloris Desmochloris halophila
2720495 2720495 PRJNA1041773_P_NODE_26623_length_403_cov_4.963636_g26292_i0 PRJNA1041773 26623 403 4.963636 20.00345308 Picochlorum sp. 2812594 Plants Plants 603 8.509999999999998e-168   NTclustered gi|2632235332|gb|OR922714.1| 2812594 g26292 i0 94.03 31.0521091811414 402 17 99 3 2 401 2273 2669 Picochlorum sp. strain AGSB0128 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 12514 603 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae     Picochlorum Picochlorum sp.
3997005 3997005 PRJNA1041773_P_NODE_59324_length_281_cov_1.480769_g58991_i0 PRJNA1041773 59324 281 1.480769 4.16096089 Chlamydomonas parkeae 156093 Plants Plants 520 5.909999999999999e-143   NTclustered gi|66864276|gb|DQ015731.1| 156093 g58991 i0 100 69.1067615658363 281 0 100 0 1 281 3231 2951 Chlamydomonas parkeae strain SAG 24.89 26S ribosomal RNA gene, partial sequence blastn 19419 520 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Chlamydomonadaceae Chlamydomonas Chlamydomonas parkeae
7822719 7822719 PRJNA1041773_P_NODE_27727_length_395_cov_10.745342_g27396_i0 PRJNA1041773 27727 395 10.745342 42.4441009 Desmochloris halophila 138176 Plants Plants 230 1.6299999999999996e-55   NTclustered gi|984294686|gb|KT390147.1| 138176 g27396 i0 77.887 20.4835443037975 407 64 100 22 1 395 1001 1393 Desmochloris halophila clone ZX14-0.2-28 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 8091 230 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Ulvophyceae Chlorocystidales Chlorocystidaceae Desmochloris Desmochloris halophila
7822930 7822930 PRJNA1041773_P_NODE_41807_length_328_cov_1.839216_g41474_i0 PRJNA1041773 41807 328 1.839216 6.03262848 Desmochloris halophila 138176 Plants Plants 224 6.179999999999998e-54   NTclustered gi|984294686|gb|KT390147.1| 138176 g41474 i0 79.341 2.24085365853659 334 57 100 11 1 328 1321 994 Desmochloris halophila clone ZX14-0.2-28 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 735 224 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Ulvophyceae Chlorocystidales Chlorocystidaceae Desmochloris Desmochloris halophila
9936486 9936486 PRJNA1041773_P_NODE_3708_length_1059_cov_2.756592_g3479_i0 PRJNA1041773 3708 1059 2.756592 29.19230928 Picochlorum 249344 Plants Plants 1609 0   NTclustered gi|2629889181|gb|CP120466.1| 1470871 g3479 i0 94.874 103.712936732767 1034 46 97 3 1 1031 69438 68409 Picochlorum sp. SENEW3 chloroplast blastn 109832 1620 0.99320987654321 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae     Picochlorum Picochlorum sp. SENEW3
9936802 9936802 PRJNA1041773_P_NODE_79488_length_250_cov_1.197740_g79155_i0 PRJNA1041773 79488 250 1.19774 2.99435 Ulva 3118 Plants Plants 54.7 0.006   NTclustered gi|2043344467|gb|MW353781.1| 63659 g79155 i0 100 0.812 29 0 12 0 202 230 78187 78215 Ulva compressa isolate Uco3 plastid, complete genome blastn 203 54.7 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Ulvophyceae Ulvales Ulvaceae Ulva Ulva compressa
10373264 10373264 PRJNA1041773_P_NODE_24309_length_421_cov_34.629310_g23978_i0 PRJNA1041773 24309 421 34.62931 145.7893951 Chloroidium ellipsoideum 63676 Plants Plants 268 3.7e-67   NTclustered gi|1169296931|gb|KY364701.1| 63676 g23978 i0 79.455 5.52969121140142 404 64 93 17 29 421 5782 5387 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 2328 268 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Watanabeales Watanabeaceae Chloroidium Chloroidium ellipsoideum
13761872 13761872 PRJNA1041773_P_NODE_48311_length_307_cov_1.525641_g47978_i0 PRJNA1041773 48311 307 1.525641 4.68371787 Trebouxiophyceae 75966 Plants Plants 87.9 7.85e-13   NTclustered gi|1169296931|gb|KY364701.1| 63676 g47978 i0 85.227 1.14983713355049 88 10 28 3 221 307 5556 5471 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 353 87.9 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Watanabeales Watanabeaceae Chloroidium Chloroidium ellipsoideum
15036335 15036335 PRJNA1041773_P_NODE_70772_length_261_cov_1.186170_g70439_i0 PRJNA1041773 70772 261 1.18617 3.0959037 Trebouxiophyceae 75966 Plants Plants 80.5 1.09e-10   NTclustered gi|1169296931|gb|KY364701.1| 63676 g70439 i0 79.487 1.55938697318008 117 21 44 3 20 135 5440 5554 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 407 80.5 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Watanabeales Watanabeaceae Chloroidium Chloroidium ellipsoideum
15473567 15473567 PRJNA1041773_P_NODE_7333_length_757_cov_5.263158_g7032_i0 PRJNA1041773 7333 757 5.263158 39.84210606 Dunaliella sp. SPMO 601-1 362594 Plants Plants 147 3.39e-30   NTclustered gi|83777116|gb|DQ324038.1| 362594 g7032 i0 76.174 5.50066050198151 298 59 39 9 190 483 2296 2007 Dunaliella sp. SPMO 601-1 26S ribosomal RNA gene, partial sequence blastn 4164 147 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Dunaliellaceae Dunaliella Dunaliella sp. SPMO 601-1
18022170 18022170 PRJNA1041773_P_NODE_43455_length_322_cov_2.759036_g43122_i0 PRJNA1041773 43455 322 2.759036 8.88409592 Desmochloris halophila 138176 Plants Plants 248 3.59e-61   NTclustered gi|984294686|gb|KT390147.1| 138176 g43122 i0 80.864 1.00621118012422 324 54 99 7 1 320 1002 1321 Desmochloris halophila clone ZX14-0.2-28 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 324 248 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Ulvophyceae Chlorocystidales Chlorocystidaceae Desmochloris Desmochloris halophila
23122417 23122417 PRJNA1041773_P_NODE_31739_length_371_cov_26.583893_g31407_i0 PRJNA1041773 31739 371 26.583893 98.62624303 Picochlorum sp. 2812594 Plants Plants 656 0   NTclustered gi|2632235332|gb|OR922714.1| 2812594 g31407 i0 98.652 101.277628032345 371 4 100 1 1 371 3751 3382 Picochlorum sp. strain AGSB0128 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 37574 656 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae     Picochlorum Picochlorum sp.

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