contig_metadata
10 rows where bioproject = "PRJEB6584", tax_kingdom = "Metazoa" and tax_phylum = "Porifera"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26340053 | 26340053 | PRJEB6584d_S_NODE_9591_length_196_cov_1.701863_g9523_i0 | PRJEB6584 | 9591 | 196 | 1.701863 | 3.33565148 | Suberites domuncula | 55567 | Porifera | other_Eukaryota | 100 | 5.97e-17 | NTclustered | gi|61654613|gb|AY857414.1| | 55567 | g9523 | i0 | 84.848 | 0.790816326530612 | 99 | 15 | 51 | 0 | 13 | 111 | 1075 | 1173 | Suberites domuncula L3 mRNA, complete cds | blastn | 155 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Suberitidae | Suberites | Suberites domuncula | |
| 26341457 | 26341457 | PRJEB6584o_S_NODE_48775_length_167_cov_1.212121_g48667_i0 | PRJEB6584 | 48775 | 167 | 1.212121 | 2.02424207 | Isabella mirabilis | 1562475 | Porifera | other_Eukaryota | 67.6 | 5e-7 | NTclustered | gi|746815728|emb|LN624154.1| | 1562475 | g48667 | i0 | 90.385 | 0.934131736526946 | 52 | 3 | 31 | 2 | 81 | 131 | 152 | 202 | Isabella mirabilis partial 28S rRNA gene, specimen voucher G318737 | blastn | 156 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Corallistidae | Isabella | Isabella mirabilis | |
| 26568032 | 26568032 | PRJEB6584b_S_NODE_6472_length_172_cov_4.087591_g6454_i0 | PRJEB6584 | 6472 | 172 | 4.087591 | 7.03065652 | Metazoa | 33208 | Porifera | other_Eukaryota | 99 | 1.83e-16 | NTclustered | gi|1284883228|gb|KY825184.1| | 178514 | g6454 | i0 | 79.452 | 14.4244186046512 | 146 | 24 | 84 | 4 | 17 | 160 | 3474 | 3333 | Amphimedon compressa voucher MNRJ:18771 internal transcribed spacer 2 and 28S ribosomal RNA gene, partial sequence | blastn | 2481 | 100 | 0.99 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon compressa | |
| 32946747 | 32946747 | PRJEB6584o_S_NODE_5946_length_338_cov_20.775578_g5838_i0 | PRJEB6584 | 5946 | 338 | 20.775578 | 70.221453639999993 | Geodia barretti | 519541 | Porifera | other_Eukaryota | 133 | 3.07e-35 | NR | CAI8026159.1 | 519541 | g5838 | i0 | 67.5 | 3.38165680473373 | 77 | 25 | 68.3 | 0 | 4 | 234 | 247 | 323 | CAI8026159.1 Cathepsin B [Geodia barretti] | diamond | 1143 | 133 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 33031708 | 33031708 | PRJEB6584o_S_NODE_10300_length_272_cov_3.046414_g10192_i0 | PRJEB6584 | 10300 | 272 | 3.046414 | 8.28624608 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 69.3 | 2.28e-11 | NR | XP_065842109.1 | 121494 | g10192 | i0 | 53.2 | 0.518382352941177 | 47 | 22 | 51.8 | 0 | 29 | 169 | 453 | 499 | XP_065842109.1 uncharacterized protein [Oscarella lobularis] | diamond | 141 | 69.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 33048852 | 33048852 | PRJEB6584o_S_NODE_2189_length_465_cov_506.902326_g2096_i0 | PRJEB6584 | 2189 | 465 | 506.902326 | 2357.0958159 | Amphimedon queenslandica | 400682 | Porifera | other_Eukaryota | 59.3 | 1.41e-7 | NR | XP_003385055.2 | 400682 | g2096 | i0 | 82.1 | 0.548387096774194 | 28 | 5 | 18.1 | 0 | 463 | 380 | 148 | 175 | XP_003385055.2 PREDICTED: ubiquitin-40S ribosomal protein S27a [Amphimedon queenslandica] | diamond | 255 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Haplosclerida | Niphatidae | Amphimedon | Amphimedon queenslandica | |
| 33059658 | 33059658 | PRJEB6584e_S_NODE_125_length_472_cov_8.627002_g110_i0 | PRJEB6584 | 125 | 472 | 8.627002 | 40.71944944 | Metazoa | 33208 | Porifera | other_Eukaryota | 116 | 8.43e-29 | NR | XP_062516318.1 | 121492 | g110 | i0 | 60.2 | 5.06567796610169 | 118 | 42 | 75 | 2 | 470 | 117 | 108 | 220 | XP_062516318.1 small ribosomal subunit protein eS6-like [Corticium candelabrum] | diamond | 2391 | 117 | 0.991452991452991 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 33133991 | 33133991 | PRJEB6584e_S_NODE_3375_length_165_cov_1.900000_g3360_i0 | PRJEB6584 | 3375 | 165 | 1.9 | 3.135 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 42.7 | 0.0131 | NR | XP_065830257.1 | 121494 | g3360 | i0 | 42.9 | 1.43636363636364 | 42 | 23 | 74.5 | 1 | 125 | 3 | 2347 | 2388 | XP_065830257.1 spectrin alpha chain, non-erythrocytic 1-like [Oscarella lobularis] | diamond | 237 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 33134194 | 33134194 | PRJEB6584o_S_NODE_15127_length_227_cov_3.458333_g15019_i0 | PRJEB6584 | 15127 | 227 | 3.458333 | 7.85041591 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 95.1 | 7.73e-21 | NR | XP_065842901.1 | 121494 | g15019 | i0 | 63.1 | 1.63876651982379 | 65 | 24 | 85.9 | 0 | 13 | 207 | 345 | 409 | XP_065842901.1 ornithine decarboxylase-like isoform X2 [Oscarella lobularis] | diamond | 372 | 95.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 33145060 | 33145060 | PRJEB6584o_S_NODE_11959_length_254_cov_3.315068_g11851_i0 | PRJEB6584 | 11959 | 254 | 3.315068 | 8.42027272 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 70.5 | 9.34e-13 | NR | XP_065906893.1 | 196820 | g11851 | i0 | 56.7 | 3.43700787401575 | 60 | 25 | 69.7 | 1 | 20 | 196 | 124 | 183 | XP_065906893.1 cystatin-B-like [Dysidea avara] | diamond | 873 | 70.9 | 0.994358251057828 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara |
Advanced export
JSON shape: default, array, newline-delimited
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);;