RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA168635" 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

  • PRJNA168635 · 7 ✖

analysis 1

  • diamond · 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
28368685 28368685 PRJNA168635_P_NODE_33906_length_156_cov_3.757009_g33490_i0 PRJNA168635 33906 156 3.757009 5.86093404 Geodia barretti 519541 Porifera other_Eukaryota 41.6 0.0218   NR CAI8013506.1 519541 g33490 i0 56.8 0.711538461538462 37 16 71.2 0 8 118 2 38 CAI8013506.1 hypothetical protein GBAR_LOCUS8552, partial [Geodia barretti] diamond 111 41.6 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
28431982 28431982 PRJNA168635_P_NODE_25006_length_169_cov_1.725000_g24590_i0 PRJNA168635 25006 169 1.725 2.91525 Sycon ciliatum 27933 Porifera other_Eukaryota 51.2 1.36e-5   NR XP_065176252.1 27933 g24590 i0 61.1 0.63905325443787 36 14 63.9 0 110 3 812 847 XP_065176252.1 uncharacterized protein LOC135806045 [Sycon ciliatum] diamond 108 51.2 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
29315991 29315991 PRJNA168635_P_NODE_21709_length_177_cov_1.617188_g21293_i0 PRJNA168635 21709 177 1.617188 2.86242276 Halichondria panicea 6063 Porifera other_Eukaryota 48.9 4.17e-5   NR XP_064393480.1 6063 g21293 i0 44.4 0.915254237288136 54 29 91.5 1 172 11 58 110 XP_064393480.1 uncharacterized protein LOC135340964 [Halichondria panicea] diamond 162 48.9 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
29631457 29631457 PRJNA168635_P_NODE_6390_length_335_cov_1.468531_g5979_i0 PRJNA168635 6390 335 1.468531 4.91957885 Geodia barretti 519541 Porifera other_Eukaryota 87.8 4.72e-19   NR CAI8030757.1 519541 g5979 i0 49.6 1.01194029850746 113 44 96.7 5 331 8 46 150 CAI8030757.1 hypothetical protein GBAR_LOCUS17449 [Geodia barretti] diamond 339 87.8 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
30547812 30547812 PRJNA168635_P_NODE_31073_length_163_cov_0.912281_g30657_i0 PRJNA168635 31073 163 0.912281 1.48701803 Sycon ciliatum 27933 Porifera other_Eukaryota 49.7 4.59e-5   NR XP_065194412.1 27933 g30657 i0 52.2 0.846625766871166 46 22 84.7 0 159 22 36388 36433 XP_065194412.1 uncharacterized protein LOC135825719 [Sycon ciliatum] diamond 138 49.7 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
31369724 31369724 PRJNA168635_P_NODE_25636_length_169_cov_0.866667_g25220_i0 PRJNA168635 25636 169 0.866667 1.46466723 Geodia barretti 519541 Porifera other_Eukaryota 73.2 2.46e-13   NR CAI8035667.1 519541 g25220 i0 53.7 0.958579881656805 54 25 95.9 0 3 164 401 454 CAI8035667.1 Peroxidasin homolog pxn-2 [Geodia barretti] diamond 162 73.2 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
32697456 32697456 PRJNA168635_P_NODE_25540_length_169_cov_0.866667_g25124_i0 PRJNA168635 25540 169 0.866667 1.46466723 Corticium candelabrum 121492 Porifera other_Eukaryota 53.9 4.53e-7   NR XP_062510638.1 121492 g25124 i0 63.9 0.63905325443787 36 13 63.9 0 169 62 76 111 XP_062510638.1 uncharacterized protein K02A2.6-like isoform X2 [Corticium candelabrum] diamond 108 53.9 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum

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