RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where bioproject = "PRJNA781196", tax_kingdom = "Metazoa" and tax_phylum = "Porifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Porifera · 19 ✖

tax_kingdom 1

  • Metazoa · 19 ✖

tax_clade 1

bioproject 1

  • PRJNA781196 · 19 ✖

analysis 1

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
759630 759630 PRJNA781196_P_NODE_6181_length_624_cov_2.339383_g5812_i0 PRJNA781196 6181 624 2.339383 14.59774992 Geodia barretti 519541 Porifera other_Eukaryota 259 1.14e-84   NR CAI8032315.1 519541 g5812 i0 65.7 4.91346153846154 204 65 96.6 2 6 608 1 202 CAI8032315.1 40S ribosomal protein S8 [Geodia barretti] diamond 3066 259 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
4587917 4587917 PRJNA781196_P_NODE_5944_length_636_cov_2.685613_g5576_i0 PRJNA781196 5944 636 2.685613 17.08049868 Porifera 6040 Porifera other_Eukaryota 271 3.2e-89   NR XP_065908390.1 196820 g5576 i0 67.2 4.27358490566038 186 61 87.7 0 636 79 5 190 XP_065908390.1 large ribosomal subunit protein uL13-like [Dysidea avara] diamond 2718 273 0.992673992673993 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
8412138 8412138 PRJNA781196_P_NODE_18627_length_388_cov_3.790476_g18250_i0 PRJNA781196 18627 388 3.790476 14.70704688 Geodia barretti 519541 Porifera other_Eukaryota 195 1.3000000000000002e-60   NR CAI8032315.1 519541 g18250 i0 76.2 0.974226804123711 126 30 97.4 0 11 388 1 126 CAI8032315.1 40S ribosomal protein S8 [Geodia barretti] diamond 378 195 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
8412860 8412860 PRJNA781196_P_NODE_7307_length_579_cov_2.035573_g6933_i0 PRJNA781196 7307 579 2.035573 11.78596767 Opisthokonta 33154 Porifera other_Eukaryota 262 6.590000000000001e-85   NR XP_064395651.1 6063 g6933 i0 67.9 11.7823834196891 190 57 98.4 1 578 9 41 226 XP_064395651.1 large ribosomal subunit protein uL18 [Halichondria panicea] diamond 6822 263 0.996197718631179 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
16061535 16061535 PRJNA781196_P_NODE_19473_length_381_cov_3.038961_g19096_i0 PRJNA781196 19473 381 3.038961 11.57844141 Oscarella lobularis 121494 Porifera other_Eukaryota 199 2.81e-63   NR XP_065826293.1 121494 g19096 i0 79.3 30.488188976378 121 25 95.3 0 18 380 1 121 XP_065826293.1 small ribosomal subunit protein uS8 [Oscarella lobularis] diamond 11616 199 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
16062265 16062265 PRJNA781196_P_NODE_68293_length_210_cov_4.722628_g67916_i0 PRJNA781196 68293 210 4.722628 9.9175188 Amphimedon queenslandica 400682 Porifera other_Eukaryota 117 1.55e-30   NR XP_003385674.1 400682 g67916 i0 84.1 4.42857142857143 63 10 90 0 190 2 1 63 XP_003385674.1 PREDICTED: 60S ribosomal protein L8-like [Amphimedon queenslandica] diamond 930 117 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
17337340 17337340 PRJNA781196_P_NODE_24714_length_346_cov_1.948718_g24337_i0 PRJNA781196 24714 346 1.948718 6.74256428 Geodia barretti 519541 Porifera other_Eukaryota 145 3.76e-41   NR CAI8032315.1 519541 g24337 i0 73.4 0.815028901734104 94 25 81.5 0 344 63 42 135 CAI8032315.1 40S ribosomal protein S8 [Geodia barretti] diamond 282 145 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
26990002 26990002 PRJNA781196_P_NODE_46102_length_264_cov_1.204188_g45725_i0 PRJNA781196 46102 264 1.204188 3.17905632 Oscarella lobularis 121494 Porifera other_Eukaryota 93.6 1.11e-20   NR XP_065836094.1 121494 g45725 i0 48.3 0.988636363636364 87 44 98.9 1 263 3 128 213 XP_065836094.1 NADH-cytochrome b5 reductase 3-like [Oscarella lobularis] diamond 261 93.6 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
27811864 27811864 PRJNA781196_P_NODE_67344_length_242_cov_0.911243_g66967_i0 PRJNA781196 67344 242 0.911243 2.20520806 Corticium candelabrum 121492 Porifera other_Eukaryota 87.8 4.91e-18   NR XP_062503312.1 121492 g66967 i0 48.8 0.991735537190083 80 39 97.9 2 240 4 162 240 XP_062503312.1 uncharacterized protein LOC134180224 [Corticium candelabrum] diamond 240 87.8 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
28190298 28190298 PRJNA781196_P_NODE_50066_length_253_cov_0.866667_g49689_i0 PRJNA781196 50066 253 0.866667 2.19266751 Oopsacas minuta 111878 Porifera other_Eukaryota 46.2 0.00126   NR KAI6659865.1 111878 g49689 i0 71.4 0.33201581027668 28 8 33.2 0 91 8 127 154 KAI6659865.1 Transposase [Oopsacas minuta] diamond 84 46.2 1 Eukaryota Opisthokonta Metazoa Porifera Hexactinellida Lyssacinosida Leucopsacidae Oopsacas Oopsacas minuta
28221889 28221889 PRJNA781196_P_NODE_20946_length_370_cov_1.902357_g20569_i0 PRJNA781196 20946 370 1.902357 7.0387209 Oopsacas minuta 111878 Porifera other_Eukaryota 76.6 2.26e-13   NR KAI6660002.1 111878 g20569 i0 52.4 1.07837837837838 63 26 51.1 2 336 148 546 604 KAI6660002.1 hypothetical protein LOD99_14343 [Oopsacas minuta] diamond 399 76.6 1 Eukaryota Opisthokonta Metazoa Porifera Hexactinellida Lyssacinosida Leucopsacidae Oopsacas Oopsacas minuta
28389282 28389282 PRJNA781196_P_NODE_10686_length_492_cov_1.112172_g10310_i0 PRJNA781196 10686 492 1.112172 5.47188624 Porifera 6040 Porifera other_Eukaryota 95.1 3.27e-19   NR KAI6660002.1 111878 g10310 i0 41.5 4.70731707317073 118 61 71.3 3 471 121 41 151 KAI6660002.1 hypothetical protein LOD99_14343 [Oopsacas minuta] diamond 2316 95.1 1 Eukaryota Opisthokonta Metazoa Porifera Hexactinellida Lyssacinosida Leucopsacidae Oopsacas Oopsacas minuta
28727321 28727321 PRJNA781196_P_NODE_44667_length_268_cov_1.200000_g44290_i0 PRJNA781196 44667 268 1.2 3.216 Dysidea avara 196820 Porifera other_Eukaryota 142 2.43e-40   NR XP_065898136.1 196820 g44290 i0 79.8 1.99253731343284 89 16 99.6 1 2 268 18 104 XP_065898136.1 small ribosomal subunit protein eS8-like [Dysidea avara] diamond 534 142 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
29999867 29999867 PRJNA781196_P_NODE_35031_length_299_cov_2.508850_g34654_i0 PRJNA781196 35031 299 2.50885 7.5014615 Opisthokonta 33154 Porifera other_Eukaryota 80.1 2.45e-16   NR XP_065188076.1 27933 g34654 i0 44.1 4.89632107023411 102 47 92.3 2 278 3 1 102 XP_065188076.1 translationally-controlled tumor protein homolog [Sycon ciliatum] diamond 1464 80.1 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
30843531 30843531 PRJNA781196_P_NODE_64414_length_243_cov_1.835294_g64037_i0 PRJNA781196 64414 243 1.835294 4.45976442 Sycon ciliatum 27933 Porifera other_Eukaryota 68.6 2.92e-11   NR XP_065181159.1 27933 g64037 i0 60.3 2.23456790123457 58 22 70.4 1 172 2 352 409 XP_065181159.1 protein disulfide-isomerase A5-like [Sycon ciliatum] diamond 543 68.6 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
30874959 30874959 PRJNA781196_P_NODE_21774_length_365_cov_1.068493_g21397_i0 PRJNA781196 21774 365 1.068493 3.89999945 Dysidea avara 196820 Porifera other_Eukaryota 120 4.68e-29   NR XP_065907426.1 196820 g21397 i0 47.5 1.98904109589041 122 61 97.8 2 358 2 259 380 XP_065907426.1 uncharacterized protein [Dysidea avara] diamond 726 120 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
30938352 30938352 PRJNA781196_P_NODE_51214_length_252_cov_1.307263_g50837_i0 PRJNA781196 51214 252 1.307263 3.29430276 Sycon ciliatum 27933 Porifera other_Eukaryota 69.3 3.99e-12   NR XP_065178541.1 27933 g50837 i0 58.6 1.57142857142857 70 20 72.6 2 70 252 86 155 XP_065178541.1 large ribosomal subunit protein eL13-like [Sycon ciliatum] diamond 396 69.3 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
31222371 31222371 PRJNA781196_P_NODE_67455_length_241_cov_2.119048_g67078_i0 PRJNA781196 67455 241 2.119048 5.10690568 Amphimedon queenslandica 400682 Porifera other_Eukaryota 96.3 3.46e-21   NR XP_003384463.2 400682 g67078 i0 55 0.995850622406639 80 33 99.6 1 1 240 341 417 XP_003384463.2 PREDICTED: uncharacterized protein LOC100639221 [Amphimedon queenslandica] diamond 240 96.3 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
32718157 32718157 PRJNA781196_P_NODE_43060_length_273_cov_1.265000_g42683_i0 PRJNA781196 43060 273 1.265 3.45345 Porifera 6040 Porifera other_Eukaryota 162 1.93e-48   NR XP_065908390.1 196820 g42683 i0 80.2 2.96703296703297 91 18 100 0 273 1 3 93 XP_065908390.1 large ribosomal subunit protein uL13-like [Dysidea avara] diamond 810 163 0.993865030674847 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara

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