RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA1186363" and tax_phylum = "Porifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Porifera · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1186363 · 6 ✖

analysis 1

  • blastn · 6 ✖
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
1594358 1594358 PRJNA1186363_P_NODE_20382_length_419_cov_0.982659_g19494_i0 PRJNA1186363 20382 419 0.982659 4.11734121 Oscarella lobularis 121494 Porifera other_Eukaryota 52.8 0.04   NTclustered gi|2746759079|ref|XM_065983510.1| 121494 g19494 i0 100 0.334128878281623 28 0 7 0 219 246 4619 4646 PREDICTED: Oscarella lobularis uncharacterized protein (LOC136194408), transcript variant X1, mRNA blastn 140 52.8 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
5422879 5422879 PRJNA1186363_P_NODE_32085_length_299_cov_1.256637_g31197_i0 PRJNA1186363 32085 299 1.256637 3.75734463 Sycon ciliatum 27933 Porifera other_Eukaryota 60.2 1.66e-4   NTclustered gi|2732893469|ref|XM_065343158.1| 27933 g31197 i0 97.143 0.852842809364548 35 1 12 0 67 101 2719 2685 PREDICTED: Sycon ciliatum adenylate kinase 9-like (LOC135830932), mRNA blastn 255 60.2 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
7419861 7419861 PRJNA1186363_P_NODE_13906_length_537_cov_2.340517_g13022_i0 PRJNA1186363 13906 537 2.340517 12.56857629 Demospongiae 6042 Porifera other_Eukaryota 180 2.32e-40   NTclustered gi|2719038895|ref|XR_010393624.1| 6063 g13022 i0 94.118 22.096834264432 119 5 22 2 332 449 2045 2162 PREDICTED: Halichondria panicea large subunit ribosomal RNA (LOC135332780), rRNA blastn 11866 180 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
9247520 9247520 PRJNA1186363_P_NODE_11428_length_606_cov_2.401501_g10546_i0 PRJNA1186363 11428 606 2.401501 14.55309606 Oscarella lobularis 121494 Porifera other_Eukaryota 309 3.23e-79   NTclustered gi|2746767013|ref|XM_065987475.1| 121494 g10546 i0 81.793 21.1369636963696 368 67 61 0 2 369 491 124 PREDICTED: Oscarella lobularis 26S proteasome non-ATPase regulatory subunit 14 (LOC136197661), mRNA blastn 12809 309 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
15622567 15622567 PRJNA1186363_P_NODE_38333_length_253_cov_0.866667_g37445_i0 PRJNA1186363 38333 253 0.866667 2.19266751 Corticium candelabrum 121492 Porifera other_Eukaryota 111 3.73e-20   NTclustered gi|2664285761|ref|XM_062646238.1| 121492 g37445 i0 77 0.790513833992095 200 43 78 3 31 228 1066 868 PREDICTED: Corticium candelabrum dihydrolipoyllysine-residue succinyltransferase component of 2-oxoglutarate dehydrogenase complex, mitochondrial-like (LOC134179367), mRNA blastn 200 111 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
23271881 23271881 PRJNA1186363_P_NODE_22359_length_393_cov_1.218750_g21471_i0 PRJNA1186363 22359 393 1.21875 4.7896875 Sycon ciliatum 27933 Porifera other_Eukaryota 56.5 0.003   NTclustered gi|2732917427|ref|XM_065325524.1| 27933 g21471 i0 96.97 0.926208651399491 33 1 8 0 266 298 3930 3962 PREDICTED: Sycon ciliatum mucin-5AC-like (LOC135812199), mRNA blastn 364 56.5 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);;