RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA270367" and tax_phylum = "Porifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Porifera · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA270367 · 4 ✖

analysis 1

  • blastn · 4 ✖
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
370215 370215 PRJNA270367_P_NODE_5241_length_597_cov_1.324818_g5050_i0 PRJNA270367 5241 597 1.324818 7.90916346 Amphimedon queenslandica 400682 Porifera other_Eukaryota 73.1 4.53e-8   NTclustered gi|1133472263|ref|XM_003388820.3| 400682 g5050 i0 75.325 0.323283082077052 154 36 26 2 161 313 540 692 PREDICTED: Amphimedon queenslandica pro-cathepsin H-like (LOC100636590), mRNA blastn 193 73.1 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
370218 370218 PRJNA270367_P_NODE_5461_length_586_cov_1.662942_g5269_i0 PRJNA270367 5461 586 1.662942 9.74484012 Corticium candelabrum 121492 Porifera other_Eukaryota 100 2.04e-16   NTclustered gi|2664244603|ref|XM_062662384.1| 121492 g5269 i0 80.851 1.84129692832765 141 15 26 6 393 533 396 524 PREDICTED: Corticium candelabrum uncharacterized LOC134193559 (LOC134193559), mRNA blastn 1079 100 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
11848684 11848684 PRJNA270367_P_NODE_30930_length_200_cov_0.827815_g30725_i0 PRJNA270367 30930 200 0.827815 1.65563 Sycon ciliatum 27933 Porifera other_Eukaryota 110 1.02e-19   NTclustered gi|457867034|emb|HF570311.1| 27933 g30725 i0 91.358 1.615 81 6 40 1 1 80 270 350 Sycon ciliatum mRNA for 40S ribosomal protein S2 (rps12 gene) blastn 323 110 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
13123834 13123834 PRJNA270367_P_NODE_27711_length_215_cov_0.969880_g27506_i0 PRJNA270367 27711 215 0.96988 2.085242 Sycon ciliatum 27933 Porifera other_Eukaryota 87.9 5.2e-13   NTclustered gi|2732919393|ref|XM_065326533.1| 27933 g27506 i0 85.542 1.49302325581395 83 12 39 0 60 142 215 133 PREDICTED: Sycon ciliatum small ribosomal subunit protein eS7-like (LOC135813436), mRNA blastn 321 87.9 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);;