contig_metadata
8 rows where bioproject = "PRJNA929952", tax_clade = "Opisthokonta" and tax_phylum = "Chordata"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4737513 | 4737513 | PRJNA929952_P_NODE_17244_length_242_cov_1.901408_g15950_i0 | PRJNA929952 | 17244 | 242 | 1.901408 | 4.60140736 | Mus musculus | 10090 | Chordata | Chordata | 52.8 | 0.022 | NTclustered | gi|71533349|gb|AC165251.2| | 10090 | g15950 | i0 | 100 | 0.115702479338843 | 28 | 0 | 12 | 0 | 58 | 85 | 87207 | 87180 | Mus musculus BAC clone RP24-75C16 from chromosome 13, complete sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 7287262 | 7287262 | PRJNA929952_P_NODE_24846_length_150_cov_2.000000_g23552_i0 | PRJNA929952 | 24846 | 150 | 2 | 3 | Heterodontus francisci | 7792 | Chordata | Chordata | 104 | 3.33e-18 | NTclustered | gi|2795582937|ref|XM_068019793.1| | 7792 | g23552 | i0 | 80.292 | 4.87333333333333 | 137 | 27 | 91 | 0 | 3 | 139 | 399 | 535 | PREDICTED: Heterodontus francisci ribosomal protein L3 (rpl3), mRNA | blastn | 731 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Heterodontiformes | Heterodontidae | Heterodontus | Heterodontus francisci | |
| 8562085 | 8562085 | PRJNA929952_P_NODE_17507_length_239_cov_2.633333_g16213_i0 | PRJNA929952 | 17507 | 239 | 2.633333 | 6.29366587 | Mus musculus | 10090 | Chordata | Chordata | 259 | 1.18e-64 | NTclustered | gi|2904934826|gb|PQ737751.1| | 10090 | g16213 | i0 | 95.679 | 86.8912133891213 | 162 | 6 | 67 | 1 | 78 | 238 | 197 | 358 | Mus musculus lncRNA161 lncRNA, complete sequence | blastn | 20767 | 259 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 11112770 | 11112770 | PRJNA929952_P_NODE_10709_length_347_cov_3.981132_g9419_i0 | PRJNA929952 | 10709 | 347 | 3.981132 | 13.81452804 | Polypterus senegalus | 55291 | Chordata | Chordata | 359 | 1.73e-94 | NTclustered | gi|1993937637|ref|XM_039741126.1| | 55291 | g9419 | i0 | 90 | 20.0432276657061 | 280 | 25 | 80 | 3 | 7 | 284 | 1173 | 1451 | PREDICTED: Polypterus senegalus E3 SUMO-protein ligase ZBED1-like (LOC120518358), transcript variant X2, mRNA | blastn | 6955 | 359 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 17832373 | 17832373 | PRJNA929952_P_NODE_4914_length_563_cov_8.481273_g3900_i0 | PRJNA929952 | 4914 | 563 | 8.481273 | 47.74956699 | Copelata | 2507557 | Chordata | Chordata | 82.4 | 7.08e-11 | NTclustered | gi|1591436771|gb|MK630286.1| | 2547645 | g3900 | i0 | 85.714 | 0.273534635879218 | 77 | 11 | 14 | 0 | 465 | 541 | 366 | 290 | Kowalevskia oceanica isolate koc-c 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence. | blastn | 154 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Appendicularia | Copelata | Kowalevskiidae | Kowalevskia | Kowalevskia oceanica | |
| 19106234 | 19106234 | PRJNA929952_P_NODE_5975_length_506_cov_9.171908_g4867_i0 | PRJNA929952 | 5975 | 506 | 9.171908 | 46.40985448 | Copelata | 2507557 | Chordata | Chordata | 82.4 | 6.31e-11 | NTclustered | gi|1591436771|gb|MK630286.1| | 2547645 | g4867 | i0 | 85.714 | 0.304347826086957 | 77 | 11 | 15 | 0 | 408 | 484 | 366 | 290 | Kowalevskia oceanica isolate koc-c 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence. | blastn | 154 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Appendicularia | Copelata | Kowalevskiidae | Kowalevskia | Kowalevskia oceanica | |
| 27024924 | 27024924 | PRJNA929952_P_NODE_13922_length_282_cov_11.940711_g12629_i0 | PRJNA929952 | 13922 | 282 | 11.940711 | 33.67280502 | Heptranchias perlo | 212740 | Chordata | Chordata | 55.5 | 1.99e-6 | NR | XP_067841360.1 | 212740 | g12629 | i0 | 56 | 0.936170212765957 | 50 | 22 | 53.2 | 0 | 1 | 150 | 11 | 60 | XP_067841360.1 LOW QUALITY PROTEIN: S-adenosylmethionine-dependent nucleotide dehydratase RSAD2 [Heptranchias perlo] | diamond | 264 | 55.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Hexanchiformes | Hexanchidae | Heptranchias | Heptranchias perlo | |
| 30063473 | 30063473 | PRJNA929952_P_NODE_21911_length_182_cov_1.928105_g20617_i0 | PRJNA929952 | 21911 | 182 | 1.928105 | 3.5091511 | Metazoa | 33208 | Chordata | Chordata | 85.1 | 1.94e-17 | NR | VTJ57755.1 | 9995 | g20617 | i0 | 68.4 | 8.47252747252747 | 57 | 18 | 94 | 0 | 6 | 176 | 610 | 666 | VTJ57755.1 Hypothetical predicted protein [Marmota monax] | diamond | 1542 | 85.9 | 0.990686845168801 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Sciuridae | Marmota | Marmota monax |
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);;