RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA608894" and tax_phylum = "Porifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Porifera · 13 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA608894 · 13 ✖

analysis 1

  • diamond · 13 ✖
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
10789414 10789414 PRJNA608894_P_NODE_23809_length_397_cov_2.496914_g23312_i0 PRJNA608894 23809 397 2.496914 9.91274858 Corticium candelabrum 121492 Porifera other_Eukaryota 151 2.19e-44   NR XP_062513731.1 121492 g23312 i0 67 0.869017632241814 115 38 86.9 0 345 1 2 116 XP_062513731.1 large ribosomal subunit protein eL31-like [Corticium candelabrum] diamond 345 151 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
14614549 14614549 PRJNA608894_P_NODE_43752_length_270_cov_1.340102_g43253_i0 PRJNA608894 43752 270 1.340102 3.6182754 Metazoa 33208 Porifera other_Eukaryota 149 4.799999999999998e-41   NR CAI8023266.1 519541 g43253 i0 80.5 91.2888888888889 87 17 96.7 0 8 268 77 163 CAI8023266.1 Serine/threonine-protein phosphatase alpha-1 isoform [Geodia barretti] diamond 24648 149 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
26903573 26903573 PRJNA608894_P_NODE_55261_length_246_cov_0.890173_g54762_i0 PRJNA608894 55261 246 0.890173 2.18982558 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 112 4.15e-28   NR XP_065889150.1 196820 g54762 i0 61.7 9.76829268292683 81 31 98.8 0 2 244 23 103 XP_065889150.1 RNA-binding motif protein, X-linked 2-like [Dysidea avara] diamond 2403 112 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
27251293 27251293 PRJNA608894_P_NODE_18303_length_488_cov_2.742169_g17807_i0 PRJNA608894 18303 488 2.742169 13.38178472 Metazoa 33208 Porifera other_Eukaryota 74.3 2.56e-12   NR KAI6649628.1 111878 g17807 i0 35 4.07581967213115 163 94 99.6 5 3 488 40 191 KAI6649628.1 Cathepsin L [Oopsacas minuta] diamond 1989 74.7 0.994645247657296 Eukaryota Opisthokonta Metazoa Porifera Hexactinellida Lyssacinosida Leucopsacidae Oopsacas Oopsacas minuta
28356436 28356436 PRJNA608894_P_NODE_60266_length_241_cov_0.916667_g59767_i0 PRJNA608894 60266 241 0.916667 2.20916747 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 72.4 1.27e-12   NR CAB59634.1 55567 g59767 i0 50 5.07883817427386 64 31 78.4 1 2 190 206 269 CAB59634.1 Ca2+/calmodulin-dependent protein kinase II [Suberites domuncula] diamond 1224 72.8 0.994505494505495 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Suberitidae Suberites Suberites domuncula
28785266 28785266 PRJNA608894_P_NODE_42547_length_274_cov_1.532338_g42048_i0 PRJNA608894 42547 274 1.532338 4.19860612 Sycon ciliatum 27933 Porifera other_Eukaryota 78.6 2.55e-16   NR XP_065181103.1 27933 g42048 i0 47.8 1.00729927007299 92 40 99.6 3 2 274 9 93 XP_065181103.1 thioredoxin domain-containing protein 17-like [Sycon ciliatum] diamond 276 78.6 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
29335365 29335365 PRJNA608894_P_NODE_20229_length_452_cov_4.926121_g19733_i0 PRJNA608894 20229 452 4.926121 22.26606692 Opisthokonta 33154 Porifera other_Eukaryota 77 3.17e-14   NR XP_065828546.1 121494 g19733 i0 48.8 9.29867256637168 80 36 53.1 2 6 245 63 137 XP_065828546.1 H/ACA ribonucleoprotein complex subunit 1-like [Oscarella lobularis] diamond 4203 77 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
29353926 29353926 PRJNA608894_P_NODE_8549_length_905_cov_5.347356_g8129_i0 PRJNA608894 8549 905 5.3473560000000004 48.3935718 Geodia barretti 519541 Porifera other_Eukaryota 143 4.93e-38   NR CAI8030757.1 519541 g8129 i0 50.6 0.550276243093923 166 67 52.7 6 297 773 18 175 CAI8030757.1 hypothetical protein GBAR_LOCUS17449 [Geodia barretti] diamond 498 143 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
30156186 30156186 PRJNA608894_P_NODE_31032_length_328_cov_0.905882_g30533_i0 PRJNA608894 31032 328 0.905882 2.97129296 Metazoa 33208 Porifera other_Eukaryota 79.7 9.53e-15   NR XP_062503731.1 121492 g30533 i0 48.3 6.59451219512195 89 44 79.6 1 58 318 124 212 XP_062503731.1 solute carrier family 35 member F6-like isoform X4 [Corticium candelabrum] diamond 2163 79.7 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
30459698 30459698 PRJNA608894_P_NODE_36013_length_300_cov_1.889868_g35514_i0 PRJNA608894 36013 300 1.889868 5.669604 Sycon ciliatum 27933 Porifera other_Eukaryota 67.4 1.56e-10   NR XP_065197523.1 27933 g35514 i0 38.6 2.69 88 54 88 0 12 275 550 637 XP_065197523.1 choline transporter-like protein 4 [Sycon ciliatum] diamond 807 67.4 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
31230544 31230544 PRJNA608894_P_NODE_48415_length_255_cov_1.274725_g47916_i0 PRJNA608894 48415 255 1.274725 3.25054875 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 123 2.15e-30   NR XP_065910049.1 196820 g47916 i0 66.3 4.87058823529412 83 28 97.6 0 6 254 369 451 XP_065910049.1 protein DD3-3-like [Dysidea avara] diamond 1242 123 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
32496283 32496283 PRJNA608894_P_NODE_32579_length_317_cov_2.528689_g32080_i0 PRJNA608894 32579 317 2.528689 8.01594413 Amphimedon 178513 Porifera other_Eukaryota 119 3.5899999999999998e-31   NR AFJ64431.1 178514 g32080 i0 68.4 2.24290220820189 79 25 74.8 0 8 244 53 131 AFJ64431.1 aldolase, partial [Amphimedon compressa] diamond 711 120 0.991666666666667 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon compressa
32528009 32528009 PRJNA608894_P_NODE_52039_length_249_cov_0.875000_g51540_i0 PRJNA608894 52039 249 0.875 2.17875 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 46.2 0.00231   NR XP_062523018.1 121492 g51540 i0 33.7 2.18072289156627 83 51 97.6 3 6 248 19 99 XP_062523018.1 WD repeat-containing protein 26 homolog [Corticium candelabrum] diamond 543 46.6 0.991416309012876 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);;