contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA1263632" and tax_phylum = "Discosea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5466964 | 5466964 | PRJNA1263632_P_NODE_1905_length_438_cov_7.073973_g1887_i0 | PRJNA1263632 | 1905 | 438 | 7.073973 | 30.98400174 | Ripella sp. 805 | 1217113 | Discosea | other_Eukaryota | 695 | 0 | NTclustered | gi|399764202|gb|JQ271713.1| | 1217113 | g1887 | i0 | 95.434 | 101.719178082192 | 438 | 16 | 100 | 2 | 1 | 438 | 998 | 565 | Ripella sp. 805 18S ribosomal RNA gene, partial sequence | blastn | 44553 | 695 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. 805 | |||
| 14392786 | 14392786 | PRJNA1263632_P_NODE_1272_length_531_cov_1.351528_g1254_i0 | PRJNA1263632 | 1272 | 531 | 1.351528 | 7.17661368 | Vannella persistens | 303303 | Discosea | other_Eukaryota | 948 | 0 | NTclustered | gi|165968548|gb|EU377588.1| | 303303 | g1254 | i0 | 98.87 | 90.6139359698682 | 531 | 6 | 100 | 0 | 1 | 531 | 559 | 29 | Vannella persistens strain CRIB69 18S ribosomal RNA gene, partial sequence | blastn | 48116 | 948 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella persistens | |||
| 15666627 | 15666627 | PRJNA1263632_P_NODE_4873_length_285_cov_1.872642_g4855_i0 | PRJNA1263632 | 4873 | 285 | 1.872642 | 5.3370297 | Thecamoeba similis | 242545 | Discosea | other_Eukaryota | 322 | 1.82e-83 | NTclustered | gi|33946350|gb|AY294154.1| | 242545 | g4855 | i0 | 88.39 | 83.8771929824561 | 267 | 31 | 94 | 0 | 19 | 285 | 25 | 291 | Thecamoeba similis actin mRNA, complete cds | blastn | 23905 | 322 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Thecamoebida | Thecamoeba | Thecamoeba similis | |||
| 18215353 | 18215353 | PRJNA1263632_P_NODE_1395_length_505_cov_1.722222_g1377_i0 | PRJNA1263632 | 1395 | 505 | 1.722222 | 8.6972211 | Ripella sp. 805 | 1217113 | Discosea | other_Eukaryota | 776 | 0 | NTclustered | gi|399764202|gb|JQ271713.1| | 1217113 | g1377 | i0 | 94.499 | 100.889108910891 | 509 | 19 | 100 | 9 | 1 | 505 | 507 | 4 | Ripella sp. 805 18S ribosomal RNA gene, partial sequence | blastn | 50949 | 776 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. 805 | |||
| 18215565 | 18215565 | PRJNA1263632_P_NODE_995_length_595_cov_2.867816_g977_i0 | PRJNA1263632 | 995 | 595 | 2.867816 | 17.0635052 | Ripella platypodia | 2047821 | Discosea | other_Eukaryota | 935 | 0 | NTclustered | gi|1269228354|gb|MF683479.1| | 2047821 | g977 | i0 | 95.294 | 100.536134453782 | 595 | 18 | 99 | 6 | 3 | 595 | 1645 | 1059 | Ripella platypodia clone 23.4.28 18S ribosomal RNA gene, partial sequence | blastn | 59819 | 935 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella platypodia | |||
| 24589987 | 24589987 | PRJNA1263632_P_NODE_3300_length_338_cov_2.301887_g3282_i0 | PRJNA1263632 | 3300 | 338 | 2.301887 | 7.78037806 | Paravannella minima | 1443144 | Discosea | other_Eukaryota | 412 | 1.2699999999999999e-110 | NTclustered | gi|571331049|gb|KF895376.1| | 1443144 | g3282 | i0 | 88.724 | 99.0532544378698 | 337 | 38 | 99 | 0 | 2 | 338 | 49 | 385 | Paravannella minima strain CCAP 1533/1 clone 1 actin gene, partial cds | blastn | 33480 | 412 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Paravannella | Paravannella minima |
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);;