RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA879067 · 5 ✖

analysis 1

  • blastn · 5 ✖
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
6342987 6342987 PRJNA879067_P_NODE_42745_length_593_cov_2.215385_g39286_i0 PRJNA879067 42745 593 2.215385 13.13723305 Coccomyxa 41891 Plants Plants 645 2.1199999999999998e-180   NTclustered gi|1601875646|gb|MK694759.1| 2315456 g39286 i0 87.434 89.9814502529511 565 65 95 5 6 567 3894 4455 Coccomyxa sp. Obi 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 53359 645 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae   Coccomyxaceae Coccomyxa Coccomyxa sp. Obi
10167923 10167923 PRJNA879067_P_NODE_91748_length_292_cov_1.273973_g88262_i0 PRJNA879067 91748 292 1.273973 3.72000116 Chlorophyta 3041 Plants Plants 508 1.34e-139   NTclustered gi|1669402958|gb|MK975490.1| 77546 g88262 i0 100 94.777397260274 275 0 94 0 1 275 567 293 Scenedesmus vacuolatus strain SAG 211-8e 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 27675 508 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Sphaeropleales Scenedesmaceae Scenedesmus Scenedesmus vacuolatus
13609923 13609923 PRJNA879067_P_NODE_87051_length_310_cov_1.299578_g83565_i0 PRJNA879067 87051 310 1.299578 4.0286918 Myrmecia sp. (in: green algae) 2897817 Plants Plants 529 1.0999999999999996e-145   NTclustered gi|2644500051|gb|PP079689.1| 2897817 g83565 i0 100 92.6709677419355 286 0 92 0 25 310 662 947 Myrmecia sp. (in: green algae) isolate C4 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 28728 529 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Trebouxiales Trebouxiaceae Myrmecia Myrmecia sp. (in: green algae)
17434324 17434324 PRJNA879067_P_NODE_81454_length_333_cov_1.080769_g77968_i0 PRJNA879067 81454 333 1.080769 3.59896077 Lobosphaera incisa 312850 Plants Plants 544 4.25e-150   NTclustered gi|725539263|gb|KM821265.1| 312850 g77968 i0 99.01 31.1201201201201 303 3 91 0 1 303 138416 138718 Lobosphaera incisa chloroplast, complete genome blastn 10363 544 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Trebouxiales Trebouxiaceae Lobosphaera Lobosphaera incisa
20365411 20365411 PRJNA879067_P_NODE_55996_length_478_cov_1.649383_g52511_i0 PRJNA879067 55996 478 1.649383 7.88405074 Chlorellales 35460 Plants Plants 459 2.35e-124   NTclustered gi|1360638129|gb|AC277064.1| 574566 g52511 i0 84.232 100.864016736402 482 64 100 11 1 478 2607 3080 Coccomyxa subellipsoidea C-169 clone FAHX137-B20, complete sequence blastn 48213 459 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae   Coccomyxaceae Coccomyxa Coccomyxa subellipsoidea

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