RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJEB43370" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 6 ✖

tax_clade 1

bioproject 1

  • PRJEB43370 · 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
1334506 1334506 PRJEB43370_P_NODE_1982_length_309_cov_1.584615_g1939_i0 PRJEB43370 1982 309 1.584615 4.89646035 Rosculus sp. 2231160 SAR_Eukaryotes SAR_Eukaryotes 466 8.7e-127   NTclustered gi|1402550476|gb|MH488762.1| 2231160 g1939 i0 93.91 58.8381877022654 312 14 100 5 1 309 1769 2078 Rosculus sp. isolate CCAC3 small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence blastn 18181 466 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus sp.
1334541 1334541 PRJEB43370_P_NODE_5042_length_201_cov_1.644737_g4999_i0 PRJEB43370 5042 201 1.644737 3.30592137 Rosculus vulgaris 2231165 SAR_Eukaryotes SAR_Eukaryotes 176 9.94e-40   NTclustered gi|1402550474|gb|MH488760.1| 2231165 g4999 i0 87.261 47.2636815920398 157 17 78 3 3 158 2216 2370 Rosculus vulgaris isolate CCA sequence blastn 9500 176 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus vulgaris
2610168 2610168 PRJEB43370_P_NODE_843_length_475_cov_1.687793_g800_i0 PRJEB43370 843 475 1.687793 8.01701675 Chlorarachniophyceae sp. P314 467060 SAR_Eukaryotes SAR_Eukaryotes 196 2.02e-45   NTclustered gi|220983378|dbj|AB453014.1| 467060 g800 i0 77.249 41.72 378 59 79 17 90 463 1471 1117 Chlorarachniophyceae sp. P314 gene for nuclear large subunit ribosomal RNA, partial sequence blastn 19817 196 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae       Chlorarachniophyceae sp. P314
3886343 3886343 PRJEB43370_P_NODE_6704_length_177_cov_1.625000_g6661_i0 PRJEB43370 6704 177 1.625 2.87625 Bodomorpha minima 188950 SAR_Eukaryotes SAR_Eukaryotes 322 1.03e-83   NTclustered gi|238617630|gb|FJ973394.1| 188950 g6661 i0 99.435 71.3559322033898 177 1 100 0 1 177 496 320 Bodomorpha minima strain ATCC 50339 actin (act) gene, partial cds blastn 12630 322 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae Bodomorpha Bodomorpha minima
17911781 17911781 PRJEB43370_P_NODE_4875_length_204_cov_1.670968_g4832_i0 PRJEB43370 4875 204 1.670968 3.40877472 Rosculus sp. 2231160 SAR_Eukaryotes SAR_Eukaryotes 294 2.68e-75   NTclustered gi|1402550476|gb|MH488762.1| 2231160 g4832 i0 96.133 16.3676470588235 181 6 88 1 23 202 3 183 Rosculus sp. isolate CCAC3 small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence blastn 3339 294 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus sp.
19185743 19185743 PRJEB43370_P_NODE_8756_length_166_cov_1.230769_g8713_i0 PRJEB43370 8756 166 1.230769 2.04307654 Rosculus vulgaris 2231165 SAR_Eukaryotes SAR_Eukaryotes 185 1.3099999999999999e-42   NTclustered gi|1402550474|gb|MH488760.1| 2231165 g8713 i0 87.5 9.52409638554217 168 12 100 8 1 166 2560 2720 Rosculus vulgaris isolate CCA sequence blastn 1581 185 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus vulgaris

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