RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA657860" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 3

tax_superkingdom 1

tax_clade 1

bioproject 1

  • PRJNA657860 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
9554014 9554014 PRJNA657860_P_NODE_3328_length_162_cov_0.824000_g3272_i0 PRJNA657860 3328 162 0.824 1.33488 Pfiesteria piscicida 71001 SAR_Eukaryotes SAR_Eukaryotes 143 7.78e-30   NTclustered gi|112253199|gb|DQ864771.1| 71001 g3272 i0 87.705 57.1666666666667 122 15 75 0 36 157 268 147 Pfiesteria piscicida clone ppi-5p-3-2 ADP-ribosylation factor mRNA, complete cds blastn 9261 143 1 Eukaryota Sar     Dinophyceae Peridiniales Pfiesteriaceae Pfiesteria Pfiesteria piscicida
11364834 11364834 PRJNA657860_P_NODE_2809_length_177_cov_1.150000_g2753_i0 PRJNA657860 2809 177 1.15 2.0355 Gomphonema 97226 SAR_Eukaryotes SAR_Eukaryotes 326 7.98e-85   NTclustered gi|357381810|gb|JN790285.1| 97227 g2753 i0 100 99.4180790960452 176 0 99 0 2 177 342 167 Gomphonema parvulum strain TCC736 18S ribosomal RNA gene, partial sequence blastn 17597 326 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Gomphonemataceae Gomphonema Gomphonema parvulum
21028000 21028000 PRJNA657860_P_NODE_797_length_371_cov_2.110778_g741_i0 PRJNA657860 797 371 2.110778 7.83098638 Placidida sp. 2810146 SAR_Eukaryotes SAR_Eukaryotes 381 3.959999999999999e-101   NTclustered gi|2048770055|gb|MT048608.1| 2810146 g741 i0 92.193 81.7762803234501 269 21 73 0 2 270 303 35 Placidida sp. strain HFCC207 heat shock protein 70 mRNA, complete cds blastn 30339 381 1 Eukaryota Sar     Bigyra Placidida     Placidida sp.
21563357 21563357 PRJNA657860_P_NODE_1677_length_245_cov_2.822115_g1621_i0 PRJNA657860 1677 245 2.822115 6.91418175 root 1 Root_unresolved Root_unresolved 56.5 0.002   NTclustered gi|84997470|ref|XM_948364.1| 5874 g1621 i0 100 0.257142857142857 30 0 12 0 101 130 352 381 Theileria annulata uncharacterized protein (TA11355), partial mRNA blastn 63 56.5 1 Eukaryota Sar   Apicomplexa Aconoidasida Piroplasmida Theileriidae Theileria Theileria annulata
22302711 22302711 PRJNA657860_P_NODE_1498_length_263_cov_1.070796_g1442_i0 PRJNA657860 1498 263 1.070796 2.81619348 Saprolegnia parasitica 101203 SAR_Eukaryotes SAR_Eukaryotes 154 6.4e-33   NTclustered gi|813163222|ref|XM_012347282.1| 695850 g1442 i0 84.277 43.5171102661597 159 23 60 2 96 253 88 245 Saprolegnia parasitica CBS 223.65 translation initiation factor eIF-5A mRNA blastn 11445 154 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia parasitica
23578099 23578099 PRJNA657860_P_NODE_2959_length_171_cov_1.641791_g2903_i0 PRJNA657860 2959 171 1.641791 2.80746261 Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 289359 SAR_Eukaryotes SAR_Eukaryotes 311 2.14e-80   NTclustered gi|53829555|gb|AY582830.1| 289359 g2903 i0 99.415 5.04093567251462 171 1 100 0 1 171 1096 926 Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 ef1a gene, partial cds blastn 862 311 1 Eukaryota Sar             Stramenopile sp. ex Nuclearia delicatula CCAP1552/1

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