RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "blastn", bioproject = "PRJNA1180292" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • Sar · 15 ✖

bioproject 1

  • PRJNA1180292 · 15 ✖

analysis 1

  • blastn · 15 ✖

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
4144746 4144746 PRJNA1180292_P_NODE_11884_length_244_cov_0.912281_g11752_i0 PRJNA1180292 11884 244 0.912281 2.22596564 Phytophthora infestans 4787 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.022   NTclustered gi|301095059|ref|XM_002896586.1| 403677 g11752 i0 96.774 0.127049180327869 31 1 13 0 206 236 182 152 Phytophthora infestans T30-4 uncharacterized protein (PITG_17785), partial mRNA blastn 31 52.8 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora infestans
6695783 6695783 PRJNA1180292_P_NODE_7406_length_259_cov_3.516129_g7274_i0 PRJNA1180292 7406 259 3.516129 9.10677411 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 409 1.22e-109   NTclustered gi|146762526|gb|EF553458.1| 2850 g7274 i0 95.038 98.9227799227799 262 10 100 3 1 259 4328 4067 Phaeodactylum tricornutum strain CCAP 1055/1 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 25621 409 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
9245749 9245749 PRJNA1180292_P_NODE_3748_length_354_cov_1.580071_g3616_i0 PRJNA1180292 3748 354 1.580071 5.59345134 Arachnula sp. CL22 862246 SAR_Eukaryotes SAR_Eukaryotes 209 1.88e-49   NTclustered gi|301014696|gb|GQ377694.1| 862246 g3616 i0 88.889 34.9350282485876 171 17 48 2 3 172 184 15 Arachnula sp. CL22 ribosomal protein S23a (rps23a) mRNA, partial cds blastn 12367 209 1 Eukaryota Sar   Endomyxa   Vampyrellida Leptophryidae Arachnula Arachnula sp. CL22
11796508 11796508 PRJNA1180292_P_NODE_5310_length_302_cov_2.187773_g5178_i0 PRJNA1180292 5310 302 2.187773 6.60707446 Plasmodium vinckei 5860 SAR_Eukaryotes SAR_Eukaryotes 250 9.29e-62   NTclustered gi|669195261|ref|XM_008624420.1| 54757 g5178 i0 82.979 55.2218543046358 282 42 92 6 2 280 853 1131 Plasmodium vinckei vinckei actin II, putative (PVVCY_1406140), partial mRNA blastn 16677 250 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium vinckei
11796553 11796553 PRJNA1180292_P_NODE_9370_length_250_cov_0.881356_g9238_i0 PRJNA1180292 9370 250 0.881356 2.20339 Oxytricha sp. LPJ-2005 329142 SAR_Eukaryotes SAR_Eukaryotes 372 1.53e-98   NTclustered gi|67462291|gb|DQ062087.1| 329142 g9238 i0 93.6 99.06 250 15 100 1 1 250 793 545 Oxytricha sp. LPJ-2005 heat shock protein 70 mRNA, partial cds; macronuclear blastn 24765 372 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Oxytricha Oxytricha sp. LPJ-2005
13071526 13071526 PRJNA1180292_P_NODE_7871_length_253_cov_0.866667_g7739_i0 PRJNA1180292 7871 253 0.866667 2.19266751 Saprolegnia diclina 112098 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.023   NTclustered gi|669166087|ref|XM_008620384.1| 1156394 g7739 i0 100 0.110671936758893 28 0 11 0 119 146 2518 2491 Saprolegnia diclina VS20 hypothetical protein mRNA blastn 28 52.8 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia diclina
13794618 13794618 PRJNA1180292_P_NODE_931_length_725_cov_4.070552_g804_i0 PRJNA1180292 931 725 4.070552 29.511502 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 1254 0   NTclustered gi|2444483125|gb|OP718169.1| 97227 g804 i0 97.931 198.085517241379 725 13 100 2 1 725 72944 72222 Gomphonema parvulum chloroplast, complete genome blastn 143612 1260 0.995238095238095 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Gomphonemataceae Gomphonema Gomphonema parvulum
15620677 15620677 PRJNA1180292_P_NODE_7053_length_266_cov_1.233161_g6921_i0 PRJNA1180292 7053 266 1.233161 3.28020826 Gastrocirrhus monilifer 402891 SAR_Eukaryotes SAR_Eukaryotes 69.4 2.42e-7   NTclustered gi|759083525|gb|KM222142.1| 402891 g6921 i0 73.558 1.21804511278195 208 43 76 12 3 204 1718 1517 Gastrocirrhus monilifer voucher CXM08100701 large subunit ribosomal RNA gene, partial sequence blastn 324 69.4 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Gastrocirrhidae Gastrocirrhus Gastrocirrhus monilifer
16894966 16894966 PRJNA1180292_P_NODE_2274_length_451_cov_3.695767_g2142_i0 PRJNA1180292 2274 451 3.695767 16.66790917 Psammothidium abundans 1912075 SAR_Eukaryotes SAR_Eukaryotes 717 0   NTclustered gi|1090888722|gb|KU565395.1| 1912075 g2142 i0 96.339 93.7627494456763 437 15 97 1 1 436 26 462 Psammothidium abundans voucher MIC5_40b 28S ribosomal RNA gene, partial sequence blastn 42287 717 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cocconeidales Achnanthidiaceae Psammothidium Psammothidium abundans
16895001 16895001 PRJNA1180292_P_NODE_5794_length_290_cov_1.110599_g5662_i0 PRJNA1180292 5794 290 1.110599 3.2207371 Babesia ovata 189622 SAR_Eukaryotes SAR_Eukaryotes 165 3.31e-36   NTclustered gi|1624694795|ref|XM_029012269.1| 189622 g5662 i0 80.083 21.8793103448276 241 33 81 9 32 266 139 370 Babesia ovata 60S ribosomal protein L44 (BOVATA_033520), partial mRNA blastn 6345 165 1 Eukaryota Sar   Apicomplexa Aconoidasida Piroplasmida Babesiidae Babesia Babesia ovata
18892723 18892723 PRJNA1180292_P_NODE_10075_length_248_cov_0.891429_g9943_i0 PRJNA1180292 10075 248 0.891429 2.21074392 Blastocystis 12967 SAR_Eukaryotes SAR_Eukaryotes 183 7.62e-42   NTclustered gi|1102131323|gb|KU900237.1| 944208 g9943 i0 84.865 67.2862903225806 185 25 74 3 45 228 3799 3617 Blastocystis sp. subtype 6 strain SSI:754 mitochondrion, complete genome blastn 16687 183 1 Eukaryota Sar     Bigyra Opalinata Blastocystidae Blastocystis Blastocystis sp. subtype 6
20719250 20719250 PRJNA1180292_P_NODE_6817_length_270_cov_1.319797_g6685_i0 PRJNA1180292 6817 270 1.319797 3.5634519 Euplotes eurystomus 5941 SAR_Eukaryotes SAR_Eukaryotes 191 5.03e-44   NTclustered gi|159037|gb|M57231.1|EUPUBQP 5941 g6685 i0 88.961 69.4185185185185 154 17 57 0 117 270 852 699 Euplotes eurystomus macronuclear polyubiquitin, complete cds blastn 18743 191 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Euplotes Euplotes eurystomus
21994487 21994487 PRJNA1180292_P_NODE_11298_length_246_cov_0.901734_g11166_i0 PRJNA1180292 11298 246 0.901734 2.21826564 Saprolegnia parasitica 101203 SAR_Eukaryotes SAR_Eukaryotes 139 1.66e-28   NTclustered gi|813142308|ref|XM_012343858.1| 695850 g11166 i0 92 2.55284552845528 100 7 41 1 4 103 890 988 Saprolegnia parasitica CBS 223.65 aspartate carbamoyltransferase mRNA blastn 628 139 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia parasitica
21994570 21994570 PRJNA1180292_P_NODE_6798_length_270_cov_1.786802_g6666_i0 PRJNA1180292 6798 270 1.786802 4.8243654 Phytophthora infestans 4787 SAR_Eukaryotes SAR_Eukaryotes 187 6.4999999999999984e-43   NTclustered gi|2661441985|ref|XR_009934438.1| 403677 g6666 i0 94.355 45.9333333333333 124 4 46 3 55 178 1292 1412 Phytophthora infestans T30-4 28S ribosomal RNA (PITG_33044), partial rRNA blastn 12402 187 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora infestans
23270030 23270030 PRJNA1180292_P_NODE_4299_length_334_cov_0.892720_g4167_i0 PRJNA1180292 4299 334 0.89272 2.9816848 Euplotes eurystomus 5941 SAR_Eukaryotes SAR_Eukaryotes 202 2.95e-47   NTclustered gi|1209311|gb|L15292.1|EUPHSP70B 5941 g4167 i0 82.353 18.8233532934132 238 37 71 5 29 264 317 83 Euplotes eurystomus macronuclear heat shock protein (hsp1a) gene, complete cds and promoters blastn 6287 202 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Euplotes Euplotes eurystomus

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