RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA1193541" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_clade 1

bioproject 1

  • PRJNA1193541 · 5 ✖

analysis 1

  • blastn · 5 ✖

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
7973889 7973889 PRJNA1193541_P_NODE_14567_length_243_cov_0.905882_g14429_i0 PRJNA1193541 14567 243 0.905882 2.20129326 Albugo laibachii 653948 SAR_Eukaryotes SAR_Eukaryotes 309 1.1800000000000002e-79   NTclustered gi|325194686|emb|FR825496.1| 890382 g14429 i0 90.535 3.05349794238683 243 9 98 8 2 240 433 665 Albugo laibachii Nc14, genomic contig CONTIG_2367_NC14_v4_847_123 blastn 742 309 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo laibachii
20722038 20722038 PRJNA1193541_P_NODE_4797_length_382_cov_9.656958_g4659_i0 PRJNA1193541 4797 382 9.656958 36.88957956 Albugo laibachii 653948 SAR_Eukaryotes SAR_Eukaryotes 678 0   NTclustered gi|325194239|emb|FR825095.1| 890382 g4659 i0 98.691 100.701570680628 382 5 100 0 1 382 1283 902 Albugo laibachii Nc14, genomic contig CONTIG_1625_NC14_v4_1818_619 blastn 38468 678 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo laibachii
21997420 21997420 PRJNA1193541_P_NODE_6118_length_347_cov_9.510949_g5980_i0 PRJNA1193541 6118 347 9.510949 33.00299303 Albugo laibachii 653948 SAR_Eukaryotes SAR_Eukaryotes 636 7.13e-178   NTclustered gi|325195057|emb|FR825852.1| 890382 g5980 i0 99.712 95.1700288184438 347 1 100 0 1 347 502 156 Albugo laibachii Nc14, genomic contig CONTIG_2891_NC14_v4_540_391 blastn 33024 636 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo laibachii
21997432 21997432 PRJNA1193541_P_NODE_6638_length_337_cov_1.037879_g6500_i0 PRJNA1193541 6638 337 1.037879 3.49765223 Albugo laibachii 653948 SAR_Eukaryotes SAR_Eukaryotes 353 7.79e-93   NTclustered gi|325195007|emb|FR825804.1| 890382 g6500 i0 85.63 73.6023738872404 341 44 100 5 1 337 101 440 Albugo laibachii Nc14, genomic contig CONTIG_2836_NC14_v4_563_215 blastn 24804 353 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo laibachii
23994525 23994525 PRJNA1193541_P_NODE_14719_length_242_cov_0.911243_g14581_i0 PRJNA1193541 14719 242 0.911243 2.20520806 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 414 2.41e-111   NTclustered gi|1915673018|emb|LR866631.1| 175275 g14581 i0 97.521 92.9834710743802 242 6 100 0 1 242 68 309 uncultured Cercozoa partial 18S rRNA gene blastn 22502 414 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);;