RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA695140", tax_clade = "Sar" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 5 ✖

tax_clade 1

bioproject 1

  • PRJNA695140 · 5 ✖

analysis 1

tax_kingdom 0

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
5779597 5779597 PRJNA695140_S_NODE_2885_length_308_cov_4.760148_g2704_i0 PRJNA695140 2885 308 4.760148 14.66125584 Rosculus piscicus 2231164 SAR_Eukaryotes SAR_Eukaryotes 473 5.179999999999999e-129   NTclustered gi|1402550472|gb|MH488758.1| 2231164 g2704 i0 96.831 39.1883116883117 284 7 92 2 13 295 1180 898 Rosculus piscicus isolate GS5C small subunit ribosomal RNA gene, partial sequence blastn 12070 473 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus piscicus
7054718 7054718 PRJNA695140_S_NODE_4506_length_247_cov_1.852381_g4325_i0 PRJNA695140 4506 247 1.852381 4.57538107 Rosculus sp. VDelafont-2023a 3079709 SAR_Eukaryotes SAR_Eukaryotes 250 7.38e-62   NTclustered gi|2589370978|gb|OR644361.1| 3079709 g4325 i0 85.957 13.1255060728745 235 31 95 2 13 246 430 663 Rosculus sp. VDelafont-2023a isolate AJ1 small subunit ribosomal RNA gene, partial sequence blastn 3242 250 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus sp. VDelafont-2023a
9604551 9604551 PRJNA695140_S_NODE_1668_length_409_cov_4.903226_g1487_i0 PRJNA695140 1668 409 4.903226 20.05419434 Rosculus sp. VDelafont-2023a 3079709 SAR_Eukaryotes SAR_Eukaryotes 573 6.779999999999999e-159   NTclustered gi|2589370978|gb|OR644361.1| 3079709 g1487 i0 91.951 6.61124694376528 410 32 100 1 1 409 441 32 Rosculus sp. VDelafont-2023a isolate AJ1 small subunit ribosomal RNA gene, partial sequence blastn 2704 573 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus sp. VDelafont-2023a
12660906 12660906 PRJNA695140_S_NODE_12190_length_155_cov_1.627119_g12009_i0 PRJNA695140 12190 155 1.627119 2.52203445 Rosculus 373137 SAR_Eukaryotes SAR_Eukaryotes 281 1.49e-71   NTclustered gi|1002343679|gb|KU738557.1| 175275 g12009 i0 99.355 41.6 155 1 100 0 1 155 165 319 Uncultured Cercozoa clone agricultural_soil21 18S ribosomal RNA gene, partial sequence blastn 6448 281 1 Eukaryota Sar   Cercozoa         uncultured Cercozoa
24133422 24133422 PRJNA695140_S_NODE_9639_length_171_cov_1.895522_g9458_i0 PRJNA695140 9639 171 1.895522 3.24134262 Rosculus 373137 SAR_Eukaryotes SAR_Eukaryotes 110 8.38e-20   NTclustered gi|1336609552|gb|MG859939.1| 175275 g9458 i0 79.141 5.21637426900585 163 30 94 4 1 160 684 523 Uncultured Cercozoa isolate 1_map+ small subunit ribosomal RNA gene, partial sequence blastn 892 110 1 Eukaryota Sar   Cercozoa         uncultured Cercozoa

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