RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA533114" and tax_phylum = "Porifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Porifera · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA533114 · 7 ✖

analysis 1

  • blastn · 7 ✖
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
1781011 1781011 PRJNA533114_P_NODE_90402_length_255_cov_1.631868_g90150_i0 PRJNA533114 90402 255 1.631868 4.1612634 Sycon ciliatum 27933 Porifera other_Eukaryota 52.8 0.023   NTclustered gi|2732927709|ref|XM_065330900.1| 27933 g90150 i0 94.118 0.266666666666667 34 2 13 0 36 69 8092 8059 PREDICTED: Sycon ciliatum E3 ubiquitin-protein ligase MYCBP2-like (LOC135817675), transcript variant X1, mRNA blastn 68 52.8 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
10709113 10709113 PRJNA533114_P_NODE_40369_length_365_cov_1.582192_g40117_i0 PRJNA533114 40369 365 1.582192 5.7750008 Amphimedon queenslandica 400682 Porifera other_Eukaryota 76.8 2.06e-9   NTclustered gi|1133473537|ref|XM_020000845.1| 400682 g40117 i0 89.831 0.161643835616438 59 6 16 0 282 340 1365 1307 PREDICTED: Amphimedon queenslandica phospholipid-transporting ATPase ID (LOC100633776), mRNA blastn 59 76.8 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
11983124 11983124 PRJNA533114_P_NODE_102350_length_248_cov_0.880000_g102098_i0 PRJNA533114 102350 248 0.88 2.1824 Suberites domuncula 55567 Porifera other_Eukaryota 167 7.679999999999999e-37   NTclustered gi|4150911|emb|Y12081.1| 55567 g102098 i0 88.889 37.2217741935484 135 15 54 0 114 248 331 197 Suberites domuncula mRNA for polyubiquitin precursor blastn 9231 167 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Suberitidae Suberites Suberites domuncula
11984161 11984161 PRJNA533114_P_NODE_63890_length_298_cov_2.168889_g63638_i0 PRJNA533114 63890 298 2.168889 6.46328922 Aiolochroia crassa 261677 Porifera other_Eukaryota 158 5.709999999999999e-34   NTclustered gi|512765256|gb|KC869494.1| 261677 g63638 i0 89.516 42.6610738255034 124 13 42 0 4 127 1211 1334 Aiolochroia crassa voucher P04 28S ribosomal RNA gene, partial sequence blastn 12713 158 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Verongiida Aplysinidae Aiolochroia Aiolochroia crassa
14533683 14533683 PRJNA533114_P_NODE_25572_length_450_cov_1.222812_g25322_i0 PRJNA533114 25572 450 1.222812 5.502654 Sycon ciliatum 27933 Porifera other_Eukaryota 340 8.309999999999999e-89   NTclustered gi|2732923042|ref|XM_065328431.1| 27933 g25322 i0 80.92 91.5733333333333 435 80 96 3 18 450 538 105 PREDICTED: Sycon ciliatum ubiquitin-ribosomal protein eS31 fusion protein (LOC135815172), mRNA blastn 41208 340 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
17082489 17082489 PRJNA533114_P_NODE_41974_length_359_cov_1.615385_g41722_i0 PRJNA533114 41974 359 1.615385 5.79923215 Amphimedon queenslandica 400682 Porifera other_Eukaryota 56.5 0.003   NTclustered gi|1133472752|ref|XM_003388929.3| 400682 g41722 i0 100 0.0835654596100279 30 0 8 0 165 194 472 501 PREDICTED: Amphimedon queenslandica uncharacterized LOC100641981 (LOC100641981), mRNA blastn 30 56.5 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
22182380 22182380 PRJNA533114_P_NODE_91658_length_253_cov_1.711111_g91406_i0 PRJNA533114 91658 253 1.711111 4.32911083 Sycon ciliatum 27933 Porifera other_Eukaryota 137 6.16e-28   NTclustered gi|2732912525|ref|XM_065323054.1| 27933 g91406 i0 80 1.83399209486166 190 34 74 4 65 252 724 911 PREDICTED: Sycon ciliatum succinyl-CoA:3-ketoacid coenzyme A transferase 1, mitochondrial-like (LOC135809651), mRNA blastn 464 137 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum

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