RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA1158727 · 7 ✖

analysis 1

  • blastn · 7 ✖
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
303882 303882 PRJNA1158727_P_NODE_136421_length_251_cov_0.865169_g128959_i0 PRJNA1158727 136421 251 0.865169 2.17157419 Volvox carteri 3067 Plants Plants 56.5 0.002   NTclustered gi|302836298|ref|XM_002949664.1| 3068 g128959 i0 100 0.119521912350598 30 0 12 0 170 199 1752 1781 Volvox carteri f. nagariensis phosphate acetyltransferase (VOLCADRAFT_117292), partial mRNA blastn 30 56.5 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Volvocaceae Volvox Volvox carteri
1037445 1037445 PRJNA1158727_P_NODE_119681_length_268_cov_0.974359_g112220_i0 PRJNA1158727 119681 268 0.974359 2.61128212 Eukaryota 2759 Plants Plants 171 6.489999999999999e-38   NTclustered gi|969822372|gb|KT950953.1| 3129 g112220 i0 80.444 49.9813432835821 225 42 84 2 1 224 517 740 Bryopsis maxima actin gene, partial cds blastn 13395 172 0.994186046511628 Eukaryota core chlorophytes Viridiplantae Chlorophyta Ulvophyceae Bryopsidales Bryopsidaceae Bryopsis Bryopsis maxima
2312669 2312669 PRJNA1158727_P_NODE_107542_length_282_cov_2.272727_g100081_i0 PRJNA1158727 107542 282 2.272727 6.40909014 Coccomyxa 41891 Plants Plants 329 1.07e-85   NTclustered gi|1360638129|gb|AC277064.1| 574566 g100081 i0 87.943 99.4255319148936 282 31 100 1 1 282 1300 1022 Coccomyxa subellipsoidea C-169 clone FAHX137-B20, complete sequence blastn 28038 329 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae   Coccomyxaceae Coccomyxa Coccomyxa subellipsoidea
10507202 10507202 PRJNA1158727_P_NODE_115729_length_272_cov_1.728643_g108268_i0 PRJNA1158727 115729 272 1.728643 4.70190896 Symbiochloris sp. 3076140 Plants Plants 503 5.729999999999998e-138   NTclustered gi|2819195128|gb|PQ456139.1| 3076140 g108268 i0 100 101.323529411765 272 0 100 0 1 272 557 828 Symbiochloris sp. voucher A160 small subunit ribosomal RNA gene, partial sequence blastn 27560 503 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Trebouxiales Trebouxiaceae Symbiochloris Symbiochloris sp.
15065486 15065486 PRJNA1158727_P_NODE_82492_length_332_cov_1.957529_g75031_i0 PRJNA1158727 82492 332 1.957529 6.49899628 Chlorophyta 3041 Plants Plants 348 3.56e-91   NTclustered gi|371782093|emb|HE610125.1| 37433 g75031 i0 85.928 99.7861445783133 334 37 100 9 1 332 4956 4631 Stichococcus bacillaris 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain SAG 379-2 blastn 33129 350 0.994285714285714 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Prasiolales Stichococcaceae Stichococcus Stichococcus bacillaris
18158693 18158693 PRJNA1158727_P_NODE_98135_length_296_cov_2.053812_g90674_i0 PRJNA1158727 98135 296 2.053812 6.07928352 Symbiochloris symbiontica 531392 Plants Plants 464 2.98e-126   NTclustered gi|922575251|gb|JQ921011.1| 531392 g90674 i0 94.949 102.831081081081 297 13 100 2 1 296 1635 1340 Dictyochloropsis symbiontica strain SAG 27.81 23S large subunit ribosomal RNA gene, partial sequence; chloroplast blastn 30438 464 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Trebouxiales Trebouxiaceae Symbiochloris Symbiochloris symbiontica
18889367 18889367 PRJNA1158727_P_NODE_94715_length_303_cov_1.673913_g87254_i0 PRJNA1158727 94715 303 1.673913 5.07195639 Marvania 97104 Plants Plants 209 1.58e-49   NTclustered gi|157060281|dbj|AB292587.1| 97105 g87254 i0 79.402 80.5115511551155 301 58 99 4 4 302 323 621 Marvania geminata gene for actin, partial cds blastn 24395 209 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Marvania Marvania geminata

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