contig_metadata
21 rows where analysis = "blastn", bioproject = "PRJEB29441" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26517 | 26517 | PRJEB29441_P_NODE_31101_length_188_cov_1.100719_g30660_i0 | PRJEB29441 | 31101 | 188 | 1.100719 | 2.06935172 | Mus musculus | 10090 | Chordata | Chordata | 54.7 | 0.004 | NTclustered | gi|74013339|gb|AC153564.6| | 10090 | g30660 | i0 | 96.97 | 0.351063829787234 | 33 | 0 | 17 | 1 | 3 | 34 | 21 | 53 | Mus musculus 10 BAC RP23-39C23 (Roswell Park Cancer Institute (C57BL/6J Female) Mouse BAC Library) complete sequence | blastn | 66 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 988401 | 988401 | PRJEB29441_P_NODE_47041_length_161_cov_0.910714_g46600_i0 | PRJEB29441 | 47041 | 161 | 0.910714 | 1.46624954 | Artiodactyla | 91561 | Chordata | Chordata | 67.6 | 4.78e-7 | NTclustered | gi|2633875539|ref|XR_009737079.1| | 9906 | g46600 | i0 | 97.436 | 12.1490683229814 | 39 | 1 | 24 | 0 | 1 | 39 | 154 | 116 | PREDICTED: Bos javanicus uncharacterized LOC133249742 (LOC133249742), transcript variant X1, ncRNA | blastn | 1956 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Bos | Bos javanicus | |
| 2576690 | 2576690 | PRJEB29441_P_NODE_45923_length_162_cov_0.902655_g45482_i0 | PRJEB29441 | 45923 | 162 | 0.902655 | 1.4623011 | Sus scrofa | 9823 | Chordata | Chordata | 119 | 1.31e-22 | NTclustered | gi|1191882025|ref|XR_002344255.1| | 9823 | g45482 | i0 | 86.916 | 12.716049382716 | 107 | 12 | 65 | 2 | 13 | 118 | 1478 | 1583 | PREDICTED: Sus scrofa uncharacterized LOC110260796 (LOC110260796), ncRNA | blastn | 2060 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Suidae | Sus | Sus scrofa | |
| 7678789 | 7678789 | PRJEB29441_P_NODE_29507_length_193_cov_1.062500_g29066_i0 | PRJEB29441 | 29507 | 193 | 1.0625 | 2.050625 | Polypterus senegalus | 55291 | Chordata | Chordata | 213 | 7.21e-51 | NTclustered | gi|1993937637|ref|XM_039741126.1| | 55291 | g29066 | i0 | 89.474 | 10.1865284974093 | 171 | 15 | 88 | 3 | 1 | 169 | 1342 | 1173 | PREDICTED: Polypterus senegalus E3 SUMO-protein ligase ZBED1-like (LOC120518358), transcript variant X2, mRNA | blastn | 1966 | 213 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 7678993 | 7678993 | PRJEB29441_P_NODE_42707_length_164_cov_0.886957_g42266_i0 | PRJEB29441 | 42707 | 164 | 0.886957 | 1.45460948 | Pseudorca crassidens | 82174 | Chordata | Chordata | 132 | 1.71e-26 | NTclustered | gi|2791837331|ref|XR_010946971.1| | 82174 | g42266 | i0 | 81.707 | 67.5 | 164 | 24 | 98 | 6 | 1 | 161 | 1847 | 2007 | PREDICTED: Pseudorca crassidens uncharacterized lncRNA (LOC137232330), transcript variant X1, ncRNA | blastn | 11070 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Delphinidae | Pseudorca | Pseudorca crassidens | |
| 8641539 | 8641539 | PRJEB29441_P_NODE_39287_length_167_cov_0.864407_g38846_i0 | PRJEB29441 | 39287 | 167 | 0.864407 | 1.44355969 | root | 1 | Root_unresolved | Root_unresolved | 309 | 7.53e-80 | NTclustered | gi|2587618203|ref|XR_009493738.1| | 9913 | g38846 | i0 | 100 | 94.2455089820359 | 167 | 0 | 100 | 0 | 1 | 167 | 3486 | 3652 | PREDICTED: Bos taurus uncharacterized lncRNA (LOC132344779), transcript variant X2, ncRNA | blastn | 15739 | 309 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Bos | Bos taurus | |
| 11504821 | 11504821 | PRJEB29441_P_NODE_40250_length_166_cov_0.871795_g39809_i0 | PRJEB29441 | 40250 | 166 | 0.871795 | 1.4471797 | Meleagris gallopavo | 9103 | Chordata | Chordata | 220 | 3.6e-53 | NTclustered | gi|1776485916|ref|XR_004160754.1| | 9103 | g39809 | i0 | 90.854 | 1.92168674698795 | 164 | 15 | 99 | 0 | 3 | 166 | 5852 | 5689 | PREDICTED: Meleagris gallopavo uncharacterized LOC104912313 (LOC104912313), ncRNA | blastn | 319 | 220 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Galliformes | Phasianidae | Meleagris | Meleagris gallopavo | |
| 11504872 | 11504872 | PRJEB29441_P_NODE_44350_length_163_cov_0.894737_g43909_i0 | PRJEB29441 | 44350 | 163 | 0.894737 | 1.45842131 | Mus musculus | 10090 | Chordata | Chordata | 302 | 1.22e-77 | NTclustered | gi|51988080|gb|AC119842.9| | 10090 | g43909 | i0 | 100 | 2 | 163 | 0 | 100 | 0 | 1 | 163 | 70624 | 70462 | Mus musculus chromosome 1, clone RP23-277F23, complete sequence | blastn | 326 | 302 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 13741855 | 13741855 | PRJEB29441_P_NODE_45171_length_162_cov_1.424779_g44730_i0 | PRJEB29441 | 45171 | 162 | 1.424779 | 2.30814198 | Gallus | 9030 | Chordata | Chordata | 294 | 2.03e-75 | NTclustered | gi|2028522877|gb|MT800350.1| | 9031 | g44730 | i0 | 99.383 | 100 | 162 | 1 | 100 | 0 | 1 | 162 | 2938 | 2777 | Gallus gallus isolate 33917 mitochondrion, complete genome | blastn | 16200 | 294 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Galliformes | Phasianidae | Gallus | Gallus gallus | |
| 15016225 | 15016225 | PRJEB29441_P_NODE_45172_length_162_cov_1.424779_g44731_i0 | PRJEB29441 | 45172 | 162 | 1.424779 | 2.30814198 | Cheloniidae | 8465 | Chordata | Chordata | 54.7 | 0.004 | NTclustered | gi|2263258949|ref|XM_048845007.1| | 8467 | g44731 | i0 | 100 | 0.895061728395062 | 29 | 0 | 18 | 0 | 115 | 143 | 8711 | 8739 | PREDICTED: Caretta caretta caspase 8 associated protein 2 (CASP8AP2), transcript variant X2, mRNA | blastn | 145 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Testudines | Cheloniidae | Caretta | Caretta caretta | ||
| 15016230 | 15016230 | PRJEB29441_P_NODE_45972_length_162_cov_0.902655_g45531_i0 | PRJEB29441 | 45972 | 162 | 0.902655 | 1.4623011 | Gallus | 9030 | Chordata | Chordata | 298 | 1.57e-76 | NTclustered | gi|2028522877|gb|MT800350.1| | 9031 | g45531 | i0 | 100 | 99.3827160493827 | 161 | 0 | 99 | 0 | 2 | 162 | 3121 | 2961 | Gallus gallus isolate 33917 mitochondrion, complete genome | blastn | 16100 | 298 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Galliformes | Phasianidae | Gallus | Gallus gallus | |
| 16603595 | 16603595 | PRJEB29441_P_NODE_44694_length_163_cov_0.894737_g44253_i0 | PRJEB29441 | 44694 | 163 | 0.894737 | 1.45842131 | Sus scrofa | 9823 | Chordata | Chordata | 302 | 1.22e-77 | NTclustered | gi|1191847866|ref|XM_021077378.1| | 9823 | g44253 | i0 | 100 | 99.9877300613497 | 163 | 0 | 100 | 0 | 1 | 163 | 958 | 1120 | PREDICTED: Sus scrofa centromere protein B (CENPB), mRNA | blastn | 16298 | 302 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Suidae | Sus | Sus scrofa | |
| 16603621 | 16603621 | PRJEB29441_P_NODE_47034_length_161_cov_0.910714_g46593_i0 | PRJEB29441 | 47034 | 161 | 0.910714 | 1.46624954 | Bos taurus | 9913 | Chordata | Chordata | 298 | 1.56e-76 | NTclustered | gi|2587618204|ref|XR_009493739.1| | 9913 | g46593 | i0 | 100 | 71.0931677018634 | 161 | 0 | 100 | 0 | 1 | 161 | 1260 | 1420 | PREDICTED: Bos taurus uncharacterized lncRNA (LOC132344779), transcript variant X3, ncRNA | blastn | 11446 | 298 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Bos | Bos taurus | |
| 17566247 | 17566247 | PRJEB29441_P_NODE_45774_length_162_cov_0.902655_g45333_i0 | PRJEB29441 | 45774 | 162 | 0.902655 | 1.4623011 | Phasianidae | 9005 | Chordata | Chordata | 294 | 2.03e-75 | NTclustered | gi|209364663|gb|AC202735.3| | 9031 | g45333 | i0 | 99.383 | 9 | 162 | 1 | 100 | 0 | 1 | 162 | 78973 | 78812 | Gallus gallus BAC clone CH261-123E19 from chromosome z, complete sequence | blastn | 1458 | 294 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Galliformes | Phasianidae | Gallus | Gallus gallus | |
| 19152295 | 19152295 | PRJEB29441_P_NODE_44596_length_163_cov_0.894737_g44155_i0 | PRJEB29441 | 44596 | 163 | 0.894737 | 1.45842131 | Mauremys mutica | 74926 | Chordata | Chordata | 158 | 2.8e-34 | NTclustered | gi|2129561913|ref|XM_045025083.1| | 74926 | g44155 | i0 | 84.049 | 3.84049079754601 | 163 | 26 | 100 | 0 | 1 | 163 | 286 | 448 | PREDICTED: Mauremys mutica ADP ribosylation factor like GTPase 8B (ARL8B), mRNA | blastn | 626 | 158 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Testudines | Geoemydidae | Mauremys | Mauremys mutica | ||
| 19152430 | 19152430 | PRJEB29441_P_NODE_8996_length_380_cov_8.407855_g8555_i0 | PRJEB29441 | 8996 | 380 | 8.407855 | 31.949849 | Mus musculus | 10090 | Chordata | Chordata | 645 | 1.3099999999999995e-180 | NTclustered | gi|2904934826|gb|PQ737751.1| | 10090 | g8555 | i0 | 99.162 | 100.110526315789 | 358 | 3 | 94 | 0 | 4 | 361 | 358 | 1 | Mus musculus lncRNA161 lncRNA, complete sequence | blastn | 38042 | 645 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 20114836 | 20114836 | PRJEB29441_P_NODE_42876_length_164_cov_0.886957_g42435_i0 | PRJEB29441 | 42876 | 164 | 0.886957 | 1.45460948 | Bovidae | 9895 | Chordata | Chordata | 287 | 3.45e-73 | NTclustered | gi|256000864|gb|AC233562.7| | 9913 | g42435 | i0 | 98.171 | 831.067073170732 | 164 | 3 | 100 | 0 | 1 | 164 | 68235 | 68398 | Bos taurus Y Chr BAC CH240-231K19 (Children's Hospital Oakland Research Institute Bovine BAC Library (male)) complete sequence | blastn | 136295 | 287 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Bos | Bos taurus | |
| 21703399 | 21703399 | PRJEB29441_P_NODE_36078_length_174_cov_1.048000_g35637_i0 | PRJEB29441 | 36078 | 174 | 1.048 | 1.82352 | Lampetra fluviatilis | 7748 | Chordata | Chordata | 56.5 | 0.001 | NTclustered | gi|2815004333|emb|OZ078626.2| | 7748 | g35637 | i0 | 100 | 0.804597701149425 | 30 | 0 | 17 | 0 | 34 | 63 | 2434517 | 2434546 | Lampetra fluviatilis genome assembly, chromosome: 58 | blastn | 140 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Hyperoartia | Petromyzontiformes | Petromyzontidae | Lampetra | Lampetra fluviatilis | |
| 24252342 | 24252342 | PRJEB29441_P_NODE_30980_length_188_cov_1.467626_g30539_i0 | PRJEB29441 | 30980 | 188 | 1.467626 | 2.75913688 | Mus musculus | 10090 | Chordata | Chordata | 52.8 | 0.016 | NTclustered | gi|72384609|gb|AC153789.11| | 10090 | g30539 | i0 | 100 | 0.148936170212766 | 28 | 0 | 15 | 0 | 1 | 28 | 166521 | 166548 | Mus musculus chromosome 8, clone RP23-466N7, complete sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 24252394 | 24252394 | PRJEB29441_P_NODE_33880_length_180_cov_0.793893_g33439_i0 | PRJEB29441 | 33880 | 180 | 0.793893 | 1.4290074 | Bos taurus | 9913 | Chordata | Chordata | 294 | 2.3e-75 | NTclustered | gi|27884899|gb|AC129959.6| | 9913 | g33439 | i0 | 96.133 | 1292.96111111111 | 181 | 6 | 100 | 1 | 1 | 180 | 187552 | 187372 | Bos taurus, clone RP42-518P7, complete sequence | blastn | 232733 | 294 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Bos | Bos taurus | |
| 24252425 | 24252425 | PRJEB29441_P_NODE_35740_length_174_cov_3.816000_g35299_i0 | PRJEB29441 | 35740 | 174 | 3.816 | 6.63984 | Myxine glutinosa | 7769 | Chordata | Chordata | 76.8 | 8.69e-10 | NTclustered | gi|2797582605|ref|XR_010983157.1| | 7769 | g35299 | i0 | 88.06 | 24.6091954022989 | 67 | 5 | 37 | 3 | 1 | 65 | 21 | 86 | PREDICTED: Myxine glutinosa U2 spliceosomal RNA (LOC137420188), ncRNA | blastn | 4282 | 76.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Myxini | Myxiniformes | Myxinidae | Myxine | Myxine glutinosa |
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);;